Jagjit Saini

Jagjit Saini

  • NA
  • 166
  • 0

Connection String Error

Sep 2 2011 3:15 AM

Hi

 public partial class Form1 : Form
    {
        string ConnectionString = ConfigurationSettings.AppSettings["cnn"];
        string str;

        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
           
        }

        private void Btn_Click_1(object sender, EventArgs e)
        {
            SqlConnection con = new SqlConnection(ConnectionString);
            con.Open();
            str = "select count(*) from temp where usrname='" + txtusername.Text.Trim() + "' and usrpassword='" + txtpassword.Text.Trim() + "'";
            SqlCommand cmd = new SqlCommand(str, con);
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds, "login");

            long x;
            x = Convert.ToInt64(cmd.ExecuteScalar());
            if (x == 1)
            {
                MessageBox.Show("Hello");
            }
            else
            {
                MessageBox.Show("Invalid UserName & Password");
            }
            con.Close();
        }
    }


Error : The connectionstring property has not been initialised.



App.Config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <add name="cnn"
         connectionString="Persist Security Info=False;
         Data Source=localhost;
         Initial Catalog=ha;
         Integrated Security=SSPI;
         Trusted_Connection=TRUE;" />
  </connectionStrings>
</configuration>

Thanks


Answers (3)