Spam and Abuse Watch

Solution #5: Posted 22-Jul-13 16:25pm

SqlConnection vcon = new SqlConnection(ConfigurationManager.ConnectionStrings["BBAConnectionString1"].ToString());
Vcon.Open();
SqlCommand cmd = new Sqlcommand (select phonenumber from Tablename,Vcon);
label1.Text = Convert.ToString(cmd.ExcuteScalar());
Vcon.Close();

Solution #7: Posted 3hrs 15mins ago

sqlconnection con = new sqlconnection(Data source=.; initial catalog= Your database name; User ID= ; password=
con.open();
SqlCommand cmd = new Sqlcommand (select phonenumber from Tablename,con);
label1.Text = Convert.ToString(cmd.ExcuteScalar());
con.Close();