Skip to content

Instantly share code, notes, and snippets.

@arbaaz
Created January 21, 2014 12:22
Show Gist options
  • Save arbaaz/8539042 to your computer and use it in GitHub Desktop.
Save arbaaz/8539042 to your computer and use it in GitHub Desktop.
Sql_connection
string connectionString = "Data Source=ARBAAZLPT\\SQLEXPRESS;Initial Catalog=bi;User ID=sa; Password=123456;";
SqlConnection sqlConnection=new SqlConnection(connectionString);
string insertStatement = "INSERT INTO comment(dashboard,userid,tab,comment,date,timestamp,chartdesc) VALUES ('" + DashboardList.SelectedValue + "','" + userid_text.Text + "','" + chartList.SelectedValue + "','" + coment_txt.Text + "','" + dt+ "', GETDATE(),'"+ chart_desc.Text + "')";
// string insertStatement = "INSERT INTO comment(dashboard,userid,tab,comment,date,chartdesc)VALUES ('mydashboard','myuserid','mytab','mycomment','02-20-1990','mychartdesc')";
SqlCommand sqlCommand=new SqlCommand(insertStatement,sqlConnection);
try
{
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
}
finally
{
sqlConnection.Close();
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment