Can't find nested SQL Query

Can someone please tell me how to refrence the Details2SqlDataSource1 in codebehind so I can do:

Details2SqlDataSource1.InsertParameters("VendorCode").DefaultValue = Request.QueryString("VendorCode")

Here's my code:

 

<%@ Page Language="VB" MasterPageFile="~/MasterPage.master" AutoEventWireup="false" CodeFile="test.aspx.vb" Inherits="test" %>

<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">




    <table style="width:100%;">
        <tr>
            <td>
                 </td>
        </tr>
        <tr>
            <td>
                <asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" 
                    DataKeyNames="VendorServicesCode" DataSourceID="T1SqlDataSource1" 
                    style="font-family: Verdana; font-size: x-small">
                    <Columns>
                        <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" 
                            SelectText="+" DeleteText="-" >
                            <ItemStyle VerticalAlign="Top" />
                        </asp:CommandField>
                        <asp:TemplateField HeaderText="Service" SortExpression="CategoryCode">
                            <EditItemTemplate>
                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("CategoryCode") %>'></asp:TextBox>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryCode") %>' 
                                    Visible="False"></asp:Label>
                                <asp:Repeater ID="Repeater5" runat="server" DataSourceID="CatSqlDataSource1">
                                <ItemTemplate>
                                <%#Eval("CategoryName")%>
                                </ItemTemplate>
                                </asp:Repeater>
                                <asp:SqlDataSource ID="CatSqlDataSource1" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                    SelectCommand="SELECT * FROM [CategoryMst] WHERE ([CategoryCode] = @CategoryCode)">
                                    <SelectParameters>
                                        <asp:ControlParameter ControlID="Label1" Name="CategoryCode" 
                                            PropertyName="Text" Type="Int32" />
                                    </SelectParameters>
                                </asp:SqlDataSource>
                                <br />
                                <asp:GridView ID="GridView4" runat="server" AutoGenerateColumns="False" 
                                    DataKeyNames="VendorProductsCode" DataSourceID="T2SqlDataSource1" 
                                    GridLines="None" ShowHeader="False" Width="150px">
                                    <Columns>
                                        <asp:CommandField ShowDeleteButton="True" ShowSelectButton="True" 
                                            SelectText="+" DeleteText="-" />
                                        <asp:TemplateField HeaderText="Product" SortExpression="ProductCode">
                                            <EditItemTemplate>
                                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ProductCode") %>'></asp:TextBox>
                                            </EditItemTemplate>
                                            <ItemTemplate>
                                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("ProductCode") %>' 
                                                    Visible="False"></asp:Label>
                                                <asp:Repeater ID="Repeater4" runat="server" 
                                                    DataSourceID="ProdLabelSqlDataSource1">
                                               <ItemTemplate>
                                               <%# Eval("ProductName") %>
                                               </ItemTemplate>
                                                </asp:Repeater>
                                                <asp:SqlDataSource ID="ProdLabelSqlDataSource1" runat="server" 
                                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                                    SelectCommand="SELECT * FROM [ProductMst] WHERE ([ProductCode] = @ProductCode)">
                                                    <SelectParameters>
                                                        <asp:ControlParameter ControlID="Label1" Name="ProductCode" PropertyName="Text" 
                                                            Type="Int32" />
                                                    </SelectParameters>
                                                </asp:SqlDataSource>
                                            </ItemTemplate>
                                            <ItemStyle Width="125px" />
                                        </asp:TemplateField>
                                    </Columns>
                                </asp:GridView>
                                <asp:SqlDataSource ID="T2SqlDataSource1" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                    DeleteCommand="DELETE FROM [VendorProducts] WHERE [VendorProductsCode] = @VendorProductsCode" 
                                    InsertCommand="INSERT INTO [VendorProducts] ([VendorLocationCode], [VendorCode], [VendorRegionCode], [CategoryCode], [ProductCode]) VALUES (@VendorLocationCode, @VendorCode, @VendorRegionCode, @CategoryCode, @ProductCode)" 
                                    SelectCommand="SELECT * FROM [VendorProducts] WHERE (([VendorCode] = @VendorCode) AND ([VendorLocationCode] = @VendorLocationCode) AND ([CategoryCode] = @CategoryCode))" 
                                    UpdateCommand="UPDATE [VendorProducts] SET [VendorLocationCode] = @VendorLocationCode, [VendorCode] = @VendorCode, [VendorRegionCode] = @VendorRegionCode, [CategoryCode] = @CategoryCode, [ProductCode] = @ProductCode WHERE [VendorProductsCode] = @VendorProductsCode">
                                    <SelectParameters>
                                        <asp:QueryStringParameter Name="VendorCode" QueryStringField="VendorCode" 
                                            Type="Int32" />
                                        <asp:QueryStringParameter Name="VendorLocationCode" 
                                            QueryStringField="VendorLocationCode" Type="Int32" />
                                        <asp:ControlParameter ControlID="Label1" Name="CategoryCode" 
                                            PropertyName="Text" Type="Int32" />
                                    </SelectParameters>
                                    <DeleteParameters>
                                        <asp:Parameter Name="VendorProductsCode" Type="Int32" />
                                    </DeleteParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                                        <asp:Parameter Name="VendorCode" Type="Int32" />
                                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                                        <asp:Parameter Name="ProductCode" Type="Int32" />
                                        <asp:Parameter Name="VendorProductsCode" Type="Int32" />
                                    </UpdateParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                                        <asp:Parameter Name="VendorCode" Type="Int32" />
                                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                                        <asp:Parameter Name="ProductCode" Type="Int32" />
                                    </InsertParameters>
                                </asp:SqlDataSource>
                                <br />
                                <asp:DetailsView ID="DetailsView1" runat="server" AutoGenerateRows="False" 
                                    DataKeyNames="VendorProductsCode" DataSourceID="Details2SqlDataSource1" 
                                    Height="50px" Width="125px">
                                    <Fields>
                                        <asp:TemplateField HeaderText="Product" SortExpression="ProductCode">
                                            <EditItemTemplate>
                                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("ProductCode") %>'></asp:TextBox>
                                            </EditItemTemplate>
                                            <InsertItemTemplate>
                                                <asp:DropDownList ID="DropDownList2" runat="server" 
                                                    DataSourceID="ProdDDLSqlDataSource1" DataTextField="ProductName" 
                                                    DataValueField="ProductCode" SelectedValue='<%# Bind("ProductCode") %>'>
                                                </asp:DropDownList>
                                                <asp:SqlDataSource ID="ProdDDLSqlDataSource1" runat="server" 
                                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                                    SelectCommand="SELECT * FROM [ProductMst] WHERE ([CategoryCode] = @CategoryCode) ORDER BY [ProductName]">
                                                    <SelectParameters>
                                                        <asp:ControlParameter ControlID="Label1" Name="CategoryCode" 
                                                            PropertyName="Text" Type="Int32" />
                                                    </SelectParameters>
                                                </asp:SqlDataSource>
                                            </InsertItemTemplate>
                                            <ItemTemplate>
                                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("ProductCode") %>'></asp:Label>
                                            </ItemTemplate>
                                        </asp:TemplateField>
                                        <asp:CommandField ShowInsertButton="True" />
                                    </Fields>
                                </asp:DetailsView>
                                <asp:SqlDataSource ID="Details2SqlDataSource1" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                    DeleteCommand="DELETE FROM [VendorProducts] WHERE [VendorProductsCode] = @VendorProductsCode" 
                                    InsertCommand="INSERT INTO [VendorProducts] ([VendorLocationCode], [VendorCode], [VendorRegionCode], [CategoryCode], [ProductCode]) VALUES (@VendorLocationCode, @VendorCode, @VendorRegionCode, @CategoryCode, @ProductCode)" 
                                    SelectCommand="SELECT * FROM [VendorProducts] WHERE ([VendorProductsCode] = @VendorProductsCode)" 
                                    UpdateCommand="UPDATE [VendorProducts] SET [VendorLocationCode] = @VendorLocationCode, [VendorCode] = @VendorCode, [VendorRegionCode] = @VendorRegionCode, [CategoryCode] = @CategoryCode, [ProductCode] = @ProductCode WHERE [VendorProductsCode] = @VendorProductsCode">
                                    <SelectParameters>
                                        <asp:ControlParameter ControlID="GridView4" Name="VendorProductsCode" 
                                            PropertyName="SelectedValue" Type="Int32" />
                                    </SelectParameters>
                                    <DeleteParameters>
                                        <asp:Parameter Name="VendorProductsCode" Type="Int32" />
                                    </DeleteParameters>
                                    <UpdateParameters>
                                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                                        <asp:Parameter Name="VendorCode" Type="Int32" />
                                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                                        <asp:Parameter Name="ProductCode" Type="Int32" />
                                        <asp:Parameter Name="VendorProductsCode" Type="Int32" />
                                    </UpdateParameters>
                                    <InsertParameters>
                                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                                        <asp:Parameter Name="VendorCode" Type="Int32" />
                                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                                        <asp:Parameter Name="ProductCode" Type="Int32" />
                                    </InsertParameters>
                                </asp:SqlDataSource>
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                </asp:GridView>
                <asp:SqlDataSource ID="T1SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                    DeleteCommand="DELETE FROM [VendorServices] WHERE [VendorServicesCode] = @VendorServicesCode" 
                    InsertCommand="INSERT INTO [VendorServices] ([VendorLocationCode], [VendorRegionCode], [VendorCode], [CategoryCode]) VALUES (@VendorLocationCode, @VendorRegionCode, @VendorCode, @CategoryCode)" 
                    SelectCommand="SELECT * FROM [VendorServices] WHERE (([VendorCode] = @VendorCode) AND ([VendorLocationCode] = @VendorLocationCode))" 
                    UpdateCommand="UPDATE [VendorServices] SET [VendorLocationCode] = @VendorLocationCode, [VendorRegionCode] = @VendorRegionCode, [VendorCode] = @VendorCode, [CategoryCode] = @CategoryCode WHERE [VendorServicesCode] = @VendorServicesCode">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="VendorCode" QueryStringField="VendorCode" 
                            Type="Int32" />
                        <asp:QueryStringParameter Name="VendorLocationCode" 
                            QueryStringField="VendorLocationCode" Type="Int32" />
                    </SelectParameters>
                    <DeleteParameters>
                        <asp:Parameter Name="VendorServicesCode" Type="Int32" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                        <asp:Parameter Name="VendorCode" Type="Int32" />
                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                        <asp:Parameter Name="VendorServicesCode" Type="Int32" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                        <asp:Parameter Name="VendorCode" Type="Int32" />
                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                    </InsertParameters>
                </asp:SqlDataSource>
                <asp:DetailsView ID="DetailsView2" runat="server" AutoGenerateRows="False" 
                    DataKeyNames="VendorServicesCode" DataSourceID="DetailsSqlDataSource1" 
                    Height="50px" Width="125px" 
                    style="font-family: Verdana; font-size: x-small">
                    <Fields>
                        <asp:TemplateField HeaderText="Category" SortExpression="CategoryCode">
                            <EditItemTemplate>
                                <asp:DropDownList ID="DropDownList1" runat="server" 
                                    DataSourceID="ServicesDDLSqlDataSource1" DataTextField="CategoryName" 
                                    DataValueField="CategoryCode" SelectedValue='<%# Bind("CategoryCode") %>'>
                                </asp:DropDownList>
                                <asp:SqlDataSource ID="ServicesDDLSqlDataSource1" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                    SelectCommand="SELECT [CategoryName], [CategoryCode] FROM [CategoryMst] ORDER BY [CategoryName]">
                                </asp:SqlDataSource>
                            </EditItemTemplate>
                            <InsertItemTemplate>
                                <asp:DropDownList ID="DropDownList1" runat="server" 
                                    DataSourceID="ServicesDDLSqlDataSource1" DataTextField="CategoryName" 
                                    DataValueField="CategoryCode" SelectedValue='<%# Bind("CategoryCode") %>'>
                                </asp:DropDownList>
                                <asp:SqlDataSource ID="ServicesDDLSqlDataSource1" runat="server" 
                                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                                    SelectCommand="SELECT [CategoryName], [CategoryCode] FROM [CategoryMst] ORDER BY [CategoryName]">
                                </asp:SqlDataSource>
                            </InsertItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Text='<%# Bind("CategoryCode") %>'></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:CommandField ShowInsertButton="True" />
                    </Fields>
                </asp:DetailsView>
                <asp:SqlDataSource ID="DetailsSqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:SiteDataConnStr %>" 
                    DeleteCommand="DELETE FROM [VendorServices] WHERE [VendorServicesCode] = @VendorServicesCode" 
                    InsertCommand="INSERT INTO [VendorServices] ([VendorLocationCode], [VendorRegionCode], [VendorCode], [CategoryCode]) VALUES (@VendorLocationCode, @VendorRegionCode, @VendorCode, @CategoryCode)" 
                    SelectCommand="SELECT * FROM [VendorServices] WHERE (([VendorCode] = @VendorCode) AND ([VendorLocationCode] = @VendorLocationCode) AND ([VendorServicesCode] = @VendorServicesCode))" 
                    UpdateCommand="UPDATE [VendorServices] SET [VendorLocationCode] = @VendorLocationCode, [VendorRegionCode] = @VendorRegionCode, [VendorCode] = @VendorCode, [CategoryCode] = @CategoryCode WHERE [VendorServicesCode] = @VendorServicesCode">
                    <SelectParameters>
                        <asp:QueryStringParameter Name="VendorCode" QueryStringField="VendorCode" 
                            Type="Int32" />
                        <asp:QueryStringParameter Name="VendorLocationCode" 
                            QueryStringField="VendorLocationCode" Type="Int32" />
                        <asp:ControlParameter ControlID="GridView3" Name="VendorServicesCode" 
                            PropertyName="SelectedValue" Type="Int32" />
                    </SelectParameters>
                    <DeleteParameters>
                        <asp:Parameter Name="VendorServicesCode" Type="Int32" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                        <asp:Parameter Name="VendorCode" Type="Int32" />
                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                        <asp:Parameter Name="VendorServicesCode" Type="Int32" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="VendorLocationCode" Type="Int32" />
                        <asp:Parameter Name="VendorRegionCode" Type="Int32" />
                        <asp:Parameter Name="VendorCode" Type="Int32" />
                        <asp:Parameter Name="CategoryCode" Type="Int32" />
                    </InsertParameters>
                </asp:SqlDataSource>
                <br />
            </td>
        </tr>
    </table>





