Guest
iConst
SanSYS
Спасибо. Почитала msdn, в итоге - код:
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
string connStr = ConfigurationManager.ConnectionStrings["<имя таблицы>"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
conn.Open();
string cmdText = "INSERT INTO <имя таблицы> (Title, Date, Location) VALUES (@Title, @Date, @Location)";
SqlCommand cmd = new SqlCommand(cmdText, conn);
SqlParameter p = cmd.CreateParameter();
p.ParameterName = "@Title";
p.Value = this.TextBox1.Text;
cmd.Parameters.Add(p);
cmd.Parameters.Add("@Date", SqlDbType.NChar).Value = this.TextBox2.Text;
cmd.Parameters.Add("@Location", SqlDbType.NChar).Value = this.TextBox3.Text;
cmd.ExecuteNonQuery();
conn.Close();
Но выдает ошибку:
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
Source Error:
Line 34: protected void Button1_Click(object sender, EventArgs e)
Line 35: {
Line 36: string connStr = ConfigurationManager.ConnectionStrings["Events"].ConnectionString;
Line 37: SqlConnection conn = new SqlConnection(connStr);
Line 38: conn.Open();
Вроде все библиотеки и reference подключила или это не с этим может быть связано?
