|
Hi , I have a dataset with some 30 records in it. I want to update it to the database tables. which is the best method to update the table. I am unable to use dataadapter.update() since i am using a procedure to populate the dataset. is there any efficient...
Started by Jebli on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
The source for the....
Within an SP you can use UPDATE FROM statement.
Did you think of calling a stored-procedure...and passing your records as XML type input parameter?
Check this article for how to work with xml datatype introduced in SQL Server 2005 .
|
|
This is just for debugging purpose. We have an abused stored proc that takes for ever to return resultset. Optimizing the proc is out of question at this moment. Is it possible for me to store loaded dataset result some where so I dont have to keep calling...
Started by dotnet-practitioner on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The details of your stored proc, but I suggest modifying it to create a new result table.
|
|
I have a strongly-typed datatable and I search for a row by primary key (FyndBy) and them if the row exists I want to delete it. From a style perspective which of the methods below do you prefer?
MyDataRowType selectedRow = table.FindByTablePrimaryKey...
Answer Snippets (Read the full thread at stackoverflow):
Using the second will require the table to be searched twice and it is also to the row - that is, by using just 4 bytes you gain in not scanning the table again, which takes up a lot of resources (depending on table....
Absolutely the first.
|
Ask your Facebook Friends
|
I have a SQL Server 2005 output like this:
Date | Result | Sum | | 8/26 | 01 | 1549 8/26 | 02 | 7972 8/26 | 03 | 4502 8/27 | 01 | 1897 8/27 | 02 | 1649 8/27 | 03 | 7949 8/28 | 01 | 8542 8/28 | 02 | 5335 8/28 | 03 | 4445
and I want it to show up (in a ...
Started by d03boy on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Here is a MSDN article.
Of the data, that will allow you to get the exact structure you want.
|
|
How to draw the table in c#.net 2008.
or suggest any control as table?
i want to display the data in that table.
help me.
Started by nithi on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Use
GridView Control - if Windows forms DataGridView Control - if ASP.NET .
You can use DataGridView component.
|
|
Hi all,
I am trying to join tableA with some data to an empty set of another tableB. The main purpose is to get all the columns of tableB. I do not need any data of tableB.
I have constucted the following SQL:
SELECT uar.*, s.screen_id, s.screen_name
...
Started by Timothy Chung on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
I'm not too familiar.
Can you try the query with a different table to confirm this?
Try listing out all your columns explicitly and review all the data types - particular the second column of uar.
table.
|
|
I am using a web service to query data from a table. Then I have to send it to a user who wants it as a DataTable. Can I serialize the data? Or should I send it as A DataSet. I am new to Web Services, so I am not sure the best way to do it.
Started by Loganj99 on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
You can send the data as a xml string from a dataset by DataSet.GetXml()
And than.
Don't make for good data-types on web services if you want the service to be portable to other to do this.
|
|
I want to backup a table saving the copy in the same database with another name. I want to do it programatically using .NET 2.0 (preferably C#). Someone can point me what should I do?
Started by Jader Dias on
, 6 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
For large tables
This automatically....
The bulk copy operation in .Net is a very fast way to copy large amount of data somewhere to SQL]
This will create the backup table from scratch (an error will be thrown if it already exists).
|
|
I'm trying to get a handle on the amount of memory overhead associated with a .NET DataTable, and with individual DataRows within a table.
In other words, how much more memory does a data table occupy than what would be needed simply to store a properly...
Started by Nick on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Well, don't forget that a DataTable stores 2? 3? versions of the data - original and updated = new List<DataTable>(); for (int j = 0; j < 5000; j++) { DataTable table = new DataTable", i, "e"); } tables.Add(table); } Console....
|
|
We have an application that creates a number of Visual Foxpro (DBF) tables. Each of those tables have a different schema, but they all contain a known date field.
I've been asked to create another application (in C#) that will copy the last week's worth...
Answer Snippets (Read the full thread at stackoverflow):
Of the data, table, and records, you can do via a single SQL-Select via
OleDbConnection oConn = new AS A NEW TABLE, so no need to explicitly declare types, columns, etc, query data from one and push() { OleDbConnection oConn....
|
