|
itagi wrote: passing objects to another aspx page from within an aspx page during run time.
In 2002 the only way to do that is the URL or the session.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I have a simple DB with fields ID and Address. Without the Page_Load script, the UpdateButton_Click code works just fine. After adding the Page_Load script (which works just fine), the UpdateButton_Click stops working with no error message; it just saves the old Address value. Why is this happening? I would like to keep my hair and my client :} 
Here's the Code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
Dim ID As Integer = 2
Dim aTable As New ATSCZDSTableAdapters.ATCSZTableAdapter
Dim aRecords As ATSCZDS.ATCSZDataTable
Dim aRecord As ATSCZDS.ATCSZRow
aRecords = aTable.GetData(ID)
For Each aRecord In aRecords
Try
IDTextBox.Text = aRecord.ID
AddressTextBox.Text = aRecord.Address
Catch ex As Exception
Label2.Text = ex.ToString()
End Try
Next
End Sub
Protected Sub UpdateButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles UpdateButton.Click
Label2.Text = "The record was updated successfully!"
Try
SqlDataSource1.Update()
Catch except As Exception
Label2.Text = except.ToString()
End Try
End Sub
Page Code:
<asp:sqldatasource id="SqlDataSource1" runat="server"
="" connectionstring="<%$ ConnectionStrings:AppDataConnectionString %>" deletecommand="DELETE FROM [ATCSZ] WHERE [ID] = ?" insertcommand="INSERT INTO [ATCSZ] ([ID], [Address]) VALUES (?, ?)" providername="<%$ ConnectionStrings:AppDataConnectionString.ProviderName %>" selectcommand="SELECT [ID], [Address] FROM [ATCSZ]" updatecommand="UPDATE [ATCSZ] SET [Address] = ? WHERE [ID] = ?">
<deleteparameters>
<asp:parameter name="ID" type="Int32">
<updateparameters>
<asp:controlparameter name="Address" controlid="AddressTextBox" propertyname="Text">
<asp:controlparameter name="ID" controlid="IDTextBox" propertyname="Text">
<insertparameters>
<asp:parameter name="ID" type="Int32">
<asp:parameter name="Address" type="String">
<asp:label id="Label2" runat="server" style="position: relative">
ID:
<asp:textbox id="IDTextBox" runat="server" style="position: relative">
ADDRESS:<asp:textbox id="AddressTextBox" runat="server" style="position: relative">
<asp:button id="UpdateButton" runat="server" style="position: relative" text="UpdateData">
|
|
|
|
|
Try using
if ispostback = false
Dim ID As Integer = 2
Dim aTable As New ATSCZDSTableAdapters.ATCSZTableAdapter
Dim aRecords As ATSCZDS.ATCSZDataTable
Dim aRecord As ATSCZDS.ATCSZRow
aRecords = aTable.GetData(ID)
For Each aRecord In aRecords
Try
IDTextBox.Text = aRecord.ID
AddressTextBox.Text = aRecord.Address
Catch ex As Exception
Label2.Text = ex.ToString()
End Try
Next
end if
I didn't get any requirements for the signature
|
|
|
|
|
It Works! Forgot a simple little rule, didn't I?!
|
|
|
|
|
How can we connect the ASP.NET (2005)application to SQL Server 2000. Please send me the code to connect db and insert data into it.
|
|
|
|
|
|
I want to create a separate class that defines the db connections. then call it in my application(ASP.NET 2005). so pls send me the code For SQL connection and also the code to call the class in the code behind in a submit button click.
|
|
|
|
|
Hello
i have a asp.net application with subfolder:
www.myapplication.com/ressourcefolder/
I have disable anonymous access to ressourcefolder in IIS, If i try to access to this folder in internet explorer i have the authentication window.
Now i want my website to access to this folder witout opening the authentication window on client side.
How do this?
Thanks
|
|
|
|
|
enable integrated security on the folder.
make sure the windows account has access to the folder.
Add the site to the trusted sites list on the client.
I didn't get any requirements for the signature
|
|
|
|
|
|
If you want to suppress the authentication window at client it can be done through clients browser settings Tools--> Internet Options --> Security and select the zone of your site ie if client is accessing your site through intranet then select intranet and click on Custom Level Button and scroll down the list to Authentication and under logon select autiomatically login in intranet zone.
However these settings are to be made at client machine I belive there is nothing that can be done for it at server side
Shujaat
|
|
|
|
|
I am attempting to port an asp site which uses reference to wsc files; for example
objMyObject = Server.CreateObject("MyFile.WSC");
over to c#/net, how do I use the existing wsc file from .net?
I have already looked at using tlbImp.exe to affect a com iterop, but this produced an error.
Thanks
|
|
|
|
|
I grabbed the gridview control onto design page and then binded it with the database. Now I want to enter data in the grid view when i run the website but i cannot find the way to do that. How can this be done? Any guidance please or show me the code or way to do that.
Thanks 
|
|
|
|
|
Be more clear, you mean, that your gridview read well the data from the database, but you can't add new records?
did you bind the gridwiew to a sqlDataSource?
|
|
|
|
|
yes i can see the data which has been added from SQL Server DB but how I can add manually?
Yes I binded gridview to SQL Data Source.
|
|
|
|
|
ok, when you bind the sqlDatasource. if you want enable edit and adding, you have to make when you are configuring the sqldatasource, in the box you select the columns you want to show from the database, there are three botton, Where, orden by and Advanced click the last one, Advanced, and check the first box "generate inset up........
and bind again your grid view to the sqldatasource.
and play with the grid view setting to make enable edit and adding.
hope that will help
|
|
|
|
|
I can see edit option but no ADD option. How can this be done?
|
|
|
|
|
|
I am trying to create a GridView with TextBoxes in the header that will allow searches. Here is the GridView:
<asp:GridView ID="gvSearchResults" runat="server" AutoGenerateColumns="false" EmptyDataText="No Records Found" OnRowCommand="gvSearchResults_RowCommand" ShowHeader="true">
<Columns>
<asp:BoundField DataField="CustomerCode" Visible="false" />
<asp:BoundField DataField="CardNumber" HeaderText="Card Number"/>
<asp:BoundField DataField="FirstName" HeaderText="First Name"/>
<asp:BoundField DataField="MiddleInitial" HeaderText="Initial"/>
<asp:BoundField DataField="LastName" HeaderText="Last Name"/>
<asp:BoundField DataField="Address" HeaderText="Street"/>
<asp:BoundField DataField="City" HeaderText="City"/>
<asp:BoundField DataField="State" HeaderText="State"/>
<asp:BoundField DataField="ZipCode" HeaderText="Zip Code"/>
<asp:TemplateField>
<HeaderTemplate>
<asp:Button id="cmdSearch" CommandName="Search" Text="Search" runat="server"/>
</HeaderTemplate>
<ItemTemplate>
<asp:Button id="cmdViewActivity" Text="Activity" CommandName="Activity" CommandArgument="CustomerCode" runat="server" />
<asp:Button id="cmdViewDetails" Text="Details" CommandName="Details" CommandArgument="CustomerCode" runat="server" />
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
Here is the code I am using to add a Label and TextBox to the header in Page_Load (when it is not a PostBack):
Label lblSearchCardNumber = new Label();
lblSearchCardNumber.Text = "Card Number<br />";
lblSearchCardNumber.CssClass = "headerlabel";
gvSearchResults.HeaderRow.Cells[1].Controls.Add(lblSearchCardNumber);
TextBox txtSearchCardNumber = new TextBox();
txtSearchCardNumber.Columns = 11;
txtSearchCardNumber.MaxLength = 11;
txtSearchCardNumber.CssClass = "headertextbox";
gvSearchResults.HeaderRow.Cells[1].Controls.Add(txtSearchCardNumber);
Everything works fine at this point (although I had to create a dummy DataSet to get the GridView to display initially). When the Search button is clicked I want to retrieve the values from the textboxes in the header to use as my search parameters. For some reason I cannot access the HeaderRow. What exactly am I doing wrong? I can access the Row information but not the HeaderRow?
protected void gvSearchResults_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "Search")
{
string searchCardNumber = "";
GridViewRow gvRow = gvSearchResults.HeaderRow;
searchCardNumber = ((TextBox)gvRow.FindControl("txtSearchCardNumber")).Text;
}
}
|
|
|
|
|
You have to recreated Lable and Textboxe in headertemplate when u click on button
Best Regard
Pathan
---------------------------------------------------
|
|
|
|
|
So when I add the TextBoxes they are lost during the postback? Is there any other way I can add them to make them persistant? I guess if there is not another way I will just remove them from the GridView. Thanks for your time.
|
|
|
|
|
You have to recreate controls in header template before using them.
but y u created at runtime?
best Regard
pathan
---------------------------------------------------
|
|
|
|
|
I created them at runtime because that was the only way I could figure out to create them and still use BoundFields. I assumed once they were created they would be persistant. I guess I could use ItemTemplates and HeaderTemplates for each field instead. Is there any reason not to use them instead of BoundFields? Thanks for your help. I am new to 2.0 and still trying to figure things out.
Edit: I just used code below and I can now access the value in the TextBox. Thanks for steering me in the right direction!
<asp:TemplateField>
<HeaderTemplate>
<asp:TextBox ID="txtCardNumber" Columns="11" MaxLength="11" runat="server"></asp:TextBox>
</HeaderTemplate>
<ItemTemplate>
<%# DataBinder.Eval(Container.DataItem, "CardNumber")%>
</ItemTemplate>
</asp:TemplateField>
-- modified at 8:29 Thursday 6th September, 2007
|
|
|
|
|
you mean to say ((TextBox)gvRow.FindControl("txtSearchCardNumber")).Text; is returning null ?
|
|
|
|
|
Yes.
divyesh1432 wrote: you mean to say ((TextBox)gvRow.FindControl("txtSearchCardNumber")).Text; is returning null ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
