what else would I use besides data sets and data tables to bind the information on with a data adapter?

also figured out how do the insert with details view

protected void function2(object sender, DetailsViewInsertEventArgs e)
{
SqlDataAdapter adapt = new SqlDataAdapter();
SqlConnection connect = new SqlConnection();
connect.ConnectionString = ConfigurationManager.ConnectionStrings["PlanetWroxConnectionString1"].ConnectionString;
SqlCommand command = new SqlCommand();
DataTable table = new DataTable();

command = new SqlCommand("INSERT INTO Genre (Name, SortOrder) VALUES (@Name, @SortOrder)");
command.Parameters.Add("@Name", SqlDbType.NVarChar, 200);
command.Parameters["@Name"].Value = e.Values["Name"].ToString();
command.Parameters.Add("@SortOrder", SqlDbType.Int);
command.Parameters["@SortOrder"].Value = e.Values["SortOrder"].ToString();

command.Connection = connect;

adapt.InsertCommand = command;
connect.Open();
adapt.InsertCommand.ExecuteNonQuery();
connect.Close();
command = new SqlCommand("SELECT * FROM Genre", connect);
adapt.SelectCommand = command;
adapt.Fill(table);

GridView1.DataSource = table.DefaultView;
GridView1.DataBind();

adapt.Dispose();
command.Dispose();
connect.Dispose();
}

used the wrong type of event arguments, but im slightly stuck on the gridview deleting a row, mainly because I don't know how to grab the value of the selected row Id and how to deal between onrowdeleting and onrowdeleted.

Once again: have you looked into Model Binding as I suggested earlier? With Model Binding your delete method simply gets passed the ID of the item to be selected.

That said, you should be able to retrieve the key using something like this:

Not much ;-) But you don't need a data adapter at all. A lot of the code you're posting is "old skool" in my opinion. The things you're doing here are a lot easier with, say, Entity Framework and Model Binding. That way you can focus on your business problems and not spend a lot of time writing boring code to set up parameters and such.

Cheers,

Imar

__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!