DataSet/field alias

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
    - ADO unable to get values This may not be in the correct place, but I am getting desperate. I am trying to get the field @FileName using vbscript. The store procedure looks like this, and I have already tried putting @FILENAME OUTPUT below the declarations and I received an error. if exists (select * from sysobjects where id = object_id('dbo.wu_ProcessQueue') and sysstat & 0xf = 4) drop procedure dbo.wu_ProcessQueue GO CREATE PROCEDURE wu_ProcessQueue AS declare @FCN int declare @FileName varchar(8) declare @myCommand varchar(175) IF (SELECT count(*) from wu_Queue where FCN = 0) = 0 RETURN exec @FCN = wu_CreateNewFCN 'I' , @FILENAME OUTPUT select * from pfa.dbo.myTable select @FileName update wu_Queue SET FCN = @FCN where FCN = 0 GO GRANT EXECUTE ON dbo.wu_ProcessQueue TO myName GO I am using VBScript and this is what the ADO looks like: Dim myNewFilex Set objCmd = CreateObject("ADODB.command") Set objCmd.ActiveConnection = cnDB objCmd.CommandText = "pfa.dbo.myTable " objCmd.CommandType = 4 Set paraFileName = objCmd.CreateParameter("@FileName") paraFileName.Type = 200 paraFileName.Value = vbNULL paraFileName.Direction = 2 objCmd.Execute MsgBox myNewFilex myNewFilex = parafileName.Value MsgBox myNewFilex On MessageBox, all I am getting is an integer of 1 on both instances. Thanks in advance for any insight. Tag: DataSet/field alias Tag: 101699
  - 2
    - Filtering a DataTable I'm trying to filter a DataTable... first I do a SELECT on my DataTable... and assign the result to a DataRow array... then I CLEAR the DataTable... and try to import the DataRows from the DataRow array... I end up with an empty DataTable... what am I doing wrong? And... is there a better way to do this? Tag: DataSet/field alias Tag: 101696
  - 3
    - DataSet binding/updates If I base my DataSet on a schema (an .xsd file), and then bind the controls on my form to the necessary fields in a DataTable in the DataSet, how then would I use the SqlDataAdapter to put all this information into the database? Loading the DataSet from a schema is easier than basing it on a query since there are several tables involved. Tag: DataSet/field alias Tag: 101694
  - 4
    - Datasets and merging Hi! I want to extract a single row from one table in a typed dataset (dsUser) containing multiple tables, and then send it on to a data access layer component for create/read/update/delete operations. I found two ways: 1. Create a standalone typed dataset (dsPerson) with the same structure as the one table I'm interested in, and use the Merge function to get the content of the datatable. dsPerson.Merge(dsUser.COR_Persons) 2. Extract the row by using the ItemArray property of the dsPerson.COR_Persons and dsUser.COR_Persons datatables respectively. Dim dsPerson As New COR_Persons Dim personRow As COR_Persons.COR_PersonsRow personRow = dsPerson.COR_Persons.NewCOR_PersonsRow personRow.ItemArray = dsUser.COR_Persons(0).ItemArray The first approach is the easiest implement, but I get a bulkier object to send on the data access layer. Does someone now anything about the performance differences for these two approaches? TIA Jonas Tag: DataSet/field alias Tag: 101692
  - 5
    - ASP.NET vs VB.NET guys i have a very simple question concerning the differences between the two. for instance, radio buttons and the checkchanged event. it really doesnt seem to respond in asp.net if i set an if statemtent in that control, where if checked = true, then one thing happens, or if checked = false another thing happens. but, in VB.NET it responds perfectly. is there something extra i have to do. i am using the radio button as a server control. thanks guys. i know this is a pretty simple one for probably everyone..........but, it's kinda got me curious thanks rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: DataSet/field alias Tag: 101684
  - 6
    - Named tables/Sql Server/Can't do TableMappings I have a stored proc that returns me multiple tables. Is there a way I could set their names to be something other than TABLE TABLE1 TABLE2 ... ?? Sorry TableMappings won't do !! I can't use that for certain reasons. I have to be able to do something in the T-Sql that after SqlDataAdapter.Fill, my tables are named properly. DM Tag: DataSet/field alias Tag: 101674
  - 7
    - Update to Visual FoxPro 6 Table is failing Everything I've read says the below code should update the foxpro table, but it doesn't. The dataview and datagrid are being updated, but the actual foxpro table isn't. The table has 3 fields ( idnum, fname and lname). The select statement gets the one matching record just fine. The record in the table has the number 2 in the idnum field, and I'm trying to change it to the number 90. I also have downloaded and installed the latest Microsoft VFPOLEDB provider from http://www.microsoft.com/downloads/details.aspx?familyid=0f43eb58-7a94-4ae1-a59e-965869cb3bc9&displaylang=en#filelist ***** code in button **** Dim ConnFoxTest As OleDbConnection = New OleDbConnection Dim SqlCmdFoxTest As OleDbCommand = New OleDbCommand Dim DaFoxTest As OleDbDataAdapter = New OleDbDataAdapter Dim DsFoxTest As DataSet = New DataSet Dim DvFoxTest As DataView = New DataView Dim idNum As Integer Dim StrSqlCmdFoxTest As String StrSqlCmdFoxTest = "Select * From FoxTest where fname='Jeff'" ConnFoxTest.ConnectionString = "Provider=VFPOLEDB.1;Data Source=c:\temp\foxtest.dbf;Persist Security Info=False" ConnFoxTest.Open() SqlCmdFoxTest.Connection = ConnFoxTest DaFoxTest.SelectCommand = SqlCmdFoxTest DaFoxTest.SelectCommand.CommandText = StrSqlCmdFoxTest DaFoxTest.Fill(DsFoxTest) DvFoxTest.Table = DsFoxTest.Tables.Item(0) idNum = DvFoxTest.Item(0).Item("idnum") ' Messagebox shows '2' MsgBox(Str(idNum)) DvFoxTest(0).BeginEdit() DvFoxTest(0)("idnum") = 90 DvFoxTest(0).EndEdit() DsFoxTest.AcceptChanges() DaFoxTest.Update(DsFoxTest) idNum = DvFoxTest.Item(0).Item("idnum") ' Messagebox shows '90' MsgBox(Str(idNum)) ' datagrid also shows '90' in the idnum field DataGrid1.SetDataBinding(DsFoxTest, DsFoxTest.Tables.Item(0).TableName) DvFoxTest.Dispose() DsFoxTest.Dispose() DaFoxTest.Dispose() SqlCmdFoxTest.Dispose() ConnFoxTest.Close() **** end code ******* Tag: DataSet/field alias Tag: 101671
  - 8
    - Child rows Hi guys, I need to know how to create child rows for a newly created parent row. I've been doing it one way, but it's obviously not the right way to do it (finally starting to cause me some problems!). Here's what I've been doing ("ParentID" is the primary key): \\ Dim NewParent as DataRow = tblParentTable.NewRow '<Initialize NewParent values> tblParentTable.Rows.Add(NewParent) Dim NewChild as DataRow = tblChildTable.NewRow NewChild.Item("ParentID") = CInt(NewParent.Item("ParentID")) '<Initialize other NewChild values> tblChildTable.Rows.Add(NewChild) // What happens is, the dataset creates a "temporary" value for ParentID, and that value is assigned to the child rows. So the relationship works okay until the database is updated and then the tables refilled. On update, the database sometimes gives a different value for ParentID than the database had, but that value change is not carried through to the child rows. What is the proper way to do this? Thanks, Nathan Tag: DataSet/field alias Tag: 101661
  - 9
    - How to INSERT pure <NULL> Into SmallDataTime Field (MS SQL Server) I need to insert NULL into the field with SmallDataTime datatype. In .NET when I tried to use "" or DBNull.Value it insert "" what will be automatically converted into '1/1/1900' by SQL Server... I need to have the Insert statement like this: INSERT tblTest (Name,smDate) Values ('John',NULL) But using pure NULL without double quotes ("") is not allowed in .NET. When I use double quotes ("NULL"), .NET interpreted it as character string and I got the SQL converting error. Thank you for the help. Eugene Tag: DataSet/field alias Tag: 101659
  - 10
    - CommandBuilder InsertCommand Update Hi All!!! Seasons Greetings.... I have read a lot of the post regarding CommandBuilder, InsertCommand and Update. The code below works.... 'This is a foxpro table that matches my MS SQL Table fpDA = New OleDbDataAdapter("select * from table", GetConnection) flat = New System.Data.DataSet() fpDA.Fill(flat, "table") Try Dim cn As New Data.SqlClient.SqlConnection(ConnSqlClient) cn.Open() da = New Data.SqlClient.SqlDataAdapter("select * from table", cn) cb = New Data.SqlClient.SqlCommandBuilder(da) cb.QuotePrefix = "[" cb.QuoteSuffix = "]" da.InsertCommand = cb.GetInsertCommand() Dim p As Data.SqlClient.SqlParameter Dim row As Data.DataRow Dim col As Data.DataColumn For Each row In flat.Tables("table").Rows For Each p In da.InsertCommand.Parameters p.Value = row.Item(p.SourceColumn) Next affectedRows += da.InsertCommand.ExecuteNonQuery Next Return affectedRows Catch ex As Exception MsgBox(ex.Source & vbCrLf & ex.Message) End Try There should be more documentation for the "Update" command from Microsoft. It seems that if you just wanted to insert an unmodified table directly into SQL server using CommandBuilder is a no go. Once again...there should be documentation showing how to insert unmodified data (rowstate is unchanged) into an SQL server database with out getting a headache and eye strain. Markus McGee Tag: DataSet/field alias Tag: 101653
  - 11
    - Data Access Application Block v3? Hi Guys, Have just downloaded v2 of the Data Access Application Block but see that v3 is available on the GotDotNet website. Does anyone know: if v3 is stable enough for use in real systems and when Microsoft are likely to release it officially. Cheers, Peter Tag: DataSet/field alias Tag: 101644
  - 12
    - Different results with the same query?!? Hi all, I want to check if a record exists in the DB. I use two different ways to create the sql query. One way is by using SqlCommand and SqlParameter. The other way by building the query myself (without SqlParameter(s)) and using the SqlCommand to execute it. In one I get false in the other i get true. Can anyone help me? //////////////////////////////////////////////// //Build the query using SqlParameters //////////////////////////////////////////////// SqlCommand m_MessageSelectCommand = new SqlCommand(); m_MessageSelectCommand.CommandText = "SELECT MessageNumber FROM Messages WHERE CommunityNumber=@CommunityNumber and ForumParent=@ForumParent and ForumNumber=@ForumNumber and WrittenBy=@WrittenBy and MessageDate=@MessageDate"; m_MessageSelectCommand.Connection = m_Connection; m_MessageSelectCommand.CommandTimeout = 0; m_MessageSelectCommand.Parameters.Add(new SqlParameter("@CommunityNumber", System.Data.SqlDbType.Int, 4, "CommunityNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumNumber", System.Data.SqlDbType.Int, 4, "ForumNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumParent", System.Data.SqlDbType.Int, 4, "ForumParent")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@WrittenBy", System.Data.SqlDbType.NVarChar, 100, "WrittenBy")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@MessageDate", System.Data.SqlDbType.DateTime, 8, "MessageDate")); // later in the code m_MessageSelectCommand.Parameters["@CommunityNumber"].Value = dlMessage.m_CommunityNumber; m_MessageSelectCommand.Parameters["@ForumParent"].Value = dlMessage.m_ForumNumber; m_MessageSelectCommand.Parameters["@ForumNumber"].Value = dlMessage.m_TopicNumber; m_MessageSelectCommand.Parameters["@WrittenBy"].Value = dlMessage.m_MessageAuthor; m_MessageSelectCommand.Parameters["@MessageDate"].Value = dlMessage.m_MessageDate; SqlDataReader reader = m_MessageSelectCommand.ExecuteReader(); bool b = reader.HasRows; // B IS FALSE!!! //////////////////////////////////////////////// //The other way - just build the query by myself //////////////////////////////////////////////// System.Text.StringBuilder sql = new System.Text.StringBuilder(256); sql.Append("SELECT MessageNumber FROM Messages WHERE CommunityNumber="); sql.Append(dlMessage.m_CommunityNumber); sql.Append(" and ForumParent="); sql.Append(dlMessage.m_ForumNumber); sql.Append(" and ForumNumber="); sql.Append(dlMessage.m_TopicNumber); sql.Append(" and WrittenBy='"); sql.Append(dlMessage.m_MessageAuthor); sql.Append("' and MessageDate='"); sql.Append(dlMessage.m_MessageDate); sql.Append("'"); SqlCommand c = new SqlCommand(sql.ToString(), m_Connection); SqlDataReader reader = c.ExecuteReader(); bool b = reader.HasRows; // I get that b is true. This happens durring the same program execution How can this be??? Tag: DataSet/field alias Tag: 101642
  - 13
    - Different results with the same query?!? Hi all, I want to check if a record exists in the DB. I use two different ways to create the sql query. One way is by using SqlCommand and SqlParameter. The other way by building the query myself (without SqlParameter(s)) and using the SqlCommand to execute it. In one I get false in the other i get true. Can anyone help me? //////////////////////////////////////////////// //Build the query using SqlParameters //////////////////////////////////////////////// SqlCommand m_MessageSelectCommand = new SqlCommand(); m_MessageSelectCommand.CommandText = "SELECT MessageNumber FROM Messages WHERE CommunityNumber=@CommunityNumber and ForumParent=@ForumParent and ForumNumber=@ForumNumber and WrittenBy=@WrittenBy and MessageDate=@MessageDate"; m_MessageSelectCommand.Connection = m_Connection; m_MessageSelectCommand.CommandTimeout = 0; m_MessageSelectCommand.Parameters.Add(new SqlParameter("@CommunityNumber", System.Data.SqlDbType.Int, 4, "CommunityNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumNumber", System.Data.SqlDbType.Int, 4, "ForumNumber")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@ForumParent", System.Data.SqlDbType.Int, 4, "ForumParent")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@WrittenBy", System.Data.SqlDbType.NVarChar, 100, "WrittenBy")); m_MessageSelectCommand.Parameters.Add(new SqlParameter("@MessageDate", System.Data.SqlDbType.DateTime, 8, "MessageDate")); // later in the code m_MessageSelectCommand.Parameters["@CommunityNumber"].Value = dlMessage.m_CommunityNumber; m_MessageSelectCommand.Parameters["@ForumParent"].Value = dlMessage.m_ForumNumber; m_MessageSelectCommand.Parameters["@ForumNumber"].Value = dlMessage.m_TopicNumber; m_MessageSelectCommand.Parameters["@WrittenBy"].Value = dlMessage.m_MessageAuthor; m_MessageSelectCommand.Parameters["@MessageDate"].Value = dlMessage.m_MessageDate; SqlDataReader reader = m_MessageSelectCommand.ExecuteReader(); bool b = reader.HasRows; // B IS FALSE!!! //////////////////////////////////////////////// //The other way - just build the query by myself //////////////////////////////////////////////// System.Text.StringBuilder sql = new System.Text.StringBuilder(256); sql.Append("SELECT MessageNumber FROM Messages WHERE CommunityNumber="); sql.Append(dlMessage.m_CommunityNumber); sql.Append(" and ForumParent="); sql.Append(dlMessage.m_ForumNumber); sql.Append(" and ForumNumber="); sql.Append(dlMessage.m_TopicNumber); sql.Append(" and WrittenBy='"); sql.Append(dlMessage.m_MessageAuthor); sql.Append("' and MessageDate='"); sql.Append(dlMessage.m_MessageDate); sql.Append("'"); SqlCommand c = new SqlCommand(sql.ToString(), m_Connection); SqlDataReader reader = c.ExecuteReader(); bool b = reader.HasRows; // I get that b is true. This happens durring the same program execution How can this be??? Tag: DataSet/field alias Tag: 101641
  - 14
    - Question about relationships - "cycles or multiple cascade paths" error I have 2 tables: Table: UserTable Field: Id (pk) Field: FullName Table: MarriageTable Field: MarriageId (pk) Field: Husband Field: Wife The MarriageTable.Husband and MarriageTable.Wife fields BOTH have to be valid users from the UserTable. In SQL Server I'm creating a relationship diagram. I (1) dragged Id from UserTable to MarriageTable.Husband and (2) dragged Id from UserTable to MarriageTable.Wife. But, the Diagram has trouble saving the Wife relationship. Any ideas? Am I doing this correctly? Here's the error: 'UserTable' table saved successfully 'MarriageTable' table - Unable to create relationship 'FK_MarriageTable_UserTable1'. ODBC error: [Microsoft][ODBC SQL Server Driver][SQL Server]Introducing FOREIGN KEY constraint 'FK_MarriageTable_UserTable1' on table 'MarriageTable' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints. [Microsoft][ODBC SQL Server Driver][SQL Server]Could not create constraint. See previous errors. Thanks. Tag: DataSet/field alias Tag: 101640
  - 15
    - VB.NET: How to apply a DataView Can somebody please help. I'm coming from VB6 and this is my first VB.NET applciation. Below is my code that fills two tables contained in a DataSet, creates a relation between them, and finally, uses them as DataSources for two grid controls on the form. This code works prefectly fine. Now, my question is how do I apply a DataView in order to sort and filter my data without destroying my relation? Ever snippet of code I've looked at involves setting up a DataView and then setting it to the DataSource of my DataGrid. This, however, destroys my relation. Thanks for any help. m_Ds = New DataSet m_Da1 = New OleDbDataAdapter("SELECT * FROM Groups", Conn) m_Da2 = New OleDbDataAdapter("SELECT * FROM Clients", Conn) m_Da1.FillSchema(m_Ds, SchemaType.Source, "Groups") m_DgGroupsCount = m_Da1.Fill(m_Ds, "Groups") m_Da2.FillSchema(m_Ds, SchemaType.Source, "Clients") m_Da2.Fill(m_Ds, "Clients") 'Create a relation and add it to the collection. Dim rel1 As New DataRelation("LinkToClients", _ m_Ds.Tables("Groups").Columns("GroupID"), _ m_Ds.Tables("Clients").Columns("GroupID")) m_Ds.Relations.Add(rel1) 'Master/detail setup. Me.dgGroups.DataSource = m_Ds Me.dgGroups.DataMember = "Groups" Me.dgGroups.AllowNavigation = False Me.dgClients.DataSource = m_Ds Me.dgClients.DataMember = "Groups.LinkToClients" Tag: DataSet/field alias Tag: 101638
  - 16
    - comparing two lists hey guys, i need some help on an approach. i need to compare, two different lists. one will be pulled from a dataset and could have as much as 2500 varchar employee numbers in it. the other will have the same data, but might be missing some of those same numbers. what's the best way to compare the two lists, or group or array and find who's missing from the second list? thanks rik ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: DataSet/field alias Tag: 101635
  - 17
    - Validating data. Hi everybody, this is my first post in this group. I'm working with an Access DB and i have the following code to validate fields with unique indexes (no duplicates): 'Field is a DataColumn If Field.Unique Then If Field.Table.Rows.Contains(NewData) Then Return "Error: This field can't have duplicate values." End If End If The problem that i found is that apparently the property 'Unique' works only for Primary Keys fields. So, how do i make a similar validation but with fields with unique indexes only (no Primary Key)? The other doubt that i have is that the property 'DataColumn.DefaultValue' doesn't set itself to anything when i get the values from a field wich has a default value. Note: I fill a DataSet with Fill and FillSchema methods in order to do the tests. Thanks. Tag: DataSet/field alias Tag: 101633
  - 18
    - OT: Database Design I am trying to make sure I'm using best practice for an Access table. If I have a table that has 100 discrete colums. Is it best to just keep the table with so many columns or to split it into a few other tables. The 100 columns are indeed discrete so splitting them isn't going to reduce any duplication of data. Tag: DataSet/field alias Tag: 101622
  - 19
    - how to merge 5 tables into one table I have a dataset that reads from an xml file. When the file was read, 5 tables where created.having the relationship between the table. how can i merge those five tables into one table or better yet how can i make that table relational? thanks Tag: DataSet/field alias Tag: 101620
  - 20
    - bound textbox text change won't save to dataset BlankHi, I select a value in a bound combobox on tab 1, then I programically assign related text to a bound textbox's text property on tab 2. I see the text in the textbox when I view tab 2 and the textchanged event fired. However, after I save the changes, close the form, reopen the form, the previous data appears in the textbox, not the new data. Here's the code from the combobox's selectedIndexChanged event: With txtSignalOffset .Focus() .Text = "10" End With CType(sender, ComboBox).Focus() CType(cmTerminal.Current, DataRowView).EndEdit() Both the combobox and textbox are bound to the same datatable. If I type data directly into the textbox there is no problem. However I want the textbox to be read only and assigned a value by code only. I tried editing the CType(cmTerminal.Current, DataRowView) datarow directly but then got screwy behavior from the combobox such that it wouldn't change its selected value - it kept bouncing back to the original value. Same thing happened when I instead tried directly editing the datatable. This is driving me crazy and wasting a lot of time. Thanks for any insights you may have, NJ Tag: DataSet/field alias Tag: 101615
  - 21
    - return value from stored procedure using SqlHelper.UpdateDataset Hi, I'm trying to update the Database (sql2000) using the DAAB v2.0 SqlHelper.UpdateDataset method. The problem is that my insert stored procedure returns the primary keys of my new inserted rows as a returned values parameters. But with the above method there seems to be no way to get back those parameteres. What woul be the best way to overcome this problem? Thanks, Gwenda Tag: DataSet/field alias Tag: 101613
  - 22
    - UPDATING database using datagrid : error on UPDATE button click I am using a datagrid to write data to the database. I am using the walkthrough by msdn "Using a datagrid to Read & write data to Database". But when i hit the update button I get the following error: : Object reference not set to an instance of an object. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.NullReferenceException: Object reference not set to an instance of an object. Source Error: Line 348: Line 349: // Updates the dataset table. Line 350: r.CompanyName = track; Line 351: r.Region =esn; Line 352: Source File: c:\inetpub\wwwroot\demo\boflog\viewrec.aspx.cs Line: 350 Stack Trace: [NullReferenceException: Object reference not set to an instance of an object.] BofLog.ViewRec.DataGrid1_UpdateCommand_1(Object source, DataGridCommandEventArgs e) in c:\inetpub\wwwroot\demo\boflog\viewrec.aspx.cs:350 System.Web.UI.WebControls.DataGrid.OnUpdateCommand(DataGridCommandEventArgs e) +109 System.Web.UI.WebControls.DataGrid.OnBubbleEvent(Object source, EventArgs e) +507 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.DataGridItem.OnBubbleEvent(Object source, EventArgs e) +100 System.Web.UI.Control.RaiseBubbleEvent(Object source, EventArgs args) +26 System.Web.UI.WebControls.LinkButton.OnCommand(CommandEventArgs e) +120 System.Web.UI.WebControls.LinkButton.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +115 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +138 System.Web.UI.Page.ProcessRequestMain() +1292 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2032; ASP.NET Version:1.1.4322.2032 MY CODE for UPDATE button click is:: private void DataGrid1_UpdateCommand_1(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e) { string track, esn; // Gets the value of the key field of the row being updated string key = DataGrid1.DataKeys[e.Item.ItemIndex].ToString(); // Gets get the value of the controls (textboxes) that the user // updated. The DataGrid columns are exposed as the Cells collection. // Each cell has a collection of controls. In this case, there is only one // control in each cell -- a TextBox control. To get its value, // you copy the TextBox to a local instance (which requires casting) // and extract its Text property. // // The first column -- Cells(0) -- contains the Update and Cancel buttons. TextBox tb; // Gets the value the TextBox control in the third column tb = (TextBox)(e.Item.Cells[1].Controls[0]); track = tb.Text; // Gets the value the TextBox control in the fourth column tb = (TextBox)(e.Item.Cells[3].Controls[0]); esn = tb.Text; // Finds the row in the dataset table that matches the // one the user updated in the grid. This example uses a // special Find method defined for the typed dataset, which // returns a reference to the row. dsCompany.FormFieldsRow r; r = dsCompany1.FormFields.FindBy_AsiOrder_(key); // Updates the dataset table. r.CompanyName = track; r.Region =esn; // Calls a SQL statement to update the database from the dataset sqlDataAdapter1.Update(dsCompany1); // Takes the DataGrid row out of editing mode DataGrid1.EditItemIndex = -1; // Refreshes the grid DataGrid1.DataBind(); } I think the problem is bcoz " key" is a string & r maybe is an int. But when I tried doing r = dsCompany1.FormFields.FindBy_AsiOrder_(INT.PARSE(key)); it showed error! Please help. thanks -- pmud Tag: DataSet/field alias Tag: 101612
  - 23
    - Read Description of Field Any way in ADO to get to the Description of the field - for example, in Access you can provide a logical description for each field in the table. Thanks, Scott Tag: DataSet/field alias Tag: 101611
  - 24
    - INSERT into Access Database using C# from ASP page The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. Is the error message I get when it gets to dbCmd.ExecuteNonQuery();. I have 15 fields to insert, therefore I did one field at the time and found that the 13th field is the one causing the problem, this field has size 20 and data I am entering has size is 1. I took the INSERT command and entered it from Access Query and it worked, but not from ASP page using C#. Please help I thank you for your assistance. I found the similar error in http://www.error-bank.com/microsoft.public.dotnet.languages.vb.1/196223_Thread.aspx. But there were no solutions posted. Tag: DataSet/field alias Tag: 101606
  - 25
    - Recordsets and Ref Cursors I am passing an ADODB.Recordset (rs) into a .Net C# dll. I need to fill a dataset using Oracle.DataAccess.Client.DataAdaptor. OracleDataAdapter da = new OracleDataAdapter(); DataSet ds = new DataSet(); DataTable dt = new DataTable(); da.Fill(dt, rs); This does not work. I need to use: da.Fill(dt, ref cursor); How do I convert the recordset (rs) to a ref cursor? Thanks.... -- Robert Hill Senior Programmer/Analyst Wake Forest Univ Baptist Med Ctr Tag: DataSet/field alias Tag: 101595
