How to get GUID from a row

Question

i tried to cast it, it throws an error. This is the row definition
ID UniqueIdentifier NOT NULL
this is the cast
empGUID = (Guid)rstEmployees.Fields["ID"].Value;
Would it make sense to anyone that it worked last night and stopped working today...I dont even think anything changed.

Kirtan Patel · Answer

Try Following Coding For Retriving and Inserting GUID private void button1_Click(object sender, EventArgs e) { // Insert GuiD in Database Guid c = Guid.NewGuid(); textBox1.Text = c.ToString(); SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database1.mdf;Integrated Security=True;User Instance=True"); con.Open(); SqlCommand comm = new SqlCommand("insert into users(id) values('"+c.ToString()+"')",con); comm.ExecuteNonQuery(); //Show Inserted GUID in DataGridView SqlCommand comm2 = new SqlCommand("select * from users",con); SqlDataAdapter da = new SqlDataAdapter(comm2); DataSet ds = new DataSet(); da.Fill(ds,"v"); dataGridView1.DataSource = ds.Tables[0]; //Retrive the Guid In MessageBox SqlCommand comm3 = new SqlCommand("select * from users",con); SqlDataReader reader = comm3.ExecuteReader(); while (reader.Read()) { Guid x = (Guid)(reader["id"]); MessageBox.Show(x.ToString()); } }

Kirtan Patel · Answer

Datatype of ID Field is GUID

patrick · Answer

Thanks, makes more sense when everything is converted to string. What would the datatype of the id field be, Guid or text?

patrick · Answer

I realized it is less sloppy to not grab the key anyway, it works better if I just work with the other fields. Thanks for trying though.

patrick · Answer

It doesnt work and I know it should. I noticed that before the GUID goes into the database, it is fine, but after i retrieve it, it has {} surrounding it. Could this be the issue? why are they being added?

Kirtan Patel · Answer

empGUID = (Guid) ( rstEmployees.Fields["ID"].Value ) ;

How to get GUID from a row

Answers (6)