Add GUIDs to new GUID column

patrick

17y4.2kVisual Basic .NET

I recently added a GUID column to an employee table. How can I programmatically add GUIDs to these columns?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Kirtan Patel17y ago
Friend ,

then Set Column Property Like below in Database so that 20 employee will have new ID Automatically

check "Do you like this answer check box" if my answer helps you :)

0
Sam Hobbs17y ago
SqlConnection Connection;
DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlParameter p;
try
{
Connection = new SqlConnection(
Properties.Settings.Default.ConnectionStringSetting);
da.SelectCommand = new SqlCommand("Select Id, Name From Emp", Connection);
da.UpdateCommand = new SqlCommand("Update Emp Set Id = @Id Where Name = @Name", Connection);
p = new SqlParameter("@Id", SqlDbType.UniqueIdentifier);
da.UpdateCommand.Parameters.Add(p);
p = new SqlParameter("@Name", SqlDbType.NChar, 10);
da.UpdateCommand.Parameters.Add(p);
Connection.Open();
da.Fill(dt);
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
return;
}
foreach (DataRow r in dt.Rows)
{
Console.WriteLine("{0} {1}", r["Id"], r["Name"]);
da.UpdateCommand.Parameters[0].Value = Guid.NewGuid();
da.UpdateCommand.Parameters[1].Value = r["Name"];
try { da.UpdateCommand.ExecuteNonQuery(); }
catch (Exception ex)
{
Console.WriteLine("Update error: {0}\r\nName: {1}", ex.Message, r["Name"]);
}
}
Connection.Close();
}
0
patrick17y ago
this is only going to add one, right? There are about 20 existing rows, and I have added the column, I just need to populate the new, empty GUID column so that existing employees will now have a GUID
0
Kirtan Patel17y ago
Friend,

Here is Coding How to Do it

please check "Do you like this answer checkbox if it helps you" :)

Guid x = Guid.NewGuid();

            SqlConnection con = new SqlConnection("Your Connection String ");

            con.Open();

            SqlCommand comm = new SqlCommand("insert into TableName(YourGUIDColumn) values(@guidValue)",con);

            comm.Parameters.AddWithValue("@guidValue", x);

            comm.ExecuteNonQuery();

            con.Close();

0