Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    MS SQL Server






SuperbHosting.net & Arvixe.com have generously sponsored dedicated servers and web hosting to ensure a reliable and scalable dedicated hosting solution for BigResource.com.







To Use A Dataset Or Not...


ok, i have a question.

im developing an application, and want to know some pro's and con's with using a dataset or using direct connection to database...

also a breif description of what a dataset is would be very handy...

Thanks, Justin


View Complete Forum Thread with Replies
Sponsored Links:

Related Messages:
How Can I Use SQL Reporting Services To Get A Dynamic Dataset From Another Web Service As My Reports Dataset?
I found out the data I need for my SQL Report is already defined in a dynamic dataset on another web service.Is there a way to use web services to call another web service to get the dataset I need to generate a report?Examples would help if you have any, thanks for looking

View Replies !   View Related
Listing Datasets In Report (dataset Name, Dataset's Commands)


Is there any way to display this information in the report?

Thanks

View Replies !   View Related
Dataset.Tables.Count=0 Where There Are 2 Rows In The Dataset.
Hi,
I havea stored procedure attached below. It returns 2 rows in the SQL Management studio when I execute MyStorProc 0,28. But in my program which uses ADOHelper, it returns a dataset with tables.count=0.
if I comment out the line --If @Status = 0 then it returns the rows.Obviously it does not stop in
if @Status=0 even if I pass @status=0. What am I doing wrong?
Any help is appreciated.


ALTER PROCEDURE [dbo].[MyStorProc]

(

@Status smallint,

@RowCount int = NULL,

@FacilityId numeric(10,0) = NULL,

@QueueID numeric (10,0)= NULL,

@VendorId numeric(10, 0) = NULL

)

AS

SET NOCOUNT ON

SET CONCAT_NULL_YIELDS_NULL OFF



If @Status = 0

BEGIN

SELECT ......
END
If @Status = 1
BEGIN
SELECT......
END





View Replies !   View Related
How To Transfer Data From One Dataset To Other Dataset
i have two datasets.one dataset have old data from some other database.second dataset have original data from sql server 2005 database.both database have same field having id as a primary key.i want to transfer all the data from first dataset to new dataset retaining the previous data but if old dataset have the same id(primary key) as in the new one then that row will not transfer.
but if the id(primary key) have changed values then the fields updated with that data.how can i do that.
 

View Replies !   View Related
Filter One One Dataset With Values In Another Dataset?
Hi,

I have two datasets in my report, D1 and D2.

D1 is a list of classes with classid and title

D2 is a list of data. each row in D2 has a classid. D2 may or may not have all the classids in D1. all classids in D2 must be in D1.

I want to show fields in D2 and group the data with classids in D1 and show every group as a seperate table. If no data in D2 is available for a classid, It shows a empty table.

Is there any way to do this in RS2005?

View Replies !   View Related
Create A New Dataset From Dataset
Hi,

Here's what I'm trying to acomplish, I have an OLE DB Source that reads a table; for each record in the table I need to run a SQL Command that retrieves information from another set of tables based upon the input data; then I would like to iterate through that resulting dataset from the SQL Command and perform another SQL Command updating the database. Here's what I've tried: OLE DB Source to OLE DB Command, however I can't view the output of the command. Any help will be much appreciated.



Thanks

View Replies !   View Related
Using Parameter From XML DataSet In Another XML DataSet
Hi every body...
I have a probleme
I have a web Services which contains a method getValue(IDEq (int), idIndicator(int), startTime(dateTime), endTime(dateTime))
I need to call this method. But my problem is how pass parameter ?
I see the tab Param but it isn't work as I wait,... maybe I do a mistake...

I want that statTime and endTime are select by the user via a calendar for example...
now idIndicator and idEq was result of an other dataSet from a xml datasource...

But I don't how integrate dynamically... I try to enter a parameter via the param tab, and create and expression :
=First(Fields!idEq.Value, "EquipmentDataSet")
but when i execute the query, the promter display <NULL>...
So I don't know how to do and if it is possible !
I hope someone can help me !
Thank you !

View Replies !   View Related
Dynamic Dataset For Another Dataset!
Hi experts,

I'm not sure my design is normal or not. Please give me some advice.

I've a dataset and query by a field name 'companyid'.

select * from companyid where companyid = @icompany which @icompany is a input field.


if user select all, i'll send 0 to @icompany then I need to select all records.

question 1. How can I get all records? (i think about this query select * from companyid <> 0)

if user select for example companyid = 1, i'll send 1 to @icompany and the query work fine.

question 2. How can I change the query to adopt this 2 condition?

Thanks a lot,

Jeff

View Replies !   View Related
Regarding Dataset
I using a stored procedure to update profile...


set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:
-- Create date:
-- Description:
-- =============================================
ALTER PROCEDURE [dbo].[SP_UpdateProfile]
-- Add the parameters for the stored procedure here
@regUserID nvarchar(20),
@regName nvarchar(50),
@regEmail nvarchar(50),
@regMobile nvarchar(10),
@regPinCode nvarchar(10),
@regCity nvarchar(12),
@regState nvarchar(12),
@RValue int output
AS
BEGIN
-- SET NOCOUNT ON added to prevent extra result sets from
-- interfering with SELECT statements.
SET NOCOUNT ON;

-- Insert statements for procedure here
UPDATE tblUserDetails
SET
regName= @regName,
regEmail= @regEmail,
regMobile= @regMobile,
regPinCode= @regPinCode,
regCity= @regCity,
regState= @regState
WHERE regUserID=@regUserID
END




here i updating the profile according to the userID..

My doubt is how to get these various values selected in a dataset and how to retrieve from tat dataset... please friends help me out...

View Replies !   View Related
Regarding Dataset
I am using storedprocedure for a process... i am selecting 4 variables from the stored procedure as a ouput parameters.. now please help me in working with a dataset to collect the 4 variables and read the variables from the dataset...

View Replies !   View Related
How To Do This With Dataset
hi developers
    i've a table named users where i store the city id ,
this city id -> citymaster (cityid,stateid)->state master (cityid,stateid) ->country master (countryid,stateid).
now i need to make the query fetches the columns like this
username,cityid,stateid,countryid
how can i do this

View Replies !   View Related
XML To DataSet To SQL
I am faced with a common situation but there is a little twist that makes it unique and has me stumped. Hopefully someone can point me to a solution or give me enough guidance to figure it out.
Here is the situation, I am loading an XML file into a Dataset and need to update SQL tables from that Dataset but the tables are slightly different than in the DataSet. I am using C#, asp.net 2.0, visual studio 2005 and sql server 2005.
When I loaded the XML into the Dataset, the Dataset contained 19 tables. I individually loaded each table from the Dataset and determined from that which tables I needed and didn't need as well as determinined which fields I needed or not. I used this information to create my SQL tables.
Briefly, when creating the SQL tables, I used the dataset table name as the SQL table name and used the same column names as well. the only difference from the Dataset tables and SQL tables is 1 column has a different name (or to be more specific, a column exists in the datset that does not exist in the sql table and a column exists in the SQL table that does not exist in the dataset table). Also, some tables in the dataset do not exist in the sql Database.
I know that I can spin through each row of the tables I need in the Dataset and create an insert command from the row data and insert that into the SQL table but I have 11 tables to do that with. I would like to take advantage  of ADO.NET and push the datset information into sql data but I am confused on how to do this.
I am confused because not all tables in the dataset are represented in the sql database and though the tablenames and most of the columns have the same name, it is not an exact fit.
Can anyone point me to a solution or give me a good game plan that I can search on to help me load my dataset info to a sql DB.
I appreciate any help I can get.
Thanks.

View Replies !   View Related
Dataset To Sql
Is there anyway to just add a dataset created from a query to a table in sql
without looping through the records individually and placeing the records in the database
Maybe a sort of mass import option

View Replies !   View Related
Using Only One Dataset
Hey,

I am using the following stored procedure, but as it is now it returns 2 datasets. I need it to return only 1.

ALTER PROCEDURE dbo.Test2
(
@Location varchar(250),
@FromDate datetime,
@ToDate datetime
)

AS
SET NOCOUNT ON

CREATE TABLE #Temp1 (themonth varchar(12), theyear varchar(12), averagedaystofilltotal float, averagefillratetotal float,
delaytimetotal float, responsetimelagtotal float)

