What is use of Row State properties in ADO.NET.

Question

Hi............. I am create a table frontend and I want to used the Row State properties in a operation of table. please clarify all Row State propertie ?

Satyapriya Nayak · Answer

Hi Manish, Untitled Page How to use DataRow RowState Property in ado.net ID="GridView1" runat="server" BorderColor="Snow" ForeColor="Snow" Width="525" > ID="Label1" runat="server" Font-Size="Large" ForeColor="DodgerBlue" Font-Italic="true" > ID="Label2" runat="server" Font-Size="Large" ForeColor="DodgerBlue" Font-Italic="true" > ID="GridView2" runat="server" BorderColor="Snow" ForeColor="Snow" Width="525" ShowHeaderWhenEmpty="true" > ID="Label3" runat="server" Font-Size="Large" ForeColor="DodgerBlue" Font-Italic="true" > ID="GridView3" runat="server" BorderColor="Snow" ForeColor="Snow" Width="525" ShowHeaderWhenEmpty="true" > ID="Button1" runat="server" OnClick="Button1_Click" Text="Populate GridView" Height="45" Font-Bold="true" ForeColor="DodgerBlue" /> using System; using System.Configuration; using System.Data; using System.Linq; using System.Web; using System.Web.Security; using System.Web.UI; using System.Web.UI.HtmlControls; using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts; using System.Xml.Linq; public partial class _Default : System.Web.UI.Page { protected void Button1_Click(object sender, EventArgs e) { DataTable dt = new DataTable(); dt.TableName = "Books"; DataColumn dc2 = new DataColumn(); dc2.ColumnName = "BookName"; dc2.DataType = typeof(string); DataColumn dc3 = new DataColumn(); dc3.ColumnName = "Author"; dc3.DataType = typeof(string); dt.Columns.AddRange(new DataColumn[] { dc2, dc3 }); dt.Rows.Add(new object[] { "Drupal Intranets with Open Atrium", "Tracy Smith" }); dt.Rows.Add(new object[] { "Drupal 7 First Look", "Mark Noble" }); dt.AcceptChanges(); GridView1.DataSource = dt; GridView1.DataBind(); DataRow dr = dt.NewRow(); Label1.Text = "Now we make a new row...."; Label1.Text += " RowState: " + dr.RowState.ToString(); dt.Rows.Add(dr); Label2.Text = "Now we add new row to table...."; Label2.Text += " RowState: " + dr.RowState.ToString(); dt.AcceptChanges(); GridView2.DataSource = dt; GridView2.DataBind(); dr["BookName"] = "Drupal 6 Search Engine Optimization"; dr["Author"] = "Ben Finklea"; Label3.Text += "Now we edit the row ...."; Label3.Text += " RowState: " + dr.RowState.ToString(); GridView3.DataSource = dt; GridView3.DataBind(); } } Thanks If this post helps you mark it as answer

Vulpes · Answer

This link lists all the possible values for the DataRow.RowState property which has a type of DataRowState: http://msdn.microsoft.com/en-us/library/system.data.datarowstate.aspx

What is use of Row State properties in ADO.NET.

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)