Mobile

Deepali Khalkar wrote:

SqlCeParameter para = new SqlCeParameter();
para.ParameterName = "@uname";
para.Value = textBox1 .Text ;
comm.Parameters.Add(para);
para.ParameterName = "@psw";
para.Value = textBox2 .Text ;
comm.Parameters.Add(para);
para.ParameterName = "@fname";
para.Value = textBox3 .Text ;
comm.Parameters.Add(para);
para.ParameterName = "@lname";
para.Value = textBox3 .Text ;
comm.Parameters.Add(para);

<br />
SqlCeParameter para1 = new SqlCeParameter();<br />
para1.ParameterName = "@uname";<br />
para1.Value = textBox1 .Text ;<br />
comm.Parameters.Add(para1);<br />
<br />
SqlCeParameter para2 = new SqlCeParameter();<br />
para2.ParameterName = "@psw";<br />
para2.Value = textBox2 .Text ;<br />
comm.Parameters.Add(para2);<br />
<br />
SqlCeParameter para3 = new SqlCeParameter();<br />
para3.ParameterName = "@fname";<br />
para3.Value = textBox3 .Text ;<br />
comm.Parameters.Add(para3);<br />
<br />
SqlCeParameter para4 = new SqlCeParameter();<br />
para4.ParameterName = "@lname";<br />
para4.Value = textBox3 .Text ;<br />
comm.Parameters.Add(para4);

private int GetRowCount()
{
            int intCount = 0;
            SqlCeConnection objCon = new SqlCeConnection("ConnectionString");
            objCon.Open();
            SqlCeCommand objCmd = new SqlCeCommand("SELECT COUNT(*) AS UserCount FROM  Users", objCon);
            intCount = System.Convert.ToInt32( objCmd.ExecuteScalar().ToString());
            objCon.Close();
            objCmd.Dispose();

            return intCount;
}