- Next
  - 1
    - Database Insert with IDENTITY ON I have a situation where I have two datasets each equal with the data from the same table. I want to update one dataset with the records from the next dataset IDs in tact. Here's the code I have: ' Set AcceptChangesDuringFill = False objDataAdapterSource.AcceptChangesDuringFill = False ' Fill the data adapter with some data from the source "myTable" objDataAdapterSource.Fill(objDataSetSource, "myTable") ' This is a function I wrote that just calls the "SET ' IDENTITY_INSERT myTableON" SetIdentityInsert(True, "myTable") ' Select everything from myTable on the database toupdate and ' create a data adapter strSQL = "SELECT * FROM myTable" objDataAdapterDest= New SqlClient.SqlDataAdapter(strSQL, strConn) ' create a commandbuilder object objCB = New SqlClient.SqlCommandBuilder(objDataAdapterDest)' 'Update the destination data set objDataAdapterDest.Update(objDataSetSource, "myTable") Let's say the Source object objDataSetSource had a "myTable" with two columns" "TableID" and "Description" where "TableID" was the key. Let's say it had one row, where the TableID = 1 and Description = "TEST". I am expecting the same table in the destination database to be inserted with the exact same data. Instead, the TableID ends up being generated by the database as if Identity_Insert isn't turned on. Any suggestions? Tag: DataSet/field alias Tag: 101586
  - 2
    - Adding Columns to DataSet-DataTable out of Position Is it possible to add a column to an existing DataTable (in a DataSet) with the new column being some place other than the end of the column collection? I looked at Columns.Add and there is no position parameter and there is no InsertAt method like some other collections. Is this possible through some other means? Maybe create a new Table and copy data??? Thanks, Ashton Tag: DataSet/field alias Tag: 101580
  - 3
    - PRIMARY KEY required for WRITING data to SQL DATABASE using DATA G I am posting this question here too coz I was not sure whether I had posted this earlier in the right group. I need an editable datagrid. But for editing a datagrid as shown in the walkthrough: Using a DataGrid Web Control to Read and Write Data, the table in the SQL database should have a primary key. But my table doesnt have one. So what is the best way I can create primary key in SQL database? Is UNIQUE IDENTIFIER a good option? Is it something like Auro Number of MS Access which is automatically filled by the database for each row? If not , how can i make a primary key for that SQL table? -- pmud Tag: DataSet/field alias Tag: 101578
  - 4
    - MEMBER_UNIQUE_NAME property NULL Hi, I use OleDb (.NET) to execute MDX queries. An simple example query: WITH MEMBER [Promotion Media].[CalcMember] AS '[Promotion Media].[All Media].[Bulk Mail]'SELECT {[Measures].[Unit Sales]} ON COLUMNS,{[Promotion Media].[All Media].[Bulk Mail], [Promotion Media].[CalcMember]} PROPERTIES MEMBER_UNIQUE_NAME ON ROWS FROM [Sales] When I use OleDb to execute this query and populate a DataTable object, the MEMBER_UNIQUE_NAME column value for the [CalcMember] row comes up NULL instead of "[Promotion Media].[CalcMember]". [Promotion Media].[Media Type].[Member_Unique_Name] [Measures].[Unit Sales] ========================================= ================ [Promotion Media].[All Media].[Bulk Mail] 4320 (null) 4320 Can anyone tell me why that is and how to fix it? Thanks in advance. Tag: DataSet/field alias Tag: 101572
  - 5
    - How to kow the Lenght of the Text in the Current DataGridTextBoxColumn (on MouseMove) Hi, I need to know the Lenght of the Text in a DataGridTextBoxColumn when I move with the mouse over it, and show it in a ToolTip. I have something that works, but it works only when the DataGridextBoxColumn is not selected. Once I select it (type some additional text in it), I don't see the ToolTip anymore... I gues that's because it isn't anymore the DataGrid that the Mouse is moving over, but the Cell. Does anybody knows a solution for this? Thanks a lot in advance, Pieter You can see my DataGrid_MouseMove here: Private Sub dbgGrid_MouseMove(ByVal sender As Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles dbgGrid.MouseMove Dim p1 As New Point p1 = dbgGrid.PointToClient(Cursor.Position) Dim intCol As Integer = dbgGrid.HitTest(p1).Column Dim intRow As Integer = dbgGrid.HitTest(p1).Row If (intCol = 3) And (intRow > -1) Then Dim strT As String Try strT = dbgGrid.Item(intRow, intCol).ToString Catch ex As Exception strT = "" End Try strT = strT & vbCrLf & "Length: " & strT.Length totImport.SetToolTip(dbgGrid, strT) totImport.Active = True Else totImport.SetToolTip(dbgGrid, "") totImport.Active = False End If End Sub Tag: DataSet/field alias Tag: 101569
  - 6
    - How to fill multiple datatables in a dataset in a single fill Anyone who knows how to fill more than one datatable in a single fill using a dataadapter? I have 4 joined tables in a select-statement that I want to fill into their datatables. Now I have to make 4 selects to do that, and that's no good. Alternatively make a datatable representing all 4 tables alltogether. Tag: DataSet/field alias Tag: 101568
  - 7
    - Identifying stored procedure output columns In VS.Net Server Explorer, you can drill down to a SQL Server store procedure and finally, it diplays not only parameter of the procedure but also the result columns. How can I replicate this behaviour in my application? Tag: DataSet/field alias Tag: 101558
  - 8
    - Getting RowCounts for Multiple Statements I am trying to execute several DML statements in a single call to an ADO.NET SqlCommand object, ie. update table1 set column1 = x update table2 set column2 = y I am wanting to get the rows affected for each update statement, ie. 10 rows for table1, 20 rows for table2, but the RowsAffected only gives me the total for the statement. Is there any way to get the records affected broken out by statement. I tried capturing the InfoMessages from the SqlConnection and turning set nocount off, but it doesn't provide any messages. Any ideas? Thanks, Ashton Hobbs Tag: DataSet/field alias Tag: 101553
  - 9
    - DataReader and record locking problem Hi, I am using the ExecuteReader method from the Microsoft DAAB to return a DataReader which I am iterating through to mainly read a binary value from one of the returned columns. I am using this value as the raw data to render a PDF document. After this is successful, I want to update the same record with a timestamp to indicate the render to PDF was successful. However,using a totally separate method in my code (using ExecuteNonQuery of the DAAB) to do this whilst the reader is still open (using the pk of the row I want to update), throws an exception - the call times out and if I look at the processes in the database, the update of the timestamp is being locked by the datareader process. My code is the only code accessing this table and the column I am updating is not one of the ones returned by the datareader. So now on to the questions: 1) Should I theoretically be able to read a row with a datareader and update a column in the same row (using a separate connection/call) before moving on to the next record? 2) If I cannot do this, what is the best and most efficient practice to perform this kind of operation (I may have to do this for up to 30,000 rows)? Do I get a list of all the rows I want to operate on (in an array or datatable) and then iterate through each one, pulling the relevant data back for one row at a time in a disconnected fashion for each row and then perform the update or should i just pull back all the records in a disconnected fashion (this seems like it would work when there are a small amount of rows but then if I have 30,000, that's going to be one very big DataSet/DataTable? Any help would be greatly appreciated Thanks in advance Mike Tag: DataSet/field alias Tag: 101548
  - 10
    - Connection pooling... I'm using connection pooling (0 min/100 max) in an asp.net web application. All users log in using the same connectionstring. Is it prudent, for instance, to close and dispose of my connection after a database update takes place which I normally do when I'm not using connection pooling? Tag: DataSet/field alias Tag: 101534
  - 11
    - Getting month from Date field in SQL DATABASE Hi I have an ASP.NET application. I am using a dataset for loading data (based on user input month & company Name) from SQL database. I have the query as :: SELECT CompanyName, Date , CEO from TABLE WHERE (CompanyName=@a && But how do I get the month part from the Date field in the database so that when the user enters the month in text box, records can be selected based on the month. Any help is appreciated. -- pmud Tag: DataSet/field alias Tag: 101531
  - 12
    - How to compare two tables? Hi, Our database is constantly updated (input data) from another DB, and sometimes it crashes our ASP.NET applications. My boss told me to write a DB utility app to check DB and make sure all apps are still running. The first step of few checks is to compare current DB tables with yesterdayâ??s tables. I store yesterdayâ??s tables at a XML file (DB is maintained by another guy, and certainly they donâ??t want me to make back copy for few tables in DB everyday). I thought itâ??s trivial, and just do loop and compare two XML DOM (XmlDocument) objects and make a new one. But the algorithm is more complex than I thought. The new rows can be inserted or deleted based on primary key. So, my question is: Is there a sample code to compare two tables (either DataTable in DataSet, or XmlDocument)? Another question is: Can I set color for individual cell in DataGrid UI, because I want to use different color to show new, deleted or modified field dynamically? Thanks Shaw Tag: DataSet/field alias Tag: 101530
  - 13
    - table ColumnChanging and windows form textbox databinding What do I need to do to get a datatables ColumnChanging event to trigger when one of it's fields is bound to a textbox? There must be some way to get this to work. It works great in complex bound scenarios. I have found that if I use a dataview for a datatable and do an "Addnew" and then bind that to a text box and alter that textbox value I can get the table ColumnChanging event to fire if I run a CurrencyManager.Refresh. But this does not work if the record already exists, a CurrencyManager.Refresh only gets the previous value. Any suggestions? Thanks, AJL Tag: DataSet/field alias Tag: 101527
  - 14
    - Driver upgrade - class naming and namespace query I've been working on the Mono Sqlite 2.x client (http://www.go-mono.com/sqlite.html) in order to make it work with Sqlite 3.0. Note that I have nothing to do with Mono, but I find this code useful for working with Sqlite in Microsoft .NET. I'm wondering what would be the best way to name the classes. The Sqlite data format changed from version 2.x to 3.x, so I need a different set of classes for the new version. Currently the namespace is Mono.Data.SqliteClient, and within this there are classes such as: SqliteConnection SqliteCommand SqliteDataReader etc My first instinct is to add new classes in the same namespace: SqliteConnection3 SqliteCommand3 SqliteDataReader3 etc This way, you can use the version 2.x and 3.x clients side by side. However, another approach is to create a new namespace, say Mono.Data.SqliteClient3, and stick with the old class names. Or to have a new namespace *and* new class names. Is there any guidance as to what is best practice here, either for ADO.NET or for .NET generally? Tim Tag: DataSet/field alias Tag: 101523
  - 15
    - URGENT:Viewing MULTIPLE RECORDS from database using DATA READER Hi, I have an ASP.NET application. I need to read records from the SQL database based on a value entered by the user. I need to get the result in Text boxes. I am using DATA READER for this. But how can i view the next record from the database in the text boxes?? I get one record in the text boxes by clicking a button....but how can i view the next record??? My code is: System.Data.SqlClient.SqlDataReader d1; private void Page_Load(object sender, System.EventArgs e) { // Put user code to initialize the page here } private void Button1_Click(object sender, System.EventArgs e) { sqlCommand1.Parameters["@a"].Value=txtC.Text; sqlConnection1.Open(); d1= sqlCommand1.ExecuteReader(); while(d1.Read()) { TextBox3.Text= d1["Company"].ToString(); TextBox4.Text=d1["Ceo"].ToString(); TextBox5.Text=d1["Month"].ToString(); } d1.Close(); sqlConnection1.Close(); } Please help. Its URGENT! -- pmud Tag: DataSet/field alias Tag: 101515
  - 16
    - OleDbLiteral Does System.Data.OleDb.OleDbLiteral have a purpose or is it just there to look good, as if it is used by something when it is not, or will be used in something in the future ? Tag: DataSet/field alias Tag: 101505
  - 17
    - About MSDTC,The same ContextUtil.TransactionId,but the state of Database A,B is different. I want to update MultiDatabase with Microsoft's MSDTC.Just like ADO.Net provided, I designed an interface below: public interface IDistributeTransaction { int StartTransaction(); int CommitTransaction(); int RollBackTranstion(); int ExecuteSql(string connectionstring,string SqlStr,out string ErrStr); } I called the Interface by Remoting. int rt = m_DistributeTrans.StartTransaction(); if(rt == 0)//sucess { rt = ExecuteSql(....);//Update A database; if(rt == 0)//sucess { rt = m_DistributeTrans.ExecuteSql(....);//Update B database } if(rt == 0)//sucess m_DistributeTrans.CommitTransaction();//Commit; else //failed DistributeTrans.RollBackTranstion();//Rollback; } But when Rollback,the A database is updated sucessful. The ContextUtil.TransactionId is the same during the whole Transaction. Why this happened? Tag: DataSet/field alias Tag: 101501
  - 18
    - exploring database schema Hi, how can I list the following things with ADO.NET in a generic way: a) list all databases available in a DBMS b) list all tables within a selected database c) list the fields (and their type, constraint etc.) with in a table I've found things like GetOleDBSchema.. but (of course) it is available only for OleDBConnector. Is there a generic way like the "Connectionstring"-Wizard does it, too? thanks doc Tag: DataSet/field alias Tag: 101500
  - 19
    - but in ado.net handling an output parameter with an initial value NULL? hi, i use ado.net to call a stored procedure in SQL Server 2000. the SP have a parameter that is input and output when i send an input value of null, the return value does not return correctly and i get null in return even if the SP set the value to something else. if the initial value is not null, the return value of the output parameter is received correctly. what's the problem??? TIA, z. Tag: DataSet/field alias Tag: 101484
  - 20
    - need guidance on - dataset, view and bit of ASP .NET Hi, I am new to web programming and am using ASP .NET (C#) and ADO .NET to develop a web based room booking application. I have been reading a lot of books on ADO .NET and ASP .NET and I have a few basic question which I am totally confused about. Please note that I am a beginner and you have to see the questions in that angle. I may be vague on my questions - if it is not clear please guide me. 1. Regarding dataset: (a) I have one bookings table which takes in all the booking information - ID of the person, date booked, start time, end time and room booked. Update, Delete, Add mainly happens in this database. there are other tables but the main one is the above mentioned table. Question: Does every client who accesses the web application end up creating a dataset? OR Is there only one dataset which is accessed by all clients? (b) If I have a view in the database - Can dataset carry the same view? or should we make up a view in the dataset? If the question is unclear to you it is because I myself is not clear about what I shold be asking. Could you please through some light on views in dataset. 2. Regarding ASP .NET: If it is only one dataset which part of the program do I set this dataset up so that the application creates only one dataset. ? If I do it in the pageload section will it not end up creating dataset for every client? Are you with me? If the above question is not clear, please let me know. The book talks about how to create the dataset - gives the code. But it doesn't actually tell me which part of the program should the code for the dataset be in. Thank you and I appreciate your guidance. Best Regards, Li Tag: DataSet/field alias Tag: 101483
  - 21
    - using IIF expression to decide what formula to use for the field? Hi, I want a datacolumn expression which will work out a value depending on the value of child records here is the expression that does not work. if any1 can help me that would be great iif(child(Packaging).CasingFlag = 'Y',Sum(child(Packaging).PackagingCostPerKg) * parent(ProductProductVariant).NetWeight,Sum(child(Packaging).PackagingCostPerKg) * parent(ProductProductVariant).GrossWeight) also is it possible to refernce a chile or parent value through multiple relationships? thanks Tag: DataSet/field alias Tag: 101480
  - 22
    - Slow to Execute Stored Procedure Hello, I've recently started playing around with SQL 2000 and Stored procedures and calling these stored procedures with a C# program. I have the following setup: 1 Windows 2003 server running SQL 2000 (SP3). I have created a small C# program to run a stored procedure called "usp_CreateNewAddressType". It has two parameters, both of type varchar: @AddressName varchar(30), @AddressDescription varchar(50). When I run the code posted below on the server itself it takes about 3 seconds to run. Is this what I am too expect as far as running this code? Or am I missing something that may make it run faster (note: the slowness only happens when I run the application for the first time, after that it inserts the two items to the db much faster). Here is the code I am using: //Constructor public Form1() { // // Required for Windows Form Designer support // InitializeComponent(); string storedProcedureName = "usp_CreateNewAddressType"; string connectionString = "server=win2003srv;database=mytestdb;uid=sa;pwd=123"; this.mySQLConnection = new SqlConnection(this.connectionString); this.command = new SqlCommand(storedProcedureName, mySQLConnection); //Sets the command type to be of stored procedure type this.command.CommandType = CommandType.StoredProcedure; } //Button Event that saves to DB private void btnSaveToDB_Click(object sender, System.EventArgs e) { //This fills in the data that has been typed in to the text boxes //this.param = this.command.Parameters.Add("@AddressName", SqlDbType.VarChar, 30); //this.param.Value = this.txtAddressTypeName.Text; //this.param = this.command.Parameters.Add("@AddressDescription", SqlDbType.VarChar, 50); //this.param.Value = this.txtAddressTypeDescription.Text; this.command.Parameters.Add("@AddressName", SqlDbType.VarChar, 30).Value = this.txtAddressTypeName.Text; this.command.Parameters.Add("@AddressDescription", SqlDbType.VarChar, 50).Value = this.txtAddressTypeDescription.Text; //Will execute the stored procedure this.mySQLConnection.Open(); this.rows = this.command.ExecuteNonQuery(); this.mySQLConnection.Close(); //Shows' user that it worked MessageBox.Show("Number of Rows affected: " + rows.ToString()); } //End of Code Can anyone point me to any reason as to why this is happening? Maybe I am just expecting this to run faster, or this may just be normal. I just want to make sure I am not missing anything that can make this code run fast the first time you run the program. For example, should I put some of the code in the load event of the windows form? Any advice provided will be greatly appreciated! Tag: DataSet/field alias Tag: 101478
  - 23
    - Unspecified error: E_FAIL(0x80004005) Hey, While wandering about one day writing some VB code, I came across an ugly little error, as seen above. Further delving into my code tosee whether I am a complete and utter fool, I managed to track downthis ugly little error's source, which is as follows: aComm.CommandText = "SELECT Cust_No, Cust_Name " & _ "FROM Customers " & _ "WHERE LOWER(Cust_Name) LIKE " & txtName.Text.ToLower() & _ " + '*' OR LOWER(Cust_City) LIKE " & txtCity.Text.ToLower() & _ " + '*' OR LOWER(Cust_Prov) LIKE " & txtProv.Text.ToLower & "+ '*'" This little bad boy is causing the executeReader() method of the command object to throw the aformentioned error. I am using an Access database to run this query against, and putting the data collected into a list box. I tried running the query without the WHERE clause from my procedure, and it ran. The query runs in Access with the WHERE, however, it won't run from here. If anyone has an idea, that would be super duper. Cheers, Matt Bailey Tag: DataSet/field alias Tag: 101471
  - 24
    - Parameter["@xxx"] does not have a default value I keep getting this error message and cannot find the solution for it. I've written the following stored procedure: SELECT Username FROM [User] WHERE Username=[@Username]; When I run the stored procedure within Access, it works. However, the following code does not work. The field in the Access table is set to: Text and has Required: yes. Any suggestions? public static bool CheckUsername(string name){ bool success = false; try{ using(OleDbConnection conn = new OleDbConnection(BroodmoorBase.CONNECTION_STRING)){ conn.Open(); OleDbCommand cmd = new OleDbCommand("bspCheckUsername",conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(new OleDbParameter("@Username",OleDbType.Char,50)); cmd.Parameters["@Username"].Value = name; if( cmd.ExecuteNonQuery() > 0 ) success = true; conn.Close(); return success; }//end using } catch(Exception e){ throw e; } } I've tried putting a breakpoint immediately before the 'if' statement to see if there is indeed a value for the parameter. There is. Sometimes, the statement conn.Close() doesn't even execute as I step through the code. It just skips that line and executes the 'return success;' statement. I'm using Access and I'm using .NET Framework 1.0. I've checked the spelling in the strored procedure and my code and it is the same. Any help would be appreciated. thanks, Prince Tag: DataSet/field alias Tag: 101470
  - 25
    - Generic Update routine, except for primary keys In my implementation of a 'Save As' routine, I have a current, multi-row dataset. When I do a save as, I create an entirely new object which therefore creates its own multi-table dataset with its own primary keys. After the new object (dataset) is created, what I need to do is copy the contents of the original dataset to the new dataset. The original dataset will already have been saved to the database. It is possible that the original dataset will have more rows than the new dataset. At first, I tried to use a dataset merge, but the issue with this is that the new table and the original table have their own unique primary key values and therefore, what I get is an extra row and not an update to the current row. I can't just copy the dataset either because then I will have two datasets with identical primary key IDS in many tables. So what I need to do is : a. If a row already exists, update the fields that are not the primary key or foriegn key to another table. How can I tell if a column is a primary or foreign key? b. If a row does not exist, add the row, not including primary key value. Here, I still can't just copy the whole row because the new row still has to have a unique ID. This new row can also have child rows, so on the client side, how can I create a primary key and then use that key as a foreign key? I am thinking of using GUIDs as primary keys but not sure if this is appropriate. Any ideas? STom Tag: DataSet/field alias Tag: 101469

Can a DataSet be used to update a database if the query that originally
populated it had table and field alias names in it?

Top

Re: DataSet/field alias by W

W
Thu Dec 30 15:07:53 CST 2004

Yes, the update command will need to match the alias - in general you can
get around aliasing though by using COlumnMappings - which map the db column
names to the names you're using in your dataset.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Random" <cipherlad@hotmail.com> wrote in message
news:e1e6j8q7EHA.3504@TK2MSFTNGP12.phx.gbl...
> Can a DataSet be used to update a database if the query that originally
> populated it had table and field alias names in it?
>
>

Top