INSERT INTO #Temp1(themonth, theyear, averagedaystofilltotal, averagefillratetotal, delaytimetotal, responsetimelagtotal)
EXEC rptStatsGraphicalYEARoverYear @Location, @FromDate, @ToDate

Create table #Temp2(averagedaystofilltarget float, averagefillratetarget float, responsetimelagtarget float)
INSERT INTO #Temp2(averagedaystofilltarget, averagefillratetarget, responsetimelagtarget)
EXEC Test1

SELECT * FROM #Temp1
Select * from #Temp2

drop table #Temp1
drop table #Temp2

Would anyone have any suggestions on how to modify this procedure so that it returns only one dataset, but yet still keeps the data seperated? Or is this even possible?


Thanks

View Replies !   View Related
Use Dataset
hi
i m working on ERP with VB.Net and SQLserver2005.
i have some problem with that query.
In the here is two administrator
1- administrator
2-HR administrator
in the table,code written on login srceen and query is following.
SELECT userGroupMaster.groupName FROM userGroupDetails INNER JOIN userGroupMaster ON userGroupDetails.groupName = userGroupMaster.groupName INNER JOIN UserNameMaster ON userGroupDetails.userName = UserNameMaster.UserName WHERE (UserNameMaster.UserName = '" & gl_strUserName & "')
whenever i execute it then error comes due two administrator.

