ASC-DESC

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
    - DBNULL In the UI, there are some optional field but in the DB I want tto store NULL instead of empty string. Do I check for empty string for these values in the business layer when I am going thru each row in the datatable for Data Validation. Thanks Tag: ASC-DESC Tag: 127057
  - 2
    - eMoovie - a new company - we need sponsors Hello ! We are eMoovie, a young swiss start-up based in Geneva. We developed SICMovie, a novel technology for VOD security. This technology is not a DRM but a DRT (Digital Rights Tatoo). The goal of DRT is not to control the customer's use of the downloaded movie but to give him responsibilities over the use of the file, and thus to unite copyright and private copy right (Fair use) in one system. We need capital from sponsors and private investors in order to continue our development. Please visit our website: http://www.emoovie.com eMoovie Team Tag: ASC-DESC Tag: 127055
  - 3
    - Help connecting to Access DB from web service I am creating a web service that returns data from an Access 2000 database using VS2005. The Access database is located on a different server than where the web service is running. The Access database is also opened by a different desktop application running on various workstations on the network. While developing / debugging the web service is hosted on my development machine using the 'ASP.NET Development Server' that is included with VS2005. When deployed it is being host with IIS. I am using the following connection string: Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\slo-science1\data\PBI Chem data\PBIChemDatabase.mdb" If the database has NOT opened by any of the workstations running the desktop application then the web service runs correctly on both my development machine as well as on the IIS server. If the database has been opened by any of the workstations running the desktop application the web service runs correctly ONLY on my development machine and fails on IIS with the following error: System.Data.OleDb.OleDbException: Could not use ''; file already in use. What are the differences between the 'ASP.NET Development Server' and IIS that would effect how a web service opens a remote Access database? Does anyone know how what settings can be changed so that the web service runs correctly on IIS? Thanks in advance, Jeff Richardson Tag: ASC-DESC Tag: 127054
  - 4
    - ODBC DataSet to Update Ole Access Table I have a dataset that shows data from an ODBC connection and want to insert that data into an access data base. I'm able to create the record lock on the access table, but am unable to get any data inserted from the dataset to the access table. Below is the coding that I have so far. I've struggled with this for about 2 weeks. This is VB.net. Any guidence is truly welcomed. RickN Private Sub btnLoadAccess_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoadAccess.Click Dim sSQL As String Dim icount As Integer Dim i As Integer Dim ds1 As DataSet1 ' create connection and create the command Dim oOleDbConnection As OleDb.OleDbConnection Dim objCommand As New OleDb.OleDbCommand Dim sConnString As String = _ "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=C:\Documents and Settings\Rick Nicholson\My Documents\Visual Studio Projects\MAX Data Interface\Lot Table.mdb;" & _ "User ID=Admin;" & _ "Password=" oOleDbConnection = New OleDb.OleDbConnection(sConnString) oOleDbConnection.Open() 'start a loop here and loop thru and update access For i = 0 To DataSet1.Tables(0).Rows.Count - 1 Next Try 'working sql from pervasive or access...what ever 'INSERT INTO table_name (column_name1, column_name2,...)VALUES (value1, value2,....) ' try this insert into "LotTrackingHistory"("PRTNUM_72") values ('333333') For Each rowX As DataRow In ds1.Lot_Tracking_Hist().Rows sSQL = "INSERT INTO LotTrackingHistory (PRTNUM_72) Values (" & rowX.Item("PRTNUM_72").ToString & ")" Next With objCommand .Connection = oOleDbConnection .CommandText = sSQL .CommandType = CommandType.Text .ExecuteNonQuery() End With 'Count the number of entries and display them 'icount = (objCommand.ExecuteNonQuery()) ' MessageBox.Show(icount) oOleDbConnection.Close() oOleDbConnection = Nothing Catch End Try End Sub End Class Tag: ASC-DESC Tag: 127051
  - 5
    - Large Upload to SQL - Async? Is there any possible way to upload a file into an image field in SQL Server asynchronously? Our users upload a lot of large files into a SQL Server, and we have no way of showing them progress. ADO had an "AppendChunk" method, but it doesn't look like .Net has anything similar. This seems like a big oversight to me... Tag: ASC-DESC Tag: 127049
  - 6
    - How to set in XSD Shema, column not to allows DBNulls? Column has property AllowDbNull to set is it allowed or not to add DbNull. How to set this property in XSD Schema in design time? My object is to make an int field required... Thanks Tag: ASC-DESC Tag: 127046
  - 7
    - deleted rows I have a strongly typed dataset 'A' with a Customer datatable and data. I create a new instance of the same dataset ('B') and import rows into the 'B' Customer datatable from dataset 'A' Customer datatable. I delete a row in dataset 'B' Customer datatable and now want to mark the row as deleted in dataset 'A' customer datatable. How can I do that? I thought I could loop through the Customer B rows, find rows with row state = deleted, find them in Customer A and delete them. However, this process throws an exception that the deleted row is inaccessible. Any suggestions. Thanks, Rick Tag: ASC-DESC Tag: 127044
  - 8
    - Is it possible to add DataRelation on Individual tables? Hello I have two tables that do not belong to DataSet. They are individual. Is it posible to create DataRelation Or ForeignKey in this situation? I tried but on: childTable.ParentRelation.Add(dataRelation) got Null Exception. Thanks Milan Tag: ASC-DESC Tag: 127041
  - 9
    - Delete using GetChanges I'm using DataSet that fills data from a filestore (filenames, size, a DelMe bool coln, etc). Now I want to delete rows which have DelMe set to true. Since I'm using a DataAdapter here, which would be the best way to delete rows that have DelMe=true; Currently I do this. DataRow[] changes = parentTable.Select(null, null, DataViewRowState.ModifiedCurrent); Then I loop and set each to row.Delete() and finally call AcceptChanges() to remove them from the table. Is there a more efficient way to select and delete. ? thanks Sunit Tag: ASC-DESC Tag: 127033
  - 10
    - <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%> You too can learn to be funny in just 7 days flat: http://www.ExpertHumor.com/HowToBeFunny.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 127028
  - 11
    - IndexOutOfRangeException - Index was outside the bounds of the array. We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an individual's printed material is destroyed in the process of fulfillment, we must reproduce the output for them. We do this by reading the XML file back into a dataset and re-outputting the text files. The XML file (and hence the datatable in the dataset) have a LOT of fields/columns (some have over 1000). We discovered that if a column is added to the datatable at the end of the columns collection, AND is later referred to in a SELECT clause to return a row collection, AND then large amounts of columns are removed and then added back into the columns collection, the following error is thrown: System.IndexOutOfRangeException - Index was outside the bounds of the array. We also discovered that if we added the column referred to in the SELECT clause at the BEGINNING of the columns collection (which was not easy) the error did NOT occur. However, this is simply side-stepping the bigger issue. I have sample code that will duplicate this behavior, but that and the XML is too long to post. Is there some way to post this code and XML? This is running on .NET 1.1 framework. Any light that could be shed on this issue would be greatly appreciated. Thank you. Tag: ASC-DESC Tag: 127026
  - 12
    - OLEDB: UpdateCommand fails Hi, can anyone help me with the following. MS Access 2002 database, Northwind, Customer table. In VB.NET using a datagrid and a dataset to fill the datagrid. I'm trying to insert, update and delete records in the datagrid. Inserts and deletes are working fine, but the updates are failing and I can't find out why. Looks strange to me because I'm using inserts, updates en deletes in the same way. My Code: Sub GridSaveDatagrid() Dim cmdUpdate, cmdInsert, cmdDelete As OleDbCommand Dim MySql_Insert, MySql_Update, MySql_Delete As String Try mDbConn.Open() 'Deletes MySql_Delete = "DELETE FROM Customers WHERE CustomerID = @CustomerID" cmdDelete = New OleDbCommand(MySql_Delete, mDbConn) cmdDelete.CommandType = CommandType.Text With cmdDelete.Parameters .Add("@CustomerID", OleDb.OleDbType.VarChar, 5, "CustomerID") End With mDa1.DeleteCommand = cmdDelete 'Updates MySql_Update = "UPDATE Customers " & _ "SET CompanyName = @CompanyName, ContactName = @ContactName, " & _ " City = @City, PostalCode = @PostalCode " & _ "WHERE CustomerID = @CustomerID" cmdUpdate = New OleDbCommand(MySql_Update, mDbConn) cmdUpdate.CommandType = CommandType.Text With cmdUpdate.Parameters .Add("@CustomerID", OleDb.OleDbType.VarChar, 5, "CustomerID") .Add("@CompanyName", OleDb.OleDbType.VarChar, 40, "CompanyName") .Add("@ContactName", OleDb.OleDbType.VarChar, 30, "ContactName") .Add("@City", OleDb.OleDbType.VarChar, 15, "City") .Add("@PostalCode", OleDb.OleDbType.VarChar, 10, "PostalCode") End With mDa1.UpdateCommand = cmdUpdate 'Inserts MySql_Insert = "INSERT INTO Customers (CustomerID, CompanyName, ContactName, City, PostalCode) " & _ "VALUES (@CustomerID, @CompanyName, @ContactName, @City, @PostalCode)" cmdInsert = New OleDbCommand(MySql_Insert, mDbConn) cmdInsert.CommandType = CommandType.Text With cmdInsert.Parameters .Add("@CustomerID", OleDb.OleDbType.VarWChar, 5, "CustomerID") .Add("@CompanyName", OleDb.OleDbType.VarChar, 40, "CompanyName") .Add("@ContactName", OleDb.OleDbType.VarChar, 30, "ContactName") .Add("@City", OleDb.OleDbType.VarChar, 15, "City") .Add("@PostalCode", OleDb.OleDbType.VarChar, 10, "PostalCode") End With mDa1.InsertCommand = cmdInsert 'Update de Customer table. Dim updTable As DataTable = mDs.Tables("Customer") mDa1.Update(updTable.Select(Nothing, Nothing, DataViewRowState.Deleted)) mDa1.Update(updTable.Select(Nothing, Nothing, DataViewRowState.ModifiedCurrent)) mDa1.Update(updTable.Select(Nothing, Nothing, DataViewRowState.Added)) Catch ex As Exception Console.WriteLine(ex.Message) Stop Finally If Not mDbConn Is Nothing Then mDbConn.Close() End Try End Sub Tag: ASC-DESC Tag: 127025
  - 13
    - Data components design question Hi all, I'm new to .NET but have quite a long experience as OO developer. I've been reading lots of documentation in order to get started with the SDK. First I started with on-line documentation about ADO.NET and now I am actually using the Microsoft Patterns and Practices document "Designing Data Tier Components and Passing Data Through Tiers" as a guide to develop my Data Access Logic Components. This document, as well as others, states that in a distributed anvironment each DALC should manage the connection towards its own data store. My questions are: 1) So, is it correct that such an approach invalidates the idea of a global connection for the whole application (example: a single Connection class instance that can be passed to each DALC constructor in the application)? Or this is true just for distributed applications? Would it be better to use a distributed oriented approach if I want to build a scalable, reusable solution? 2) Should the DALC know everything about the data store type? I mean, imagine I want to build a helper class for my DALC which would incapsulate methods needed to provide the right type of objects (Sql/OracleCommand, Sql/OracleDataAdapter and so on) to the DALC in order to accomplish a multiple db platforms implementation? Then I should tell the DALC, at a certain point in its lifecycle, (let's assume during its creation/initialization => in its construcytor code) which type of data store should be used (Sql Server, Oracle etc.). In a traditional approach, this would usually be implemented as a property read from the client application registry or something like that, and passed to the the DALC constructor. Now, if the DALC does manage the connection on its own who tells it which data store type should be used? And how? Am I taking it wrong if I think to read this option from a config file placed into the DALC phisical location? Or, again, am I thinking it wrong as in a distributed environment a single DALC "hides" its data store to all the callers and then it can be fixed at complie time? Hope I pointed out my doubts, and thanks in advance for any answers. Cheers, baba. Tag: ASC-DESC Tag: 127024
  - 14
    - >@>@>@>@>GET MORE CHICKS............LEARN GUITAR............. Chicks dig guitar players. So get more chicks! Learn how to play guitar! http://www.ExpertHumor.com/LearnGuitar.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 127023
  - 15
    - <><><><><><><>The Net's #1 Joke e-Book!<><><><><><><><> That's Comedy - Over 460 Pages of Little Snickers, Medium-Sized Chuckles, and Great Big Belly Laughs: http://www.ExpertHumor.com/That'sComedy.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 127022
  - 16
    - AllowDBNull in DataTables I use a data adapter to fill a DataTable (that contains no row or columns) with data from a table in my SQL Server Express database. The columns that the DataAdapter creates in my DataTable all have the correct datatype but each is created so that AllowDBNull = True. However, the table in the SSE Database has columns where NULLs are not allowed. Any idea why this information isn't making it from teh database to the DataTable? Whats more, if I try and change the change the columns in the DataTable myself after the Fill() method is called, setting AllowDBNull = True seems to have no effect. Why would this be? TIA Tag: ASC-DESC Tag: 127021
  - 17
    - SqlDataReader Function From a VB6 refugee All, I'm trying to create a DataReader Function to call from within my class to open a simple datareader. I have thoroughly read the Data Access Patterns and practices and do not believe in using canned code right off the bat. I want to rebuild the canned code so I understand it, then I may use it or use my own understood version. The error message is in Error Text: Message="Invalid attempt to Read when reader is closed." '===================== This is call to function =================== Dim dr As SqlDataReader = Create_SQL_DataReader("20060213") While dr.Read() !!! Errs here End While '===================== End call to function =================== Shared Function Create_SQL_DataReader(ByVal sDate As String) As SqlDataReader Dim SQLConn As New SqlConnection(sConn) Using SQLConn ' This Builds SQL String into "s" and uses passed in param "sDate" Dim s As String = BuildShiftSQL(sDate) Dim Cmd = New SqlCommand(s, SQLConn) SQLConn.Open() Dim iDr As SqlDataReader = Cmd.ExecuteReader() Return iDr s = String.Empty SQLConn.Close() SQLConn.Dispose() End Using End Function Error Text: System.InvalidOperationException was unhandled Message="Invalid attempt to Read when reader is closed." Source="System.Data" StackTrace: at System.Data.SqlClient.SqlDataReader.ReadInternal(Boolean setTimeout) at System.Data.SqlClient.SqlDataReader.Read() at WindowsApplication1.dataReaderDataSetForm.Main() in C:\Data\VBExpress\Parts\Parts\Form1.vb:line 20 at System.AppDomain.nExecuteAssembly(Assembly assembly, String[] args) at System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args) at Microsoft.VisualStudio.HostingProcess.HostProc.RunUsersAssembly() at System.Threading.ThreadHelper.ThreadStart_Context(Object state) at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.ThreadHelper.ThreadStart() Tag: ASC-DESC Tag: 127015
  - 18
    - ODP .net Dear All, i have establish a connection to Oracle 10g using ODP.net , i could populate data in a listbox/combo box, but i need to display these data in one by one , i mean navigation using |< < > >| these buttons , plshelp me blw is the code i'm using to populate data in combo/list box ----------------------------------------- dbconnection.getConnection() ' connection string written in a module calling her e Dim conn As New OracleConnection(oradb) Dim exp As Exception Try conn.Open() Dim sql As String = "select EMPNO,ENAME,mgr from emp where 1 =1 " Dim cmd As New OracleCommand(sql, conn) cmd.CommandType = CommandType.Text Dim dr As OracleDataReader = cmd.ExecuteReader() TextBox1.Text = dr.Read() MsgBox("1") ListBox1.Items.Add(dr.Item(1)) conn.Close() conn.Dispose() Catch exp MsgBox(exp.Message.ToString) End Try ------------------------------------------------ Tag: ASC-DESC Tag: 127011
  - 19
    - Problem in creating sql database in visual web developer 2005 express Hi, When I go to Add New item->Sql database-> click ADD i get the following error.I also get the same error when i open the security page on web site admininstration tool. "There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. An unexpected error occurred while checking the sector size for file 'U:\VISUAL STUDIO 2005\WEBSITES\APP9\APP_DATA\ASPNETDB_TMP.MDF'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information. Creating the ASPNETDB_1e007377194340a4850801591429f1bc database" Please help me-- Thanks Tag: ASC-DESC Tag: 127009
  - 20
    - ObjectDataSource field binding to DataSet does not work I built a dataset with 11 tables and their relationships using the data set builder. I removed all the table adapters: the intention is to use the Enterprise Library to load the data, and to do the updates. That side of things works fine. The plan is to use ObjectDataSource to bind web controls to the tables in the data set. Unfortunately the data source does not show any of the fields in the table I am returning. The class I am linking to the data source has a bunch of parameter-less methods to return each of the tables in the data set. These are strongly typed, but the signature of my method is GetCompany(), returns DataTable, and I specify it as the Select method. I have verified that the method is called at run-time, but the details view does not appear, even with a manual bound field. How do I bind do a table in a dataset? Tag: ASC-DESC Tag: 127004
  - 21
    - How to synchronise, grid and dataset update ??? Dear all, I have a strange behaviour when updating a grid. I will try to explain clearly: I have a CustDataSet object fill with customer information like Name, Firstname, Country, adress That Custdataset contains all my customer information. Then I have a web page on which my user can select only customers from a particular country. For that i create a Dataview object from CustDataset. I set the RowFilter to get only the desired country. Then I bind that DataView to my DataGrid. If CustDataset contains information from that country, then they get properly displayed in the grid. At this stage, my user is able to edit records from that dataGrid bind to DataView or Add a new entry. For edition an Edit, Upadate template column has been added and in the EditCommand event I have following code : dgLabData.EditItemIndex = e.Item.ItemIndex dgLabData.DataSource = dataView dgLabData.DataBind() Then my user gets text box field to update data directly from grid. When pressing the Updade link, current records need to be update and store in custDataset. In the grid UpdateCommand I retrive cells value as follow: newData(0) = CType(e.Item.Cells(1).Controls(0), TextBox).Text newData(1) = CType(e.Item.Cells(2).Controls(0), TextBox).Text newData(2) = CType(e.Item.Cells(3).Controls(0), TextBox).Text dgLabData.EditItemIndex() = -1 dgLabData.DataSource = dataview dgLabData.DataBind() After this I did not get display any changes made, or new row added but always the previous initial state. How to synchrosise changes made in the dataGrid, dataview, dataset object in order that it reflect changes when DataBind is called ?? I am lost, thnaks for your help serge Tag: ASC-DESC Tag: 127003
  - 22
    - <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%> You too can learn to be funny in just 7 days flat: http://www.ExpertHumor.com/HowToBeFunny.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 126999
  - 23
    - >@>@>@>@>GET MORE CHICKS............LEARN GUITAR............. Chicks dig guitar players. So get more chicks! Learn how to play guitar! http://www.ExpertHumor.com/LearnGuitar.htm *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 126998
  - 24
    - Amnesty for illegal immigrants will not happen this time..................... Our politicians lead the league in all talk, no action. Is blowing us some sunshine good enough? Read what The Expert thinks: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 126997
  - 25
    - Will illegal immigrants get deported?.........Of course not..................... Our politicians just wanted to blow us some sunshine. Get the details from The Expert: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 126995
