Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Warning 1 Field 'abc.Form1.ds' is never assigned to, and will always have its default value null
- using (SqlConnection connection = new SqlConnection(ConnStr))
- {
- connection.Open();
- adapter = new SqlDataAdapter(sql, connection);
- commandBuilder = new SqlCommandBuilder(adapter);
- adapter.InsertCommand = new SqlCommand("sp_CreateUser", connection);
- adapter.InsertCommand.CommandType = CommandType.StoredProcedure;
- adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ппп", SqlDbType.Text, 50, "тип ппп"));
- adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ффф", SqlDbType.Text, 0, "тип ффф"));
- adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ззз", SqlDbType.Text, 50, "тип ззз"));
- adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ммм", SqlDbType.Text, 0, "тип ммм"));
- adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ккк", SqlDbType.Text, 50, "тип ккк"));
- adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип щщщ", SqlDbType.Text, 0, "тип щщщ"));
- SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@№ азс", SqlDbType.NChar, 10, "№ азс");
- parameter.Direction = ParameterDirection.Output;
- adapter.Update(ds);
- public partial class Form1 : Form
- {
- DataSet ds;
- ...
- string sql = "SELECT * FROM [Азс1]";
- namespace station
- {
- public partial class Form1 : Form
- {
- DataSet ds;
- SqlDataAdapter adapter;
- SqlCommandBuilder commandBuilder;
- string ConnStr = @"Data Source=.SQLEXPRESS;AttachDbFilename=C:123base.mdf;Integrated Security=True;User Instance=True";
- //Выбор всего из
- string sql = "SELECT * FROM Азс";
Add Comment
Please, Sign In to add comment