I wanna use dataset in that query to read first administrator.

Ashish

View Replies !   View Related
How To Use Dataset?
i am having a stored procedure and i want to use dataset to retrieve the first row of my table.

View Replies !   View Related
What's In A Dataset Name?
I have come into a company where my predesessor used a TON of differently named RDS files to connect to the same SQL Server Database; the same connection string, login id, etc. My suspicion is that he thought that datasources were the same as datasets and created one for each. I can't find a difference in any of them; except their name.

Is there any good reason to do this?

Should they all have been changed to be something generic like "ConnectTo{servername}Production.RDS (instead of {Report Name}.RDS)??? What is the easyiest way to change them all to the same RDS file?

Any thoughts?

Thanks,
Keith

View Replies !   View Related
Get Second Dataset Value
hi,

how do I get value from second dataset (in multi dataset report)

in some function it provide scope parameter like

Sum(Fields!amount.Value, "DS2")

but now I need to show the value without using function



thks,





View Replies !   View Related
XML Dataset
For some reason a report runs but when we try to run in the datset window we are getting this error. I need to add another field to a dataset in a preexisting report but we can't get the dataset windows to run. It seems like its a problem with one of our date parameters. Any suggestions would be very helpful.



<?xml version="1.0" encoding="utf-8"?><soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><soap:Body><soap:Fault><faultcode>soap:Client</faultcode><faultstring>Server was unable to read request. ---&gt; There is an error in XML document (9, 42). ---&gt; The string '1/1/2006' is not a valid AllXsd value.</faultstring><detail /></soap:Fault></soap:Body></soap:Envelope>



View Replies !   View Related
DataSet
Hi everybody!
Can we have more than one DataSet in one list?
Thanks for your help!

View Replies !   View Related
Using Dataset(on 2nd)


Hi all,
If i have dataset in Dotnet Code,Can i use that dataset to report design?
Any body know.



