next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » .NET
 How to Add Row to datatable through C#?

[shefeekj]

shefeekj  

 How to Add Row to datatable through C#?

Here is the code in C#.net which can be used to add rows dynamically to a datatable. This datatable can be made the sourse of a data grid to display the dynamically added row.

Code:

DataTable dt = new DataTable();

DataRow dr = dt.NewRow();

dr["Option"] = txt_Opt.Text;

dt.Rows.Add(dr);

dg_Opt.DataSource = dt;

[polas]

polas  

 Re: How to Add Row to datatable through C#?

Cheers for posting it - when you say datatable, do you mean database?

[shefeekj]

shefeekj  

 Re: How to Add Row to datatable through C#?

No..data table is actually a datatype in c#.net and vb.net to hold the data returned by a query

[polas]

polas  

 Re: How to Add Row to datatable through C#?

Ah right, thanks for the clarification

[singam]

singam  

 Re: How to Add Row to datatable through C#?

Are you sure the values arent being saved or is the problem that you are not recalling them properly? I don't see any problem with the saving part, the recall is no good though. For one you are putting the insert statement into the adapters select command, secondly you are setting the textbox text values to an empty string after your attempt at loading the values (""). I cleaned up the code a bit using better practices and it should work:

Code:

Using Connection As New SqlClient.SqlConnection("Data Source=.\SQLEXPRESS;AttachDbFilename=|Da… Security=True;User Instance=True")
Connection.Open()

Using Command As New SqlClient.SqlCommand("INSERT INTO [users] (@Val1, @Val2)", Connection)
Command.Parameters.Add(New SqlClient.SqlCommand("@Val1", textbox1.text))
Command.Parameters.Add(New SqlClient.SqlCommand("@Val2", textbox2.text))
Command.ExecuteNonQuery()
End Using

[Admin]

Admin  

 Re: How to Add Row to datatable through C#?

@singam: The code posted by shefeekj, is for adding a new row in the DataTable and not in Database Table.

In C#.Net, DataTables are part of DataSet which is used for disconnected architecutre of dealing with database. Once connected to the database you can fetch required data in the DataSet. The fetched data is saved in form of DataTable inside DataSet. DataTables are carbon copy [table structure wise] of Tables  from which we fetch the data. Once the data is saved in the DataSet--> DataTable we can close the database connection.

Now, we have DataSet ---> DataTable.

We can perform any data related operation [add/edit/delete] in this DataTables and once done, we can again connect to the database and update database with our DataTables.

[singam]

singam  

 Re: How to Add Row to datatable through C#?

To specify a column as AutoIncrement (naturally it should be an integer type of field only), you need to set some properties of the column like AutoIncrement, AutoIncrementSeed. See the code below, here I am setting the first column "AutoID" as autoincrement field. Whenever a new row will be added its value will automatically increase by 1 as I am specified AutoIncrementSeed value as 1.

// specify it as auto increment field

auto.AutoIncrement = true;

auto.AutoIncrementSeed = 1;

auto.ReadOnly = true;
=================

seo | link building

[mak14317]

mak14317  

 Re: How to Add Row to datatable through C#?

Declare a new instance of the typed dataset. then , you declare a new instance of the Customers  Row class, assign it a new row, populate the columns with data, and add the new row to the Customers table's Rows collection:

[johnpitter]

johnpitter  

 Re: How to Add Row to datatable through C#?

Thanx for sharing.. It will be helpful to other people also

[dotnetword]

dotnetword  

 Re: How to Add Row to datatable through C#?

Here is the code in C#. net which can be used to add rows dynamically to a datatable.

Code:

using System;
using System. Data;
using System. Data. SqlClient;

class ModifyDataTable
{
   static void Main(string[] args)
   {
      string connString = @"server = . \sqlexpress;integrated security = true;database = northwind";

      string sql = @"select * from employee where country = 'UK'";

      SqlConnection conn = new SqlConnection(connString);

      try
      {
         SqlDataAdapter da = new SqlDataAdapter();
         da. SelectCommand = new SqlCommand(sql, conn);

         DataSet ds = new DataSet();
         da. Fill(ds, "employees");

         DataTable dt = ds. Tables["employees"];

         dt. Columns["firstname"]. AllowDBNull = true;

         dt. Rows[0]["city"] = "w";

         DataRow newRow = dt. NewRow();
         newRow["firstname"] = "R";
         newRow["lastname"] = "B";
         newRow["titleofcourtesy"] = "Sir";
         newRow["city"] = "B";
         newRow["country"] = "USA";
         dt. Rows. Add(newRow);

         foreach (DataRow row in dt. Rows)
         {
            Console. WriteLine("{0} {1} {2}",
               row["firstname"]. ToString(). PadRight(15),
               row["lastname"]. ToString(). PadLeft(25),
               row["city"]);
         }
      }
      catch(Exception e)
      {
         Console. WriteLine("Error: " + e);
      }
      finally
      {
         conn. Close();
      }
   }
}