Saving current edits

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
    - DataTable creating question? Hello, I have a large table in Sql Server that I want to populate from a VB.Net app. I have 2 data sources that are exactly the same structure but data from different geographic locations. I want to populate 2 separate dataTables in my VB.Net app (simultaneously on different threads) with the respective source data and then I want to merge the data from these 2 separate dataTables into a dataTable that I create from a Sql DataAdapter. I know how to use a Sql Adapater (sort of) Dim SqlDA As SqlDataAdapter = New SqlDataAdapter ... sqlDA.SelectCommand = New SqlCommand("Select * From tbl1",conn) ... sqlDA.Fill(dataSet1, "tbl1") - creates a dataTable with the correct schema. I tried doing the following with my 2 separate datatables Dim dt1 As DataTable = ds1.Tables("tbl1") Dim dt2 As DataTable = ds1.Tables("tbl1") But dt1 and dt2 turned out to be the same table. If I place from 1 to 1000 records in dt1 and 1001 to 2000 recs in dt2 (simultaneously using multithreading), tbl1 contains 4000 recs, not 2000. I would like to create dt1 with the same schema as tbl1 and dt2 also. Then I want to transfer the data from dt1 and dt2 into tbl1. In my situation, simultaneously pick up data and place it into tbl1 where I end up with 2000 records, not 4000. What is the best way to do this? How do I transfer the data from dt1 and dt2 into tbl1 (not even worried about updating the Sql Server table for now - just end up with 2000 records in tbl1 from dt1 and dt2). TIA, Rich Tag: Saving current edits Tag: 90190
  - 2
    - Syntax for convert in ado.net I have a dataadapter that I pass a sqlcommand to, which has paramters. I have the following sqlcommand on my page: SELECT * FROM tbl_Changes WHERE (CAST(@column1 AS nvarchar(20)) LIKE @Criteria1) and have the following code to call this sqlcommand in my webpage: cmdSelectNone.Parameters("@Column1").Value = "Change_Status" cmdSelectNone.Parameters("@Criteria1").Value = "%" & txtSearchCriteria1.Text & "%" SqlDataAdapter2.SelectCommand = cmdSelectNone SqlDataAdapter2.Fill(DsChanges2) dgSearch.DataSource = DsChanges2 dgSearch.DataBind() Every time I call the above code it returns no records, yet if I comment out the '@column1' parameter in the code and hard code the column name in the sqlcommand it works just fine. Could anyone please tell me what's wrong with my cmdSelectnone.Parameters("@Column1").value="Change_Status" line please?? Thanks in advance, Jason Tag: Saving current edits Tag: 90184
  - 3
    - Large DataSet Question Hi, I am retrieving a dataset with over 100 records and can vary based on user in which it can get even larger. I am displaying the dataset in a datagrid. I was looking for reccomendations on how to breakup the dataset because I do not want to show 100 records in a datagrid. I was thinking about limiting the dataset to 50 records based on the a stored procedure, is that a better idea? The stored procedure is based on a like clause which the user enters. Thanks Tag: Saving current edits Tag: 90180
  - 4
    - Deploy to Windows Server 2003 & connect to Oracle database What do I have to do on Windows Server 2003 (other than install ODP.NET) to have my deployed WebApp connect to an Oracle database? Tag: Saving current edits Tag: 90179
  - 5
    - Get Column Name from a DataSet Hello, I was wondering if anyone knows how to get a column name from a dataset where the column name contains nulls. I am able to get a columns name using getxml() however columns that have null's do not return the name of the column in the xml. Basically I want the dataset to return columns names even if the column names contain null values. thanks guys. Tag: Saving current edits Tag: 90172
  - 6
    - excel question i have oledb connection with this string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Downloads\sase2.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"" and work fine with normal *.xls file but when file is saved as web page i get error initializing connection. What i need to do to read that excel document? thx Tag: Saving current edits Tag: 90171
  - 7
    - duplicating a DataRow Hi All, I've got a strongly typed DataSet where I want to: traverse the rows in a table and do a check. If the check is successful, I want to duplicate the row, tweak a column, then add it to the same table in the DataSet. What's the most efficient way to do this? I tried to 'new' a new DataSet-derived DataRow (and hoping to copy a row into it), but the constructor wanted a DataRowBuilder, which i don't have. DataRowBuilder appears to be an internal object, not useable by us developers. Also, the table has 34 columns and it's a pain in the rear to write all the code to deal with the DataRow indexes. Is there a better (less typing) way to do the copy, or do I have to deal with the base DataSet class exclusively? Thanks in advance! Corey. Tag: Saving current edits Tag: 90167
  - 8
    - Problems with connection pooling on Oracle (ORA-03114) We are having issues with some of our applications that utilize= connection pooling via the OracleConnection Class Of the System=2EData=2EOracleClient Namespace=2E At this time we are= unable to determine of the problem lies within our code that= connects to our DB and then executes the necessary stored= procecures, the parameters we define in the ConnectionString= property, or the Oracle DB itself=2E What we do know, however is= that when we enable connection pooling, over time our= application is no longer able to connect to our DB and we= receive =2ENET errors like the one I?ve pasted below=2E Then, when= we recycle the application pool that this application is running= in, we are able to connect to the DB again and our application= works=2E Then, like I said over time, it will fail again, with the= same or similar message=2E I?m also wondering if our code is not= handling the connection to the DB properly=2E Perhaps we are not= closing connections when an exception is thrown, or we are just= not handling errors returned from the DB gracefully=2E *****************************************************************= **** Application KSLearn FailedSystem=2EWeb=2EHttpUnhandledException:= Exception of type System=2EWeb=2EHttpUnhandledException was thrown=2E= ---> System=2EData=2EOracleClient=2EOracleException: ORA-03114: not= connected to ORACLE ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>PqWnZqQwA0WZPDSxYXDN7w=3D=3D</Id> Tag: Saving current edits Tag: 90165
  - 9
    - Create dataadapter programically or drog &drop ? my tables are very big size. If i drag&drop the table as adapter, it seems fill in all the data in dataset during formload. Which is the best way ? programmically to create or use drag or drop ? Tag: Saving current edits Tag: 90162
  - 10
    - DataRowView.Row == Null??? Hi all, I have noticed some weird behavior of the DataView. When I call DataView[i].Delete() on a DataView it appears that the row is deleted. But sometimes the DataRowView lives on, but the underlying DataRow is null. Also, I handled the DataRowChanged event and inside of there I do a GetChildRows() on that same table, but along with all the valid rows, a null value is returned. It's as if the underlying DataTable still thinks the row is there even though it is not. I am changing the DataView.RowFilter inside of the RowChanged/RowDeleted events. I think this is what is causing the problems. I change the filter on the child view when the parent view updates its primary key and it appears that this is what is causing the funky behavior. That's my best guess. I have got around the problem by updating all my rows first and then going through and doing the deletes separately. Has anyone else experienced anything like this?? Cole Tag: Saving current edits Tag: 90160
  - 11
    - lock records for update: how? options? Hi, I know ADO.Net recommand using disconnected update (optimistic concurrency) for good reasons, but it's just not an option for us. 99% of our client would rather seeing "record locked" kind of message up front when they load records, than being told "updating failed" after they spend all the time entering the data. So here I am spending a lot of time trying to find a good way to do the "read with lock" type of opration. I know you can do some thing like that, at the query level, if you are running some late version of SQL server, but what if I can't use those DB specific features? Is there a recommanded way of doing this at ADO.Net level"? What about ADO.Net's transaction? If someone can point me to a right direction that would be highly appreciated! Thanks Feng Tag: Saving current edits Tag: 90159
  - 12
    - SOS! ORA-03114: not connected to ORACLE && MS's Bug?? ORA-03114: not connected to ORACLE && MS's Bug?? DataBase:Oracle 817 using OracleClient,net framework 1.1 I'm using ADO.Net in C# with Oracle 817. and following is my public data access class. using System.Data.OracleClient; public class ComFun { static public IDataReader ComFun_ExeReader(string Sql) { OracleConnection Conn=new OracleConnection(ConfigurationSettings.AppSettings["OracleConnectionString"] ); OracleCommand Cmd=new OracleCommand(); Cmd.CommandText=Sql; Cmd.Connection=Conn; Conn.Open(); OracleDataReader Reader=Cmd.ExecuteReader(CommandBehavior.CloseConnection); return Reader; } static public DataSet ComFun_ExeDataset(string Sql) { OracleConnection Conn=new OracleConnection(ConfigurationSettings.AppSettings["OracleConnectionString"] ); OracleDataAdapter Ad=new OracleDataAdapter(Sql,Conn); DataSet ds=new DataSet(); Conn.Open(); Ad.Fill(ds); Conn.Close(); return ds; } static public Object ComFun_ExeScalar(string Sql) { OracleConnection Conn=new OracleConnection(ConfigurationSettings.AppSettings["OracleConnectionString"] ); OracleCommand Cmd=new OracleCommand(); Cmd.CommandText=Sql; Cmd.Connection=Conn; Conn.Open(); Object Obj=Cmd.ExecuteScalar(); Conn.Close(); return Obj; } } in other .cs files i always coding like this string sql="select person_name,person_age from person"; IDataReader Reader=ComFun.ComFun_ExeReader(sql); DropList.DataSource=Reader; DropList.DataText.....="person_name"; DropList.DataBind(); Reader.Close();Reader.Dispose(); but sometimes returning the following exception "ORA-03114: not connected to ORACLE". sometimes not. Why????? I find a article http://www.dotnet247.com/247reference/msgs/49/248580.aspx And find this one !!!!!!!!!!!!!! " Michael Bachar Hi, I'm using ADO.Net in C# with Oracle9i Release 9.2.0.4.0 when loosing the connection with the Oracle database server the connections doesn't recover and always returning the following exception even when the connection has been restore: "ORA-03114: not connected to ORACLE". I'm closing the connection properly in that it will return to the connection pool. Here is an example code: using(OracleConnection conn = new OracleConnection(connectionString)) { conn.Open(); using(OracleCommand cmd = new OracleCommand(sql, conn)) { object obj = cmd.ExecuteScalar(); } } This should close the connection properly. In the MSDN it is mention that if the connection pooler detect that the connection with the server has been severed it will remove the connection from the connection pool. It appears that this is not happening an I always get bad connections from the pool, even after the connection with the database server has been restore. How can I solve this? What is the proper way to recover from connection lost with database server? Thanks, Michael. !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Angel Saenz-Badillos[MS] (VIP)!!!!!!!!!!! Michael, I am sorry this one is my fault and it is a very bad bug.!!!!!!!!!!!!!!!!!!!! The problem here is that our pooler fails to understand that a 03114 exception means we should not put the connection back in the pool. We have a QFE that fixes this problem by discarding the connection in the following Oracle exceptions. Please let me know if you know of any other exceptions that also result in a connection no longer being valid. oracle exceptions checked case 18: // max sessions exceeded, case 19: // max session licenses exceeded case 24: // server is in single process mode case 28: // session has been killed case 436: // oracle isn't licensed case 1012 //not logged on error case 1033: // startup/shutdown in progress case 1034: // oracle not available case 1075: // currently logged on case 3113: // end-of-file on communication channel case 3114: // not connected to ORACLE case 12154: // can't resolve service name case 12xxx //any error starting with 12 thousand To get the fix please contact PSS directly and request QFE 830173 " ???? Does It's MS's BUG? And What should I Do? Tag: Saving current edits Tag: 90158
  - 13
    - Speed of inserting data in table SqlServerCE I have written some proof of concept code that adds records to a table, utilizing SqlServerCe, using a parameters in a insert statement. I am forced to read data from a BinaryStream (in the form of a file), assign values to the parameters and execute the sql insert statement from within a while loop The table contains 11 fields, and it currently takes over two minutes to read 4500 records... This is maddness, as I am porting from an old application, and I can accomplish the above in about 2 seconds using my old code (written in OPL) using a device thats 4x slower than the one I'm currently developing on. Anybody have an idea how to speed this up? or mybe a sneaky workaround... :) Regards BM Tag: Saving current edits Tag: 90156
  - 14
    - Data Form Wizard Question. Hello, Is there a way to make the data form wizard create windows forms using sqlConnection, sqlDataAdapter and sqlCommand instead of OleDBConnection, OleDbDataAdapter since all my projects deal with SQL 2k server? Thank you in advance. Tag: Saving current edits Tag: 90154
  - 15
    - SqlDbType not Found using VB.NET (compact framework) I am trying to populate a table in a table in a database I have created using parameters. The following line doesn't work. cmd.Parameters.Add(New SqlCeParameter("CUniq", SqlDbType.Shortint)) due to the fact that SqlDbType is not found. (not declared) I have the following imports. Imports System.IO Imports System.Data.SqlServerCe Imports System.Data.Common Imports System.Data The documentation says that SqlDbType enumeration is a member of the System.Data namespace, but I can't find in the tab completion. Please, any explanation or commentary is very appreciated... Regards, BM Tag: Saving current edits Tag: 90153
  - 16
    - load tables with constraints Hi How to lad tables from database to dataset with constraints. Thanks Konrad Tag: Saving current edits Tag: 90152
  - 17
    - relationship Hi How to create relation in SQL Server Database programatically? Thanks Konrad Tag: Saving current edits Tag: 90146
  - 18
    - Using a datagrid to display info from database Is it possible to be able to select a single row in a datagrid and use that selection to open a new form that contains all of the data in the row? I'm working on a home inventory program in VC++ with a database backend and I'd like to be able to standardize the forms used. But I can't get around an effective means to edit a selected data item. Any ideas? Thanks! Alex Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Saving current edits Tag: 90141
  - 19
    - Getting information messages back in real-time Hello, It's possible to create messages in SQL Server 2000 that get sent to the client immediately, by using RAISERROR ... WITH NOWAIT. For example, the following code works great in Query Analyzer: RAISERROR(N'Message 1', 0, 1) WITH NOWAIT WAITFOR DELAY '00:00:02' RAISERROR(N'Message 2', 2, 1) WITH NOWAIT WAITFOR DELAY '00:00:02 RAISERROR(N'Message 3', 4, 1) WITH NOWAIT WAITFOR DELAY '00:00:02' However, I find that when I try to execute a script or procedure from ADO.NET, and try to receive these messages using the InfoMessage delegate, I don't get them until the very end, all in one chunk. I'm writing a long-running procedure, and I'd like the client to be able to receive status messages to print to the console. Is there any way to get messages to get sent to the client in real-time? Thanks, Brian Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Saving current edits Tag: 90136
  - 20
    - Multiple XML nodes with the same tag + DataRow access? hello, I have the following xml structure which I load into a DataRow (the xml document is loaded into a dataset...) <EXMAPLE_NODE> <A>string1</A> <B>string2</B> <C>string3</C> <D>string4_1</D> <D>string4_2</D> <D>string4_3</D> </EXMAPLE_NODE> I know I can Access nodes A,B &C using indexed access. How can I access the D nodes (I don't want unique names for them)? Is there anyway to access these via a foreach iteration? Thank you in advance, Jamie Tag: Saving current edits Tag: 90134
  - 21
    - DataSet filtering Hi, If I retreive a set of records from my database e.g. NAME GROUP John Beetles John Sting John Queen Bob Brittany and I have in a dataset. If I want to display in a list Bob John is there an easy way to do a operation such as SELECT DISTINCT NAME FROM DATASET so that I can filter it without doing another database call? thanks Tim Tag: Saving current edits Tag: 90131
  - 22
    - excel question i have oledb connection with this string "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Downloads\sase2.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1"" and work fine with normal *.xls file but when file is saved as web page i get error initializing connection. What i need to do to read that excel document? thx Tag: Saving current edits Tag: 90128
  - 23
    - Using the FillSchema I have a question about the Fillschema method. According the documentation the schema is built base on the contents of the SelectCommand. I using stored procedure to load tables in the dataset. I also use the fillschema to load the schema into my datatable. I'm not sure if things are working as I think they should. How would I get a schema loaded if I'm not using the Select query in the selectcommand? I'm using stored procedures instead. I have sample code below: Sub CheckForAlertData(ByVal MinDevice As String) Dim AlertDBConnection As SqlConnection = New SqlConnection(AlertVar.AlertConnectionString) Dim AlertHist_ID As Integer Dim AlertVehiclServiceID As Integer Dim AlertOdometerID As Integer Dim AlertReading As Integer Dim ServiceID As Integer Dim AlertThreadConnection As SqlConnection = New SqlConnection(AlertVar.AlertConnectionString) 'Read Min_GPS_History to get Min Device detail Dim AlertThreadDataCMD As SqlCommand = New SqlCommand("SelectMinGPSHistoryByMin", AlertThreadConnection) AlertThreadDataCMD.CommandType = CommandType.StoredProcedure Dim AlertThreadParm As SqlParameter = AlertThreadDataCMD.Parameters.Add("@MinDevice", SqlDbType.VarChar, 10) AlertThreadParm.Direction = ParameterDirection.Input AlertThreadParm.Value = MinDevice AlertThreadDataCMD.Parameters.Add(AlertThreadParm) Dim AlertDA As SqlDataAdapter = New SqlDataAdapter(AlertThreadDataCMD) AlertThreadConnection.Open() AlertDA.FillSchema(AlertDS, SchemaType.Source, "MinGPSHistory") AlertDA.Fill(AlertDS, "MinGSPHistory") AlertDBConnection.Close() End Sub Thanks Tag: Saving current edits Tag: 90126
  - 24
    - Getting data from a dataset one field at a time I have create a dataset that contains only the data that I want. Now I want to display the data a field at a time. How do I retreive the data in order to display it? I have included a code sample below: Private Sub GetDataByEventType(ByVal AlertType) Dim AlertTypeData As DataTable = AlertDS.Tables("AlertDetail") ' Check for Alert Type of Speeding as an EventType. Dim AlertExpression As String ' Dim EventType as String = 'Dim TypeOFAlert As String = AlertType AlertExpression = "EventType = 'Speeding' and Speed > EventDataLow" Dim AlertsFound() As DataRow ' Use the Select method to find all rows matching the filter. AlertsFound = AlertTypeData.Select(AlertExpression) Dim Alert As Integer ' Send Message to Screen of each returned row. For Alert = 0 To AlertsFound.GetUpperBound(0) Console.WriteLine(AlertsFound(Alert)(0)) ' MsgBox("Min Number: " & Min_Num & "is Speeding" & "Speed is: " & Speed) Next Alert End Sub Tag: Saving current edits Tag: 90119
  - 25
    - .NET and SQL Server on Separate Machines Hi all, We're working on an ASP.Net Web Application that makes several calls to a SQL Server database. Everything was running correctly when the database and the web server were on the same computer, but we have sinced moved them to separate computers; IIS V6 on Win2000 and SQL Server 8(SP3) on Win Serv 2003 Ent. The connection string in our web.config file originally looked like this: <add key="ConnectionString" value="server=localhost;Trusted_Connection=true;database=Store;" /> After moving the database (and changing the server in the connection string), we started to receive this error: "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection." We ended up changing the connection string to look like this: <add key="ConnectionString" value="Integrated Security=SSPI;Initial Catalog=Store;Data Source=192.168.0.12;" /> This string only works if we add the following to the .config file: <authentication mode="Windows" /> <identity impersonate="true" /> Unfortunately, the web application was designed to use forms authentication, so we're still looking for a valid connection string. We've tried setting Trusted_Connection=false and providing a username and password, but we get the same error as before - only with the provided username listed instead of (null). We've tried setting the database to mixed mode, and Win Auth only and got the same results. Any help would be greatly appreciated. -- Jason DeCock Elk River Systems, Inc. http://www.elkriversystems.com Tag: Saving current edits Tag: 90118
- Next
  - 1
    - VB.NET PROJECT to C# Project conversion Hi, DO we have any tool which will help us to convert the web project from the VB.NET to C# language? Thanks, Vijay Tag: Saving current edits Tag: 90112
  - 2
    - KeyInfo using Data Access Application Block for .NET Is there a way to retrieve the KeyInfo using the Microsoft Data Access Application Block for .NET? I want to use either a DataSet or SqlDataReader object to grap the primary key information from the columns. Tag: Saving current edits Tag: 90104
  - 3
    - 405 error on put I am trying to upload a pdf file to a web server. The server is local right now for testing. I am running xp, iis5 I get a 405 error on the post, please help. String uriString = "http://localhost/PineNet/"; WebClient myWebClient = new WebClient(); string fileName = txtFilename.Text; byte[] responseArray = myWebClient.UploadFile(uriString,"POST",fileName); Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: Saving current edits Tag: 90101
  - 4
    - Viewstate works on test server but not production server Please help! I am tearing out my eyes trying to figure this out. I have a test server IIS 5.0 and a production server IIS 6.0. The test server holds the viewstate of a 3 dropdowns with a problem. However, the production server only holds the viewstate of 2 of the dropdowns. Why would it work on one server and not the other? Why would it work for 2 of the controls but not all 3? THANK YOU IN ADVNACE FOR THE HELP. I am using ASP.NET with VB (no code behind). Here is a snippet of the code. DropList_OS is the problematic dropdown. <asp:DropDownList id="dropList_Dates" runat="server" dataTextFormatString="{0:d}" CssClass="Headings" AutoPostBack="True"> <asp:ListItem Value="{0}" Selected="True"></asp:ListItem> </asp:DropDownList> <asp:DropDownList id="dropList_Regions" runat="server" CssClass="Headings" AutoPostBack="True"> <asp:ListItem Value="{0}" Selected="True"></asp:ListItem> </asp:DropDownList> <asp:DropDownList id="dropList_OS" runat="server" CssClass="Headings" AutoPostBack="True"></asp:DropDownList> Tag: Saving current edits Tag: 90094
  - 5
    - Annotations in Strongly typed datasets with webservices hi, I am using annotiations in my xsd schema. the dataset is generated correctly on my webservice, but when i add a webreference to the webservice from another webservice, the dowloaded xsd schema from my webservice doesn't contain the annotiated names, my codegen namespace is filtered out of the xsd schema. Has anyone an idea to resolve this Tag: Saving current edits Tag: 90091
  - 6
    - Add sorting to SQLDataAdapter at runtime. How? I have a SQLDataAdapter that I have configured. Since I want to tie this to a DataGrid and add sorting to the datagrid, I do not want to configure the adapter with sorting. I want to be able to add the sorting at runtime depending on the column that the user clicked on the datagrid. I am probably missing something very simple here. Below is the code that I am using to fill my datagrid. Thanks in advance! sqlMfgNumber.SelectCommand.Parameters(0).Value = "%" & txtSearchFor.Text.Trim & "%" sqlMfgNumber.SelectCommand.Parameters(1).Value = strOmittedNumber sqlMfgNumber.Fill(DsMfgNumberSearch1) If DsMfgNumberSearch1.Tables(0).Rows.Count > 0 Then lblError.Visible = False Datagrid1.DataSource = DsMfgNumberSearch1 Datagrid1.DataBind() Else lblError.Visible = True End If Tag: Saving current edits Tag: 90090
  - 7
    - Persistance UPDATE problem - revised Q for clarity I'd like to clear up a very long-standing problem I have had only because I have done a little more testing, but the problem is still there. On Page_Load event, the textfields on my page fills with the personal data stored in a SQL DB, as follows: Dim cn As SqlConnection Dim cmd As SqlCommand Dim rdr As SqlDataReader cn = New SqlConnection("xxx") cn.Open() cmd = New SqlCommand("SELECT SName FROM ClientDetails WHERE clientRef=100", cn) rdr = cmd.ExecuteReader() rdr.Read() 'fill the surname textbox txtSName.Text = rdr("ColSurName") cn.Close() e.g. pretend the value of the colSurNamel in the DB is 'Smith' Then on the form my clients can update their details by simply overwriting the text in the textboxes and hitting the UPDATE button. Assume I have now updated the textbox with 'Bloggs' and I've hit the UPDATE button (code as follows): Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim conCOMP As SqlConnection Dim cmdUPDATECOMP As SqlCommand conCOMP = New SqlConnection("xxxxxx") strCOMP = "UPDATE ClientDetails SET colSurName= '" & txtSName.Text & "' WHERE ClientRef = 100" cmdUPDATECOMP = New SqlCommand(strCOMP, conCOMP) Label4.Text = strCOMP conCOMP.Open() cmdUPDATECOMP.ExecuteNonQuery() conCOMP.Close() End Sub I've added a label here to view the value of the UPDATE command when it is passed BUT it gives the value already stored in the DB / or rather the value it already got in the Page_Load routine: the text in Label4 is: " UPDATE ClientDetails SET colSurName = 'Smith' WHERE ClientRef = 100 " I think it is obviously the text box variable: having got a value for when the Page_Load event occurs. But how can my clients change the text boxes to update their details and hit UPDATE?????? PLEASE PLEASE HELP. This seriously has been BUGGing me for a month. My Client is not happy :( Tag: Saving current edits Tag: 90089
  - 8
    - Stupid XML Serialisaton and Web Services My company's XML webservice has several methods that pass back= serialised data, and all seemed well during testing, and during= the first few weeks of deployment=2E But people are coming back to= me saying that the keep getting the error "DataRelation cannot= be serialized because it does not have a default public= constructor" when they browse to the URL of the Web Service=2E But= it does have a public constructor, it really does, and now it's= driving me up the wall=2E Thanks -------------------------------- Matthew Carter Development Manager Applied Language http://www=2Eappliedlanguage=2Ecom ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>eDIiibqwKEyiHx8pwjI4lA=3D=3D</Id> Tag: Saving current edits Tag: 90084
  - 9
    - Stupid XML Serialisaton and Web Services My company's XML webservice has several methods that pass back= serialised data, and all seemed well during testing, and during= the first few weeks of deployment=2E But people are coming back to= me saying that the keep getting the error "DataRelation cannot= be serialized because it does not have a default public= constructor" when they browse to the URL of the Web Service=2E But= it does have a public constructor, it really does, and now it's= driving me up the wall=2E Thanks -------------------------------- Matthew Carter Development Manager Applied Language http://www=2Eappliedlanguage=2Ecom ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>CYL2gyk18kiRmISG88IWbw=3D=3D</Id> Tag: Saving current edits Tag: 90083
  - 10
    - Autoincrementing Primary Keys with PostGres I am using an ODBC connection to a PostGres database, that has various tables that use SERIAL types to implement automatically incrementing primary keys. My problem is that I have a dataset containing tables that I have turned AutoIncrement on, and set the seed and step to -1. My update statement works a treat, and any new rows are added sequentially to the end of the table. However, I need a way of immediately returning a new rows primary key, in order to keep the dataset up to date. I know that in SQL Server you can use the @@IDENTITY feature, to immediately return the last used value. Is there something similar in PostGres? I have tried adding a 'SELECT CURRVAR('public.equipmenttype_equipmenttypeid_seq') just after my insert statement (which is the SQL that you use to find out the current sequence id in PostGres), but I am not sure of the ODBC syntax needed to get this information into a parameter (I assume I would need to use a ParameterDirection.ReturnValue). This problem has been vexing me for a few days now. Any ideas or a better way of handling autoincrementing keys would be gladly received. Tag: Saving current edits Tag: 90076
  - 11
    - DataTable column question Hi! It's easy to add Columns into DataSet DataTable for example like this way ... ds.Tables("MyTable").Columns.Add("MyColumn", GetType(Integer)) ... but how can I remove this column of the DataSet which was created earlier by code? Do I have to create whole new DataSet table again? I mean something like ds.Tables("MyTable").Columns.Remove("MyColumn") - ofcource it's not possible to do like this way :) I tried ... ds.Tables("MyTable").Columns("MyColumn").Dispose() ... but it doesn't seem to do what I want. -- Thanks in advance! Mika Tag: Saving current edits Tag: 90065
  - 12
    - Persistent UPDATE Problem Hi there I have had an application where I have not been able to successully add an 'update details page' for my clients logged in to the website. I have posted a query on this before and the result was that the WHERE clause was probably wrong; without success....but I have added a test labels to test so now know a little more so hopefully you can help. Have ASP.NET / SQL Server 2000. The web app has a members area which is https. i'm using authenication ticket which stores the member ID ref as a state variable called 'MemberRef' So problem page.... When this UPDATE PERSONAL DETAILS page loads, it fills the textboxes on the page with a datareader according to who is logged in. One textbox example is as follows: txtFirstName.Text = rdr("colFName") Then of course I need a process so my members can update their personal details stored in the DB, so those text boxes allow updates and I've added a button which should update the DB Private Sub ButUpdatePractice_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) 'Handles ButUpdatePractice.Click Dim strCOMP As String Dim conCOMP As SqlConnection Dim cmdUPDATECOMP As SqlCommand conCOMP = xxx cmdUPDATECOMP = New SqlCommand(strCOMP, conCOMP) strCOMP = "UPDATE ClientDetails SET colFName = @Fname WHERE MemberRef = @MemberRef" cmdUPDATE.Parameters.Add("@Fname", txtFirstName.Text) cmdUPDATE.Parameters.Add("@@MemberRef", MemberRef) conCOMP.Open() cmdUPDATECOMP.ExecuteNonQuery() conCOMP.close -now plrease ignore any misspellings above - done it for speed for this forum. Now this doesn't update the DB when pressing the update button. It re-freshes the page. I've added a label to the page which shows the strCOMP update string on the page to test ( label1.text = strCOMP ) and it contains the existing value from the DB. Please help. Tag: Saving current edits Tag: 90062
  - 13
    - Dataset constraint violoation with null foreign key value Hi, I'm loading a dataset from a cached viewstate version of the dataset created on a previous http request. When I read the call ReadXml on the typed dataset, I get: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints" I suspect this is due to a field in one of the tables which can be null, but if it is not null it is a foreign key to another dataset table. At present the field in this table is null (in the database). What attributes of the dataset table field, or the dataset constraint should I set to indicate null values don't violate the constraint? Thanks Martin Tag: Saving current edits Tag: 90061
  - 14
    - Datagrid hide identical columns from a JOIN I do not normally use JOINS in my queries these days, but I have some instances where I am simply showing historical data in a grid, and it is thus much more convenient to JOIN everything I need in one stored procedure. Thus I might end up with data from 3, 4 or more tables -- some with identical names (the JOIN criteria). I know how to hide columns in a straightforward query, but how about in a JOIN query where you may have 2 or even 3 or more identical field names (IDs usually)? How do you hide, for example, the SalesID from the 2nd table or the from the 3rd table? For example, the following statement works for the first SalesID, but what about the other JOINED SalesID fields? (I've tried "SalesID1" and "Expr1", but no joy except SalesID1 seems to work on a simple query with 2 joined tables). ds.Tables("dtSalesPayments").Columns("SalesID").ColumnMapping = MappingType.Hidden Tag: Saving current edits Tag: 90057
  - 15
    - .NET SQL Client: Connection pooling issue Hi All Follow up to my last week' postings on connection pooling issue we experience. Thanks all for your replies but since I still don't have a solution ? I've decided to start a new thread. Here is a link to the original thread: http://tinyurl.com/yu68q We use SQL Client (SqlCommand, SqlConnection and SqlDataReader) in our 3-tiered ASP.NET app written in C#. The problem we are running into is that under heavy load the number of pooled connections increases approximately by the current pool size every time the garbage collector kicks in. This happens even when only about 60 connections exists in the pool with the max size of 100. The number of pooled connections does not grow until the GC engages and ? the most puzzling ? the new connection pool is being created at that very moment. I rely on .NET CLR Data performance counters which I suspect might not be reliable. But if they aren't ? what is? The documented MS Knowledge base issue with the counters http://support.microsoft.com/default.aspx?scid=kb;en-us;314429 doesn't seem to apply here) I also follow all the good coding practices such as closing the connection and DataReader in the finally block. I do not have any destructors or Finalize implementations in the app as well. I have performance monitor screenshots for all interested. Any ideas? Thank you! Tag: Saving current edits Tag: 90054
  - 16
    - HLP: Adding Column Info to ListView What I'm trying to do is to Add the information of Two Tables into a single ListView. The ListView has 10 columns. The following Code populates the LV columns 1 to 5 (or rather 0 to 4) from a DataSet... Private Sub MstrEmPay() Dim dtDataTbl As DataTable = DsMstrEmPay.MASTER_PRM_EMPLOYEE_PAY ' Get Info from Data Base For cntr = 0 To DsMstrEmPay.MASTER_PRM_EMPLOYEE_PAY.Rows.Count - 1 Dim dr As DataRow = dtDataTbl.Rows(cntr) Dim LItem As New ListViewItem Dim rowTtl As Double = 0 LItem = New ListViewItem LItem.Text = dr("amount") LItem.SubItems.Add(dr("employee")) LItem.SubItems.Add(dr("pay_id")) LItem.SubItems.Add(dr("pay_type")) lvProjDisplay.Items.Add(LItem) Next ' cntr End Sub What I want to do is to get the info of another DataSet and dump it's info into the next 5 remaining Columns (starting at the first row of the ListView). I've done some reading and I 'think' I need something like: LItem.SubItems.Insert(5, myTextHere)... but haven't found how to make this work. Anyone can help? Regards, Bruce Tag: Saving current edits Tag: 90053
  - 17
    - SQL Server JOBS Hi!. I am developing a windows application where i need to give users alerts about their pending jobs once they login into the application. I am trying to create SQL Server jobs to give those alerts( If anyone has any other option kindly post the same). now can anyone tell me how do i populate the alert on the user machine. Thanks in advance Baren Tag: Saving current edits Tag: 90048
  - 18
    - Het zal toch niet zijn wie ik denk dat het is? Is het die Ear Youth weer? Nee, het is Arjen Jongeling! Het is een kwestie van geduld voor heel usenet Hollands lult Tag: Saving current edits Tag: 90044
  - 19
    - Making an app run on a local area network. I realize I have asked this question before and the answer is slowly becoming clearer but I do not yet quite have it in place. I have a VB.net application that I have written from a client machine of a local area network. The LAN has a dedicated file server. The solution is located in a shared directory of the LAN's file server The drive letter is F. The application is bound to a SQL Server 2000 database that also resides in a shared directory on the F drive of the file server. My application works on the machine I am using but then I have a full blow copy of VS 2003 installed on the machine. I would like to be able to run the application from other machines on the local area network. These other machines all have Windows XP Pro installed and the .net framework. What do I need to do in order for this to happen? If I understand correctly I do not have to even worry about creating a .MSI file; I can simply point the other machines to the .exe file that is created in the Bin directory of the application that, again, is located in a shared directory of the server. Is this right? What else do I need to do in order to make (allow) this application to run from other machines on the Local Area Network? Tag: Saving current edits Tag: 90042
  - 20
    - Cannot change row in RowUpdating event Hi, I had expected to be able to change the DataRow that is passed into the RowUpdating event, but for some reason it does not seem to work. Am I doing something wrong or is a workaround? -- Thanks in advance, Juan Dent, M.Sc. Tag: Saving current edits Tag: 90041
  - 21
    - detaching an XmlDataDoc from a DataSet Hi All, I've got an XmlDataDocument that is attached to a DataSet with one DataTable in it. Then I take the XML as text and throw it into a Text Box on a form. Later on, I wanted to add another DataTable to the DataSet and it complained: Cannot add or remove tables from the DataSet once the DataSet is mapped to a loaded XML document. How do/can I detach the XMLDataDoc from the DataSet? Thanks! Corey. Tag: Saving current edits Tag: 90040
  - 22
    - ADO Shape command to return XML I'd like to be able to utilize the ADO Shape syntax to return XML. I've seen examples in MSDN that returns an OLEDB DataReader of this hierarchical data..however I'd like the XML out of it. I've done this in the previous version of ADO, but I haven't figured out how to do this in ADO.NET. Any insight would be appreciated. Many thanks- Dan Tag: Saving current edits Tag: 90033
  - 23
    - How to create data adapter for multiple tables (joint tables)? I use sql builder to create a dataadapter. If there is only one table, the insert/update/delete commands are automatically created successful. However, if I build a select command based on multiple tables, I got errors: "insert/update/delete commands can't create automatically for multiple tables...?". Any of you know how to accomplish this? Any suggestions are greatly appreciated. -V Tag: Saving current edits Tag: 90023
  - 24
    - Query Analyzer speed vs. SqlCommand.ExecuteReader speed All, I have an SP that takes about 5 seconds to run before any caching performed by SQL server (I run DBCC DROPCLEANBUFFERS to make sure in my tests). When I hook the SP into a SqlCommand object, the SP Cmd.ExecuteReader line takes about 5 seconds every time I reload the page. But if I run it through Query Analyzer it takes 5 seconds for the first run and every subsequent request is less than half a second. I assume this is behavior of Sql Server caching the tables/results. My question is why would Cmd.ExecuteReader take 5 seconds each time if Sql Server is indeed caching teh tables/results (as evidenced by the fast subsequent QA calls)? It is possible there is SET environment variable being called by SqlCommand, or a lack of variable in the connection string that causes the ExecuteReader to take so long each time? Thanks, JL Tag: Saving current edits Tag: 90022
  - 25
    - global connection or seperate connections for each stored proc cal Hi I seem to recall reading that it can be a bit risky using just 1 global data connection in the global.aspx file, instead of multiple connections, but can not recall why. Also is there a lot of overhead with multiple connections? I did a search but did not find anything. Thanks. -- Paul G Software engineer. Tag: Saving current edits Tag: 90017

Pardon this newbie question: I have a user control with a bunch of
textboxes bound to a DataView drawing from a DataSet in a different
class. Data display works fine, but the changes don't seem to get
posted to the underlying table; hence, DataSet.HasChanges always
returns false. What am I missing?

TIA

lc

Top

Re: Saving current edits by Miha

Miha
Sat Jun 19 03:36:25 CDT 2004

You are missing BindingManagerBase.EndCurrentEdit method.
Data isn't commited to dataset until you change row or call the above
method.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"lc" <lcdata@hotmail.com> wrote in message
news:8op6d0589i95073v7jf4v9rl3v8f21hfkh@4ax.com...
>
> Pardon this newbie question: I have a user control with a bunch of
> textboxes bound to a DataView drawing from a DataSet in a different
> class. Data display works fine, but the changes don't seem to get
> posted to the underlying table; hence, DataSet.HasChanges always
> returns false. What am I missing?
>
> TIA
>
> lc

Top

Re: Saving current edits by lc

lc
Sat Jun 19 11:18:39 CDT 2004

Thanks.

Top