i don't have table in database. i need to create table and insert my data table values to database at a single hit.i am creating data table at front end and i want to insert into database at single hit to the database. is it possible to do?
following is my code to update my database from a datatable. My rows are manipulated by my code perfectly. that i can see in my gridview but my database is not getting updated according to the manipulation
I have a form where users upload a file (csv), then the server does some processing, and generates a datatable. the table will be shown in grid. however, the table's column is unknown, and sometimes, the table is huge. I need show this table in another form.
It seems session variable is not good for this since the table maybe huge. is there a way to write this table to sql, then load it again in the other form?
If I have a DataTable (in-memory) read by my C# program from a flat file, and I want to create it as a new table in a SQL Server database... what is the simplest way to do that?
It seems like something like SqlBulkCopy with an option to create a new destination SQL server table would be on my line of thinking, but I dont see a way.
I have a products table with 3 fields name, price and quantity, I need to fill a datatable with those 3 fields and using a foreach build a chain. I build my chain currently using a datagrid with my following code
this code work good.
string item_name; string amount; string quantity;
[Code]....
but I like to form my chain directly from datatable, not rely on a datagrid.
i have the dataset with one table.Table contains three column like 'Name','Location','Pin'.I would like to move the data from another table based on schema.
If I am passed a datatable and I cant change the column structure..is there anyway to set an existing column to a Primary key so I can easily Find() the row I am looking for?
im trying to copying specific record from one datatable to another datatable i used below code
public System.Data.DataTable selectspecificdatarow(System.Data.DataTable dtg, int count, int startindex) { System.Data.DataTable dtn = dtg.Clone(); for (int i =startindex; i < count; i++)
[Code]....
its taking too long time in cloneing is there any better way to do this task which is Time effecent
how to join two datatable datas into one datatable to show in one gridview
i.e in 1 datatable i have username and pwd and in another datatable i have that user details. how to show all these in one datatable to get those values display in gridview(asp.net)
Dim dt As New DataTable Dim da As New SqlDataAdapter(s, c)
c.Open() if Not IsNothing(da) Then da.Fill(dt)
[code]...
When I call da.fill I am inserting all records from my query. I was then hoping to filter them to display only those where the GroupingID is equal to 0. When I run the above code. I am presented with all the data, the filter did not work. Please can you tell me how to get this working correctly.
I have a DataTable of available time slots. I have another DataTable of reserved time slots. I need to remove from the list of available slots the ones that have been reserved. The blocks are in 15 minute increments, but one of my problems is that the reservation can be longer than 15 minutes. I've had some luck removing one or two, but not all of the required columns.
I have two datatables, I want to get all records which are in one datatable but all matching records which exist in another datatable should not be available.
In terms of set, you can say that record which are in 1st datatable but not in 2nd DataTable.