View Replies !   View Related
Dataset WHERE Clause
I've created quite a complicated Dataset to enable users to search for names in a database.
Is there a way I could modify the WHERE clause without having to rebuild the Dataset each time?
I'd like to support general search criteria ie.
1) quotes, so WHERE NameSearch LIKE '%FirstName Surname%'
2) unlimited multiple keywords, so WHERE (NameSearch LIKE '%FirstName%' ) AND (NameSearch LIKE '%NickName%')
 
The query has already been built (and tested), so the problem is only with generating the WHERE clause, particularly when I'm not sure how many keywords are involved.
 
Any help would be greatly appreciated.
Thanks, Pete.

View Replies !   View Related
SqlDataAdapter And DataSet
I'm getting a strange error with my dataadapter.  Here's my code:  using (SqlConnection conn = new SqlConnection(
ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString))
{
SqlDataAdapter da = new SqlDataAdapter("sprocCUSTOM", conn);
da.SelectCommand.Parameters.AddWithValue("@eventID", EventID);

conn.Open(); //open connection
DataSet ds = new DataSet();
da.Fill(ds);
gvAttendees.DataSource = ds;
gvAttendees.DataBind();
}This is the error I'm getting: Incorrect syntax near 'sprocCUSTOM'.But the error is highlighted at the line that reads "da.Fill(ds);"There's nothing wrong with the stored procedure either.  It exists and works fine. 

View Replies !   View Related
DataSet To SqlDataSource
I can find lots of examples of how to extract a DataSet from a SqlDataSource, but not the opposite.
I have a DataSet that has been populated with 3 DataTables, and I want to create a SqlDataSource, and populate it with the first DataTable in the DataSet.
Is this possible?

View Replies !   View Related
How To Push A Dataset Into The DB?
Dear all,,
I used a code that import data from an excel file into a dataset,
 now I want to insert the dataset into a table in my database(SQLserver database) using a VB.NET code
Could you help me?
Thanks in advance,,
Here is my code:
Imports System.Data.OleDbPartial Class _DefaultInherits System.Web.UI.Page
 
Protected Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles Button1.ClickDim connString As String = ConfigurationManager.ConnectionStrings("xls").ConnectionString
' Create the connection object Dim oledbConn As OleDbConnection = New OleDbConnection(connString)
Try
' Open connection
oledbConn.Open()
' Create OleDbCommand object and select data from worksheet Sheet1Dim cmd As OleDbCommand = New OleDbCommand("SELECT * FROM [Sheet1$]", oledbConn)
' Create new OleDbDataAdapter Dim oleda As OleDbDataAdapter = New OleDbDataAdapter()
oleda.SelectCommand = cmd
' Create a DataSet which will hold the data extracted from the worksheet.Dim ds As Data.DataSet = New Data.DataSet()
' Fill the DataSet from the data extracted from the worksheet.oleda.Fill(ds, "Sheet1")
' Bind the data to the GridView
GridView1.DataSource = ds.Tables(0).DefaultView
GridView1.DataBind()
Catch
Finally
' Close connection
oledbConn.Close()
End TryEnd Sub
End Class
 

View Replies !   View Related
My SQL Dataset Will Not Work!
For the life of me, I cant get this thing to work.. any insight would be greatly appreciated. What I'm trying to do is simply get the RealName field from my aspnetdb.Here the code.           SqlConnection conn = new SqlConnection("Data Source=(local);Initial Catalog=aspnetdb;Integrated Security=SSPI");                    SqlDataAdapter a = new SqlDataAdapter                    ("select RealName from dbo.aspnet_Users where UserName='Dude';", conn);                    DataSet s = new DataSet();                    a.Fill(s);                    foreach (DataRow dr in s.Tables[0].Rows)                    {                    getusersrealname.Text = (dr[0].ToString()); 

View Replies !   View Related
Can I Select * From DataSet?
I used codes below:
sqlA = "select * from order where orderby = 'Mike'"
myDataset = makeDataset(sqlA) // I created a function to return a dataset
I knew the code below is working:
select * from Product where OrderID in ( "select * from order where orderby = 'Mike'")
Can I do the way below?
select * from Product where OrderID in myDataset

