Title says it all. What is the difference between a DataSource and DataAdapter? I'm trying to decide if I should descend from IDataSource or IDataAdapter for code to be shared between Winforms and WebForms and I can't seem to figure out what the difference is other than slightly different ways to use them.
View 1 Replies
How could I add parameters on dataadapter? I tried
[Code]....
But parameters is unknown for dataadapter.
public static DataSet GetSubCategories(int category_id)
View 4 Repliesi'm tring to read data from a sql DB, where is email == mystring - then display its name here is the code:
string mystring;
mystring = "email@email.com";//"Welcome " + System.Convert.ToString(Session["user"]);
generalTableTableAdapters.kurtula_generalTableAdapter generals = new
generalTableTableAdapters.kurtula_generalTableAdapter();
generalTable.kurtula_generalDataTable genaraltab = generals.Getgeneral();
foreach (DataRow row in genaraltab.Rows)
{
if (Convert.ToString(row["email"])== user)
{
Label1.Text = System.Convert.ToString(row["name"]);
}
}
as you can see I'm a table adapter but is giving me the following error: i realy dont know what this error means - though i did a simular action using access DB (and it did work), where i had to user the following: using System.Data.OleDb; now because im using SQL DB im using: using System.Data.SqlClient; //sql server
i am having a datatable with 10 rows.
Out of this 10 rows 3 Rows have their RowState as Added, 2 rows as Modified, and 4 as Deleted.
Now i want to use Datadapter's InsertCommand, UpdateCommand and DeleteCommand
Is it possible to update datatable's changes to Database with Single DataAdpater.Update(DataTable) Call.
Means i will call DataAdapter.Update(DataTable) method only once and with this all new added rows should be inserted in database, modified rows should be updated and deleted rows should be deleted from Database.
Im trying to do the batchinsert (bulk) in sqldataadapter using dataset.but somehow its not inserting (even no error as well), i dunno where i went wrong.my coding..
Dim _cmd As New SqlCommand
I am not sure how to do this. I would like to merge the identity back into the dataset.
View 2 RepliesMy code is not updating the sql database. I am definately passing the correct information in to this function, and it runs without errors. If I exec the procedure with the passed in data, it works great. Can someone tell me what is missing?
public DataTable UpdateEmailList(int listId, string connectionString, DataTable EmailList)
{
//DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
SqlDataAdapter da = new SqlDataAdapter(null, conn);
SqlCommand cmd = null;
//add
cmd = new SqlCommand("dbo.fp_ServiceAwards_AddEmailToList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.InsertCommand = cmd;
//delete
cmd = new SqlCommand("dbo.fp_ServiceAwards_DeleteEmailFromList", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@emailList_id", SqlDbType.Int)).Value = listId;
cmd.Parameters.Add(new SqlParameter("@email_address", SqlDbType.NVarChar, 255, "email_address"));
cmd.Connection = conn;
da.DeleteCommand = cmd;
try
{
da.Update(EmailList);
}
catch (Exception ex)
{
string msg = ex.Message;
}
conn.Close();
conn.Dispose();
return EmailList;
}
I want to issue an INSERT command for an SQL Server table using DataAdapter without first issuing a SELECT command. Could anybody send me lines of code to handle this? Also how do i manage INSERT into selective table columns (I have 10 columns but i only want to update 2 of them)?
View 2 RepliesIs there any difference whether the DataSource was in or out the UpdatePanel?
View 2 Repliesi need some detail about ole and odbc.. what diffrence between ole and odbc
View 4 RepliesWhat is the difference between SqlServer2000 and sqlServer2005
View 1 RepliesWhat is the difference between DataRelation and ForeignKeyConstraint ?
Is a DataRelation generates automaticly a foreignkeyconstraint ?
What are the basic difference between the char and varchar datatype ?
View 5 RepliesI have a legacy solution where all the DataSources are defined in the markup for all .aspx-pages. The problem I have with this is that the DataSource get instantiated several times since it is used in page, control... What I want is to have NInject to handle the instantiation of the DataSource so this doesn't happen. I have got that part to sort of work, but when the DataSource is defined in the code-behind instead of in the markup the Page property is not set on the DataSource, does anyone know why? A simple solution to this is to set the the Page property in a base class or something, but I do think that the property should be there and want to know why.
View 2 RepliesI have a simple datatable with 2 fields, one a primary key which I will call PK and other which I will call COL1. I have used the dataset designer to generate update/insert/delete methods on the tableadapter. On my development system two update methods are generated wit hthe follow signatures:
Update(PK as System.String, COL1 as System.Bool, Original_PK as System.String)
Update(COL1 as System.Bool, Original_PK as System.String)
On the production system, however, the latter signature is not generated. What is more preplexing is that prior to today, production operated similar to test. Obviously somethign changed, but I have been unable to identify what.
Unfortunately the method being used now is the latter. Now I can create my own method with a similar signature, but this problem isn't unique to this datatable/tableadapter. I am very hesitent to make thsi change throughout the application, and even more so in touching the several other applications which I fear may have similar issues (though those rely less on generated udpates).
i am using my sql database. what type of data connection improve the performance.oledb connection or odbc connection ? what is the theory of these architectures?
View 8 RepliesCurrently I am working in Sql server 2005. I do not know the Sql Server 2000 and Sql Server 2008. what is the difference between Sql server 2005 and 2008?
What is the Difference between Sql Server 2000 and Sql Server 2005
i want to update many rows with difference values inside table. i'm coding a timetable.
View 3 RepliesI would like to write Set difference minus operation with Linq on list objects using Except method. [Code]....
Tha above code always returns lstrbb objects.
This should be a fairly simple one. I am creating a dataset which will contain a description field which I would like to sort by. The reason I want to sort the dataadapter and not in my SQL is that I am already ordering by the results that have a particular value. My SQL looks like this:
SELECT pif_desc, pif_fund, psf_end, (CASE WHEN SUM(pmi_units) IS Null THEN 0 ELSE SUM(pmi_units) END) As fundunits FROM tbl_mem INNER JOIN tbl_sfunds ON pm_scheme = psf_scheme INNER JOIN tbl_invfun ON tbl_fund = tbl_fund LEFT JOIN pe_minv ON pmi_fund = pif_fund AND pm_member = pmi_member WHERE pm_member = @pm_member GROUP BY pif_desc, pif_fund, psf_end ORDER BY fundunits DESC
My VB looks like this:
Dim cmd As New SqlCommand("getMembersFundsDCGENST", conn)
cmd.CommandType = CommandType.StoredProcedure
Dim p_pm_member As New SqlParameter("@pm_member", SqlDbType.Int)
p_pm_member.Value = pm_member
cmd.Parameters.Add(p_pm_member)
Dim p_period_closing_date As New SqlParameter("@closingdate", SqlDbType.DateTime)
p_period_closing_date.Value = period_closing_date
cmd.Parameters.Add(p_closing_date)
Dim da As New SqlDataAdapter(cmd)
da.Fill(ds)
I want to sort the datarows is ds.tables(0) by pif_desc but still have the rows with fundunits > 0 listed first.
I have a DataSet containing a small two-by-two table. When I call the da.Update(DataTable) method, I get the infamous DBConcurrencyException. However, the change does get updated in the actual database. What's up with that? I checked the RowState for both rows and one is Modified while the other is Unchanged. I would very much like to get rid of that exception!
View 1 RepliesHow do I reference my data adapter? I've been running through some tutorials (worx Professional ASP.Net 4 in c#) but have become stuck after creating my data adapter and trying to reference it. Steps I have taken to get this far: Added an 'App_Code' folder to project and added a dataset in it. I dropped a data adapter onto the visual dataset designer screen and followed the prompts for select statement etc. I tested the query and it worked. So under the App_Code folder I have a 'Product.xsd' file, which has 3 files under it (Product cs,xsc and xss files.) Created a new object 'Web-> Webform'. I dropped a gridview onto the form and a couple of textboxes and a button for filtering (my select is narrowed down by a date range).Tried to put code into c# section to fill dataset on page load but ran into problems. Code attached below.
[Code]....
I have to pull 150K records from DB. I am using da.Fill(ds,"Query") and its throwing system.outofmemoryexception.
Dim daGrid As New SqlDataAdapter(sqlcmd_q)
daGrid.Fill(dsGrid, "Query")
daGrid.Dispose()
I need this datatable only. I cannot use XML. because I need assign this to MSChartControl to display ScotterPlot.
I have some problem in inserting the wholerow in mt database table at once.....I would like to explain it:i have a function as
public DataSet senddata()
{
........................... [code]...
Now I to insert this data into the database I have made in the same format(schema).I have a function like :
database name is ABC
tablename is XYZ
public void inserttodatabase()
{
DataSet ds= senddata();
