Save mix data in database

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
 - Get Query string from Dataset/Datatable Hello When i fetch data from database i do the following: DataSet ds = new DataSet(); OledbConnection con = new OledbConnection(ConnectionString); using ( OledbCommand cmd = con.CreateCommand()) { cmd.CommandText = "SELECT * FROM [tblCustomers] WHERE [CustomerName] LIKE 'A%';"; using ( OledbDataAdapter da = new OleDbDataAdapter(cmd)) { da.Fill(ds); ds.Tables[0].TableName = "tblCustomers"; } } The above just ment as an illustration. The DataSet ds now contain one table with the result of the query within the cmd. Now my question, is the cmd Query stored somewhere within the DataSet/Table? Kind regards Johnny E. Jensen Tag: Save mix data in database Tag: 142179
 - 2
 - ANN: High performance of remoting ADO.NET objects cross desktop and smart devices Hi, All: UDAParts has updated .NET versions of SocketProAdapter at www.udaparts.com for supporting binary remoting .NET ADO.NET objects, DataSet, DataTable and DataReader. Key features and improvements over MS technologies are: 1. Bi-directional remoting DataSet, DataTable and DataReader across desktop and smart devices. 2. Bi-directional remoting DataSet, DataTable and DataReader across different .NET runtime versions (1.0, 1.1, 2.0, .....). 3. Significantly faster (1 - 6 times) than MS .NET remoting and MS WCF. 4. Significantly reduce transaction latency without using worker threads. 5. Consume significantly less memory and much smaller footprint. 6. 100% open source code (C++/CLI and C#) for your reviewing. It is highly extensible. 7. Secure through SSL/TLS. 8. Built-in real-time notification, 9. Integrated or user defined authentication. 10. Built-in online compression. ...... Samples for VB.NET and C# are available at ..\udaparts\SocketPro\samples\RAdo after you downloading latest version (4.8.2.19) of SocketPro Soon, UDAParts will provide a short article for describing remoting ADO.NET objects through SocketPro using batching, asynchrony and parallel computation. www.udaparts.com Tag: Save mix data in database Tag: 142170
 - 3
 - DAtaset comparision ?? Dear all, What is the best way to compare 2 dataset ? What I mean by that is not comparing that its teh same object but allso that rows data values in both . In other words I need an effeective way which tells me if records between 2 dataset are the same or different thnaks for help regards serge Tag: Save mix data in database Tag: 142168
 - 4
 - there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? there seems to be some overhead between SQL Server 2005 and a CLR function written in C#. Why is this? I have a simple wraper around System.Diagnostics.Stopwatch.GetTimestamp() : public partial class UserDefinedFunctions { [Microsoft.SqlServer.Server.SqlFunction] public static long GetTimestampF() { return System.Diagnostics.Stopwatch.GetTimestamp(); } }; but if i run this it is hardly accurate. the time of getting from sql server to a CLR function seems to be relatively slow for nanosecond calculations: DECLARE @before bigint DECLARE @after bigint SET @before = dbo.GetTimestampF() -- do something SET @after = dbo.GetTimestampF() SELECT @after - @before as nanoseconds is there nyway to elimitate this overhead so that dbo.GetTimestampF() executes as fast for TSQL as it is to call GetTimestampF() in C#? If i call my GetTimestampF() on c# it executes fast enough for the nanosecond results to be accurate Tag: Save mix data in database Tag: 142167
 - 5
 - Problem in copying SQLite file in C# code I have a little Windows application written in C# with a SQLite back- end. I'm using the System.Data.SQLite provider. One of the features the application provides is a database back-up, which just basically copies the S3DB file to a specified location. See the code below: //------------------------------------------------ System.IO.File.Copy(srcPath, destPath, true); //------------------------------------------------ The file is copied without any problems, but when the application attempts to access the original S3DB file again, the following exception is thrown: -------------------------------------------------- System.Data.SQLite.SQLiteException was unhandled Message="Unable to open the database file" Source="System.Data.SQLite" ErrorCode=-2147467259 StackTrace: ...etc... -------------------------------------------------- If I shut the application down and then start it up again, I can access the database again with no problems. Suspicious of what the File.Copy() method might be doing behind the scenes, I tried using the following approach instead to hopefully ensure that the files were being released: //------------------------------------------------ using (FileStream fsSrc = new FileStream(srcPath, FileMode.Open)) { //Get the source length once so we don't have to keep retrieving it later int srcLen = (int)fsSrc.Length; //Create the destination file (this will overwrite the destination file if it already exists) using (FileStream fsDest = File.Create(destPath, srcLen)) { //Buffer the contents of the source file Byte[] buffer = new Byte[srcLen]; fsSrc.Read(buffer, 0, srcLen); //Write buffered contents to the new file fsDest.Write(buffer, 0, srcLen); } } //------------------------------------------------ Unfortunately, the same problem occurs. I even tried executing the code in its own thread, but with the same results. Any ideas why this is happening and how to fix it? Thank you. Tag: Save mix data in database Tag: 142165
 - 6
 - databinding I have a checkbox (along with textboxes) that I am trying to use as a databound control to an integer field on a database. I am using Format and Parse with the checkbox to write -1 to the database if the checkbox is unchecked and 0 if checked. I am finding that the Dataset and Database are not updated if I change the checkstate of the checkbox and when I change the checkstate of the textbox, the other controls (textboxes) will not allow focus. The code I have written is below. Any suggestions would be appreciated. // chbActive System.Windows.Forms.Binding chkBoxBinding = new System.Windows.Forms.Binding("CheckState", this.tblEmployeeBindingSource, "inActive", true); chkBoxBinding.Format += new System.Windows.Forms.ConvertEventHandler(IntegerToCheckState); chkBoxBinding.Parse += new System.Windows.Forms.ConvertEventHandler(CheckStateToInteger); this.chbActive.DataBindings.Add(chkBoxBinding); this.chbActive.CheckStateChanged += new System.EventHandler(this.chbActive_CheckStateChanged); //this handles integer to checkstate private void IntegerToCheckState(object sender, ConvertEventArgs cevent) { // the method converts only to CheckState inActive is 0 if false if ((int)cevent.Value == 0) { chbActive.CheckState = CheckState.Checked; } else { chbActive.CheckState = CheckState.Unchecked; } } private void CheckStateToInteger(object sender, ConvertEventArgs cevent) { // if Active is checked then they are active and inActive should be 0 if (chbActive.CheckState == CheckState.Checked) { cevent.Value = 0; } else { cevent.Value = -1; } } Tag: Save mix data in database Tag: 142164
 - 7
 - Confusing Error related to MappingSource? I'm trying to force LINQ to SQL to do some inheritance modeled around the "Table per Concrete Class" methodology as opposed to the normal "Table per Class Hierarchy" model it officially supports. To do this, I omitted all the properties of the inheritance relationship (Discriminator information and such) and provided the proper Table attribute to associate my derived class with its own table by addint a new partial class implementation manually. So what I end up with is a base class that has all the columns in it, and two derived classes that inherit from it in the designer, and have no additional properties. Then in another file, I declare both derived classes just to supply the Table attribute, providing each derived class' table name. The problem I run into is this error message: "Data member 'Int32 DocNum' of type '(my base class)' is not part of the mapping for type '(my derived class)'. Is the member above the root of an inheritance hierarchy?" Now I've checked the contents of the MappingSource. I retrieved context.Mapping.GetMetaType(GetType(<my derived class>)).DataMembers and was able to verify in the debug window that the DocNum property was defined in that MetaType information, and the DeclaringType matched <my derived class>, so I don't know what it's complaining about. Is there any way to make this work? Any explanation what this error is complaining about? I did notice that if I create a property in my derived class that shadows the base class DocNum property, then that property doesn't have the error any more (the next property does). But the point is not to have to re-declare all the properties in all me derived classes again. Why doesn't it pick up the base class' attributes, even though the mapping info makes it look like it did? Tag: Save mix data in database Tag: 142162
 - 8
 - How do I (cleanly) dispose of a row in DataGridView DataError even (Reposted from Winforms forum. Not sure where this belongs.) I'm writing a Winforms project in VB/Dot Net 2.0 and I'm having some trouble handling the DataError event. The grid is bound to a filtered binding source. Add is enabled. Part of the primary key is set by one of the cells in the grid which is in combobox mode. My main concern is duplicate keys. The combobox cell is the only problem. The other row fields are either hidden or easy-to-validate text entry boxes (handled in RowValidating). What I want to do in DataError is give the user the choice of remaining in the row to fix it (e.cancel = true) or just dispose of the changes/additions. If it is an existing row, virtually anything seems to work fine (such as <bindingsource.ResetBindings, or nothing for that matter.) What gives me trouble is a newly added row (I'm even sure 'new' is the right term, but it is newly added. By the time it gets to DataError, the row's IsNewRow property = False). Any attempt to get rid of the new row by any means seems to get me into some sort of infinite loop back to DataError, with errors like 'Index <number> does not have a value'. Am I even trying to handle the error in the right place? Tag: Save mix data in database Tag: 142161
 - 9
 - Inconsistent dat paremeter in query I am using the same code to query different databases, one SQL 2005 and the other SQL 2000. The query contains a date paremeter @Date... Me.SqlSelectCommand1.Parameters.AddRange(New System.Data.SqlClient.SqlParameter() {New System.Data.SqlClient.SqlParameter("@Date", System.Data.SqlDbType.DateTime, 8, "Date")}) The code was written using VS2003 (.Net 1.1) and is now executing on .Net 2.0. SQL Profiler displays the generated query for SQL 2000 as... exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY StartTime', N'@Date datetime', @Date = 'Oct 26 2007 12:00:00:000AM' and the generated query for SQL 2005 as ... exec sp_executesql N'SELECT FunctionID, Name, Date, Description FROM vwTicketedFunctions WHERE (Date >= @Date) AND (OnSaleDate <= @Date) ORDER BY StartTime',N'@Date datetime',@Date=''2007-10-26 00:00:00:000'' Note that the date paremeter formats are different. My problem is that the SQL 2000 query parses Ok but the SQL 2005 generates the error: Line 2: Incorrect syntax near '2007'. Note also that regional setting is English(Australia). Tag: Save mix data in database Tag: 142155
 - 10
 - web service for accessing db? hi, is web service good solution for accesing (havily) database (remote or not)? that looks slow, any other methods for secure connection? SOme of coworkers wants to use web service because they don't want expose connection string. thanks fro advise Tag: Save mix data in database Tag: 142154
 - 11
 - Null Dates in Dataset Using C# 2.0 & SQL Server 2000, have a stored procedure that return 0, 1, or more rows. At least one of the columns is a date and it may null. I have created an XSD of the output from the stored proc. The entry for the nullable date column is "<xs:element name="Sent_Dttm" minOccurs="0" type="xs:dateTime" nillable="true"></xs:element>". I copied the XSD to the C# 2.0 windows app I am developing and it nicely generates a strongly typed dataset. The problem is I get an error when attempting to access this column in the dataset when the value is null: [System.Diagnostics.DebuggerNonUserCodeAttribute()] public System.DateTime Sent_Dttm { get { try { return ((System.DateTime)(this[this.tableOwizCommDoc.Sent_DttmColumn])); } catch (System.InvalidCastException e) { throw new System.Data.StrongTypingException("The value for column \'Sent_Dttm\' in table \'OwizCommDoc\' is DBNull.", e); } } set { this[this.tableOwizCommDoc.Sent_DttmColumn] = value; } } Checking the properties of this field, I noticed that the "NullValue" property has a value of "(throw exception)' Tag: Save mix data in database Tag: 142146
 - 12
 - Jobsite for SALE JOBSITE FOR SALE For Details Contact: Netxure@gmail.com FEATURE LIST Job Seeker Features =B7 This Job site contains Advanced features of Dice and Monster =B7 Search jobs by location, date range, categories, Job type and keywords. =B7 View all jobs posted by a specific employer =B7 Find out how often your resume was viewed by interested employers. =B7 Set up job notification agents to automatically get matching jobs by email everyday. =B7 Submit your resume to any registered employer from your account with one click. =B7 Add Jobs to Inbox for later viewing. =B7 Apply to multiple Jobs with one click. =B7 Post 'Private' resumes =B7 Make resume searchable or unsearchable =B7 Update your profile at any time. =B7 Subscribe/unsubscribe to the mailing list from your account. =B7 Email a specific job to a friend. =B7 Retrieve forgotten passwords by automated email. =B7 Save time with the easy-to-use and clean user interface. Employment Features =B7 Search resumes by date range, geographic location, industry, Job type and keywords. =B7 Advanced Talent Search to find Jobseekers thru skill search. =B7 Role Based / Position Based Search for easy search process =B7 Add, edit and delete jobs from your account on the fly. =B7 Find out how often each posting has been viewed by job seekers. =B7 Build your company profile and upload a company image or logo. =B7 Professional display of job searches and resume details make for easy reading. =B7 Sign-up for multiple resume notification agents to automatically receive matching resumes by email everyday. =B7 Resumes sent to employer are saved in private inbox for viewing at a later time. =B7 Save time with flexible and powerful resume search interface. =B7 Ability to display resume details in a 'printer friendly format' without any images/colors for easy printing. =B7 Ability to easily sign-up online for Memberships, Job packages, job postings or resume database access. =B7 Automatically receive automated emails notifying of expiring jobs or expiring memberships to give the chance to renew online Administration Features =B7 Broadcast e-mails to job seekers and/or employers who signed up for the mailing list. =B7 Add, edit, and delete jobs on the fly. =B7 Add, edit, and delete employers on the fly. =B7 Add, edit, and delete job seekers on the fly. =B7 Add, edit, and delete job categories on the fly. =B7 Print mailing list of job seekers and employers in the database along with their contact information. =B7 Get general statistics summary including the number of registered job seekers, registered employers, pending job orders, active jobs, active resumes in the database and searched keywords and categories statistics. =B7 Control job expiry dates. =B7 Control resumes expiry dates. =B7 Define featured Jobs to be displayed on homepage =B7 Define featured employers to be displayed on homepage, with direct link to employer's job listing. Tag: Save mix data in database Tag: 142143
 - 13
 - Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. I get this error when I try to run a SQL Server Project with a CLR stored Procedure in it. The target DB is SQL Server 2005 and im using VS 2005. I simply create a new SQL Server Project which creates a Test.sql, i then simply added a Stored Procedure to it called the default name StoredProcedure1.cs and put a break point in my simple StoredProcedure1.cs and hit F5 and i got this error: Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Do i need to do something on the server so that I can debug this? Any walk through on how to configure this sql server 2005 to have this RPC so i can debug my CLR stored procedures in this way? e.g. step over, step into, run to cursor etc. Is this CLR debugging feature complete and tested yet? if so is there any walk through on creating simple CLR helloworld in vs2005 and then executing it in sql server 2005 but catching a break point in the StoredProcedure1.CS code? I would like to debug these StoredProcedure1.cs as while sql server executes it is why. so as of now my current error when i try this is: Unable to start TSQL Debugging. Could not attach to SQL Server Process on 'srvname'. The RPC server is unavailable. Tag: Save mix data in database Tag: 142128
 - 14
 - datatable vs custom List<MyClass> Let's say I want a read-only copy of a simple query that joins 2 tables. When I compare a DataTable (adapter.fill) and a custom List + DataReader, I see that the custom sol'n is about 6x faster and takes 5x less memory. For my test I read about 100K rows and then bind to a grid so the timing takes into account both getting the data and binding the data. From profiling the app I see one thing that really stands out - the internal DataTable routine to build the (default?) index takes up most of the time - it clearly is doing linear scans of a red-black tree and the hit count for traversing parts of the tree ending up in the 100's of millions. Can I give the DataTable some hint (via a property) to tell it not to perform this extra work? In the end I may go w/ a custom sol'n but I first want to check if the built in classes can solve my problem. btw, this is .net 2.0, c#, and I'm just setting the datasource w/out any other binding code. thanks, Paul. Tag: Save mix data in database Tag: 142127
 - 15
 - very strange behavior of the method GetChanges(...) from the DataSet class Hello ! i'm using a typed DataSet called myDs. This dataset has 2 Tables, Table1 and Table2. i have created a DataSet like this: myDs dsOld = new myDs(); //here i populate the 2 tables ...... //and then call the method to get the added rows myDs dsNew = (myDs)dsOld.GetChanges(DataRowState.Added); at this point on dsNew i have only the added rows of Table1 instead Table2 is set to null.So, the method returns only the rows of 1 table (Table1). i have debugged the code and i see that the both tables of the dataset dsOld are full of rows that have the rowstate = added. somebody can explain me whats the problem ? it's seem like a bug E. Tag: Save mix data in database Tag: 142122
 - 16
 - Access vs vb.net/ado.net Hi What are the advantages of writing an app in vb.net/ado.net as opposed to MS Access? I need this to sell the idea to the management. Many Thanks Regards Tag: Save mix data in database Tag: 142118
 - 17
 - Why is SQLFreeStmt within the transaction using parameterized inse I am using ODBC.NET to perform mulitple parameterized inserts into a database. The performance has been terrible. Upon research into the ODBC trace log, it appears the a SQLFreeStmt is being executed by ODBC upon every ExecuteNonQuery that I am issuing. This is causing a huge amount of overhead, especially when working with thousands of inserts. When coding against the ODBC API (outside of .NET), I only issue the SQLFreeStmt upon committing the data, and it is very quick (as expected). Of course, I need to figure this out in .NET, as this is our platform. Here is basically what I am doing in .NET: 1) Open OdbcConnection 2) Begin Transaction 3) Create OdbcCommand and assign to transaction 4) Create parameter collection 5) Loop through all records, assign values to parms, and perform parameterized inserts 6) Commit transaction 7) Close transaction. Any ideas on what I can do to stop these SQLFreeStmts from being issued would be greatly appreciated! Thanks in advance!!! Tag: Save mix data in database Tag: 142116
 - 18
 - how to insert record in a dataSet into another database table hi, pls can someone help me out. its very urgent i get the solution today. i have a webservice that i use to retrieve new record from a database, also there is a client application (window form) that calls this service which returns the record in a dataset. now i need to insert the record in this dataset into another database table on a different server.how do i do these.i 've tried so many things and also implement a suggestion on a thread about inserting from one db into another but its not working. am using MySql5.1 community edition,IIS 5.o and Visual studio.Net2003 to develop and test. pls someone help me. i need a simple code to do this. Tag: Save mix data in database Tag: 142115
 - 19
 - how to insert record in a dataset into another database hi, how do i insert a record inside a dataset into another database table on a different server. i use a web service to retrieve the record and store in it into a dataset.i have a client application (a window form) that calls this web service and return the dataset. now i need to insert this record into another database table. am using MySql server and Odbc. pls somebody help me out. i have tried the suggestion on the thead about inserting from one db into another but its not working. Tag: Save mix data in database Tag: 142114
 - 20
 - Copy database schema from Access to SQL Server Hi all, I'm trying to write an application that takes an Access database as template to customize a new or existing SQL Server database. When something in the template database is changed, I want to apply these changes to the SQL database. For example if new columns are added to a table or constraints are changed, the application parses each Access table and relation and whatever and applies this to the SQL Server database. The data in the tables is irrelevant, only the schema is important. I have to apply default values, check contraints (I think it's validation rules in Access), maximum column lengths, ... How can I accomplish this? Do I have to loop through the Access tables and relations and create a DDL SQL statement for each? What if the column/contraint already existed? Seems complicated, maybe there is an easier solution. I'm using Visual Studio 2005 and C# 2.0, so this should be the way to go. Thanks in advance. Regards, Hannes Tag: Save mix data in database Tag: 142102
 - 21
 - Memory keeps creaping up...why? This is a multi-part message in MIME format. ------=_NextPart_000_0006_01C8155A.951AF170 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I have a simple subroutine (see below) which reads a table and populates = the items of a combobox. As the subroutine is executed, I'm watching = the taskmanager and the memory in use increases; however, once I get to = the Error_Exit: logic and start to close and dispose my memory = variables, the memory is not released and does not decrease in the task = manager. Why is that? Eventually, my program is giving me = "Insufficient memory" errors. *************************************************************************= *************** On Error GoTo Error_Handling Dim cnn As New Odbc.OdbcConnection Dim cmd As New Odbc.OdbcCommand Dim rdr As Odbc.OdbcDataReader cnn.ConnectionString =3D "dsn=3D" & accpac_companyid cnn.Open() cmd.Connection =3D cnn cmd.CommandText =3D "select schedkey, scheddesc from cssktb order by = schedkey" rdr =3D cmd.ExecuteReader Do While rdr.Read combo.Items.Add(rdr("schedkey").ToString.Trim) Loop Error_Exit: If Not IsNothing(rdr) Then rdr.Close() cmd.Connection.Close() cmd.Dispose() cnn.Close() cnn.Dispose() End If rdr =3D Nothing cmd =3D Nothing cnn =3D Nothing Exit Sub Error_Handling: Select Case Err.Number Case Else MsgBox("The following error occured in LoadSchedules()" & vbCrLf = & Err.Description) End Select Resume Error_Exit ------=_NextPart_000_0006_01C8155A.951AF170 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.6000.16544" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> I have a simple subroutine (see = below) which=20 reads a table and populates the items of a combobox.  As the = subroutine is=20 executed, I'm watching the taskmanager and the memory in use increases; = however,=20 once I get to the Error_Exit: logic and start to close and dispose my = memory=20 variables, the memory is not released and does not decrease in the task=20 manager.  Why is that?  Eventually, my program is giving me=20 "Insufficient memory" errors. ****************************************************************= ************************ On Error GoTo Error_Handling Dim cnn As New = Odbc.OdbcConnection <FONT=20 face=3DArial size=3D2>Dim cmd As New Odbc.OdbcCommand Dim rdr As Odbc.OdbcDataReader cnn.ConnectionString =3D "dsn=3D" &=20 accpac_companyid cnn.Open() <FONT=20 face=3DArial size=3D2>cmd.Connection =3D cnn cmd.CommandText =3D "select schedkey, scheddesc from cssktb = order by=20 schedkey" rdr =3D = cmd.ExecuteReader Do While rdr.Read    =20 combo.Items.Add(rdr("schedkey").ToString.Trim) Loop Error_Exit:     If Not IsNothing(rdr) Then         = rdr.Close() <FONT=20 face=3DArial size=3D2>       =20 cmd.Connection.Close()    =20     cmd.Dispose()         = cnn.Close() <FONT=20 face=3DArial size=3D2>       =20 cnn.Dispose()     = End=20 If     rdr =3D = Nothing <FONT=20 face=3DArial size=3D2>    cmd =3D Nothing     cnn =3D Nothing Exit=20 Sub Error_Handling:     Select Case Err.Number     Case Else         MsgBox("The following = error occured=20 in LoadSchedules()" & vbCrLf & Err.Description) <FONT=20 face=3DArial size=3D2>    End Select Resume = Error_Exit</DIV></BODY></HTML> ------=_NextPart_000_0006_01C8155A.951AF170-- Tag: Save mix data in database Tag: 142100
 - 22
 - Sybase AsaClient and DbProviderFactories Hello all, My team is trying to use the iAnywhere.Sybase.Asaclient (middle part might be spelled incorrect) in our C# project with a DbProviderFactory class to generate new code. However when we try to create a new factory with DbProviderFactory factory = DbProviderFactories.GetFactory("iAnywhere.Sybase.Asaclient). This returns an ArgumentException to us. Is there something special we need to install or do to be able to use Asaclient objects with the ADO.NET factories? Thanks in advance Tag: Save mix data in database Tag: 142096
 - 23
 - Decimal data type wont work! I have a SQL Express db with a table field defined as data type decimal(18,0). When I type in .785 in the table field it rounds it to 1. Any ideas why???? Tag: Save mix data in database Tag: 142093
 - 24
 - Question about finding records using Stored Procedures I have a table called Customer. I have a locator screen which is composed of a grid and a couple of search boxes. The user is going to choose which customer records to display in the grid. The choices are LastName or firstName or any part of them, Social Security Number, Status (Active,Inactive, etc.) and office. Now the user can choose to find all customers who are active and from a certain office or they could find all the customers whose last name starts with S and is active and from a particular office. In the past, I looked at each search field and built a where clause which was then passed to a select statement to retrieve the correct records. I am not happy doing this and want to switch to stored procedures. When the user clicks the 'Find' button after filling in some search fields, I will create an empty customer object and fill in the fields that are in the search screen and this past this object to the server. On the server, I will parse the object and figure out which fields have values in them meaning that they are to be part of the search critieria. Once I have done that, then I will call the appropriate Find method for the cusotmer. That is my dilemma. Do I have the followng in my code? FindCustomerBySocSecNo(string socsecno) FindCustomerByLastName(string lastname) FindCustomerByOffice(string office) FindCustomerByStatus(string status) FindCustomerByStatusAndOffice(string office,string status) FindCustomerByLastNameStatusAndOffice() etc. etc. etc. This seems like a lot of work to do. Bill Tag: Save mix data in database Tag: 142091
 - 25
 - Question about SUM query I have a "transaction" table with 2 columns, TransTypeId and TransAmt. Example: TransTypeId TransAmt A 100 A 200 B 100 C 50 B 100 A 100 I am trying to do a SUM of all the TransTypeId A and B. The result should be 600. I WANT TO GET ONLY THIS 1 VALUE BACK. But, the result of the query is returning... A 400 B 200 It's not summing it as a "group", but per "TransTypeId". Any ideas why? Here's the raw query... ( SELECT SUM(Transactions.TransAmt) AS Expr1, Enroll.ProgramId, Enroll.EnrollId FROM Transactions INNER JOIN Enroll ON Transactions.EnrollId = Enroll.EnrollId GROUP BY Enroll.ProgramId, Enroll.EnrollId, Transactions.TransTypeId HAVING (Enroll.ProgramId = @ProgramId) AND (Enroll.EnrollId = @EnrollId) AND (Transactions.TransTypeId = 1 OR Transactions.TransTypeId = 2 OR Transactions.TransTypeId = 3) Thanks! Tag: Save mix data in database Tag: 142087
- Next
 - 1
 - i have a problem . please help me Hello, I am writing ASP.NET application using SQL Server 2005 Express Edition. my connection string is : "Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\DB.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"; I used connection strings syntax from www.connectionstrings.com. this app work in IIS very well but when i upload it on the host i reiceve this error : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) please help me if you can ? *** Sent via Developersdex http://www.developersdex.com *** Tag: Save mix data in database Tag: 142083
 - 2
 - How sluggish is a big xml file in combination with datasets? Hello, I am currently working on a project which will run in an environment, where the size of the database is very limited. That's why I thought about relying in some parts entirely on xml files (and datasets) as an DB replacement. I.E.: DataSet myDataSetToRead = new DataSet(); myDataSetToRead.ReadXmlSchema("c:\\abcd.xsd"); myDataSetToRead.ReadXml("c:\\abc.xml"); dostuff with the dataset data etc. Now, I will doing this only for the little used parts application, where maybe 5 users at once will use it. I know that this approach is slow compared to a real DB, but, what are the other limitations? Is there a size limit? I mean, will it somehow break after the file reaches 50 MB? And how much slower will it be, compared to a DB? 10 times slower? More? Tag: Save mix data in database Tag: 142079
 - 3
 - Install SQL Server 2005 Express With ClickOnce? Is it possible to install SQL Server 2005 Express on a machine that restricts installs by using ClickOnce? For example, I can't install new applications on my machine at work unless I use ClickOnce to do so. I want to be able to use SQL Server 2005 Express in my applications and move away from MS Access. Tag: Save mix data in database Tag: 142078
 - 4
 - Ajax enabled page Oct 20, 2007 01:00pm Hi all When you create an Ajax enabled web site, the application creates the default page with a "Script Manager". I created a Master Page. I then created a "Home" page with reference to this master page. As I wanted this Home Page to come first I added the following code to the default page Server.Transfer("Home.aspx", True) My questions are: 1. To ensure that Microsoft Ajax toolkit works, does the default page with the "Script Manager" has to be the first page. 2. Can I give the reference of the Master Page on the "Default Page" so that I get the template I require. Then the "Default Page" can be my first page. Thank you in advance. Mike TI Tag: Save mix data in database Tag: 142074
 - 5
 - Obtaining column properties in .NET Hi all, I want to obtain column properties using C# and the System.Data namespace. Using DbDataReader.GetSchemaTable() or DataAdapter.Columns I only retrieve properties like DataColumn.MaxLength or DataColumn.AllowDbNull in a correct fashion. But if I want properties like DefaultValue or certain column validation rules, I fail. Does anyone know how to obtain these values? If so, please post some sample code or links. Thank you very much in advance. Regards, Hannes Tag: Save mix data in database Tag: 142059
 - 6
 - HP Desktop for sale! Hi, I have an unused HP Pavilion with the fallowing specs: # Processor: AMD Athlon 64 X2 4000+ (2.1GHz, 2000MT/s System Bus) # Memory: 2048MB PC2-5300 DDR2 SDRAM memory (2x1GB) (expandable to 8 GB (4 x 2 GB) (64-bit OS)/ 4 GB (4 x 1 GB) (32-bit OS)) # Hard Drive:320GB 7200RPM SATA 3G (3.0 Gb/sec) hard drive # Optical Drive: 16X DVD(+/-)R/RW 12X RAM (+/-)R DL LightScribe SATA drive # Expandable Drive Bay: HP Pocket Media Drive bay # Video Graphics: Integrated graphics # Network Interface: Integrated 10/100BaseT network interface # Sound: High Definition 8-channel audio # Fax/Modem: 56K bps data/fax modem # Operating System: Genuine Windows Vista® Home Premium This is "used" but basically brand new (it has literally been on for no more than 6 total hours..) is only 1 month old.. PRICE: $425 OBO Email- pbdude911@yahoo.com Tag: Save mix data in database Tag: 142050
 - 7
 - Fatloss computer program I have been using this computer program for a couple weeks now and i am very pleased with the results so far. its a software fatloss program, if your looking for a diet/weightloss plan i reccomend you check this place out first: http://fatloss9.50webs.com Tag: Save mix data in database Tag: 142048
 - 8
 - Watch NFL Games Online Watch NFL Games Online! For every one who wants to watch the games online because they dont live in the teams town or are at work i found a site that has basically every game covered. Its perfect if you have afford a monthly $70 direct tv nfl access subscription. they got a bunch of channels The sites http://nflonline.wizhoo.com Tag: Save mix data in database Tag: 142047
 - 9
 - ReadXML error I'm using DataSet.ReadXML method to populate the dataset with data from XML file. If one of the values contains apostrophe (for instance: It's something) then an error occures: System.Xml.XmlException: Invalid character in the given encoding. Is this a bug or what? I wouldn't want to parse an XML created by another program which is using the same ADO.NET for creating the file. On that side apostrophe is allowed. Thank you vovan Tag: Save mix data in database Tag: 142046
 - 10
 - vs 20028 when?? Hi When is vs2008 due out? Many Thanks Regards Tag: Save mix data in database Tag: 142040
 - 11
 - Reading a XLS file with a embeded combo Hi, I=B4m trying to read a xls file which one colum has a combo to select the value. The value is linked to the cell below the combo, however in certain columns the ado.net returns null value instead of the value selected. Is there anything I=B4m missing? I remember the bug in ADO when reading columns with multiple formats. Thanks, Ezequiel Naftali Tag: Save mix data in database Tag: 142039
 - 12
 - Data Type 'Image' is missing from the development environment for Please disregard my previous post for the same problem. the posting was incomplete. I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the following message. "@p5 : Byte array truncation to a length of 8000." Parameter corresponds to the image field. In the parameter, it is displayed as a Binary. However, I cannot see the type 'Image' in the list of data types. -- test Tag: Save mix data in database Tag: 142037
 - 13
 - ComboBox loads slow I am noticing that it seems to take windows a long ass time to paint a ComboBox control that has say, 32000 items in its dropdown. Yes, I know that's a lot. However, I have a VB6.0 application that uses DAO to access an Access database, and it can load up a 32000 item combobox in a fraction of the time it takes .net 2.0. Why is this? Also, it seems like setting the .DataSource property takes a while, but the bulk of the wait time is when the control gets drawn on the screen. Tag: Save mix data in database Tag: 142030
 - 14
 - Filtering DataSet with Multiple Tables I have a DataSet with 3 tables. I need to be able to filter the parent table and get all records from the 3rd level table that correspond with it. I have relations set up between the parent and first child and also the first child and it's child tables. However, when I filter the top level table, it doesn't appear to filter the other tables. How can I do this? Tag: Save mix data in database Tag: 142029
 - 15
 - How do I merge tables in ado.net Hi, I'm fairly new to ado.net and I'm not sure I'm doing this in the best way... I retrieve two tables from two different databases and place them in a dataset. Both tables have a column which relates them. The relation type is one to many. I use a custom procedure to "merge" the two tables into a third before I display the third table in a datagrid. The procedure creates a new table and iterates through the two tables using a relation object and GetChildRows. Is this how it should be done or is there a built in function that can do the work for me? Regards Pete Tag: Save mix data in database Tag: 142027
 - 16
 - QueriesTableAdapter does not appear in toolbox. Why not? I created a stored procedure called AddOrder which does an 'insert' statement. It appeared in the Server Explorer of Visual Studio. Then I dragged it to the Dataset Designer. This makes a QueriesTableAdapter, which I do find in the diagram when I "Edit Dataset in Designer". The problem is that this QueriesTableAdapter does not appear in the ToolBox, so I cannot drag it on to forms. Is there any reason why it doesn't show up in the toolbox? Is there some way to drag it to the form? Thanks, HA Tag: Save mix data in database Tag: 142018
 - 17
 - SQLBulkCopyOptions with Default values Hello. I'm changing my code which copies data from memory to a SQL Server from using a data adapter's update method to using the writeToServer method of the SQLBulkCopy object. The update method of the data adapter worked fine, but I expect the SQLBulkCopy to perform better. The problem is I'm getting an error message that one of the fields doesn't allow null values. With the data adapter, I didn't explicitly have to set the fields to anything, as the fields have a default value of zero defined on the server. I'm using the SQLBulkCopyOption KeepIdentity and even tried using (Not SqlBulkCopyOptions.KeepNulls), but still get the error. Does SQLBulkCopy not recognize default values unless the field value is explicitly set to null? That's the next thing I'm going to try, and if it doesn't work, I'm going back to using the data adapter. Thanks for any information you can provide. Tag: Save mix data in database Tag: 142012
 - 18
 - dbType 'Image' not available in the data adaptor window for CE How come there is no dbType='Image' available in the data adaptor parameter types? Please find the atta -- test Tag: Save mix data in database Tag: 142011
 - 19
 - Cross network Access db connection problem Hi I wonder if you can help me. I've got an asp.net (version 1.1) intranet application that connects across a network to an access backend db. The backend db is on a directory where everyone (including the ASP.Net account) has full access (not sure if that's the right way to go about things but it works). However my application now needs access to some information from another network access db, which is on a directory where everyone (including the ASP.Net account) has read & execute rights. When I try and open a connection I get the "you can't do this because the db is already opened exclusively by another user" message. I can't, and don't want to, change the directory rights to the second db and it's in constant use so I can't kick people out. Is there any way around this? Thanks for your help in advance. Tag: Save mix data in database Tag: 142008
 - 20
 - adapter.Update question ?? Dear all, I have an application sQL statement which call an SQL view. The return dataset from the View is bind to a WinForm datagriview control. From this datcontrol, data can be edited and updated. What I woul like to get is that this modification goes back to the View at SQL server side which will then update proper table. The call method which will get that modification back is done as follow : =====> public static Boolean UpdateAlarm(string ConnectionString,DataSet dsSource) { //Connection definition using (SqlConnection sqlConnection = new SqlConnection(ConnectionString)) { // Request Definition using (SqlCommand sqlcommand = new SqlCommand()) { sqlcommand.Connection = sqlConnection; sqlcommand.CommandType = System.Data.CommandType.Text; sqlcommand.CommandText = "Select * from v_Current_Alarm"; try { sqlConnection.Open(); SqlDataAdapter adapter = new SqlDataAdapter(sqlcommand); adapter.Update(dsSource,dsSource.Tables[0].TableName); sqlConnection.Close(); } <=== What is strange from that is that if I Watch the dsSource object, modification are seen inside Rows.ItemArray, but the RowsState is set to "Unchanged" Then my Update function of Adapter seems to not modiy anything on the back end database. Any ideas what I do wrong ? regards serge Tag: Save mix data in database Tag: 142006
 - 21
 - Stored procedure name in config file? Hi all, I'm building a Web Service to INSERT records into an Oracle DB. For this I'm using a DataSet (.xsd) with a QueriesTableAdapter, to call a stored procedure for inserts in the Oracle DB. The connection string is stored in a configuration file (Web.Config) like so: <connectionStrings> <add name="conn_oracle" connectionString="Provider=MSDAORA;Data Source=mydb;Password=mypwd;User ID=myuser" providerName="System.Data.OleDb" /> </connectionStrings> The name of the stored procedure is set in a wizard when you create the QueriesTableAdapter and it's then stored in the CommandText property. I would like to make this name configurable by storing in the configuration file too, like so: <appSettings> <add key="insert_command" value="myInsertStoredProcedureName"/> </appSettings> Is a there a way to get this value at run-time and use it in the query? Gustaf Tag: Save mix data in database Tag: 142003
 - 22
 - Timeout expired on Insert Hi, We have a huge table having around 29579242 Rows.The table is huge and there is no clustered index on the table. There are a couple of non-clustered indexes. We have started experiencing these errors. We increased the command timeout to 120 (2 minutes) but the error isstill occuring on Insert. Data is being inserted 1 row at a time and is not transactional. Any ideas? Thanks Sandhya With the Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) Tag: Save mix data in database Tag: 141997
 - 23
 - How to Provide Unique Key Values During DataContext.SubmitChanges I am using Visual Studio 2008 Beta 2 and investigating various aspects of LINQ. I used the LINQ to SQL designer to derive a new DataContext class with some entity classes, and am overriding the behavior of SubmitChanges and implementing the Insert partial method for a particular entity class's insert operation. I'm doing this because I'm dealing with a black-box SDK that updates data in the database according to its own business rules, but I'd like to be able to access this SDK via LINQ. So I've constructed entity classes in the designer based on the tables accessed by the SDK, and am only going through the SDK on updates and inserts. The problem is, this SDK is not row-based. It does not update the database until an object and all its children have been provided (which is important when inserting a write-once object). The data does, however, have the notion of a primary key (as do the SQL tables underlying the data). So DataContext wants values in there after every insert I guess. My first question is, if I don't call ExecuteDynamicInsert and instead perform the update through the SDK, how to I provide a unique key value back to the DataContext? Right now, if I add multiple rows in a single SubmitChanges operation, I receive an exception: System.Data.Linq.DuplicateKeyException I assume this is because the primary key values in the entity class instances were left as null and I see no way to fill them in from the derived DataContext methods (the primary key property is read-only, and the internal storage for the property is private). My next question is, is there a way to implement a system where the primary key values are not known until all the Insert and Update operations are complete (at the end of SubmitChanges). Right now the error is happening as soon as the second Insert operation completes (the first duplicate empty key is noticed). I have considered implementing some entity class partial method like OnValidate to provide a dummy unique key in there (by directly setting the private member variable), then at the end of SubmitChanges, turning off ObjectTrackingEnabled and providing the actual key values, but I suspect the framework won't like me changing ObjectTrackingEnabled after the initial query. Tag: Save mix data in database Tag: 141996
 - 24
 - stored procedure times out after 10 minutes Hello. Can anyone help with this one? I've written an app that queries data on two linked servers (sql server 2000). The stored procedure runs fine when I 'exec' it in management studio, but it times out when launched from VB2005. The funny thing is it worked last week - I'm just not sure what has changed since then. Here's (some of) my vb source Dim Conn As New System.Data.SqlClient.SqlConnection(My.Settings.ModelstockConnString) Dim Cmd As New System.Data.SqlClient.SqlCommand Dim sqlstr As String Cmd.CommandTimeout = 600 Cmd.CommandType = Data.CommandType.Text Conn.Open() Cmd.Connection = Conn Dim dr As System.Data.SqlClient.SqlDataReader = Nothing Dim dtms As New System.Data.DataTable sqlstr = "exec MWLBringToModelstockQuery '" & DataGridView1.Rows(0).Cells("cCustNo").ToString.Trim & "'" Cmd.CommandText = sqlstr dtms.Load(Cmd.ExecuteReader) Here's my connection string Data Source=TESTSERVER;Initial Catalog=TESTDB;Integrated Security=True Here's my SP: set ANSI_NULLS ON set QUOTED_IDENTIFIER ON go ALTER procedure [dbo].[MWLBringToModelstockQuery] ( @custno nchar(10), @itemno nchar(20) = '', @storeno nchar(10) = '' ) as Tag: Save mix data in database Tag: 141991
 - 25
 - "@p5 : Byte array truncation to a length of 8000." I'm trying to update the data in a DataGridView control. The underlying data are from SQL Server CE database. There is an image field in the DataGridView control when U give the save command, I get the following message. "@p5 : Byte array truncation to a length of 8000." Parameter corresponds to the image field. In the parameter, it is displayed as a Binary. -- test Tag: Save mix data in database Tag: 141989

