ASP.NET

<br />
void button1_click (object sender , EventArgs e)<br />
{<br />
    Response.Redirect("page2.aspx?username="+textbox1.text+"&password="+textbox2.text);<br />
}<br />

<br />
void Page_Load(object sender , EventArgs e)<br />
{<br />
    if(Request.QueryString["username"] != null && Request.QueryString["password"] != null)<br />
{<br />
        //do something with those querystring values <br />
        string username = Request.QueryString["usename"];<br />
        string  password = Request.QueryString["password"];<br />
}<br />
<br />
}<br />

<br />
Dim CurrentMaxDocumentIDForASpecificUser As Integer<br />

<br />
Dim CurrentMaxDocumentIDForASpecificUser As Integer<br />
<br />
CurrentMaxDocumentIDForASpecificUser = (int)SqlCommand.ExecuteScalar();<br />
<br />
if(CurrentMaxDocumentIDForASpecificUser > 0)<br />
//there was a record returned <br />
else<br />
//there was no any records returned back<br />

<br />
Private Sub GetMaxDocumentIDForASpecificUser()<br />
<br />
        Dim Get_MaxDocumentIDForASpecificUser_StrSQL As String<br />
        Dim Get_MaxDocumentIDForASpecificUser_ObjCmd As SqlCommand<br />
<br />
<br />
        Dim strConn As String = ConfigurationManager.ConnectionStrings("HomeConnectionString").ToString()<br />
<br />
        Dim MyCon As SqlConnection<br />
        MyCon = New SqlConnection(strConn)<br />
<br />
        Get_MaxDocumentIDForASpecificUser_StrSQL = "Select max(DocumentID) from UploadedDocuments where Owner='" & Trim(Session("CurrentlyLogedinUserName")) & "'"<br />
<br />
        MyCon.Open()<br />
<br />
        Get_MaxDocumentIDForASpecificUser_ObjCmd = New SqlCommand(Get_MaxDocumentIDForASpecificUser_StrSQL, MyCon)<br />
<br />
        CurrentMaxDocumentIDForASpecificUser = Get_MaxDocumentIDForASpecificUser_ObjCmd.ExecuteScalar<br />
<br />
        If CurrentMaxDocumentIDForASpecificUser Is DBNull.Value Then<br />
<br />
            CurrentMaxDocumentIDForASpecificUser = 0<br />
        Else<br />
<br />
        End If<br />
<br />
        MyCon.Close()<br />
    End Sub<br />

Get_MaxDocumentIDForASpecificUser_StrSQL = "Select max(isnull(DocumentID,0)) from UploadedDocuments where Owner='" & Trim(Session("CurrentlyLogedinUserName")) & "'"<br />

Trishul Tandel wrote:

reply soon