Ошибка conversion failed when converting from a character string to uniqueidentifier

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

System.Data.SqlClient.SqlException произошло
  HResult=-2146232060
  Message=Conversion failed when converting from a character string to uniqueidentifier.
  Source=.Net SqlClient Data Provider
  ErrorCode=-2146232060
  Class=16
  LineNumber=1
  Number=8169
  Procedure=""
  Server=(LocalDB)v11.0
  State=2
  StackTrace:
       в System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       в System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
       в System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
       в System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
       в System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async, Int32 timeout, Boolean asyncWrite)
       в System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite)
       в System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
       в WindowsFormsApplication1.reg.button1_Click(Object sender, EventArgs e) в d:Program Filestest c#1WindowsFormsApplication1WindowsFormsApplication1reg.cs:строка 26
  InnerException:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32

namespace WindowsFormsApplication1
{
    public partial class reg : Form
    {
        SqlConnection con = new SqlConnection(@"Data Source=(LocalDB)v11.0;AttachDbFilename=D:Program Filestest c#1WindowsFormsApplication1WindowsFormsApplication1Data.mdf;Integrated Security=True;Connect Timeout=30;");
        public reg()
        {
            InitializeComponent();
        }
 
        private void button1_Click(object sender, EventArgs e)
        {
            con.Open();
            SqlDataAdapter sda = new SqlDataAdapter("insert into LOGIN (Id,login,pasword,status)values('"+textBox1.Text+"','"+textBox2.Text+"','"+textBox3.Text+"','"+textBox4.Text+"')",con);
            sda.SelectCommand.ExecuteNonQuery();// тут ошибку выдаёт
            con.Close();
 
            MessageBox.Show("Регестрация прошла успешно");
            con.Close();
            
        }
       public static void main(string[] args)
       {
           Application.Run(new reg());
       }
 
       private void reg_Load(object sender, EventArgs e)
       {
 
       }
    }
}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

const string CONNECTION_STRING = @"Data Source=(LocalDB)v11.0;AttachDbFilename=D:Program Filestest c#1WindowsFormsApplication1WindowsFormsApplication1Data.mdf;Integrated Security=True;Connect Timeout=30;";
 
private void button1_Click(object sender, EventArgs e)
{
    using (var con = new SqlConnection(CONNECTION_STRING))
    {
        var cmd = new SqlCommand("insert into LOGIN (Id,login,pasword,status) values(NEWID(),@login,@password,@status)", con);
        cmd.Parameters.AddWithValue("@login", textBox2.Text);
        cmd.Parameters.AddWithValue("@password", textBox3.Text);
        cmd.Parameters.AddWithValue("@status", textBox4.Text);
        con.Open();
        cmd.ExecuteNonQuery();
    }
    MessageBox.Show("Регестрация прошла успешно");
}