View Replies !   View Related
How To Get A Count From A Dataset?
I'm using strongly typed datasets.  Not I want to get a single number, say the number of males, instead of a table or rows.  How can I do that?Diane 

View Replies !   View Related
Problem With Dataset()
Hello all
i m facing a problem " There is already an open DataReader associated with this Command which must be closed first."
what is this alll the another page like thispage is currently working properly
so what is this problem
pleasse help me
 
ashwani

View Replies !   View Related
Creating A Dataset
Im trying to complete my function which will allow me to insert data into a table by referencing it in the relevant pages, the following code is what i am using to take the SQL query, execute it and return the resultant dataset in destResponse. However i am getting the following error message; "Compiler Error Message: CS1026: ) expected". And it is coming from the following line;
SqlCommand command = new SqlCommand("INSERT INTO" + strTableName + strData +") VALUES (" + strData + ")";
 Here is my code below, please feel free to criticise it, and im sure the error above is not the only error i will be getting.
 public static void SQLExecute(string strTableName, string strData)
{DataSet dsetResponse = new DataSet();
// create connection objectstrConnection = ConfigurationManager.AppSettings["strConnectionString"];
SqlConnection conn = new SqlConnection(strConnection);SqlCommand command = new SqlCommand("INSERT INTO" + strTableName + strData +") VALUES (" + strData + ")";command.Fill(dsetResponse,"table");
conn.Close();return dsetResponse;
}
 

View Replies !   View Related
Dataset Blues
i don't know if this is the right forum for this question but here goes.  I have created a gridview to display a list of records retrieved by a SQL query.  Everytime I run it, I get the following error:
Object must implement IConvertible.
 
I thought it might have to do with the data I'm passing in the session string from the previous page.  Here is that code:Protected Sub cmdSubmit_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles cmdSubmit.Click
Session.Add("Shift", shShift.SelectedItem)Session.Add("Type", shType.SelectedItem)
Session.Add("SelDate", OccDate.SelectedDate)
Response.Redirect("SelectIncRep.aspx")
 
Here is the code that is supposed to execute and display the data on page_init:
 
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="RID" DataSourceID="SqlDataSource1" Width="1215px" BorderStyle="Groove" BorderWidth="4px">
<Columns>
<asp:BoundField DataField="RID" HeaderText="Record ID:" InsertVisible="False" ReadOnly="True"
SortExpression="RID" />
<asp:BoundField DataField="Date" HeaderText="Date:" SortExpression="Date" />
<asp:BoundField DataField="Shift_ID" HeaderText="Shift:" SortExpression="Shift_ID" />
<asp:BoundField DataField="Xref_ID" HeaderText="Type Of Occurence:" SortExpression="Xref_ID" />
<asp:BoundField DataField="Notes" HeaderText="Notes:" SortExpression="Notes" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:PerfDataConnectionString %>"
SelectCommand="SELECT [RID], [Notes], [Date], [Shift_ID], [Xref_ID] FROM [Safety_data] WHERE (([Shift_ID] = @Shift_ID) AND ([Xref_ID] = @Xref_ID) AND ([Date] = @Date))">
<SelectParameters>
<asp:SessionParameter Name="Shift_ID" SessionField="Shift_ID" Type="Int32" />
<asp:SessionParameter Name="Xref_ID" SessionField="Type" Type="Int32" />
<asp:SessionParameter Name="Date" SessionField="Date" Type="DateTime" />
</SelectParameters>
</asp:SqlDataSource>
 
What could be causing the issue?

View Replies !   View Related
Problem With Dataset
My data from this dataset works until I get to a column that has no value in it then it starts not showing the value in the three columns after the no value column.  This is my code to handle the no value column. 
 
 if ((myDataset.Tables[0].Rows[i][j].ToString()) == "")

View Replies !   View Related
Sqldatasource And Dataset
Dear sir or madamI have a problem related to using sqldatasource and dataset.I heard that using dataset is faster than using sqldatasource,but I think that in sqldatasource have a DataSourceMode property allowing user to choose to use with dataset or datareader.Now,I still wonder why they said that dataset is faster than sqldatasource. I look forward to hearing from you.Thank you in advance.Best wishes,   

View Replies !   View Related
How Can I Request Row #3 In A Dataset?
I've got a table that houses the data for several routes, (routeID, pointID, Longitude, Latitude and Elevation).  a set of Points make up a route.  I'd like to programmatically access specific points and I'm trying to figure out how to request...say the third point in my dataset.  I'm new to SQL, but I was able to figure out that I can find the row number by using the SQL syntax:SELECT ROW_NUMBER() OVER(ORDER by PointID) as 'Num', Latitude, Longitude, Elevation
FROM [PointTable]
WHERE (RouteID = 5)
 But I cannot (or do not know how to) add a clause that saysAND (Num = 3) So can someone show me how to request a specific row?
 

View Replies !   View Related
Asp.net DataSet Object
I've been using the asp.net's DataSet and it seems to be leaving connections open, I'm not entirly sure if its due to the DataSet or some random code I forgot to close its connection, but I just wanted to cover all of my Basis. Is it possible though, that this DataSet object is leaving connections open?
 
Thanks for reading!
-Teenprogrammer

View Replies !   View Related
Dataset Or Datareader?
i need help to know what is the best practice
i have a stored proc which returns 4 different resultselts
will that be easy to use dataset or datareader?
my purpose of using dataset/datareader is to load the data in a class
thanks.
 

View Replies !   View Related
DataSet And Transactions...
hi all,
i'm developing a WebApplication with VisualStudio2005 (with C# code).i've defined a DataSet with some TableAdatpter. For each TableAdapter, i've definet some "customized" commands, performing specialized operations over the table on DB. (db is SqlServer2000).For each TableAdapter, i've set as "public" the connection, so that i can use it within my code for beginning a new transaction. Now, how can i set that transaction, to the specialized commands I defined for each TableAdapter?
Thanks all.Andrea.

View Replies !   View Related
SQL Query In DataSet
I create a Query in Dataset that get values from multiple tables when i execute query in query builder its execute successfuly but whan i am save this query found following message.
"The new command text returns data with schema different from the schema of the main query. Check your query's command text if this is not desired"
 after OK i am check my query result in Preveiwdata its show deffrent result.
 
Help me
regards
Fakhruddin
 

View Replies !   View Related
Dataset Manipulation
Have an XML file that i load in to a Dataset. works fine, it builds its own scheme perfectly.
I loop through that data to load a check list which also works wonderfully.
 two questions based on that.
1) can i add a column after the fact? I want to basically update the the info in the dataset to store if the record was checked in the check list. if not, i can manipulate one of the already defined columns, but i would rather not.
2) what is the best way to update data with in the dataset? Never really done anything but pull data from one. how do i locate the correct row to update ("select name from tbl where name = " + checklist.items[index].tostring(); update row)
 
