Add GUIDs to new GUID column

Question

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

Kirtan Patel · Answer

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 : )

Sam Hobbs · Answer

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}
Name: {1}", ex.Message, r["Name"]); } } Connection.Close(); }

patrick · Answer

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

Kirtan Patel · Answer

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();

Add GUIDs to new GUID column

Answers (4)