- Next
  - 1
    - Illegal Immigration, the Non-Issue of the Week?????????????? The way our politicians rushed to talk about illegal immigration this week, maybe they thought it came with a free lunch. They won't do anything about it, but it will get them some money. The Expert provides the details at: http://www.ExpertHumor.com/ *** Free account sponsored by SecureIX.com *** *** Encrypt your Internet usage with a free VPN account from http://www.SecureIX.com *** Tag: ASC-DESC Tag: 126994
  - 2
    - can't connect to sql server using ip number My code: Dim IP As String IP = "192.168.0.169" SqlConnection1.ConnectionString = "workstation id=xxxxx;integrated security=SSPI;Data Source=" & IP & ";persist security info=False;initial catalog=adp1SQL" The error occurs when I use the IP address instead "mshome". when IP="MSHOME" the code runs smoothly. while in the development stage, this project is only instaled in the PC where MSDE 2000 is installed. Could this be the problem? Tag: ASC-DESC Tag: 126991
  - 3
    - changing key field in Data Form Wizard form I created a form using the Data From Wizard. It lets me change and update all the fields except the primary key. When I modify the pk textbox, it throws this exception: "Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints." The row count on the form in incremented by 1 and everything is messed up until I restart the application. Any ideas? Thanks. Tag: ASC-DESC Tag: 126988
  - 4
    - IndexOutOfRangeException - Index was outside the bounds of the arr We are encountering an extremely odd issue. We process incoming files for customers and output text files to produce printed material. Then an XML file containing the fields of the original file along with all fields necessary to produce the output text files are saved as an XML file. If an individual's printed material is destroyed in the process of fulfillment, we must reproduce the output for them. We do this by reading the XML file back into a dataset and re-outputting the text files. The XML file (and hence the datatable in the dataset) have a LOT of fields/columns (some have over 1000). We discovered that if a column is added to the datatable at the end of the columns collection, AND is later referred to in a SELECT clause to return a row collection, AND then large amounts of columns are removed and then added back into the columns collection, the following error is thrown: System.IndexOutOfRangeException - Index was outside the bounds of the array. We also discovered that if we added the column referred to in the SELECT clause at the BEGINNING of the columns collection (which was not easy) the error did NOT occur. However, this is simply side-stepping the bigger issue. I have sample code that will duplicate this behavior, but that and the XML is too long to post. Is there some way to post this code and XML? This is running on .NET 1.1 framework. Any light that could be shed on this issue would be greatly appreciated. Thank you. Tag: ASC-DESC Tag: 126986
  - 5
    - Concurrency violation trying to update a table in SQL Server I have an intermittent error where I get the following exception: "Error: Concurrency violation: the UpdateCommand affected 0 records." Here are the steps I follow: Create SQLConnection Set connection string of the connection. Open connection Create SQL Data Adapter with the connection and a simple select statement including an indexed column Create SqlCommandBuilder on this adapter Fill DataTable with the Adapter Loop through each datarow and based on contents of a field, possibly update another field in the same row Call If Not tbl.GetChanges Is Nothing Then adapter.Update(tbl) This last step is where the error occurs. I am the only user of the system so there are no concurrency issues. When I tried to run profiler while executing, the problem went away and I no longer seem to be able to reproduce this problem on that machine. Any help would be appreciated. Thanks in advance, Boris Zakharin Tag: ASC-DESC Tag: 126985
  - 6
    - How to loop through rows of strongly typed dataset table In vb.net 1.1 I could do this: Dim ds As dsEquip = GetDataset() Dim dr As dsEquip.tbEquipRow For Each dr In ds.tbEquip.Rows 'Do something Next now in c# 2.0 I'm trying to do the same thing like this: dsEquip ds = oData.PersonGetRecShort(); foreach (dsEquip.tbEquipRow dr in (dsEquip.tbEquipRow)ds.tbEquip.Rows) { } I get a compile error saying: Error 1 Cannot convert type 'System.Data.DataRowCollection' to 'ClientDataLayer.dsEquip.tbEquipRow' F:\Data\Sample Projects\WWF\myFormState\BusinessLayer\Persons_BLL.cs 53 63 BusinessLayer Using c# 2.0, what's the correct way to loop through all the rows in ds.tbEquip.Rows? Thanks. Tag: ASC-DESC Tag: 126983
  - 7
    - XML string to SqlDataReader for SQL Server 2005 CLR Stored Procedure I need some help getting an xml string into a SqlDataReader and I am stuck. (I admit I'm no guru at this stuff.) I can easily get it into a DataSet object, but the SqlContext.Pipe.Send() method needs a SqlDataReader object as a parameter. (I don't want to send it as an XML string.) Here is my method so far...any clues and code samples would be greatly appreciated...I'm a visual learner. =) [Microsoft.SqlServer.Server.SqlProcedure] public static void GetAPList2() { // allow https access System.Net.ServicePointManager.CertificatePolicy = new AirWave.TrustAllCertificatePolicy(); string webURL = "https://webservice.somesite.com/ap_list.xml?id=47"; CredentialCache sec = new CredentialCache(); sec.Add(new Uri(webURL), "Basic", new NetworkCredential("*****", "*****")); WebClient client = new WebClient(); client.Credentials = sec; string pageHTML = Encoding.UTF8.GetString(client.DownloadData(webURL)); Byte[] pageData = client.DownloadData(webURL); string pageHtml = Encoding.ASCII.GetString(pageData); DataSet xmlDS = new DataSet(); XmlTextReader rdr = new XmlTextReader(pageHTML, XmlNodeType.Document, null); xmlDS.ReadXml(rdr); SqlDataReader dr = /* STUCK HERE!???? */ SqlContext.Pipe.Send(dr); } Tag: ASC-DESC Tag: 126982
  - 8
    - How can I determinate if the Database exist before detach it? I use the code below to detach a Database, but if the database does not exist, it will thow exception. How can I determinate if the Database exist before detach it? *********************************************************************** string sConnection = "Data Source=......"; string sCmdDetach="sp_detach_db 'Health'"; SqlConnection cnn = new SqlConnection(sConnection); cnn.Open(); SqlCommand cmd= new SqlCommand(sCmdDetach, cnn); try { cmd.ExecuteNonQuery(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { cnn.Close(); } Tag: ASC-DESC Tag: 126980
  - 9
    - How could you explain this? Hello I've experienced a very low speed filling DataSet in program running on PocketPC and connected to SQL Server via Wireles Lan. I used SqlDataAdapter. Table basically consists of text fields of type nvarchar and has about 6000 rows. It takes about 5 minutes to fill DataSet using SqlDataAdapter.Fill. Then I wrote a stored procedure which created a temporary table inserting there fields from the initial table and converting them from nvarchar to varchar. And now from resultset of this procedure SqlDataAdapter fills DataSet 8-9 times faster! I've expected 2 times increase in better case. Why is there such increase of speed? Maybe because SqlDataAdapter or DataSet makes something like a re-encoding when filling and there is a way to avoid this not converting nvarchar to varchar? Tag: ASC-DESC Tag: 126974
  - 10
    - Trouble entering empty date into Access table from ASP.NET app using ADO.NET Hi, I have an ASP.NET app that uses ADO.NET for data access. I have a form that allows a user to enter a date. This date field is not required however. If they don't enter it, I shove a variable declared of type System.DateTime that is initialized to null into the database. It works but if you open the table in Access, the date field contains 12:00 AM. When this value is rendered in an Access form, it shows as 12/30/1899. What can I do to basically insert null/nothing into that field? I'm using the System.Data.OleDb library and a parameterized query to insert this date data into the Access table. I tried checking for an empty date and substituted the date parameter value with DBNull.Value but that doesn't seem to remedy the situation. Thanks for the help, Josh Blair Evergreen, CO Tag: ASC-DESC Tag: 126972
  - 11
    - Why won't Dataset reflect changes? I have a single page application that uses Web Service to fill a dataset decending. When I add a new record to the database and re-fill dataset it won't reflect the first record added until after I've added a second one. Like wise the second record added won't show in dataset until a third is added. I've read 44 pages of this forum and tried about every solution to dataset updating that I found. DataAdapter.Update, dsxxxx.AcceptChanges, totally killing the dataset and recreating and still I get this same effect. I do not use any caching or states on this page. To check if it was the Web Service I added a direct sqlDataAdapter to the page along with another dataset and these 2 preformed exactly the same as Web Service supplied dataset. I know the record is being written as I can time stamp the page post-back and look at the SQL table and times are same down the 10ths of a second. I'm using VS2003 with SQL2005 with C# coding. Any idea's I would be willing to try. Thanx Tag: ASC-DESC Tag: 126971
  - 12
    - Nesting ambient transactions.. doable? im trying to put a transaction around my NUnit tests fixtures and a seperate transaction around each test and I'm trying to do that in my base class so that all my test can benefit from them. The problem is that I can't find a way to do both transactions. it's either around the whole fixture or around the test. is there a way to do both? here is my base test class: using System; using System.Transactions; using NUnit.Framework; namespace Library.Tests { public enum TestTransactionMode { None, AroundFixture, AroundTests } [TestFixture] public abstract class BaseFixtureWithTxRollback : BaseFixture { Transaction fixtureTransaction; Transaction testTransaction; private TestTransactionMode testTransactionMode = TestTransactionMode.AroundFixture; /// <summary> /// The transaction mode of the test /// </summary> public TestTransactionMode TestTransactionMode { get { return testTransactionMode; } set { testTransactionMode = value; } } [TestFixtureSetUp] public override void TestFixtureSetUp() { base.TestFixtureSetUp(); if (testTransactionMode == TestTransactionMode.AroundFixture) { fixtureTransaction = new CommittableTransaction(); Transaction.Current = fixtureTransaction; } } [TestFixtureTearDown] public override void TestFixtureTearDown() { if (fixtureTransaction != null) { fixtureTransaction.Rollback(); } } [SetUp] public override void TestSetUp() { base.TestSetUp(); if (testTransactionMode == TestTransactionMode.AroundTests) { testTransaction = new CommittableTransaction(); Transaction.Current = testTransaction; } } [TearDown] public override void TestTearDown() { base.TestTearDown(); if (testTransaction != null) { testTransaction.Rollback(); } } } } So basically i want to have another TestTransactionMode.AroundTestAndFixture. I found SubordinateTransaction class which takes ISimpleTransactionSuperior in its constructor but there is no implementation for this interface. Tag: ASC-DESC Tag: 126960
  - 13
    - How can i write an object to db? I get an e-mail in C# I want to store this e-mail item in SQL Server 2005. I don't have any hardcopy of this mail item. I only have a programmatic C# object, and i wish to insert it into a varbinary field. How can i convert this object to a suitable form to insert to db? Tag: ASC-DESC Tag: 126953
  - 14
    - Join two Datatables I have two datatables in a dataset with a relation defined. How do I generate a JOINed view of this data? Thanks, MS Tag: ASC-DESC Tag: 126949
  - 15
    - Empty Parameter Hello, I have sql command like: "Select... Where myColumn = @myParameter" Now, I can simply add parameter to the collection and filter data. What if I want to return not filtered data, I mean to skip, avoid executing this "myColumn = @myParameter"?! Is this possible, or I have to change select command every time I don't want filtered data? Tag: ASC-DESC Tag: 126945
  - 16
    - Update Database records ?? Dear all, I have a dataset object which as been filled from an SQL server table I have then a dataview from that dataset,which is bind to a datagrid object. My user can edit, update, delete entry directly from that datagrid through an ASP page. Is there a simple way to automatically handle a database object based on the rowstate of the datagid ? What I mean is that : - if my user add an entry I should run a proper INSERT querry - if my user Update an entry I should run a proper UPDATE querry - if my user add an entry I should run a proper DELETE querry Is there any self intelligent function which is able to read the status of Rows and execute proper statement. I could also use the GetChange function to build a new dataset and then handle th select .. Any tips thnaks for your help regards serge Tag: ASC-DESC Tag: 126943
  - 17
    - Is there a way i can debug through the Sql script in my SqlDataSource .... Hello, I'm very excited about the new SqlDataSource in asp.net 2.0. I have written a wuite long sql script on my SqlDatasource UpdateCommand. I want to see wheater it actually does what it was meant to do. Is there any way i can do this? Many thanks JJ Tag: ASC-DESC Tag: 126937
  - 18
    - Connecting to SQL 2005 Express over a network share Hello, To my amazement I cannot connect to a SQL 2005 Express over a network share. Now reading through the newsgroups I can understand why this can be a problem BUT... HOW does one go about having two PCs read/write data to a centralized SQL 2005 Express Database? Any help would be GREAT! Phil Tag: ASC-DESC Tag: 126934
  - 19
    - Threads and Transaction Problems.... After four long hours of googling on the subject and finding almost nothing, I'm forced to post this one. I'm doing a small project that reads several IIS and stores in a database the domains hosted there. This application runs quite fine. But I'd like to add some transaction control on it, because it might ab-end at any given time (so far it didn't, but I think it's sheer dumb luck :-) Stripped out of anything meaningful code, my approach to create the transaction is: ---- BEGIN pseudoCode ---- Imports System.Threading Private ThreadCount As Integer = 0 Sub Main() For Each s as Server In Farm Interlocked.Increment(ThreadCount) Do While Not ThreadPool.QueueUserWorkItem(AddressOf WorkerThreadForServer, s) Thread.Sleep(100) Loop Next Do While (ThreadCount <> 0) Thread.Sleep(100) Loop End Sub Sub WorkerThreadForServer(s as object) Dim dbConn as SqlConnection Dim dbTrans as SqlTransaction Try dbConn = new SqlConnection dbConn.QueryString = QUERYSTRING dbConn.Open() dbTrans = dbConn.BeginTransaction() For Each w as WebServer in s InsertDataInDB() Next dbTrans.Commit() Catch(ex as Exception) dbTrans.Rollback() Finally dbConn.Close() End Try Interlocked.Decrement(ThreadCount) End Sub ---- END pseudoCode ---- As far as I could gather on the net the above code SHOULD work fine, but it stumbles on the transactions. If I remove the transactions the code works fine, smoothly even. During the process of inserting the data on the server I dump some information on the screen and in a log file. When there's no transaction I see information being dumped from all servers at once, when the transactions are active, however, I see information of only one server and then it throws an TimeOutException while including the info. I've checked, rechecked and triple-checked the code and I can't see anything wrong. Can anyone help me? Regards, PJ http://pjondevelopment.50webs.com Tag: ASC-DESC Tag: 126928
  - 20
    - Create XLS file from Query? (VB, OLEDB, ADO.NET 2.0) I need to create new Excel 2003 XLS files containing a single worksheet that has the results of a database query (a combination of text, integer, and date columns). Can someone please point me to an example of how to do this in a VB2005/ADO.NET 2.0 Winforms app, *WITHOUT* using Interop (Office will *not* be installed on the machine generating the file). Thanks! Tag: ASC-DESC Tag: 126927
  - 21
    - How do i perform intersection in 2 datsets?? How do i perform intersection in 2 datasets having a same col. *** Sent via Developersdex http://www.developersdex.com *** Tag: ASC-DESC Tag: 126910
  - 22
    - Datarelation query If i need to relate two tables using datarelation on a column "col1" out of which,table1 i want to make as parent table contains duplicate entries in "col1" and i want to retrieve all the rows present in table2 having matching rows on "col1" of only ("col1" and "col2") of table2. *** Sent via Developersdex http://www.developersdex.com *** Tag: ASC-DESC Tag: 126909
  - 23
    - Data Access Layer design question Hi. I have a quick question. I am trying to create a quick data access layer for command CRUD tasks using stored procedures. My question is more of a design point of view. In each of my methods Create, Read, Update, and Delete, it seems I am repeating a lot of code such as: <Code> // Create the connection and Open it SqlConnection conn = new SqlConnection(connectionString); conn.Open(); cmd = new SqlCommand(storedProcedure, conn); // Set the type of command to a stored procedure cmd.CommandType = CommandType.StoredProcedure; // Add the SP parameters to the command cmd.Parameters.AddRange(parameters); </Code> What's the opinion on this? Should I create a connection in a method and pass it back or just repeat this chunk of code in each method? I read some articles that mentioned that when passing connection references around one needs to be careful to close connections, etc. Tag: ASC-DESC Tag: 126903
  - 24
    - how to INSERT records to an OLEDB target ?? Hi I have a datatable with several field and, particularly, a binary field (byte[]) (taken from some database) using the OleDB connection. Now I want to INSERT all the record of this table into a newly CREATEd table of another database (say mysql or access or sybase or whatever: just assume it be an arbitrary OleDb connection). I am connected via the OleDb connection. My question. What is the best way to insert these records (I would like to be able to do the insert whatever be the target (always OleDb)). Any snippet would be much appreciated. I have already seen several posting on how to use PARAMETERS, @field, BUT my greatest concern is the binary field. If you could elaborate a little on the best way to upload the BINARY stuff, I would be grateful. I have no idea how to deal with it. Is it sufficient that I assign the byte array to the Value property of a parameter? Or would this not make any sense? -Pam Tag: ASC-DESC Tag: 126902
  - 25
    - TableAdapter vs DataAdapter performance Hi, Thinking of the best way to develop a data acces layer for a new program I have been doing some performance test. My lab pilot is as follows: SqlServer 2000 + VS2005 TS in the same machine. Storage procedure returning 100.000 records from a table ----------------------------------------------- DataTable dt = new DataTable(); ArticulosTableAdapter ta = new ArticulosTableAdapter(); SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter(sqlCommand);. Connected Model: ----------------------------- puno = Environment.TickCount; sqlCommand.Connection.Open(); SqlDataReader sqlDim = sqlCommand.ExecuteReader(); dt.L.oad(sqlDim); sqlDim.Close(); sqlCommand.Connection.Close(); time = TimeSpan.FromMilliseconds(Environment.TickCount - puno); Trace.Write("Load From DataReader Time-> "); Trace.WriteLine(time); Running: Load From DataReader Time-> 00:00:02.3440000 Disconnected Model: ------------------------------------ 1) TypedDataSet with DataAdapter puno = Environment.TickCount; da.Fill(_articulosDS); time = TimeSpan.FromMilliseconds(Environment.TickCount - puno); Trace.Write("Typed DataSet With DataAdapter Time-> "); Trace.WriteLine(time); Running: Typed DataSet With DataAdapter Time-> 00:00:00.5620000 2) TypedDataSet with TableAdapter puno = Environment.TickCount; ta.Fill(_articulosDS.Articulos); time = TimeSpan.FromMilliseconds(Environment.TickCount - puno); Trace.Write("Typed DataSet With TableAdapter Time-> "); Trace.WriteLine(time); Running: Typed DataSet With TableAdapter Time-> 00:00:02.6250000 I understand that filling a DataTable with a DataReader is a time consuming process that will take 2,34 secs for 100.000 records, but I do not understand why Filling a TableAdapter I am getting poor performance (3 times less) than Filling a DataAdapter. Any Idea ? Thank you José Ramón Tag: ASC-DESC Tag: 126896

Hi,
The Asc or Desc functions work well on the sql server, but when I try to use
the parameters collection through ASP.NEt . The SQL statements doesn't
execute the same way. Ex: I'm trying to sort months say as 1-Jan,2-Feb etc.
on ASP page I get is as 1 Apr, 8 Aug etc. The sql stmt ends ass ORDER BY
month(date) DESC & works well.
Thanks.

Top

Re: ASC-DESC by Cor

Cor
Sat Apr 01 06:04:16 CST 2006

Gurvar,

I have read it fout times and I know now what works. What does not work?

Cor

Top

Re: ASC-DESC by Terry

Terry
Sat Apr 01 07:05:40 CST 2006

:-D

I read it about four times as well , I think you have your date in the wrong
culture and its sorting the days as months. One way is to convert the date
to a serial

--
Terry Burns
http://TrainingOn.net
"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:etpKqQYVGHA.4900@TK2MSFTNGP12.phx.gbl...
> Gurvar,
>
> I have read it fout times and I know now what works. What does not work?
>
> Cor
>

Top