sorry for the fairly basic question. i appreciate the help.
 Justin
 

View Replies !   View Related
Update Dataset ?
Hi, I am trying to figure out how to update a dataset. Below is my sample code but it gives me this error on the mySqlDataAdapter.Update line.Dynamic SQL generation for the UpdateCommand is not supported against a SelectCommand that does not return any key column information. I looked around and it seems like I'm supposed to add a Primary Key but I did that and still get nothing. Below is my page load code... it is based on the quickstart at http://quickstarts.asp.net/QuickStartv20/howto/doc/adoplus/UpdateDataFromDB.aspx but I'm still having trouble and not sure what I'm missing. 1 // Create a new Connection and SqlDataAdapter
2 SqlConnection myConnection = new SqlConnection("Server=localhost;uid=user;pwd=password;database=northwind");
3 SqlDataAdapter mySqlDataAdapter = new SqlDataAdapter("Select * from Customers", myConnection);
4 DataSet myDataSet = new DataSet();
5 DataRow myDataRow;
6
7 // Create command builder. This line automatically generates the update commands
8 // for you, so you don't have to provide or create your own.
9 SqlCommandBuilder mySqlCommandBuilder = new SqlCommandBuilder(mySqlDataAdapter);
10
11 // Set the MissingSchemaAction property to AddWithKey because Fill will not cause
12 // primary key & unique key information to be retrieved unless AddWithKey is specified.
13 mySqlDataAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
14 mySqlDataAdapter.Fill(myDataSet, "Customers");
15
16 showData(myDataSet);
17
18 // Set PK of table to CustomerID ??
19 DataColumn[] pk = new DataColumn[1];
20 pk[0] = myDataSet.Tables["Customers"].Columns["CustomerID"];
21 myDataSet.Tables["Customers"].PrimaryKey = pk;
22
23 // Edit some data
24 myDataSet.Tables["Customers"].Rows[0]["ContactName"] = "Maria Anders2";
25 //DataRow myDataRow1 = myDataSet.Tables["Customers"].Rows.Find("ALFKI");
26 //myDataRow1["ContactName"] = "Maria Anders2";
27
28 showData(myDataSet);
29
30 //Update DB
31 mySqlDataAdapter.Update(myDataSet, "Customers");
32  Thanks!