</asp:Content>

 
0
jfierst
1/29/2008 6:51:25 PM
asp.net.presentation-controls 72751 articles. 3 followers. Follow

15 Replies
811 Views

Similar Articles

[PageSpeed] 16
Get it on Google Play
Get it on Apple App Store

What error are you getting?


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/29/2008 7:28:31 PM

Object reference not set to an instance of an object.

Line 31:
Line 32:         Dim Details2SqlDataSource1 As SqlDataSource
Line 33:         Details2SqlDataSource1 = GridView3.SelectedRow.FindControl("Details2SqlDataSource1")

 

[NullReferenceException: Object reference not set to an instance of an object.]
   test.Page_Load(Object sender, EventArgs e) in C:\websites\telegent\test.aspx.vb:33
   System.Web.UI.Control.OnLoad(EventArgs e) +99
   System.Web.UI.Control.LoadRecursive() +47
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1436

0
jfierst
1/29/2008 7:42:17 PM

Can you please explain what exactly you want to do in line 33?


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/29/2008 8:50:08 PM

I am simply trying to access the sqlquery so I can then do this:

Details2SqlDataSource1.InsertParameters("VendorCode").DefaultValue = Request.QueryString("VendorCode")

Details2SqlDataSource1.InsertParameters("VendorLocationCode").DefaultValue = Request.QueryString("VendorLocationCode")

