dataset questioin

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - CommandBuilder commands Hi How or where can I see full used commands generated via CommandBuilder for DataAdapter. Using DataAdapter not CommandBuilder? Thanks Konrad Tag: dataset questioin Tag: 66109
  - 2
    - Display Related Item or Add Item Hi, Trying to create a registration form for members of organizations. I have three tables, Users user_id, user_name, user_mail, etc. Orgs org_id, org_name, org_description, etc. Locs loc_id, loc_address, loc_town, loc_st, loc_zip, etc. GOAL: I want users to... Register / Edit user data on the form. Then... Choose from an existing Org. OR Register an Org. Then... Choose a Location (address, state, etc) associated with the org specified. or Register an Org. location to be associated with the Org chosen. GOAL: And I would like to do this on 1 form, as opposed to creating a pop-up window for new Org or Loc registrations. I could not get more then one datagrids to work on one page, no matter what I did. Perhaps TABS would work? I have no experience with them but I'm open to this option also. I have already succeeded in getting forms authentication to work, and bind a single table to user data. I've implemented checkboxes, textboxes, dropdownlists, etc. and I was able to edit, update, and add new record. Please help! I am working hard but falling very far behind on this project ! Thanks! Drew NY Tag: dataset questioin Tag: 66104
  - 3
    - SQL and .NET passing parameters... I'm trying to pass parameters out of a SQL 2000 procedure to VB .NET. I used the wizard with'in .NET to create my SP's and they work fine for updates except I can't get any values back out of them. By default the wizard set up a ReturnValue with'in my parameters collection called @RETURN_VALUE. I assume I need to set the SourceColumn, and SqlDbType for it to return the correct info. But it will only return a 0 as a value. Here is the SQL code: Alter PROCEDURE wgo.Members_Update ( @wit_no char(10), @active bit, @attn char(30), @name1_last varchar(30), @name1_first varchar(30), @name1_init char(1), @name2_last varchar(30), @name2_first varchar(30), @name2_init char(1), @last_flag bit, @addr1 varchar(30), @city varchar(20), @state char(2), @zip char(10), @mail_class tinyint, @snow_attn varchar(30), @snow_addr1 varchar(30), @snow_city varchar(30), @snow_state char(2), @snow_zip char(10), @snow_bdate datetime, @snow_edate datetime, @snow_flag bit, @snow_class tinyint, @serial_no char(8), @wit_news bit, @annual_dir bit, @phone1_type char(1), @phone1_no char(10), @phone2_type char(1), @phone2_no char(10), @email1 varchar(50), @email2 varchar(50), @new_free smallint, @total_free smallint, @amt_paid numeric(18,2), @current_paid numeric(18,2), @status char(1), @memb_type char(1), @renew datetime, @expiration datetime, @setup datetime, @new_paid numeric(18,2), @Original_wit_no char(10), @Original_tstamp timestamp ) AS SET NOCOUNT OFF; UPDATE dbo.Members SET wit_no = @wit_no, active = @active, attn = @attn, name1_last = @name1_last, name1_first = @name1_first, name1_init = @name1_init, name2_last = @name2_last, name2_first = @name2_first, name2_init = @name2_init, last_flag = @last_flag, addr1 = @addr1, city = @city, state = @state, zip = @zip, mail_class = @mail_class, snow_attn = @snow_attn, snow_addr1 = @snow_addr1, snow_city = @snow_city, snow_state = @snow_state, snow_zip = @snow_zip, snow_bdate = @snow_bdate, snow_edate = @snow_edate, snow_flag = @snow_flag, snow_class = @snow_class, serial_no = @serial_no, wit_news = @wit_news, annual_dir = @annual_dir, phone1_type = @phone1_type, phone1_no = @phone1_no, phone2_type = @phone2_type, phone2_no = @phone2_no, email1 = @email1, email2 = @email2, new_free = @new_free, total_free = @total_free, amt_paid = @amt_paid, current_paid = @current_paid, status = @status, memb_type = @memb_type, renew = @renew, expiration = @expiration, setup = @setup, new_paid = @new_paid WHERE (wit_no = @Original_wit_no) and (tstamp = @Original_tstamp); SELECT wit_no, active, attn, name1_last, name1_first, name1_init, name2_last, name2_first, name2_init, last_flag, addr1, city, state, zip, mail_class, snow_attn, snow_addr1, snow_city, snow_state, snow_zip, snow_bdate, snow_edate, snow_flag, snow_class, serial_no, wit_news, annual_dir, phone1_type, phone1_no, phone2_type, phone2_no, email1, email2, new_free, total_free, amt_paid, current_paid, status, memb_type, renew, expiration, setup, new_paid, tstamp FROM dbo.Members WHERE (wit_no = @wit_no) Here is my VB code calling the returned value: MsgBox("WIT NUMBER " & Memb_adp.UpdateCommand.Parameters("@RETURN_VALUE").Value) If anyone can tell me how to get a value I would really appreciate it. I'm really trying to get the tstamp so I can verify if the record has been modified since last read, but I can't get anything back. Thanks! Scott Tag: dataset questioin Tag: 66103
  - 4
    - Best way to take DB output and turn it into XML? This is one of those "what's my best way to do this?" questions... I've written a shell for an ASP.NET web service. This service takes in a single string and makes a database call to get information. The information comes back as a whole slew of data. Numerous recordsets with a variable number of rows each, a number of individual data items sent back as output parameters to stored procedures... the works. What I need to do is package up all of this information into XML, in a format that I get to define. This chunk of XML will be sent back out from the web service. Consumers of the web service will then use the XML to do what they wish with it. Some will use the data to populate windows forms, some will apply XSLT to it for very simple formatted text output, and the like. The web service is very simple - takes in a string and returns a string (the return string being the XML blob). I presume that this is the easiest and most robust way to expose this, right? So my first thought was to take the database output and build an XMLDocument from scratch as I go along. I do not have the luxury of getting the database to give me my results in XML, so that's out of the question. Building the XMLDocument and populating it is pretty easy, but tedious. But then I wondered - is it possible to take the recordsets that I get back and have them serialize to an XML format of my choosing? Would this be any easier? Or am I overlooking an obvious solution? Many thanks in advance! Christopher chris@ambler.net Tag: dataset questioin Tag: 66094
  - 5
    - How to discover required field Hi How to discover that field should be set. This is Access database. Thanks Konrad Tag: dataset questioin Tag: 66088
  - 6
    - Microsoft Oracle .NET Data Provider failure! Help! I have a web site that was just completed in .net using c#. There are a few places where the website needs to access an Oracle Database to get data to build some drop down lists for forms...etc. I build the site with Visual InterDev on my development server and access the web pages through IE 6.0 and everything seems fine. When I do a copy project, I copy only the files necessary to run the web site to my production server. When I try to view the web site on my production server I get the following error occuring on the lines containing "OracleDataAdapter.Fill(DataTable)" System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. My production server has release 3 of Oracle 8i install and the Microsoft Oracle .NET Data Provider installed, along with Microsoft .NET Framework(English) v1.0.3705. Any ideas? Thanks - Bill Jones Tag: dataset questioin Tag: 66084
  - 7
    - Error 7631 Expected ''''' near .. I am querying data using full text indexing like: SELECT a, b, c FROM X WHERE whatever AND CONTAINS(fldField, 'john doe') and I get error 7631. Syntax error near 'doe'. Expected ''''' in search for 'john doe'. Can somebody help me with this please. I am querying from SQL Server. Thank you, -- Dino Buljubasic Software Developer http://rivusglobal.com Tag: dataset questioin Tag: 66083
  - 8
    - Distinct rows in a DataTable Hi, Which is the best way to copy all the distinct rows from one data table to another data table? Thanks, Rajiv Tag: dataset questioin Tag: 66082
  - 9
    - Setting DataView Filter Hello, I was wonder how you set your rowfilter property in a dataview to return rows in which a particular column has a null value. I tried, columnName is Null, but it does not like this. The documentation identifies ways to change the value returned when a column is NULL, but I don't see anything about selecting columns where the value is or is not a null value. Thanks in advance for your assistance!!!!!!!!!!! -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: dataset questioin Tag: 66081
  - 10
    - Error with SqlDataAdapter in Fill Method Hi all, I'm getting an error when my class calls the SqlDataAdapte.Fill(SomeDataSet) I have a SqlCommand object with a valid query and connection (this part works), I then set the SqlDataAdapter's SelectCommand = SqlCommand. I make a new DataSet such as: Dim SomeDataSet as DataSet = New Dataset, then call the .Fill The error is as follows: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. I've looked online for help, but can't seem to find anything specific. Any help would be greatly appreciated. Thanks, Philip Tepedino ftepedino@swgs.net Database/Software Development Siemens Westinghouse Generation Services Tag: dataset questioin Tag: 66078
  - 11
    - System Tray Apps My turn to ask a question !! I want to create a program which runs in the system tray in VB.NET/Framwork. Can anyone point me to a good example ( In English please ). Thanks OHM Tag: dataset questioin Tag: 66071
  - 12
    - Urgent: please help with this as im now completley stuck Ive asked this a few times over the last few weeks and still im no further forward i have the following SQL string that im trying to use to retrieve data from a access database and place into a datagrid the problem seem to be arising with the Left(Personal.postcode,Len(personal.postcode)-2) AS Expr1 part of the statement because if i set the Len(personal.postocde)-2) to be -1 the whole thing works fine, similarly if is set it to -3, -4, or -5 it works great but not with -2 which is what i want, the row its working on can have a few possibilities for the data (being a UK postcode) which are: A1 1AA AA1 1AA AA11 1AA all i want to do is remove the last 2 characheters from the postcode but i cannot get it to work, ive worked on this for a few weeks now with no joy, if i put the SQL string into MS Access it works perfectly but not from my .net app - any help would be greatly appreciated, below is my code: SQLStr = "SELECT Left(Personal.postcode,Len(personal.postcode)-2) AS Expr1, LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal INNER JOIN PendingTracker ON Personal.ID = PendingTracker.ID) LEFT JOIN LiveTracker ON Personal.ID = LiveTracker.ID) LEFT JOIN Closed ON Personal.ID = Closed.ID ORDER BY personal.postcode;" da.SelectCommand = New OleDbCommand(SQLStr, ocon) da.Fill(ds) <--------------DEBUGGER STOPS HERE RowCount = ds.Tables(0).Rows.Count Me.DataGrid1.DataSource = ds.Tables(0) da.Dispose() ds.Dispose() ocon.Close() ocon.Dispose() Tag: dataset questioin Tag: 66068
  - 13
    - Different kind of db connection hallo everybody Does anyone know if it's possible to connect to a different database from access and sql server I work with perversive db and dont know how to connect to it. there are only access and sql server adapters available. if it so could anyone tell me how to do it? Tag: dataset questioin Tag: 66064
  - 14
    - pending local transaction Is there anyway to determine if the OleDbConnection is in a pending local transaction? thanks, Shawn Tag: dataset questioin Tag: 66063
  - 15
    - Values in a new datatable row Hi all, I have a very simple question: how to set default values in a new table row? 1. DataTable.RowChanged does not work if I have gui controls bound to the table, because it fires after the new record is accepted. 2. DataColumn.DefaultValue does not work either - what if I want to store the exact row-creation time? 3. CurrencyManager.PositionChanged does not work either - what if I don't have controls bound to to table. So, where is the DataTable.OnNewRow event ??? Regards radi Tag: dataset questioin Tag: 66061
  - 16
    - QueryBuilder and OLEDB I'm using VS .NET 2003 ASP.NET project C#. If I create a query like this in the query builder (using the selectcommand of a oledbDataAdapter) SELECT * FROM TABLE WHERE ID IN (?) and pass the parameters in this way myDataAdapter.SelectCommand.Parameters["paramName"].Value="'COD1','COD2'"; when I fill the dataset I obtain no rows. If I change the commandtext in SELECT * FROM TABLE WHERE ID IN ('COD1','COD2') I obtain 10 rows when fill the dataset. Can someone help me? Thanks Gianluca Miseria Tag: dataset questioin Tag: 66058
  - 17
    - Unecessary spaces in table. Why the hell is it that whenever I open a page in VS.net it always shoves blank spaces before all of my text fields. I am sick of this. I keep having to remove them every time I open the page. Tag: dataset questioin Tag: 66057
  - 18
    - some problem in System.Data with delete Hi to all I try to delete row from DataTable. When I make row.Delete sometimes I get this exception System.ArgumentOutOfRangeException I trace a little bit the problem and I think found something When I make delete in DataTable is invoked RecordStateChanged which in Turn meke this int i = LiveIndexes.Count; and then for (int j = 0; j < i; j++) { if (record1 != -1 && record2 != -1) { ((Index)indexes[j]).RecordStateChanged(record1, oldState1, newState1, record2, oldState2, newState2); } ... From here we see that this method calls RecordStateChanged in System.Data.Index and some times the LiveIndexes.Count is changed, but i is unchanged and here comes the problem If in the beginning i = 21, after this call LiveIndexes.Count = 20 , but i is still 21 and it make access by index 20 which course exception. I think that because System.Data.Index. RecordStateChanged fire event OnListChanged which in turn can change indexes ArrrayList. Can somebody help to resolve the probem? Thanks Tag: dataset questioin Tag: 66054
  - 19
    - Transaction with oledbCommandBuilder Hello, I want to give transaction support with Commands generated by OledbCommandBuilder, can anybody tell me how to do that. Regards, Devdatta Tag: dataset questioin Tag: 66050
  - 20
    - how can I make the dataadapter to return multiple recordsets? I want to use adapter.Fill(ds); to get the data result, and I hope this can contain two or more recordsets in the dataset, then I can use ds.tables[i] to access the different recordsets. thanks Tag: dataset questioin Tag: 66049
  - 21
    - VB.NET Retrieving Identity form MSSQL2000 without using stored procedures Hello! I have a problem. I'm using a dataset in VB.NET with multiple tables with relations between them. I would like dataset to update to all related tables with right identity, when certain record is added. The problem is that I don't know how to do it, when I'm not using stored procedures. I found an article in which OnRowUpdated event of the dataadapter is used. On this event ExecuteScalar method of the oledbcommand object is called to retrieve "@@Identity" http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm l/cpconretrievingidentityorautonumbervalues.asp But this example was for Access 2000 database. I tried to translate it for MSSQL 2000 but ExecuteScalar always returns null. In the same article there's an example which calls a stored procedure in a insert command. In that case everything is working perfectly, all child tables in dataset are automatically changed. Does anybody have any idea how to solve this? Regards, Taras Tag: dataset questioin Tag: 66047
  - 22
    - Basic Question - But is Stopping me... any help? how to add items and update the index of the relationship table automatically? A sample of the problem : I have 2 tables with a relationship n..n so this means that the relationship is also generating a table so what kind of code I can use to do this. table 1 has the name of the persons : table 2 has the car that this person have... Note that I already have the peoples name filled with some records. first table has a PK let's call table1_rowid second table has a PK ... table2_rowid then the relationship m to n is generating a tbl1_tbl2 where I have two fields table1_rowid and table2_rowid When I'll add a new record in the table2 for the person that has the table1.rowid =1 what is the code that I can use to automattically fill the necessary information in the relationship table tbl1_tbl2?????? No doubt that exist some code to that automattically in the new ado.net or regular oledb.... objects in the DOTNET??? Any idea, to make my life easier? Tag: dataset questioin Tag: 66043
  - 23
    - Reading output parameter from stored procedure...... In my ADO.Net coding I am using SQLCommand and SQLParameter to run stored procedure. Can any one advice me how to read the output parameter from a stored procedure. I am using SQL Server 2000. Gish Smith Tag: dataset questioin Tag: 66041
  - 24
    - "Generate Dataset" for custom data provider Hello, my company offers a set of ado.net components for its own database format and we want to respond to the general "Generate Dataset", "Preview Data" and "Configure Data Adapter" commands in the menus. In Visual Studio 2002 we had found a dirty trick to enable those commands but this doesn't work with VS 2003 anymore. The question now is whether there is now an official way to support those commands for custom data providers. Or has somebody found another way to activate them? Any help apreciated Peter Tag: dataset questioin Tag: 66027
  - 25
    - Filling a DataSet from a sql query against a XML schema Hi I'd like to know if it's possible, with an OleDbProvider, to fill a dataset from a sql squery against a XML schema. For exemple, i have this OleDbCommand : SELECT computer.name, processor.frequency, soundCard.model FROM computer INNER JOIN processor ON computer.processor_id = processor.id LEFT OUTER JOIN soundCard ON computer.soundCard_id = SoundCard.id After I use an OleDbDataAdapter to fill a dataset whose name is "computers". And I want to have to get the Xml data of this dataset. The result i want (by getting Xml) is <computers> <computer> <name>My Computer</name> <processor> <frequency>3Hz</frequency> </processor> <soundCard> <model>16 Bits sound card</model> </soundCard> </computer> </computers> But I have : <computers> <computer> <name>My Computer</name> <frequency>3Hz</frequency> <model>16 Bits sound card</model> </computer> </computers> I tried to load a schema into the dataset with ReadXml method but it seems that it doesn't work after the oleDbDataAdapter Fill method. I tried Microsoft SQLXML but it's still incomplete and very slow. So If someone knows if the thing i want to do is possible, please answer. Thanks Monorom SARIN Tag: dataset questioin Tag: 66026
- Next
  - 1
    - Two DataGrids on One Form? Could be simple solution, but I can't findcontrol !!! I have the something like the following data structure: Users users_ID, orgs_ID, users_email, users_password, etc. Orgs orgs_ID, orgs_name, orgs_description, etc. I have a single form with two datagrids. I have loaded one dataset with two tables. There is only a single record at any time in each of the tables in the bound dataset. I bind the first datagrid to one datatable, and the second datagrid to another datatable. Both datagrids seem to populate just fine in edit mode, but... My UPDATE routine is fired on the update command of the first user_profile datagrid. SO THE PROBLEM IS: I can't findcontrol for the org_id in the second datagrid. The key issue here is the need to easily enable additional records to be added to the second datagrid, to enable the registration of different orgs. Anyone know about using multiple datagrids (not necessarily nested) on the same page? Just to prove I have NO idea what I'm doing, here's some of my code my code (simplified)... CODE SNIPPET Private Sub user_profile_update(Sender As Object, E As DataGridCommandEventArgs) If page.isValid Then Dim main_email As TextBox = e.Item.FindControl("main_email") Dim main_password As TextBox = e.Item.FindControl("main_password") Dim org_id As DropDownList = CType(FindControl("org_id"), DropDownList) data_set = load_user_data() Dim data_table as String data_table = "main_identity" If data_set.tables(data_table).Rows.Count > 0 Then With data_set.tables(data_table).Rows(0) .Item("main_email") = main_email.Text .Item("main_password") = main_password.Text .Item("org_id") = org_id.selecteditem.value <<<<<< ERROR ERROR System.NullReferenceException: Object reference not set to an instance of an object. End With End If user_profile.EditItemIndex = -1 org_profile.EditItemIndex = -1 bind_profiles() ViewState("Add") = "Off" ViewState("Edit") = "Off" End If End Sub <form runat="server" name="profile"> <ASP:DataGrid id="user_profile" runat="server" Autogeneratecolumns="false" MaintainState="false" Border="0" Cellspacing="0" Cellpadding="0" ShowFooter="true" OnEditCommand="user_profile_edit" OnCancelCommand="user_profile_cancel" OnUpdateCommand="user_profile_update" DataKeyField="main_id"> <Columns> <asp:EditCommandColumn EditText="Edit" CancelText="Cancel" UpdateText="Update" /> <asp:BoundColumn DataField="main_id" ReadOnly="True" visible="false"/> <asp:TemplateColumn> <ItemTemplate> Email Address: <%# Container.DataItem("main_email") %><br> Password: <%# Container.DataItem("main_password") %><br> </ItemTemplate> <EditItemTemplate> Email Address: <asp:TextBox id="main_email" Size="7" Text='<%# Container.DataItem("main_email") %>' runat="server"/><br> Password: <asp:TextBox id="main_password" Size="7" Text='<%# Container.DataItem("main_password") %>' runat="server"/><br> </EditItemTemplate> </asp:TemplateColumn> </columns> </asp:datagrid> <ASP:DataGrid id="org_profile" runat="server" Autogeneratecolumns="false" MaintainState="false" Border="0" Cellspacing="0" Cellpadding="0" ShowFooter="false" ShowHeader="false" DataKeyField="org_id"> <Columns> <asp:EditCommandColumn visible="false" EditText="Edit" CancelText="Cancel" UpdateText="Update" /> <asp:BoundColumn DataField="org_id" ReadOnly="True" visible="false"/> <asp:TemplateColumn> <ItemTemplate> Organization Name: <%# Container.DataItem("org_name") %><br> Organization Type: <%# Container.DataItem("org_type_id") %><br> </ItemTemplate> <EditItemTemplate> Organization Name: <asp:dropDownList id="org_id" DataSource='<%# load_dropdown_data("organization_company","org_id","org_name","Other") %>' DataValueField="org_id" DataTextField="org_name" runat="server" SelectedValue = '<%# DataBinder.Eval(Container.DataItem, "org_id")%>' /> </EditItemTemplate> </asp:TemplateColumn> </columns> </asp:datagrid> </form> Thanks! Drew ssoss Tag: dataset questioin Tag: 66024
  - 2
    - dataAdapter'rs command statements Do I need to fill all the 3 commands ( InsertCommand, DeleteCommand and UpdateCommand), even though I'm using only one of them ? Like if I wants to update records in db, I'm sure that I have to assign the UpdateCommand, in this scenario, do I need to assign the Insert and Delete statements also ? TIA Kishore Tag: dataset questioin Tag: 66019
  - 3
    - SqlDataReader recordsaffected Hi. Just reading about the sqldatareader object I am confused about the recordsaffected property. The example on the help docs use a procedure with some inserts and a select. Can I use a datareader object to run sql commands that does not return records? What is the advantage of using a datareader.recordsaffected instead of command.executenonquery, since the later also can give me the records affected? Regards, Chris Leffer *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: dataset questioin Tag: 65998
  - 4
    - Trouble clearing SqlParameters from my Command object (note - sorry for the crosspost - I sent to .vb thinking i was sending to .adonet). I implemented a very small, basic data access layer for my web application. It works just fine, except for this one bug. One of my methods returns an abstracted dataset. To accomodate X number of input parameters, I created a function signature that accepts a ParamArray of SqlParameters as well as the name of the stored proc. In the body of the function I loop through the param array and append each object to the Parameters collection of my Command object. The problem comes up when I try to append a SqlParameter object that I have already used in a previous call, that is also an argument for the next stored procedure. For example, I have: dim objParam1 as New SqlParameter("@userid", intUserid) dim objDS as DataSet objDS = objDAL.GetDataSet("storedprocname", objParam1) ' do some stuff with the dataset, now try a new query, different proc, same parameter objDS.clear() objDS = objDAL.GetDataSet("anotherprocname", objParam1) The error returned is something like "There is already a parameter named objParam1 in the SqlParametersCollcetion. Prior to adding each parameter, I check its count and, if greater than 0, remove each item before appending the new params. In debugging the count is always 0, so how can there be an SqlParameter object in its collection? ' create our command object with the passed in ProcedureName. ' and sqlparameter object. Dim objCommand As New SqlCommand(ProcedureName, Me.Connection) Dim sqlParam As SqlParameter objCommand.CommandType = CommandType.StoredProcedure Me.LocalCommand = objCommand If objCommand.Parameters.Count > 0 Then ' in case any parameters are hanging around, clear them out For Each sqlParam In objCommand.Parameters objCommand.Parameters.Remove(sqlParam) Next End If objCommand.Parameters.Clear() ' add the parameters passed in from the ParamArray ' into the command's parameters collection. For Each sqlParam In DataParameters sqlParam = objCommand.Parameters.Add(sqlParam) ' ERROR THROWN HERE Next What element am I missing please? This has me bending my brain pretty badly. Thank you in advance. Tag: dataset questioin Tag: 65997
  - 5
    - SqlDataAdatper Bug? I am new to .Net but have been unable to find anything about this in the newsgroups. Using C# and the following SQL stored procedure in my SqlDataAdapter: CREATE PROCEDURE HouseholdNextPrevious @PassedName varchar(150), @Direction varchar(4) AS Set NoCount on if @Direction = 'down' /* next household */ begin SELECT TOP 1 BuildingId, LabelName, Street1, Street2, City, StateProvince, Zipcode, Country, Phone, PhoneNote, Household.CellPhone, Fax, NoNewsletter, NoAppeal, NoCalendarAnnouncement, NoFlyer, Household.InactiveId, FirstConnectionId, Salutation, ICodeId, IncomeId, PrimaryContactId, Household.Note, Household.LastEditDate, SortName = isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId)) FROM Household LEFT OUTER JOIN Individual on IndividualId = PrimaryContactId where (isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId))) > @PassedName order by SortName asc end else /* previous household */ begin SELECT TOP 1 BuildingId, LabelName, Street1, Street2, City, StateProvince, Zipcode, Country, Phone, PhoneNote, Household.CellPhone, Fax, NoNewsletter, NoAppeal, NoCalendarAnnouncement, NoFlyer, Household.InactiveId, FirstConnectionId, Salutation, ICodeId, IncomeId, PrimaryContactId, Household.Note, Household.LastEditDate, SortName = isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId)) FROM Household LEFT OUTER JOIN Individual on IndividualId = PrimaryContactId where (isnull(LastName + ' ' + FirstName + ' ' + isnull(MiddleInitial,'') + Convert(varchar(40),Household.BuildingId),'aaaaa' + Convert(varchar(40),Household.BuildingId))) < @PassedName order by SortName desc end When I generate the dataset based on the above stored procedure, it constructs two tables (HouseholdNextPrevious and Table1) in the dataset which have identical columns. If I use an OledbDataAdapter, it only contructs one table in the dataset (HouseholdNextPrevious). Any insight as to why this is happening? Thanks, Tag: dataset questioin Tag: 65995
  - 6
    - Shouldn't An Exception Be Thrown - Establishing a Primary Key Hello, I was setting the primary key on a table which was a collection of 3 columns. I mispelled the name of the second column when I built the array of collumns when I created the array of collumns for the primary key. When I used the "dt.primarykey(myArrayOfKeys)" no exception was thrown, and rather then the primary key being a set of 3 columns, it was only a single column. When you make this type of mistake when setting foreign keys, that process throws and exception. Why the inconsistency? -----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 100,000 Newsgroups - 19 Different Servers! =----- Tag: dataset questioin Tag: 65994
  - 7
    - CommandTimeout property Clarification I have a stored proc that runs and calls others and sometimes the process runs for 3 to 5 minutes depending on traffic. ASP.NET - ADO.NET - Sql 2000 Code - dim cmdV as sqlcommand = new sqlcommand("ValidateUpdatePrograms",cnOAP) cnoAP.Open() cmdV.ExecuteNonQuery() cmdV = nothing cnoap.Close() Does the CommandTimeout property refer to the time to wait until a command starts processing or does it refer to how long a command can process before it is considered overdue? If it is the second case will sql actually stop in the middle of processing? Currently I am getting Application Unavailable in the browser after the Machine.config setting responseDeadlockInterval has been exceeded. I will set this higher. But I am wondering if sql is still processing and the web server times out, will sql continue processing until it is done? I have tested and it seems like it does. It seems like it will also stick with the command until it is done no mater how long it takes. I have not set the CommandTimeout. I am trying to figure out how to make sure sql doesn't stop. Thanks! Tag: dataset questioin Tag: 65991
  - 8
    - Connection Pools I have an app that I have recently been testing to try an determine the cause of this Timeout Expired issue. I am using the performance monitor to check the # of connection pools as well as the # number of pooled connections. When I start the app and the user logs in a pool & connection is created and all is well. However when I shut down the app the pool does not go away. Then if I start the app again another pool and connection are created and soon, and so on?? Does anyone have any idea how I should deal with this? Should the pool created by the app be detroyed when the app is no longer in memory. By the way I am using CLR .Net Data for the specific app, not _global. Tag: dataset questioin Tag: 65983
  - 9
    - DataTable schema changes I need to handle dynamic changes to a table's schema, even when there is already data present. It appears that the only thing supported by DataTable is to remove a column so I am pulling all the data out into a 2D array, performing my manipulations on the raw data, and then clearing out the table's Rows and Columns collections and attempting to recreate them. Basically, Rows.Clear(); Columns.Clear(); RebuildColumns(/*...*/); RebuildRows(/*...*/); Where I rebuild the columns from a separate list of schema parameters that I have available and then rebuild the rows from the 2D array of raw data that I originally pulled from the table. For a simple test I am trying to remove the third column from a four column table (something that I suppose I could have done simply via Columns.RemoveAt, but am trying this way as a test). The problem is that when I'm adding the rows back, I'm getting an exception thrown on adding the second row: System.IndexOutOfRangeException "Cannot find Column 3" System.Data.DataTable.InsertRow Can anyone shed some light on this for me? Thanks in advance. -- Thomas Brown Tag: dataset questioin Tag: 65982
  - 10
    - OleDbConnection.Open very slow on ASP.NET App running under XP??? Does anybody know why when connecting to an Oracle database from a ASP.NET web app running under Windows XP, the connection is very slow. It takes about 2 minutes to open the database connection. The same code running on a NT2000 machine executes in under 4 seconds. To test this, is very simple On an XP machine, create a new ASP.NET app and create a new OleDbConnection object. Assign a valid connection string and execute the Open statement. That is it. The connection string I used was: Private f_cConn As String = "Provider=MSDAORA.1;Password=JJ;User ID=JJ;Data Source=OLT" ANy help is greatly need and appreciated. Tag: dataset questioin Tag: 65981
  - 11
    - The same table (types) cannot be the child table in two nested relations. I have a Schema describing an XML feed i'm receiving. The problem is, when i load it i get the above error. In this schema i have several fields describing an article. Two of these fields(tables) are called videos and sounds. They both contain a complex type (table) called Types which contain from 0-unbound number of "type" elements. So the case is. Both the sounds and the videos nodes have types/type nodes, which won't map to my DataSet. I don't think i can get the xml provider to change the format, but is there any way i can add something to the schema to allow the "same table" twice? Thanks in advance Per Here is an example to describe the problem: <xs:element name="sounds"> <xs:complexType> <xs:sequence> <xs:element name="sound" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence>  <xs:element name="types" > <xs:complexType> <xs:sequence> <xs:element name="type" type="xs:string" maxOccurs="unbounded" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> <xs:element name="videos"> <xs:complexType> <xs:sequence> <xs:element name="video" minOccurs="0" maxOccurs="unbounded"> <xs:complexType> <xs:sequence>  <xs:element name="types" > <xs:complexType> <xs:sequence> <xs:element name="type" type="xs:string" maxOccurs="unbounded" minOccurs="0" /> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> </xs:sequence> </xs:complexType> </xs:element> Tag: dataset questioin Tag: 65980
  - 12
    - dataset.haschanges=false allthough change have been made I have the following problem: I have a dataset with one table. I bind the fields of the table to several entities like textboxes etc. Now I change the values of a row of the table through the textboxes. The value in the table of my dataset has changed (I checked it) but my dataset still has the status .haschanges=false??? Why? Regrads, Christoph Tag: dataset questioin Tag: 65975
  - 13
    - SQL String Connecting to MS Access via ADO I have an SQL string that im trying to use to connect to an Access DB im currently using the following string: SQLStr = "SELECT LEFT(LTRIM(RTRIM(Personal.postcode)),LEN(personal.postcode)-1) AS Expr1, LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal INNER JOIN PendingTracker ON Personal.ID = PendingTracker.ID) LEFT JOIN LiveTracker ON Personal.ID = LiveTracker.ID) LEFT JOIN Closed ON personal.ID = Closed.ID ORDER BY LEFT(LTRIM(RTRIM(Personal.postcode)),6);" the above currently works perfectly and i have no problems but it doesnt do exaclty as i want, what i would like it to do is this statement: SQLStr = "SELECT Left(Personal.postcode,Len(personal.postcode)-2) AS Expr1, LiveTracker.ID, LiveTracker.MortgageAppSubmitted, Closed.ID FROM ((Personal INNER JOIN PendingTracker ON Personal.ID = PendingTracker.ID) LEFT JOIN LiveTracker ON Personal.ID = LiveTracker.ID) LEFT JOIN Closed ON Personal.ID = Closed.ID ORDER BY personal.postcode;" the only difference between the two SQL statements is that the second statement takes 2 charachetrs from the end of postcode whereas the first statment only removes one! when i try to run the second statement I get the following error: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: The provider could not determine the String value. For example, the row was just created, the default for the String column was not available, and the consumer had not yet set a new String value. any help with this would be greatly appreciated Regards Mike Fellows Tag: dataset questioin Tag: 65966
  - 14
    - difference between output and returnValue sqlParameter ? Hello ! Can someone please explain to me what the difference between "output" and "returnValue" as direction for sqlParameter in a stored Procedure ? Thanks, Lanz Tag: dataset questioin Tag: 65965
  - 15
    - COM+ vs ADO.NET I am a newbie in .NET, I am trying to implement Database access components which need to handle transaction management and concurrency control. I have been seeing that the COM+ provides functionalities on transaction management, but is the difference between the COM+ transactions and the transactions in ADO.NET? And which one should i use to get a better performance or which one is simpler to implement? Tag: dataset questioin Tag: 65964
  - 16
    - DataRow Position How can I find the DataRow position into the DataRowCollection when I have got the DataRow object after a call to DataTable.Find or Select (C#) Thanks Tag: dataset questioin Tag: 65961
  - 17
    - how can export datatable to excel how can export datatable to excel i try to use new excel application then fill data to excel but it very slow how can i to do export datatable to excel fast thanks Tag: dataset questioin Tag: 65960
  - 18
    - Is Data Binding for Drop Down box slow? Project is on ASP.NET+VB.NET. We are using many binded drop down boxes in the project. Page display is slow, is this because of binding of data? What are the alternate approaches please. Thanks, Raghavendra Narayana Tag: dataset questioin Tag: 65949
  - 19
    - Updating a DataTable as opposed to a DataSet Hi, I have loaded up some data into a DataTable as opposed to a Dataset. The DataAdapter allows this. I don't need all the associated stuff with the DataSet and this is why I have chosen the DataTable. However I'd like to update the changes to the DataTable to the database it was loaded from. The DataAdapter can update a dataset but not a datatable. How can I do this then without having to resort to a manual procedure. Does the version of the .NET framework I'm running make a difference. I have 1.0. Does 1.1 support updating of DataTables. Thanks, Nick Zdunic Tag: dataset questioin Tag: 65940
  - 20
    - param array and stored procedure call Is there any way to modify the following code so I can run it with any number of paramNames as well as any number of paramValues? So far it works with an array of paramValues, but since you can only pass a variable number of parameters in the last parameter of a method, I'm stumped. Perhaps the paramValues could be multidimensional? And a (?) has to be present for each paramName as well, correct? Thanks in advance. public DataSet returnStoredProc(string spName, string paramName, params Object[] paramValues) { OdbcDataAdapter _da = new OdbcDataAdapter(); DataSet _ds = new DataSet(); OdbcConnection cn = new OdbcConnection(connectionString); try { OdbcCommand _cmdSel = new OdbcCommand(); OdbcParameter prm = new OdbcParameter(); cn.Open(); _da.SelectCommand = _cmdSel; _cmdSel.CommandText = "{CALL " + spName + " (?)}"; _cmdSel.CommandType = CommandType.StoredProcedure; _cmdSel.Connection = cn; for (int x = 0; x < paramValues.Length; x++) _cmdSel.Parameters.Add("@" + paramName, paramValues[x]); _da.Fill(_ds); return _ds; cn.Close(); } } Tag: dataset questioin Tag: 65934
  - 21
    - Hello I need help about to use the component CrystalResport or Reports in C#......Yuni Tag: dataset questioin Tag: 65933
  - 22
    - ExecuteReader and output params Hi I am trying to run SP using ExecuteReader for SqlCommand object. SP has Output parameters that I add to Parameters collections but it seems that output parameter is always null. Debugging SP return not null values so it is not a problem with SP. Does ExecuteReader skips output parameters? Thanks, Shimon. Tag: dataset questioin Tag: 65925
  - 23
    - Excluding Noise Words from Search How can check if a search phrase contains a noise word and let the user about it so he/she can do search again without the noise word. Thanks, -- Dino Buljubasic Software Developer http://rivusglobal.com Tag: dataset questioin Tag: 65923
  - 24
    - Connection class Hi How can I create and call a class for a connection to my database? Code example would be great. Thanks Regards Tag: dataset questioin Tag: 65922
  - 25
    - RowFilter - Accent Insensitive with Strings Hello Folks! I have a SQL Server table column and two records. One column have "Porão" and the other "Porao". I want filter my dataview using the RowFilter property. example: dv.RowFilter = "column = 'Porao'" datagrid.datasource=dv datagrid.databind(); I need to see two records. But i see only one because the filter use accent sensitive when searching. Is there a way to configure the dataset for accent sensitive? Tks Robson Tag: dataset questioin Tag: 65920

Hi

I think I've a simple question.
I'm using c# and have written a method that gets the dataset as an argument.
In this method I want to retrieve the used sql statement what was used for
building this dataset, is this possible ?
So I only have to dataset and want to retrieve the sqlstatement (eg select *
from customer)

Kris

Top

Re: dataset questioin by Mary

Mary
Wed Sep 17 12:34:16 CDT 2003

Not unless you passed it along somehow as part of the data. the
DataSet is a local cache, and doesn't know anything about where the
data came from.

-- Mary
MCW Technologies
http://www.mcwtech.com

On Wed, 17 Sep 2003 20:14:35 +0200, "Nonkel Buck" <joske@ms.com>
wrote:

>Hi
>
>I think I've a simple question.
>I'm using c# and have written a method that gets the dataset as an argument.
>In this method I want to retrieve the used sql statement what was used for
>building this dataset, is this possible ?
>So I only have to dataset and want to retrieve the sqlstatement (eg select *
>from customer)
>
>Kris
>

Top