C#

srinivassam wrote:

Requirement is upto 34 questions the data stored like int after that means 35 and 36 questions(feedback question )data is stored as a string.

SqlCommand sql_cmd = new SqlCommand("insert into Info values(@id,@name,@age)");
            sql_cmd.Parameters.Add("@id", SqlDbType.Int);
            sql_cmd.Parameters.Add("@name", SqlDbType.NVarChar);
            sql_cmd.Parameters.Add("@age", SqlDbType.Int);

            sql_cmd.Parameters["@id"].Value = int.Parse(textBox1.Text);
            sql_cmd.Parameters["@name"].Value = "Aman";
            sql_cmd.Parameters["@age"].Value = 23;

            sql_cmd.ExecuteNonQuery();

humdumof wrote:

is there any way by which i can pick a file

<br />
string path = @"D:\file.txt";<br />
<br />
if (File.Exists(path))<br />
            {<br />
                using (StreamReader sr = new StreamReader(path))<br />
                {<br />
                    textBox1.Text = sr.ReadToEnd();<br />
                    sr.Close();<br />
                }<br />
                using (StreamWriter sw = new StreamWriter(@"D:\newfile.txt"))<br />
                {<br />
                    sw.WriteLine(textBox1.Text);<br />
                    sw.Close();<br />
                }<br />
            }<br />
            else<br />
            {<br />
                MessageBox.Show("File does not exist.");<br />
            }<br />

try {
	SqlConnection con = new SqlConnection("connectionstring");
	string sqlQuery = "select user,pwd from Login where user= ' " + this.TextBox1.Text + " ' and pwd=' " + this.TextBox2.Text + " ' ";
	con.Open();
	SqlCommand com = new SqlCommand(sqlQuery, con);
	int results = com.ExecuteScalar;
	if (results == 1)
	{
		return true;
	}
	else
	{
		return false;

	}
	con.Close();
	com.Dispose();
}
catch (SqlException ex) {
	MessageBox.Show(ex.ToString);
}