Details2SqlDataSource1.InsertParameters("CategoryCode").DefaultValue = Label1.Text

 

0
jfierst
1/29/2008 8:53:55 PM

You can directly do this in Page_Load. Why are you doing Findcontrol?


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/29/2008 9:07:02 PM

The query is located within Gridview3.  I can't access it directly.

0
jfierst
1/29/2008 9:11:04 PM

THe query is associated with the sqldatasource and the gridview is bound to the sqldatasource. So you can access the sqldatasource directly.


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/29/2008 9:32:42 PM

The datasource I am trying to get to is Details2SqlDataSource1 which is bound to a DetailsView, and both the detailsview and the Details2SqlDataSource1 are inside the Gridview3 gridview.

When I try to set it in pageload with simply:

Details2SqlDataSource1.InsertParameters(
"VendorCode").DefaultValue = Request.QueryString("VendorCode")

, it says Details2SqlDataSource1 is not declared.  That makes me think that I need to do a findcontrol on it.

0
jfierst
1/30/2008 2:03:21 PM

try this

Dim ds As sqldatasource = TryCast(GridView3.SelectedRow.FindControl("Details2SqlDataSource1"), sqldatasource)

ds.InsertParameters("VendorCode").DefaultValue = Request.QueryString("VendorCode")


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/30/2008 3:55:37 PM

