Guest User

Untitled

a guest
May 26th, 2018
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. Warning 1 Field 'abc.Form1.ds' is never assigned to, and will always have its default value null
  2.  
  3. using (SqlConnection connection = new SqlConnection(ConnStr))
  4. {
  5. connection.Open();
  6. adapter = new SqlDataAdapter(sql, connection);
  7. commandBuilder = new SqlCommandBuilder(adapter);
  8. adapter.InsertCommand = new SqlCommand("sp_CreateUser", connection);
  9. adapter.InsertCommand.CommandType = CommandType.StoredProcedure;
  10. adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ппп", SqlDbType.Text, 50, "тип ппп"));
  11. adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ффф", SqlDbType.Text, 0, "тип ффф"));
  12. adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ззз", SqlDbType.Text, 50, "тип ззз"));
  13. adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ммм", SqlDbType.Text, 0, "тип ммм"));
  14. adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип ккк", SqlDbType.Text, 50, "тип ккк"));
  15. adapter.InsertCommand.Parameters.Add(new SqlParameter("@тип щщщ", SqlDbType.Text, 0, "тип щщщ"));
  16.  
  17. SqlParameter parameter = adapter.InsertCommand.Parameters.Add("@№ азс", SqlDbType.NChar, 10, "№ азс");
  18. parameter.Direction = ParameterDirection.Output;
  19.  
  20. adapter.Update(ds);
  21.  
  22. public partial class Form1 : Form
  23. {
  24. DataSet ds;
  25. ...
  26. string sql = "SELECT * FROM [Азс1]";
  27.  
  28. namespace station
  29. {
  30. public partial class Form1 : Form
  31. {
  32.  
  33. DataSet ds;
  34. SqlDataAdapter adapter;
  35. SqlCommandBuilder commandBuilder;
  36. string ConnStr = @"Data Source=.SQLEXPRESS;AttachDbFilename=C:123base.mdf;Integrated Security=True;User Instance=True";
  37. //Выбор всего из
  38. string sql = "SELECT * FROM Азс";
Add Comment
Please, Sign In to add comment