View Replies !   View Related
Help Filling Dataset
I have a class that works fine using the SQLDataReader but when I try and duplicate the process using a Dataset instead of a SQLDataReader it returnsa a null value.
This is the code for the Method to return a datareader
 
publicSqlDataReader GetOrgID()
{
 Singleton s1 = Singleton.Instance();
 Guid uuid;
uuid = new Guid(s1.User_id);
 SqlConnection con = new SqlConnection(conString);
 string selectString = "Select OrgID From aspnet_OrgNames Where UserID = @UserID";
 SqlCommand cmd = new SqlCommand(selectString, con);
cmd.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier, 16).Value = uuid;
 
con.Open();
 SqlDataReader dtr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
 
 
 return dtr;
 
This is the code trying to accomplish the same thing with a Dataset instead.
 
 public DataSet organID(DataSet dataset)
{
 Singleton s1 = Singleton.Instance();
 Guid uuid;
uuid = new Guid(s1.User_id);
 string queryString = "Select OrgID From aspnet_OrgNames Where UserID = @UserID";
 SqlConnection con = new SqlConnection(conString);
 
 SqlCommand cmd = new SqlCommand(queryString, con);
cmd.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier, 16).Value = uuid;
 
 SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
 
adapter.Fill(dataset);
 return dataset;
 
 
 
}
 
Assume that the conString is set to a valid connection string. The Singlton passes the userid in from some code in the code behind page ...this functionality works as well.
So assume that the Guid is a valid entry..I should return a valid dataset but its null.
 Additionally if I change the sql query to just be Select * From aspnet_OrgNames I still get a null value...I am assuming I am doing something wrong trying to fill the dataset.
 
Any help would be appreciated.
 

View Replies !   View Related
Dataset Rows?
Hello Team
i want to insert more than one row to the dataset before update the sqladapter for ex i want to insert rows for orderlines then i send them all to sql by updating adapter
is it done by javascript ? because when i press the button a postback hapend then it clears the dataset so the new row clears the old one
any idea Thanks lot

View Replies !   View Related
DataSet - Inserted Row ID
I have a dataset that uses generated stored procedures to do its select, insert, update, delete.  I am inserting a row to that dataset, and after the update, using the ID of newly created row.  This worked just fine until I added triggers to some of the tables on my DB, and now, when I insert a row, the row's ID is not available after the update (it's 0) Any idea what happened / what I have to do to fix this? Thnx! 

