Friday, April 17, 2015

SQL connection and command

s = System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        SqlConnection c = new SqlConnection(s);
        c.Open();
        SqlCommand cmd = new SqlCommand("insert into sample(name) values(@name)", c);
        cmd.Parameters.Add("@name", TextBox1.Text);
        cmd.ExecuteNonQuery();
        c.Close();

Local Database Connection in ASP

Web.config:

Data Source=.\SQLEXPRESS;AttachDbFilename="C:\Documents and Settings\Anvesh\My Documents\Visual Studio 2010\WebSites\WebSite2\App_Data\Database.mdf";Integrated Security=True;User Instance=True


s= System.Configuration.ConfigurationManager.ConnectionStrings["con"].ConnectionString;
        SqlConnection c = new SqlConnection(s);
        c.Open();