ASP.NET

21-Jun-09 19:06

Hello,

I am using VS 2005

<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:ScriptManager id="ScriptManager1" runat="server">
        </asp:ScriptManager>
        <asp:UpdatePanel id="UpdatePanel1" runat="server" EnableViewState="False">
            <contenttemplate>
                <asp:TextBox ID="TextBox1" runat="server" Style="position: relative; top: 0px;"></asp:TextBox><br />
                <asp:Button ID="Button1" runat="server" OnClick="Button1_Click1" Style="position: relative"
                    Text="Next" />
                <asp:Button ID="Button2" runat="server" Style="position: relative" Text="Pevious" OnClick="Button2_Click" />
                <asp:Button ID="Button3" runat="server" Style="left: 0px; position: relative" Text="Update" OnClick="Button3_Click" /><br />
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" SelectCommand='SELECT * FROM "EMP"'>
                </asp:SqlDataSource>
</contenttemplate>
            <Triggers>
                <asp:AsyncPostBackTrigger ControlID="Button3" EventName="Click" />
            </Triggers>
        </asp:UpdatePanel>
                </div>
    </form>
</body>
</html>

And in the aspx.vb file i have code following:

Protected Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
MessageBox.Show(TextBox1.Text, "xx", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.DefaultDesktopOnly)
End Sub

but it is not showing me the current value (user chaged the value; when page comes on the browser) of the textbox; it is showing me the value which was at the time of page load.

After searching a lot on the net, i am posting the question here, to get the solution how to get the current/changed value of the textbox which is in the update panel; on click of the button.

Thanks & Regards
Girish Sharma

padmanabhan N21-Jun-09 19:35

21-Jun-09 19:35

plz check whether you have checked the page load in your page load event....
code in c#:
if (!IsPostBack)
{
//Code
}

Padmanabhan

Girish48121-Jun-09 19:53

21-Jun-09 19:53

in the page load event i have following code:

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Page.IsPostBack = False Then
Session("r") = 0
End If
'dv.Table.Rows(1)(1) = "xx"
showdata()
End Sub

Regards
Girish Sharma

padmanabhan N21-Jun-09 20:37

21-Jun-09 20:37

try to put the showdata() inside the post back. that is the error...
code:
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
If Page.IsPostBack = False Then
Session("r") = 0
'dv.Table.Rows(1)(1) = "xx"
showdata()
End If
End Sub

Padmanabhan

Girish48121-Jun-09 21:04

21-Jun-09 21:04

Thanks a lot padmanabhan N. It is working fine; but it is really new to me how it is working now; when page's postback event has been fired and i have following in showdata:
Public Sub showdata()
dv = CType(SqlDataSource1.Select(DataSourceSelectArguments.Empty), System.Data.DataView)
TextBox1.Text = dv.Table.Rows(Session("r"))(1).ToString()
End Sub

what is the relation with the postback's true/false?

I wish to thanks for providing the the answer and shall be more informative for the question i asked above please.

Best Regards
Girish Sharma

padmanabhan N21-Jun-09 22:19

21-Jun-09 22:19

with pleasure,
The postback is doing all the things. The loop your write inside the postback will fire only when the page is loaded and the value will be maintained and the loop wont be executed after that. So, if we write the code after the loop will be fired in even and every postback. just keep the breakpoint in the page load and check. You can see for each and every postback the pageload event is fired.

So each and every time the button click it fires the page load first and then the button event. So, the showdata() will clears your modification and the original data will be set. For this only you got the old values.
I hope you understand now.

Padmanabhan

Girish48121-Jun-09 23:39

21-Jun-09 23:39

padmanabhan N
Thank you so much for clearing doubts and nice explanation.

Best Regards
Girish Sharma

padmanabhan N22-Jun-09 0:03

.net database connectivity problem in visual studio

22-Jun-09 0:03

its ok, Happy coding..

Padmanabhan

Sundar 200921-Jun-09 18:52

Sundar 2009

21-Jun-09 18:52

i am unable to connect database to my web page in visual studio. i have created a separate web form in my project. i add an sqlDataSource from the tool box . i just entered into configure data source option and created a new connection. i got an add connection pop up window in which i have selected sqlexpress as my server. i have selected my database name and when i click ok i am getting an error as follows

object reference not set to an instance of an object

Re: .net database connectivity problem in visual studio

padmanabhan N21-Jun-09 19:01