Nope, didn't work.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

0
jfierst
1/30/2008 4:02:13 PM

In what event are you writing this code?


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/30/2008 6:26:50 PM

I have tried Page Load, and GridView3_RowDataBound, and GridView3_Load

0
jfierst
1/30/2008 6:34:55 PM

try this in Page_Load

try this

Dim ds As sqldatasource = TryCast(GridView3.FindControl("Details2SqlDataSource1"), sqldatasource)

ds.InsertParameters("VendorCode").DefaultValue = Request.QueryString("VendorCode")

Selectedrow probably doesn't make sense while loading.


Regards

Partha Mandayam
Sr Prog Analyst
Kaiser Permanente

0
mcp111
1/30/2008 8:45:57 PM

Object reference not set to an instance of an object

0
jfierst
1/30/2008 8:54:50 PM

Hi jfierst ,

Try to invoke findcontrol method in GridView3_RowDataBound and you need to do it in the rows which RowType equals DataRow.

See my codes below.

        protected void GridView3_RowDataBound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                //do findcontrol
            }
        }

 



Samu Zhang
Microsoft Online Community Support

Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question.
0
Samu
1/31/2008 5:28:34 AM
Reply:

Similar Artilces:

Can't find EDM wizard (can't add ADO.NET Entity Data Model)
I'm having trouble getting started with EDM.  I'm ultimately trying to experiment with ASP.NET Data Services.  I have never installed any ASP.NET 3.5 Extensions CTPs.  However, I have installed VS2008 SP1 Beta1 and .NET 3.5 SP1 Beta 1.  Based on the list of features in SP1 Beta 1 (http://www.microsoft.com/downloads/details.aspx?familyid=8C36ACA4-E947-4760-9B05-93CAC04C6F87&displaylang=en ) I believe I should have both EDM support and Data Services support. When I try to add a new item to my VS2008 project, ADO.NET Entity Data Model is not in the list.&nb...

Tomcat can't find novlwww and Httpd2 can't find wwwrun at boot time
Hello, After installing NSS services, when my OES Linux SP2 server finishes loading I see "Failed services in runlevel 3: novell-tomcat4 apache2" Looking in /var/log/boot.msg I see: <notice>start services (novell-tomcat4 novell-nss apache2) Starting tomcat4: chown: `novlwww:www': invalid user su: user novlwww does not exist Starting httpd2 (worker) httpd2-worker: bad user name wwwrun The command line was: /usr/sbin/httpd2-worker -f /etc/apache2/httpd.conf -DSSL failed This is the first OES Linux server on which NSS was installed, and there is no n...

can't find SQL query analyzer??
I downloaded the portal and SQL server and have chosen to install the database remotely. I'm now following the instrucstions in readme.htm, but I'm stuck b/c I can't find the SQL Query Analyzer anywhere under Programs. But I'm seeing MSSQLServer icon running on the bottom right of my task bar. Where/how can I launch SQL Query Analyzer to run the scripts?Running SQL scripts on remote server: 1. Open SQL Query Analyzer on the remote machine. 2. Run Setup\Portal_CreateDB.sql. Just execute "isqlw" in the start|Run on your OS.If SQL server is installed, this will la...

Can't find nested control. Help!!
Greetings, everyone. I wrote a web report that requires 3 nested gridviews. I am trying to retrieve/populate a hidden variable inside the 3rd one.For some reason, I can access the first 2 gridviews ok, but the third one comes up empty (and thusly, I cannot find my hidden variable).What am I doing wrong?Here's the code:  1 Dim gv_da As GridView = FindControl("GV_REPORT_DA") 2 Dim gv_sa As GridView = gv_da.Rows.Item(0).FindControl("GV_REPORT_SA") 3 Dim gv_pa As GridView = gv_sa.Rows.Item(0).FindControl("GV_REPORT_P...

ListView and sql insert can't find control.
I have the a ddl in side of a ListView and a sqlinsert statement.  With the following sql, I get an error that it can't find the contolid.  What am I missing:ListView code inside the "InsertTemplate"::            <asp:DropDownList ID="ddlProducer" runat="server" AutoPostBack="True" DataSourceID="sqlProducer"                DataTextField="ProducerName" DataValueField="ProducerID"...

They Can't Crack What They Can't Find
They Can't Crack What They Can't Find noeld@rootprompt.org The Internet today is a jungle full of predators. Some of these predators are trying to crack your machine others are just looking for a machine to crack. By using the firewalling tools built into the Linux kernel it is possible to make a desktop machine virtually disappear from the crackers view. In this article I will describe how to hide a machine running Linux that uses PPP over a modem to connect to the Internet. I will use ipchains and the firewalling built into the Linux kernel to protect the services that are ...

I can't get no cache, I can't get no cache. 'Cause I try and I try and I try and, I can't get no, I can't get no cache.
I have fiddled out for days tinkering with the setting in about:config trying to get FireFox 12 to use the disk cache. I have NOT found the trick. This One Trick Pony ain't doing it like it used to up until recently. Pray tell anyone, What information can I share that will point a knowledgeable person to aid me in getting FF to disk.cache? I have also tried restarting FF with add-ons disabled, (There were NOT too many to do this to, so it was quick and easy) Here is my stab at trying to convey the information that MIGHT govern matters Using about:cache Informatio...

.js file doesn't understand $get command
var adiv = $get('ctl00_AlertDiv'); alert(adiv);  If i put this in a .js file <atlas:ScriptReference Path="~/Includes/Async.js" ScriptMode="Auto" />  It comes up null. If I put the code in the masterpage in a script block without a .js file - it works  WHY? actually  adiv = $get('ctl00_AlertDiv'); works  adiv = $get('<%=AlertDiv.ClientID%>'); doesn't why  That "<%= %>" syntax is ASP.NET.  If you put this code in a .js file, ASP.NET is not processing the file (and thus not understanding <%= %>). One idea: you could pu...

Re: I can't get no cache, I can't get no cache. ' Cause I try and I try and I try and, I can't get no, I can't get no cache.
<div>please com e see me about htis<br /> <br /> ------- Original Message f= rom the Global Relay Archive -------<br /> From: Hp &lt;ferd@farkel.net&gt;= <br /> To: "support-firefox@lists.mozilla.org" &lt;support-firefox@lists.mo= zilla.org&gt;<br /> Sent: Sun, 27 May 2012 18:30:18 -0700<br /> Subject: I = can't get no cache, I can't get no cache. 'Cause I try and I try and I try = and, I can't get no, I can't get no cache.<br /> <br /></div> <pre class=3D"gr-maex-body-pre&qu...

.net Project can't find image? but the image is present!
I've got an image in a directory called App_Data, App_Data is on the root of the project. Also i included the image into the project. The image is located in the App_Data directory. If i run the project i dón't see an Image.Its a red cross instead of an image.So i right click for the details:   http://localhost:49984/App_Data/image.jpgEverything is ok.so i made a copy of it and places this in my browser.I get this error: Server Error in '/' Application. HTTP Error 403 - Forbidden. Version Information: ASP.NET Development Server 8.0.0.0 Is thi...

2010: Can't register - can't download the software - can't register until I have the software
I have active maintenance on Rad Studio: From: Vicky Rassmisaengthong [mailto:Vicky.Rassmisaengthong@EMBARCADERO.COM] Sent: Wednesday, February 25, 2009 1:58 PM To: rgrossman Cc: amer.supportadmin@codegear.com; Ashley Cosentino Subject: Software Assurance Support for Tech III Inc PO# Credit Card Dear Embarcadero Technologies Support Customer, Welcome! You have been registered as the primary contact on support account number AM####### Herewith we confirm your Embarcadero Technologies support agreement covering: Qty 1 RAD Studio Enterprise Named User licens...

nested datalist in a selecteditemtemplate can't find control or get datakey
I am trying to create a navigation menu with two data lists - a category and subcategory. I was unsucessfull in accessing the nested datalist control from the onitemcommand so I achieved my goal this way. The problem with doing it this way is that I cannot access the datakey of the nested datalist doing it this way. It give me an error saying that column doesn't exist. Can anyone tell me a way to do this? If not can anyone show me how I can use the findcontrol to find the nested datalist control so I can use codebehind to bind the dataset to the nested datalist.  because I cou...

I need a control like AutoCompleteExtender,but I can't find it in the ajax.net RC
Like the title I need the function that AutoCompleteExtender has. so I search AutoCompleteExtender control in the RC control toolkit list,but I can't find it. and I google it, the control seems to be in the atlas. now,can I use the AutoCompleteExtender control,and does it drop by the ajax.net.if I can,how can I get it,I hava install the RC.if I can't any control instead it? Of course, you need to install another Apps called AJAX Features CTP Dec, then you will get it back.The more you cook the ASP.NET, the much better you taste it....

Can't find nested controls on UserControls with New version of AjaxToolKit.dll
I have noticed much improvement in Accordion, and overall speed in the Toolkit with the June release but It seems something broke the ability to get a reference to a nested control with the latest June Toolkit release (in my case specifically within a TabContainer). With the previous release I had the following scenario without any problems: Partial extract of code inside userControl that is contained within Accordion control: <asp:ScriptManagerProxy id="ScriptManagerProxy1" runat="server"> </asp:ScriptManagerProxy> <div> <aj...

Web resources about - Can't find nested SQL Query - asp.net.presentation-controls

Resources last updated: 11/26/2015 8:12:42 PM