ASP.NET

SqlCommand cm = new SqlCommand("select count(*) from myusers where username= @usrnm and password=@password",cn);

cm.Parameters.Add("@usrnm", SqlDbType.NVarChar).Value = textBox1.Text;
cm.Parameters.Add("@password", SqlDbType.NVarChar).Value = textBox2.Text;

aratireddy wrote:

initially i created a table and inserted some data and connected to that table. i took 2 labels and 2 textboxes and a button. one for username and one more for password . in button_click i wrote the code as following

string something = Gridview1.SelectedRow.Cells[0].Text;

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {
        GridViewRow row = GridView1.Rows[GridView1.SelectedIndex];
        string strValCell = row.Cells[2].Text;
    }

//and 

public void GridView1_SelectedIndexChanged(Object sender, EventArgs e)
    {
      
        TextBox1.Text = GridView1.SelectedRow.Cells[2].Text; 
    }  

public void GridView2_SelectedIndexChanged(Object sender, EventArgs e)
    {
                TextBox tb = GridView1.SelectedRow.FindControl("id0") as TextBox;
        if (tb != null)

         TextBox1.Text = tb.Text;

        else
           TextBox1.Text = "no data";
       
    }

<columns>
            
                <asp:templatefield xmlns:asp="#unknown">
                    <edititemtemplate>
                        <asp:textbox id="id0" runat="server" text="<%# Bind("c1") %>"></asp:textbox>
                    </edititemtemplate>
                    <itemtemplate>
                        <asp:label id="id01" runat="server" text="<%# Bind("c1") %>"></asp:label>
                    </itemtemplate></asp:templatefield></columns>