View Replies !   View Related
Dataset To Sql Server
How to transfer data in a table in dataset to a table in sql server ?
i.e. I want to transfer the table values in excel to a table in sql server. I have populated the excel table in a dataset. I just want to know how to transfer from dataset to sql server.
 
Thanks
 
 

View Replies !   View Related
Dataset StoredProcedures
Hello,
I need to create a page where I can Select, Update, Insert and Delete users.
I use aspnet_Users and a table that I created and I call UserInformation, where I store address, phonenumbers etc. 
I am trying to use DataSet and StoredProcedures.  I call the following StoredProcedures for Membership: 
SELECT: aspnet_Membership_GetUserByUserId
INSERT: aspnet_Membership_CreateUser
UPDATE: aspnet_Membership_UpdateUser
DELETE: aspnet_Users_DeleteUser
If I would have used SQL Statements I could have created a subquery for CRUD from UserInformation. Does someone know how I can use stored procedures to Select, update, insert, delete (CRUD) from these two tables? 
Or should I be doing this somehow differently?
Thanks,
Bill
 

View Replies !   View Related
DataSet Confusion
I am new to the DataSet-DataTable-TableAdapter concept.  I am using the Working with Data in ASP.NET 2.0 tutorial to assist in learning.  Here is my confusion:
I have tables in SQL Server 2000 and I use Stored procedures for all the CRUD operations on the tables.  Say I have a table with the following fields:
CustomerID - int, CSRID - int, PartNumber - varchar(25), Reason - varchar(200)
All of these fields - except Reason - are foreign keys to other tables.  So I can include CustomerName and CustomerPhone in a query by joining on CustomerID.  PartNumber can be used to get PartWidth, PartLength, PartDescription.
When you initially create the DataSet with the configuration wizard, do you need to include ALL possible fields you might want to use in the SELECT operation? 
I know you can add more TableAdapters, but if you use a query that contains fields outside the DataTable, this causes problems.
Thanks

View Replies !   View Related
How To Get DataSet From A SqlDataSource?
I have set the SelectQuery in the SqlDataSource, and it get the right data.
I want to get DataSet from a SqlDataSource in source codes, how to get it?
 
 

View Replies !   View Related
How To Fill A Dataset?
Can a SqlDataSource be used to fill a DataSet? If so, will you show me how it's done?

View Replies !   View Related
SQLDataSource To DataSet?
Hi
At the moment I gave a function (GetProfile) which returns a dataset (dSet) something like this
Dim dataAdapter As System.Data.SqlClient.SqlDataAdapter = New System.Data.SqlClient.SqlDataAdapter(sqlCommand)Dim dSet As System.Data.DataSet = New System.Data.DataSetdataAdapter.Fill(dSet)
return dSet
I am using the .Tables  property of the dataset to loop round the values. like this (below), I can't use the SQLDataSource control to bind to a form or controls due to the functionality of what I'm doing.
    Dim dataSet As System.Data.DataSet = GetProfile(UserID)    With dataSet      If .Tables(0).Rows.Count = 1 Then        With .Tables(0).Rows(0)
                  (some code like)
            lblName.Text = .Item("Name").ToString            Page.Title = "Member profile::" & lblName.Text 
                        etc...
               End With
            End If
         End With
So my question: is there a way of using an SQLDataSource control to populate a dataset rather than using my function?

View Replies !   View Related
DataSet To SQL Script?
Hi,

Does anyone have a way to generate a SQL 2000 database generation script from a DataSet? I'm looking to load an XML file into a DataSet and use it to create the db design.

Matt.

View Replies !   View Related
Dataset In SqlDataSource
Probably some simple question but I'm struggling with this one:How can I retrieve the dataset from the SqlDataSource? I would like to just place a SqlDataSource control on my webform and then bind several items (column/row) to a Label or TextBox.

View Replies !   View Related

Copyright 2005-08 www.BigResource.com, All rights reserved