Hi EveryBody:

What is the data type that I have to use when I want to save mix data in
database for example photos,music,text fiel,doc file and movies ?

any help will be appreciated regard's

Husam

Top

Re: Save mix data in database by Morten

Morten
Sun Oct 28 09:06:49 PDT 2007

Hi Husam,

Use the 'image' datatype. Image is a binary datatype capable of holding up to 2Gb of data

On Sun, 28 Oct 2007 06:43:00 +0100, Husam <Husam@discussions.microsoft.com> wrote:

> Hi EveryBody:
>
> What is the data type that I have to use when I want to save mix data in
> database for example photos,music,text fiel,doc file and movies ?
>
> any help will be appreciated regard's
>
> Husam
>

--
Happy coding!
Morten Wennevik [C# MVP]

Top

Re: Save mix data in database by William

William
Mon Oct 29 10:18:27 PDT 2007

None of the above should be stored in the database IMHO--not until SQL
Server 2008 that introduces the FileStream datatype. For reasons to lengthy
to list here, putting BLOBs in the database (no matter how well SQL Server
handles them) leads to too many other issues to justify their inclusion.

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant, Dad, Grandpa
Microsoft MVP
INETA Speaker
www.betav.com
www.betav.com/blog/billva
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
-----------------------------------------------------------------------------------------------------------------------

"Husam" <Husam@discussions.microsoft.com> wrote in message
news:575A099F-03BE-4721-94B6-9476AE9DCD3F@microsoft.com...
> Hi EveryBody:
>
> What is the data type that I have to use when I want to save mix data in
> database for example photos,music,text fiel,doc file and movies ?
>
> any help will be appreciated regard's
>
> Husam

Top