Store and retrieve an array of double into image field(sql server)

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
    - How to do a simple update command with ado.net? I am trying to execute a simple SQL Update command on an Access database. I have an OleDBConnection (gDatabaseConn) that has successfully been executing select commands, but I cannot get an update command to work. Here is the code in question: Dim cmdUpdate As New OleDb.OleDbCommand("", gDatabaseConn) sSQL = "UPDATE NoteTable SET AcctID = '" & Account.sAcctID sSQL = sSQL & "' WHERE AcctNo = '" & Account.sAccountNo & "'" cmdUpdate.CommandText = sSQL cmdUpdate.ExecuteNonQuery() The call to ExecuteNonQuery throws an exception with the message "No value given for one or more required parameters". Both of the variables used in the string have values. Is ADO.NET capable of running a simple SQL command like this, or do I need to investigate OleDBParameter objects? This way would be preferrable, since I am not using DataTables or DataRows. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114912
  - 2
    - New column added to old table causes ORA-00904 I added a new column to an old table, and any time I try to add it to a select, I get an ORA-00904 error. I'm using the MS OracleDataProvider for DotNet, and Oracle 9.2.0.4.0. Experimenting has proven that any new column on any table produces the same error. I have renamed the column, dropped and re-added, and tried various simple names and a variety of datatypes. Has anyone else ever seen this problem? Tag: Store and retrieve an array of double into image field(sql server) Tag: 114911
  - 3
    - dataset sort I want to use two SQL statements: Dim strSQLLCMR As String = "SELECT DTG, POO FROM LCMR WHERE (Confirmed = true and Friendly = False) ORDER BY DTG" Dim strSQLQ36 As String = "SELECT DTG, POO FROM Q36 WHERE (Confirmed = true and Friendly = False) ORDER BY DTG" to fill one table in a dataset. Then I want to sort that dataset by the field DTG. Is this possible? The reason for this is that I then want to loop through the table and determine records that have a Date/Time group (DTG) within 5 minutes of each other. Any suggestions welcome. Thanks, Thomas -- Posted via NewsDemon.com - Premium Uncensored Newsgroup Service ------->>>>>>http://www.NewsDemon.com<<<<<<------ Unlimited Access, Anonymous Accounts, Uncensored Broadband Access Tag: Store and retrieve an array of double into image field(sql server) Tag: 114889
  - 4
    - Problems with array<Byte>^ Hi everyone! I was playing a little with VC++ 2005 Express for evaluation purposes (and out of curiosity) when I stumbled over some problems. I have a set of binary data in a postgresql-table. I managed to insert the data via the npgsql-data-provider. I can also read string and numeric values, but when it comes to reading the data out of the db and writing it to disk I fail. I tried the following (I did this on another computer and type from mind here so don't bother typos plz): String^ statement = "SELECT data FROM jpegimages WHERE \"ID\" = " + Convert::ToString(newObject->GetID()) + ";"; NpgsqlCommand^ command = gcnew NpgsqlCommand(statement, this->conn); NpgsqlDataReader^ reader = command->ExecuteReader(); // I know there is only one row... reader->Read(); if (reader[0] != IntPrt::Zero) { array<Byte>^ bytes = (array<Byte>^)(reader[0]); bufferedWriter->Write(bytes); ... The code compiles without errors but when it is run I get "Cast not valid" Exceptions at the "array<Bytes.."-line. There isn't much info in the help about stuff like this. The docs for the postgres-data-provider are written against c# (which I didn't intent to use in this special case) where one can use a simple "byte[]"-construct. Any help is highly appreicated. regards... ...Dennis Tag: Store and retrieve an array of double into image field(sql server) Tag: 114885
  - 5
    - ADO.net book, resources Hello All, I am new to ADO.net and C#, I have been trying to understand both but having problems. Can anyone please guide me to a good ADO.net book using C# that I can buy, I have checked books on Amazon but have not been able to make a decision as to which one should I buy. In addition a good online resource that I should use to work with ADO.net would be great, for now although there are lot of resources, but have not been able to find one that I can get most of the information from, generally have to search for each thing on Google and then spend hours to find answer to something simple as declaring a null column in the prepared statement. Thanks a lot. Imran. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114813
  - 6
    - parameter not supplied error , using parameters.add Hello All, I have a table with few fields that allow null, I use the following code to add entries strQuery = "insert into tblChannelItems (nChannelID,sItemTitle,sItemLink,sItemDesc,sItemAuthor,sItemCategory,sItemComments,sItemEnclosure,sItemPubDate) values (@nChannelID,@sItemTitle,@sItemLink,@sItemDesc,@sItemAuthor,@sItemCategory,@sItemComments,@sItemEnclosure,@sItemPubDate);"; strQuery = strQuery + " SELECT nItemID from tblChannelItems where nItemID=SCOPE_IDENTITY();"; SqlCommand objCmd = new SqlCommand(strQuery, this.conn); SqlParameter nChannelID = objCmd.Parameters.Add("@nChannelID", SqlDbType.Int); SqlParameter sItemTitle = objCmd.Parameters.Add("@sItemTitle", SqlDbType.NVarChar); SqlParameter sItemLink = objCmd.Parameters.Add("@sItemLink", SqlDbType.NVarChar); SqlParameter sItemDesc = objCmd.Parameters.Add("@sItemDesc", SqlDbType.Text); SqlParameter sItemAuthor = objCmd.Parameters.Add("@sItemAuthor", SqlDbType.NVarChar); SqlParameter sItemCategory = objCmd.Parameters.Add("@sItemCategory", SqlDbType.NVarChar); SqlParameter sItemComments = objCmd.Parameters.Add("@sItemComments", SqlDbType.NVarChar); SqlParameter sItemEnclosure = objCmd.Parameters.Add("@sItemEnclosure", SqlDbType.NVarChar); SqlParameter sItemPubDate = objCmd.Parameters.Add("@sItemPubDate", SqlDbType.DateTime); nChannelID.Value = objStItem.nChannelID; sItemTitle.Value = objStItem.sItemTitle; sItemLink.Value = objStItem.sItemLink; sItemDesc.Value = objStItem.sItemDesc; sItemAuthor.Value = objStItem.sItemAuthor; sItemCategory.Value = objStItem.sItemCategory; sItemComments.Value = objStItem.sItemComments; sItemEnclosure.Value = objStItem.sItemEnclosure; sItemPubDate.Value = objStItem.sItemPubDate; nItemID = (int)objCmd.ExecuteScalar(); but I get the error of {"Prepared statement '(@nChannelID int,@sItemTitle nvarchar(33),@sItemLink nvarchar(50' expects parameter @sItemAuthor, which was not supplied."} Seems although the author column is optional but still somehow since I dont specify the parameters as optional in my prepared statement so I get this error, can anyone please guide me how I can set these parameters as optional , so I dont get this error? Imran. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114793
  - 7
    - Controlling a primary key column Hello: I have an application with a data base. i insert information by the application in the data base, and i have to control that the user doesn't give a value for the primary key column that already exists. I would want to know what happens in that case, when you try to insert a new row in the table with a value for the primary key that already exists, an exception is raised? nothing happens? it happens an updated? Thanks for the help. Bye. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114768
  - 8
    - ADODB.DLL - Error Object Reference not set to an instance of an object Hello, I have the following problem on certain servers, when trying to access ADO objects I get the following error message 'Object Reference not set to an instance of an object', on certain servers ADODB.DLL is in the GAC and on other servers its in the application folder. On certain server it works when installed in the application folder, and on ther servers it does not, if I install it in the GAC then it works, why does this happen? I've seen the following artcles KB321688 KB810098 Please can some explain why it works on some servers when not installed in the GAC. Thanks, Tag: Store and retrieve an array of double into image field(sql server) Tag: 114691
  - 9
    - Bulk insert Hi, I need to insert nearly more than 6000 records in a single shot. For that I need to get the data from tree view (windows app) control, Im reading through recursive mannner to get parent & childs and im forming an xml file then sending to backend. here to compose the xml file from tree view control it is taking 25 secs time and at back end I returned and Stored procedure for bulk insert. Create PROC insertversion ( @VersionData ntext ,@Update bit ) AS DECLARE @hDoc int EXEC sp_xml_preparedocument @hDoc OUTPUT,@VersionData IF @Update = 1 BEGIN INSERT INTO Version_Map (version_id, question_id, parent_question_id, disp_sequence_nbr, created_by, created_date, updated_by, updated_date) SELECT * FROM OPENXML(@hDoc, 'ROOT/QUESTIONS/QUESTION',1) WITH ( VERSION_ID int , QUESTION_ID INT, PARENT_QUESTION_ID int, SEQNO int, created_by varchar(20), created_date datetime, updated_by varchar(20), updated_date datetime) XMLVersion END ELSE BEGIN INSERT INTO Version_Map (version_id, question_id, parent_question_id, disp_sequence_nbr, created_by, created_date) SELECT * FROM OPENXML(@hDoc, 'ROOT/QUESTIONS/QUESTION',1) WITH ( VERSION_ID int , QUESTION_ID INT, PARENT_QUESTION_ID int, SEQNO int, created_by varchar(20), created_date datetime) XMLVersion END EXEC sp_xml_removedocument @hDoc GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO Here Im using the OpenXml method... for bulk insert this is taking 50 secs.. Total insert opration it is taking 84 secs to do this operation... but Im looking a solution to this operation with in 10 secs.. plz help me .... thanks .... Tag: Store and retrieve an array of double into image field(sql server) Tag: 114681
  - 10
    - Incorrect syntax near the keyword 'DEFAULT' Hello Experts! I am attempting to use the OleDbCommand.ExecuteScaler() function within my ASP.NET C# web page to perform a simple validation, but receive the following error: "Incorrect syntax near the keyword 'DEFAULT'" The form has 2 fields on it, called tb_username and tb_password. (see code snippet below). The SQL Server table is called _users and has a number of columns, 2 of which I am reading: username and password. I've searched the net for any clues on this but so far none of the items I've found were relavent to what I was doing. Can anyone shed any light on this? Many thanks! === here is my code ==== private bool ValidateLogin() { // set the connection string oleDbConnection_login.ConnectionString = C_Constants.g_sDSN; // add parameters to the query oleDbCommand_login.Parameters.Add("@user",System.Data.OleDb.OleDbType.VarWChar,25,tb_username.Text); oleDbCommand_login.Parameters.Add("@pass",System.Data.OleDb.OleDbType.VarWChar,25,tb_password.Text); oleDbCommand_login.CommandText = "Select username from _users whereusername=? AND password=?"; // open the connection oleDbConnection_login.Open(); // execute the query oleDbCommand_login.Connection = oleDbConnection_login; object objResults = oleDbCommand_login.ExecuteScalar(); <--- errormessage occurs here // close the connection oleDbConnection_login.Close(); if (objResults==null) { return false; } return true;} Tag: Store and retrieve an array of double into image field(sql server) Tag: 114675
  - 11
    - Distinct Values from a Datatable guys, Has anyone tried this before? i have a dataset and rather than doing an addtional trip to the server with a DISTINCT sql query - i'd like to just loop thru the existing dataset in memory. i assign that dataset (ds) to a datatable, declare a datarow and then use the select property to get the distinct employee id. i keep getting "Syntax error: Missing operand after 'EmplId' operator." and i've pretty much been out on the web looking for a solution to this. any help is appreciated. snippet of the code is below. thanks rik Dim oTable As DataTable = ds.Tables(0) Dim myRow As DataRow For Each myRow In oTable.Select("DISTINCT EmplId") cboEmplList2.Items.Add(myRow.Item(0)) Next ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources... Tag: Store and retrieve an array of double into image field(sql server) Tag: 114666
  - 12
    - Saving a dataview to a new dataset in C# Hi, I am hoping I can get some help with a small problem I have run into using C#. U have an XML file that I load into a Dataset and then display this in a Datagrid. No problems doing this at all. I then use a Dataview to filter this view using a keyword and I have no problems with this either. What I would like to do is to save this Dataview to a new Dataset so I can save the reslts to a new file but here is where I am having the problem. A Dataview is typically not written back to a Dataset so I'm not sure what would be the best way to do this. I found a code snippet after looking for a day but I have errors with it and I do not know why. I have created my main Dataset called 'ds' and after filtering it and displaying it I clone 'ds' to a new Dataset and then try to import the rows back into my new data set. The code I am using to do this is posted below.... //*************************************************** DataSet ds2 = ds.Clone(); for(int iTable = 0; iTable < ds.Tables.Count; iTable++) { for(int iRow = 0; iRow < ds.Tables[iTable].DefaultView.Count; Row++) { ds2.Tables[iTable].ImportRow(ds.Tables[iTable].DefaultView[iRow].Row); } } ds2.WriteXml(@"c:\data.xml"); //************************************************* My problem comes in on the this line... for(int iRow = 0; iRow < ds.Tables[iTable].DefaultView.Count; iRow++) The error that is displayed is as follows.... "An unhandled exception of type 'System.Data.InvalidConstraintException' occurred in system.data.dll Additional information: ForeignKeyConstraint Computer_ComputerHardware requires the child key values (3) to exist in the parent table." On this part of the code three matches are found & displayed so I'm not sure if it is important. The error occurs on the 'iRow++' part pf the statement but I don't know why. I can't set breakpoints in C# nor can I see where the error is because I can't step through the code. Any idea of this would happen? I'm really stumped on this, below is a snippet of my XML document so you know what I am using in this code. Thanks for any help, Dennis //***************************************** <Office_Inventory> <Computer> <RoomNumber>G2017</RoomNumber> <ComputerNumber>G201701</ComputerNumber> <InServiceDate>2003-03-15</InServiceDate> <ComputerHardware> <Printer>HP DeskJet 500</Printer> <Scanner>HP Scan 100</Scanner> <CD-DVD>40X CD-ROM</CD-DVD> <Monitor>Acer 67L</Monitor> </ComputerHardware> <ComputerSoftware> <OS>Windows 2000</OS> <Office>Office 2003 Professional</Office> <Programming>Visual Studio 2003 Profressional</Programming> <Utilities>Norton AntiVirus 2005</Utilities> </ComputerSoftware> </Computer> </Office_Inventory> Tag: Store and retrieve an array of double into image field(sql server) Tag: 114664
  - 13
    - Use datareader to get a value for UserNo Hi, I'm relatively new to ADO, so forgive me if I am going about this in the wrong way. I have a login.aspx page, with a textbox 'usernameTxtBx' I would like to extract a value from a single table in an SQL database. The database has two columns of interest usrNo and usrName, they are in the same table. I would like to set the value from usrNo as an int where the value in the usrName column matches that entered in the usernameTxtBx. I have attempted to use a datareader in c#. Here's the relevent code: // Declare conn from Web.Config SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]); conn.Open(); // Set username as a string string Username = usernameTxtBx.Text; //find usrNo SqlCommand cmd = new SqlCommand("SELECT usrNo FROM tblUser WHERE usrName = 'Username'", conn); SqlDataReader dr = cmd.ExecuteReader(); dr.Read(); int UserNo = (int)dr["UserNo"]; conn.Close(); This gives the following error: Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.IndexOutOfRangeException: UserNo In debugging the value of UserNo appears to get set to 0 regardless of the login used, where i would expect the value to equal 1 or 3 or similar integer. Any ideas what i'm doing wrong? am I even on the right track?? Thanks Tag: Store and retrieve an array of double into image field(sql server) Tag: 114662
  - 14
    - Clearing dataset tables where they have relations I'm using a Public dataset in the module for all data throughout the project. For most forms, this is great, no need to instantiate a new object, just clear the datatables and reload as needed. However, an issue arises where I have data relations in a form. Reloading the data on those forms requires clearing the relation and the datatables. What I've done in the past is reset the dataset and clear the relations. This also works fine -- except for the obvious, that being that it kills off any data in the dataset. So, I've tried to just clear the tables and then clear the dataset relations. This causes an exception on the 2nd load of data ("The row doesn't belong to the same DataSet as this relation."). How do I resolve this -- without creating a new dataset for each form where I have a data relation? ********************************************************* TECHNIQUE A (this works well, except clears the dataset entirely) ds.Reset() ds.Relations.Clear() TECHNIQUE B (this causes an exception on 2nd load of employee data) If ds.Tables.Contains("dtEmployees") Then ds.Tables("dtEmployees").Clear() End If If ds.Tables.Contains("dtEmpCategoryMatches") Then ds.Tables("dtEmpCategoryMatches").Clear() End If ds.Relations.Clear() Tag: Store and retrieve an array of double into image field(sql server) Tag: 114655
  - 15
    - Can rows be ordered in a datatable? I have a DataTable that is bound to a DataGrid that displays a number of selections from a product menu: Item1 quantity price totalAmount Item2 quantity price totalAmount TAX - - - - - - - - - - totalAmount TOTAL - - - - - - - - totalAmount Each time the user makes a selection, the DataTable is updated and re-bound to the DataGrid. The problem is I need to keep the TAX and TOTAL rows as the last rows in the DataTable so they appear at the bottom of the DataGrid. But the only way I know how to do this is to delete the rows every time the user makes a selection from the product menu, then recalculate the order, and lastly reinsert the rows in the DataTable (otherwise the user's most recently selected product is the last row in the DataTable and appears at the bottom of the DataGrid). Is there a way to re-order the rows rather than deleting and re-inserting every time? Is there some way to tell the data table that the Total row should be the last row in the table, and the Tax row second-to-last? That way I could just overwrite the value in those rows rather than deleting and re-inserting after each time the users selects another item. Thanks in advance. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114653
  - 16
    - Check to ensure server and db available When I load the startup form, I want to make a check to ensure the named server AND database (SQL2k) is available before trying to load any data. Any recommendations? Tag: Store and retrieve an array of double into image field(sql server) Tag: 114646
  - 17
    - Sort Dataview by relationships Is it possible to sort a child table in a dataview on its own ? for example if there are two tables: tblParent & tblChild The form is bound by its dataview. Now there is a tab on the frmMain which lists all the records in tblChild The main form is sorted by a field in tblParent, further to that can I sort the records in the tab by another field in tblChild ? Any input would be appreciated. Thanks Tag: Store and retrieve an array of double into image field(sql server) Tag: 114642
  - 18
    - How to create and schedule full-text catalogue programatically Hi, I have writen a database installation application that simply creates tables inside a database. I also need to create and schedule full-text indexing on some of my tables. I am using SQL server 2000 and and VB.NET 2003. Thank you, _dino_ Tag: Store and retrieve an array of double into image field(sql server) Tag: 114639
  - 19
    - How do I connect to a FoxPro 6 .dbf file using OleDb? Does anyone know how to simply connect to a FoxPro 6 .dbf file using ADO.NET's OleDb provider so I can query the data? Mainly I need to know what the connection string is so I can execute a query. Thanks, Tony Tag: Store and retrieve an array of double into image field(sql server) Tag: 114638
  - 20
    - Stupid bugs in ODP.NET 9.2.0.4.01 1. Execute this SQL DELETE FROM ... WHERE ROWNUM=1 RETURNING a,b INTO :pa,:pb with ExecuteNonQuery(), here a and b are number columns, and the two output parameters' datatype is set to DbType.Int64, you are ok where there is row in database, otherwise your app crashs. 2. Guess what the DbType of this parameter is: OracleParameter p = new OracleParameter("name",0L); it is DbType.AnsiString other than DbType.Int64. Oracle did not release any patch for it for so long time. How could it be a company? Tag: Store and retrieve an array of double into image field(sql server) Tag: 114636
  - 21
    - Stupidly named field selection I am trying to work with and IBM AS400 OLE DB data provider and when using the wizard, I am going along selecting my fields and setting a WHERE clause. There is a field with a "#" at the end of it. As soon as I type this WHERE clause, I have an error message about the syntax and I know that it has to do with the "#". I have enclosed the field name with quotes, single quotes and nothing seems to work. I have been using the ODBC which does work fine, however I am a beginner at ASP .Net (I usually do Windows apps) and I have a problem with pulling data from the AS400 using ODBC. Help, what can I do? Brad Tag: Store and retrieve an array of double into image field(sql server) Tag: 114634
  - 22
    - Capturing return value from SQL Server's stored procedure Using Microsoft.Practices.EnterpriseLibrary.Data, how do I capture the return value from executing a stored procedure on SQL Server 2000 (i.e., how could I tell the Stored Procedure did not return 0 [indicating failure] or that a transaction the stored procedure begun had been rolled back): No exceptions were thrown from the following when -1 was returned and transaction rolled back: Database db = DatabaseFactory.CreateDatabase(); string sqlCommand = "uspCreator"; DBCommandWrapper creatorCommandWrapper = db.GetStoredProcCommandWrapper(sqlCommand); db.ExecuteNonQuery(creatorCommandWrapper); Tag: Store and retrieve an array of double into image field(sql server) Tag: 114627
  - 23
    - Dataset constraints A question please. Lets say I have a grid with its datasource as a dataset with three columns in it; UserID (an auto generated ID), LastName and FirstName. Additionally, lets say I want to restrict the user from entering two records with the same last name and first name. I have created a constraint for LastName FirstName in the dataset but I would like a different message than the default message I get when the constraint is violated. Is there a way for me to do this? Tag: Store and retrieve an array of double into image field(sql server) Tag: 114622
  - 24
    - Interesting Problem regarding Parameters Backgroud: My company is currently migrating to .Net from PHP for a number of reasons, however we have one slight problem we would very much like to solve before moving to .Net (ok, many but this one is a toughie). Problem: On our current PHP platform we have our own database abstraction class which inherits from the PEAR DB abstraction class. One of the major reasons why we did this is because we wanted to add automatic querie logging to our database connection object. Here is a brief snippit of code to demonstarte the functionality we currently have: //Creating DB connection objects $connection = mis_DB::connect( 'database-server', 'database' ); $connection->addLog( 'file', '/log_path/filename.log', PEAR_LOG_MODE ); $connection->setLogMask( MISDB_LOG_ALL ); This will automatically log any queries thrown at at, for example (I'm using prepare and execute syntax for a reason that will be come clear in just a minute): /* Disclaimer, such a DB does not exist on my company DB server, but it should! */ $query = "SELECT * FROM beer.beer_styles WHERE style = ?"; $handle = $connection->prepare( $query ); $result_object = $connection->execute( $handle, array( "Imperial Stout" ) ); What our current database class will do (after executing the query) is logg the following message to the /log_path/filename.log file: Friday, July 29, 2005 8:41:10 AM [Informational] SELECT * FROM beer.beer_styles WHERE style = 'Imerial Stout' What we would like is to have some thing similar with our new .Net DB class, however the problem I'm running into is I don't know how to get the query that was actually executed on the server, what I mean by that is: //Assum proper connection string OleDbConnection Connection = new OleDbConnection( ConnectionString ); OleDbCommand Command = new OleDbCommand( Connection ); Connection.Open(); Command.CommandText = @"SELECT * FROM beer.beer_styles WHERE style = @style"; Command.Paramaters.Add( "@style", "Imperial Stout" ); OleDbDataReader Reader = Command.ExecuteReader(); Now that the query has executed, how to I pull the value: "SELECT * FROM beer.beer_styles WHERE style = 'Imperial Stout'" out of the database class v. "SELECT * FROM beer.beer_styles WHERE style = @style" Thanks for any help you can provide! -------------------- Carlo Razzeto carlo.razzeto@mtginfo.com Tag: Store and retrieve an array of double into image field(sql server) Tag: 114617
  - 25
    - Interesting Problem regarding Parameters Backgroud: My company is currently migrating to .Net from PHP for a number of reasons, however we have one slight problem we would very much like to solve before moving to .Net (ok, many but this one is a toughie). Problem: On our current PHP platform we have our own database abstraction class which inherits from the PEAR DB abstraction class. One of the major reasons why we did this is because we wanted to add automatic querie logging to our database connection object. Here is a brief snippit of code to demonstarte the functionality we currently have: //Creating DB connection objects $connection = mis_DB::connect( 'database-server', 'database' ); $connection->addLog( 'file', '/log_path/filename.log', PEAR_LOG_MODE ); $connection->setLogMask( MISDB_LOG_ALL ); This will automatically log any queries thrown at at, for example (I'm using prepare and execute syntax for a reason that will be come clear in just a minute): /* Disclaimer, such a DB does not exist on my company DB server, but it should! */ $query = "SELECT * FROM beer.beer_styles WHERE style = ?"; $handle = $connection->prepare( $query ); $result_object = $connection->execute( $handle, array( "Imperial Stout" ) ); What our current database class will do (after executing the query) is logg the following message to the /log_path/filename.log file: Friday, July 29, 2005 8:41:10 AM [Informational] SELECT * FROM beer.beer_styles WHERE style = 'Imerial Stout' What we would like is to have some thing similar with our new .Net DB class, however the problem I'm running into is I don't know how to get the query that was actually executed on the server, what I mean by that is: //Assume I have a proper connection string OleDbConnection Connection = new OleDbConnection( ConnectionString ); OleDbCommand Command = new OleDbCommand( "", Connection ); Connection.Open(); //Set the query with parmater then execute reader Command.CommandText = "SELECT * FROM beer.beer_styles WHERE style = @style"; Command.Paramaters.Add( "@style", "Imperial Stout" ); OleDbDataReader Reader = Command.ExecuteReader(); How do I get the query that actually executed on our DB server, i.e. "SELECT * FROM beer.beer_styles WHERE style = 'Imperial Stout'", not "SELECT * FROM beer.beer_styles WHERE style = @style". Thanks for the help! ---------------------- Carlo Razzeto carlo.razzeto@mtginfo.com Tag: Store and retrieve an array of double into image field(sql server) Tag: 114616
- Next
  - 1
    - CAPTION FOR UPLOAD CONTROL Has anybody been able to figure out how to change the wording of the word "Browse" in a file upload control? It seems to be built in the browser and it doesn't seem like we can change it. anybody knows? THANKS! Tag: Store and retrieve an array of double into image field(sql server) Tag: 114612
  - 2
    - Hoping some one here can help me, or at least point me in the right direction I know this dosen't really fit the category, but most of you ADO.NET guys do some reporting at some point in time. If you know a better place for me to put this let me know. I have a Crystal Report that is external to my application. It uses an XML file (also outside my application) as it's datasource. I need to be able to change the XML datasource and pass this to the report (THE XML file it's reporting on) I can't seem to find the anwser. I don't want to pull the XML file into a dataset and then push it to the report, I would prefer to use the Crystal Pull method. Thanks again! Justin Tag: Store and retrieve an array of double into image field(sql server) Tag: 114608
  - 3
    - ado.net 2.0 and sql server 7 Hello, we are migrating our "old" .net 1.1 application to 2.0 and have noticed that opening connections to a sql server 7 now is very very slow, but this doesn't happen with sql server 2000. Is there any workaround to speed up this a bit. Our application is now unusable with sql 7. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114603
  - 4
    - ODBC Driver not displaying? Hello, I'm trying to install an ODBC driver, specifically IBM's Client Access OBDC Driver (32 Bit) which is installed as part of Client Access for the AS/400. The ODBC driver is installed okay, but if I launch odbcad32.exe (managing odbc data sources), I do not see the driver. I cannot choose the driver when creating a new dsn because it just is not listed. I have checked the registry a HKLM\Software\ODBC and I see that there are entries for the driver, and they appear to be correct. Why can't I see this driver listed so I can use it to create a DSN? My system is WinXp Pro, SP1, .Net 1.1, MDAC 2.8 Thanks for the help - Wayne P. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114598
  - 5
    - TableAdapter problems w VS.NET 2005 Hi everyone, When I use the TableAdapter wizard with a SQL select that contains a linked server table (like Select * from SF...Account) , I get an error message when generating the SQL insert. A dialog box appears with the msg : The specified identifier was in an invalid format". The select command generates ok but the insert, update and delete commands do not. I'm using the June CTP of VS.NET 2005 Thanks. -- Bill Emerson Tag: Store and retrieve an array of double into image field(sql server) Tag: 114596
  - 6
    - Writing updates from a wide DataTable I have a DataTable with a large number of colums - 50 or more. I'm following the recommendations to use stored procedures to apply updates to the database, and using the Enterprise Llibrary. So I end up with a stored procedure with 50+ parameters, and an Update statement that updates the same number of columns. In a typical use case only a few columns will actually be updated, but my DAL generally doesn't know which - it just gets a DataSet with some changes. Everything works fine, but I feel uncomfortable with this solution. I don't like rewriting all those columns I haven't changed. I don't like shipping all this unchanged data around. Should I feel uncomfortable? Are there better ways of handling this kind of situation? Thanks... -------- Nigel Norris Tag: Store and retrieve an array of double into image field(sql server) Tag: 114582
  - 7
    - = Null problem Hi Am using ADO.NET connection from my ASP.NET application to connect to MS SQL SERVER 2000. I have a Stored procedure which works fine when I directly connect to the Database using Native drivers, the same is not working properly when I use ADO.NET connection. When I debugged the Stored procedure I found that the following script was not working with ADO.NET emp_name = Null and the same was working fine when I changed the sql script to emp_name IS Null. I have few hundreds of stored procedure and It might not be possible for me to alter the Stored Procedure. 1.Any body have faced the same problem? 2.Is there an alternative solution to overcome from this problem ? 3.Is this fixed in any service packs from Microsoft ? 4. Or there is no other option rather than change the sql script in Stored Procedure to emp_name IS NULL ? Any help would be greatly appreciated Thank you Mahesh.V Tag: Store and retrieve an array of double into image field(sql server) Tag: 114571
  - 8
    - Debug skips DataAdapter.Update code. Why?? Hi, I'm attempting to input data into two related tables using stored procedures. I found some good example code, which i have followed, checked and double checked, but for some reason the update is not happening. Below is the code, it's pretty lengthy so to save you time i'll say now that it runs through fine in debug until near the very end, the patientDataAdapter.Update(dsAddPatient, "Patient"); line just above the 'catch' section. It runs the previous line then jumps this and subsequent lines going straight to 'catch'. The code: private void addPatientDataToDB() { try { // Create the DataSet object DataSet dsAddPatient = new DataSet(); // Connect to database SqlConnection conn = new SqlConnection(ConfigurationSettings.AppSettings["strConn"]); conn.Open(); // Create the DataTable "Patient" in the Dataset and the DataAdapter SqlDataAdapter patientDataAdapter = new SqlDataAdapter(new SqlCommand("SELECT * FROM tblPatient", conn)); patientDataAdapter.InsertCommand = new SqlCommand("proc_InsertPatient", conn); SqlCommand cmdInsert = patientDataAdapter.InsertCommand; cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.Parameters.Add(new SqlParameter("@patientNo", SqlDbType.Int)); cmdInsert.Parameters["@patientNo"].Direction = ParameterDirection.Output; cmdInsert.Parameters["@patientNo"].SourceColumn = "patientNo"; cmdInsert.Parameters.Add(new SqlParameter("@pntUnitID", SqlDbType.NVarChar,15,"pntUnitID")); cmdInsert.Parameters.Add(new SqlParameter("@pntTitle", SqlDbType.NVarChar,4,"pntTitle")); cmdInsert.Parameters.Add(new SqlParameter("@pntFName", SqlDbType.NVarChar,20,"pntFName")); cmdInsert.Parameters.Add(new SqlParameter("@pntLName", SqlDbType.NVarChar,30,"pntLName")); cmdInsert.Parameters.Add(new SqlParameter("@pntDOB", SqlDbType.DateTime,8,"pntDOB")); cmdInsert.Parameters.Add(new SqlParameter("@pntSex", SqlDbType.NVarChar,1,"pntSex")); cmdInsert.Parameters.Add(new SqlParameter("@pntAddress1", SqlDbType.NVarChar,150,"pntAddress1")); cmdInsert.Parameters.Add(new SqlParameter("@pntAddress2", SqlDbType.NVarChar,150,"pntAddress2")); cmdInsert.Parameters.Add(new SqlParameter("@pntAddress3", SqlDbType.NVarChar,150,"pntAddress3")); cmdInsert.Parameters.Add(new SqlParameter("@pntcountryNo", SqlDbType.Int,4,"pntCountryNo")); cmdInsert.Parameters.Add(new SqlParameter("@pntPostcode", SqlDbType.NVarChar,10,"pntPostcode")); cmdInsert.Parameters.Add(new SqlParameter("@pntHPnone", SqlDbType.NVarChar,14,"pntHPnone")); cmdInsert.Parameters.Add(new SqlParameter("@pntWPhone", SqlDbType.NVarChar,14,"pntWPhone")); cmdInsert.Parameters.Add(new SqlParameter("@pntMobPhone", SqlDbType.NVarChar,14,"pntMobPhone")); cmdInsert.Parameters.Add(new SqlParameter("@pntEmail", SqlDbType.NVarChar,50,"pntEmail")); cmdInsert.Parameters.Add(new SqlParameter("@pntStage", SqlDbType.NVarChar,5,"pntStage")); cmdInsert.Parameters.Add(new SqlParameter("@pntT", SqlDbType.TinyInt,1,"pntT")); cmdInsert.Parameters.Add(new SqlParameter("@pntN", SqlDbType.TinyInt,1,"pntN")); cmdInsert.Parameters.Add(new SqlParameter("@pntM", SqlDbType.TinyInt,1,"pntM")); cmdInsert.Parameters.Add(new SqlParameter("@pntPreviousTreatments", SqlDbType.Char,1000,"pntPreviousTreatments")); cmdInsert.Parameters.Add(new SqlParameter("@pntFurtherNotes", SqlDbType.Char,1000,"pntFurtherNotes")); patientDataAdapter.FillSchema(dsAddPatient, SchemaType.Source); DataTable pTable = dsAddPatient.Tables["Table"]; pTable.TableName = "Patient"; // Create the DataTable "Histology" in the // Dataset and the DataAdapter SqlDataAdapter histologyDataAdapter = new SqlDataAdapter(new SqlCommand("SELECT * FROM tblSample", conn)); histologyDataAdapter.InsertCommand = new SqlCommand("proc_InsertHistology", conn); cmdInsert = histologyDataAdapter.InsertCommand; cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.Parameters.Add(new SqlParameter("@patientNo", SqlDbType.Int,4)); cmdInsert.Parameters["@patientNo"].SourceColumn = "patientNo"; cmdInsert.Parameters.Add(new SqlParameter("@lesHistology", SqlDbType.NVarChar,50)); cmdInsert.Parameters["@lesHistology"].SourceColumn = "lesHistology"; cmdInsert.Parameters.Add(new SqlParameter("@lesNull", SqlDbType.NVarChar,10)); cmdInsert.Parameters["@lesNull"].SourceColumn = "lesNull"; histologyDataAdapter.FillSchema(dsAddPatient, SchemaType.Source); pTable = dsAddPatient.Tables["Table"]; pTable.TableName = "Histology"; // Create the relationship between the two tables dsAddPatient.Relations.Add(new DataRelation("ParentChild", dsAddPatient.Tables["Patient"].Columns["patientNo"], dsAddPatient.Tables["Histology"].Columns["patientNo"])); // Insert the Data DataRow patientRow = dsAddPatient.Tables["Patient"].NewRow(); patientRow["pntUnitID"] = patientCodeTxtBx.Text; patientRow["pntTitle"] = titleCboBx.SelectedValue; patientRow["pntFName"] = fNameTxtBx.Text; patientRow["pntLName"] = lNameTxtBx.Text; patientRow["pntSex"] = sexCboBx.SelectedValue; patientRow["pntDOB"] = DOBTxtBx.Text; patientRow["pntAddress1"] = address1TxtBx.Text; patientRow["pntAddress2"] = address2TxtBx.Text; patientRow["pntAddress3"] = address3TxtBx.Text; patientRow["pntcountryNo"] = countryCboBx.SelectedValue; patientRow["pntPostcode"] = postcodeTxtBx.Text; patientRow["pntHPhone"] = phoneTxtBx.Text; patientRow["pntWPhone"] = workPhoneTxtBx.Text; patientRow["pntMobPhone"] = mobileTxtBx.Text; patientRow["pntEmail"] = emailTxtBx.Text; patientRow["pntStage"] = stageCboBx.SelectedValue; patientRow["pntT"] = tTxtBx.Text; patientRow["pntN"] = nTxtBx.Text; patientRow["pntM"] = mTxtBx.Text; patientRow["pntPreviousTreatments"] = previousTreatmentsTxtBx.Text; patientRow["pntFurtherNotes"] = notesTxtBx.Text; dsAddPatient.Tables["Patient"].Rows.Add(patientRow); DataRow histologyRow = dsAddPatient.Tables["Histology"].NewRow(); histologyRow["lesHistology"] = histologyCboBx.SelectedValue; histologyRow.SetParentRow(patientRow); dsAddPatient.Tables["Histology"].Rows.Add(histologyRow); patientDataAdapter.Update(dsAddPatient, "Patient"); histologyDataAdapter.Update(dsAddPatient, "Histology"); messageLbl.Text = "Data successfully added to database"; } catch (Exception ex) { messageLbl.Text = ex + "Unable to connect to the database"; } finally { // Close the connection DataAccess.DBConnection.CloseDBConnection(); } } Anyone with any ideas why it might be jumping the patientDataAdapter.Update(dsAddPatient, "Patient"); and histologyDataAdapter.Update(dsAddPatient, "Histology"); statements? Thanks. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114569
  - 9
    - Strange Behavoir With OleDBDataAdapter Hi, Hope someone can explain this... OK, here is the simplest subset of my code that shows the problem: I have a C# Method: Private void UpdateDataTable(DataTable myDT) { OleDbCommand comm = new OleDbCommand(); comm.CommandText = "AddComponentsForJobT"; comm.CommandType = CommandType.StoredProcedure; OleDbConnection conn = new OleDbConnection(CONNECTION_STRING); conn.Open(); comm.Connection = conn; comm.Parameters.Add("pPartNo",OleDbType.VarChar,10,"PartNo").SourceVersion = DataRowVersion.Current; da.InsertCommand = comm; da.Update(myDT); } An Access Query: AddComponentsForJobT ================== PARAMETERS pPartNo Text ( 255 ); INSERT INTO PropJobParts ( PartNo ) SELECT [pPartNo] AS Expr2; If I pass into the above method a DataTable containing 3 rows with a RowState of 'Added' PartNo ===== AAA BB C The code runs successfully, but what finished up in my Access table is: AAA BBA CBA Anyone tell me what I'm doing wrong or missing out??? It seems like the Automagic stuff inside OledbDataAdapter.Update that runs the Insert command is not clearing the parameters between each subsequent insert. Please! Thanks, Chris. -- Remove Elvis's shoes to reply. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114565
  - 10
    - newbie ado net questuon I am trying to get started with ado.net, coming from experience with ado. I have a simple SQL Server stored procedure which inserts a row and returns the value of the identity column for the inserted row (seel below). I have a method in a C# project which is simply going to add a record and return the identity. I am looking throught the documentation to see how to do this. You see I have a dataadapter and a dataset. But I cannot see what methods to use to execute the sp and get back tha value. Can anyone point me in the right direction? public String add(DateTime entryDate, DateTime startTime, DateTime endTime, String shortDescription, String longDescription) { SqlConnection cn = new SqlConnection("Data Source=sstowe;Initial Catalog=Time;User ID=sa;Password=password;"); SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); cn.Open; da. <--- WHAT now? da.Fill(ds); return <--- I think I used to know how to work } CREATE PROCEDURE Entry_Add @EntryDate datetime, @StartTime datetime, @EndTime datetime, @Short char(50), @Description varchar(255), @ID int OUTPUT AS BEGIN SET NOCOUNT ON INSERT INTO Entry ( EntryDate, StartTime, EndTime, Short, Description ) VALUES ( @EntryDate, @StartTime, @EndTime, @Short, @Description ) SELECT @ID = SCOPE_IDENTITY() END GO Tag: Store and retrieve an array of double into image field(sql server) Tag: 114563
  - 11
    - Get the ID of the newly added row Hello All, I am fairly new to ADO.net, I am using this simple command to add a new row to the database, what I want now is to get the auto increment ID of the row added, can anyone please help me with this? strQuery = "insert into tblFeedChannels ...."; SqlCommand objCmd = new SqlCommand(strQuery, conn); objCmd.ExecuteNonQuery(); Imran. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114560
  - 12
    - Newbie help with relations Hi, I have two tables in a dataset. I want to create a relation between the two tables in which the child table can have foreign keys that do not match primary key fields in the parent table. When the parent table is updated, I want any related foreign key fields in the child table to be updated, but I don't want any deletions to be cascaded. I've tried setting DeleteRule to SetNull and UpdateRule to Cascade, but I get a constraint error on filling the dataset in my program, I guess because most fields in the child table do not have parent rows (but I don't want them to have parent rows). How do I set this up in the dataset schema editor? Thanks, Nathan Tag: Store and retrieve an array of double into image field(sql server) Tag: 114558
  - 13
    - ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe (BIS) Hello, I resend the same question i previously sent because i did'nt used the good reply-to address. I'm having a ThreadAbortException and i don't know why. When i launch the same code sometimes it never crash a the same place but always in the proc. you find below. If it can help, i'm using Nant and i launch the code with "Test with debugger". My base code is reading files on disk and making a lot of insert and update queries on the server. I'm the only user of the database. This is the code : Public Shared Function QueryDataSetWithNoExceptionCode(ByVal SQLQuery As String) As DataSet Try Dim sConnectionString As String = _GetConnectionString() Dim conDB As New SqlConnection(sConnectionString & ";connect timeout = 60") Dim cmdQuery As New SqlCommand(SQLQuery, conDB) cmdQuery.CommandTimeout = 300 Dim da As New SqlDataAdapter(cmdQuery) Dim ds As New DataSet da.Fill(ds) cmdQuery = Nothing conDB = Nothing da = Nothing Return ds Catch ex As Exception Throw ex End Try End Function When the breakpoint is on the catch i have this : ?ex.ToString "System.Threading.ThreadAbortException: Le thread a été abandonné. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Corus.FortisDocumentService.FortisDocumentService.Metier.CorusFortisDataAccess.QueryDataSetWithNoExceptionCode(String SQLQuery) in C:\DATAS\Dvpt\Sources\Clients\Fortis\FortisDocumentService\Trunk\src\FortisDocumentService.Metier\CorusFortisDataAccess.vb:line 55" Tag: Store and retrieve an array of double into image field(sql server) Tag: 114557
  - 14
    - ThreadAbortException at System.Data.SqlClient.SqlCommand.ExecuteRe Hello, I'm having a ThreadAbortException and i don't know why. When i launch the same code sometimes it never crash a the same place but always in the proc. you find below. If it can help, i'm using Nant and i launch the code with "Test with debugger". My base code is reading files on disk and making a lot of insert and update queries on the server. I'm the only user of the database. This is the code : Public Shared Function QueryDataSetWithNoExceptionCode(ByVal SQLQuery As String) As DataSet Try Dim sConnectionString As String = _GetConnectionString() Dim conDB As New SqlConnection(sConnectionString & ";connect timeout = 60") Dim cmdQuery As New SqlCommand(SQLQuery, conDB) cmdQuery.CommandTimeout = 300 Dim da As New SqlDataAdapter(cmdQuery) Dim ds As New DataSet da.Fill(ds) cmdQuery = Nothing conDB = Nothing da = Nothing Return ds Catch ex As Exception Throw ex End Try End Function When the breakpoint is on the catch i have this : ?ex.ToString "System.Threading.ThreadAbortException: Le thread a Ã©tÃ© abandonnÃ©. at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior) at System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) at Corus.FortisDocumentService.FortisDocumentService.Metier.CorusFortisDataAccess.QueryDataSetWithNoExceptionCode(String SQLQuery) in C:\DATAS\Dvpt\Sources\Clients\Fortis\FortisDocumentService\Trunk\src\FortisDocumentService.Metier\CorusFortisDataAccess.vb:line 55" Tag: Store and retrieve an array of double into image field(sql server) Tag: 114556
  - 15
    - Newbie question about dataadapter parameter Hi, I have a dataadapter that has 2 parameters. But sometimes I would like to use only one of the parameters. For example: The dataadapter selectcommand would be like this: SELECT CategoryID, CategoryName, Description, Picture FROM Categories WHERE (CategoryID = @CID) AND (CategoryName = @CName) On My code, before filling the dataset, I would add the parameters Mydataadapter.SelectCommand.Parameters("@CID").Value = 1 Mydataadapter.SelectCommand.Parameters("@CName").Value = "Beverages" Mydataadapter.Fill(Mydataset) This Code would run nicely. But how if I want to ignore one of the parameter? For example I just want to use The @CID parameter. How to ignore the @CName parameter? Hope, my question is clear cause my English is not so good. All helps will be greatly appreciated. Thank you Tag: Store and retrieve an array of double into image field(sql server) Tag: 114547
  - 16
    - C# Prepared Statements Hi all, Can someone point me to an example of prepared statements being used in C# ado.net? the MSDN site has examples using VB and my documentation in VS 2005 says "to be filled in" or something equally useful. thanks in advance, Pat Tag: Store and retrieve an array of double into image field(sql server) Tag: 114538
  - 17
    - Passing Optional Parameter to Stored Procedure in VS VB.net Hi, I'm trying to pass only the required parameters to a stored procedure using the following code. I keep getting the following error now. Running dbo."InsertEmployee" ( @pemployeeno = "888888", @S_I_N = "123456789", @pfirstname = "Sam", @plastname = "Wise", @pmiddlename = <DEFAULT>, @pprimaryemail = "swise@sd61.bc.ca", @psecondaryemail = <DEFAULT>, @status_code = "A" ). ---> Error converting data type varchar to numeric. <------ Dim SIMSSqlcommand As New SqlCommand SIMSSqlcommand.Connection = connection SIMSSqlcommand.CommandText = "InsertEmployee" SIMSSqlcommand.CommandType = CommandType.StoredProcedure SIMSSqlcommand.namedparameter = True SIMSSqlcommand.Parameters.Add("@CustomerID", "PAULK") SIMSSqlcommand.Parameters.Add("@CompanyName", "Pauly's Bar") STORED PROCEDURE CREATE PROCEDURE dbo.InsertEmployee /* ( @parameter1 datatype = default value, @parameter2 datatype OUTPUT ) */ ( @pemployeeno char(10), @S_I_N nvarchar(10), @pfirstname nvarchar(50), @plastname nvarchar(50), @pmiddlename nvarchar(50)=" ", @pprimaryemail nvarchar(50)=" ", @psecondaryemail nvarchar(50) = " ", @status_code char(10) = " " ) AS declare @pstatusid numeric /* SET NOCOUNT ON */ select @pstatusid = statusid from status where statuscode = @status_code; insert into Employee ( Employeeno, S_I_N, firstname, lastname, middlename, primaryemail, secondaryemail, statusid ) values ( @pemployeeno, @S_I_N, @pfirstname, @plastname, @pmiddlename, @pprimaryemail, @psecondaryemail, @status_code ) select @@identity RETURN GO thanks, Will Tag: Store and retrieve an array of double into image field(sql server) Tag: 114531
  - 18
    - Validate a CSV file I have a CSV file which contains comma seperated data that I need to validate against our database.I was thinking about loading that CSV file into a Typed-Dataset which has our database schema in it and then try to load the CSV file into that Typed-Dataset and automatically get all the errors and constarint violations. 1) Is it doable? 2) Because I need to check the foriegn keys as well,Can I loaded the data of those refferecing tables into my dataset as well? 3)If number 2 is doable ,how should I update my dataset if a key has been added to the existing refferncing tables? Thanks a lot for taking your time answering this post in advance. J-T Tag: Store and retrieve an array of double into image field(sql server) Tag: 114529
  - 19
    - SqlParameter with ParameterName is not contained... I'm receiving the following error when I try to use a stored proc in my code: SqlParameter with ParameterName '@unionRep' is not contained by this SqlParameterCollection I have searched several newsgroups and found similar situations, but so far none of the solutions have worked for me. *Note, I have tried setting the connection and opening it both before and after setting the command text. Please help! Thanks in advance. Here is the code I have: SqlSelectCommand1.CommandType = CommandType.StoredProcedure SqlSelectCommand1.CommandText = "sp_UpdateContractOut1" Dim param As SqlParameter = New SqlParameter("@unionRep", SqlDbType.NVarChar, 50) Dim param1 As SqlParameter = New SqlParameter("@unionSign", SqlDbType.SmallDateTime) Dim param2 As SqlParameter = New SqlParameter("@areaUnionRep", SqlDbType.NVarChar, 50) Dim param3 As SqlParameter = New SqlParameter("@areaUnionRepSign", SqlDbType.SmallDateTime) Dim param4 As SqlParameter = New SqlParameter("@unionComm", SqlDbType.NVarChar, 255) Dim param5 As SqlParameter = New SqlParameter("@companyCoord", SqlDbType.NVarChar, 50) Dim param6 As SqlParameter = New SqlParameter("@companySign", SqlDbType.SmallDateTime) Dim param7 As SqlParameter = New SqlParameter("@maintSupt", SqlDbType.NVarChar, 50) Dim param8 As SqlParameter = New SqlParameter("@maintSuptSign", SqlDbType.SmallDateTime) Dim param9 As SqlParameter = New SqlParameter("@coordComm", SqlDbType.NVarChar, 255) Dim param10 As SqlParameter = New SqlParameter("@ID", SqlDbType.Int) SqlSelectCommand1.Parameters("@unionRep").Value = unionRep.Text SqlSelectCommand1.Parameters("@unionSign").Value = unionSign.Text SqlSelectCommand1.Parameters("@areaUnionRep").Value = areaUnionRep.Text SqlSelectCommand1.Parameters("@areaUnionRepSign").Value = areaUnionRepSign.Text SqlSelectCommand1.Parameters("@unionComm").Value = unionComm.Text SqlSelectCommand1.Parameters("@companyCoord").Value = companyCoord.Text SqlSelectCommand1.Parameters("@companySign").Value = companySign.Text SqlSelectCommand1.Parameters("@maintSupt").Value = MaintSupt.Text SqlSelectCommand1.Parameters("@maintSuptSign").Value = maintSuptSign.Text SqlSelectCommand1.Parameters("@coordComm").Value = coordComm.Text SqlSelectCommand1.Parameters("@ID").Value = txtWO.Text SqlSelectCommand1.Connection = SqlConnection1 SqlConnection1.Open() Try SqlSelectCommand1.ExecuteNonQuery() lblUpdateSuccess.Visible = True btnSuccess.Visible = True Catch ex As Exception lblFail.Visible = True btnFail.Visible = True Finally SqlConnection1.Close() End Try Tag: Store and retrieve an array of double into image field(sql server) Tag: 114522
  - 20
    - SCOPE_IDENTITY won't return correct value, but @@IDENTITY does Hi all, I have the following codes, but SCOPE_IDENTITY() just returns NULL to me. If I comment out SCOPE_IDENTITY() line and run @@IDENTITY line, it works fine!! Since I have a trigger on the table, I have to use SCOPE_IDENTITY(). Any ideas? SqlConnection conn = new SqlConnection(connectionString); conn.Open(); //Create the dataadapter SqlDataAdapter da = new SqlDataAdapter(); //Assign the connection & Create and execute the Insert Command da.InsertCommand = new SqlCommand("insert into table1......"); da.InsertCommand.Connection = conn; da.InsertCommand.ExecuteNonQuery(); //Create,assign and Execute the Identity statement da.SelectCommand = new SqlCommand("SELECT SCOPE_IDENTITY()", da.InsertCommand.Connection); //da.SelectCommand = new SqlCommand("SELECT @@IDENTITY", da.InsertCommand.Connection); int intID = Convert.ToInt32(da.SelectCommand.ExecuteScalar()); conn.Close(); return(intID); -- WWW: http://hardywang.1accesshost.com ICQ: 3359839 yours Hardy Tag: Store and retrieve an array of double into image field(sql server) Tag: 114515
  - 21
    - ANN: QueryADataset Product Release For anyone who might have visited the web site before or anyone needing a full SQL query engine against a ADO.NET DataSet or XML document, you might be interested in the QueryADataset assembly I've been working on at http://www.queryadataset.com. It lets you perform complex SQL SELECT statements including UNION, INNER and OUTER JOINS, GROUP BY, HAVING, ORDER BY, sub-queries, aggregates etc against the tables in a DataSet. The release version also supports common built-in functions like ISNULL, date functions, string functions and math functions. The assembly is now available for purchase at an introductory price of $100 US. You can also download a trial version for evaluation. For more information, please visit the link below or contact me. Thanks Adrian Moore http://www.queryadataset.com Tag: Store and retrieve an array of double into image field(sql server) Tag: 114511
  - 22
    - number of Columns in DataGrid (not DataSource!) Hi, I need a function that gives me the number of Columns shown in a DataGrid. So I don't need to know the number of columns shown in tha DataSource, because this number can be completely something else than the number of columns defined in the currently active TableStyle! I currently use DataGrid.TableStyles(0).GridColumnStyles.Count, but i know this won't work when using more than one TableStyle, or having a TableStyle with another mappingname... Has anybody any idea? Maybe a combination of these 2 functions that search first which type of DataSource I have, if it has a table, and if there is a TableStyle with that name etc? But it doesn't seem really logical to me, and I really wonder if there isn't any method that gets it directly from the DataGrid? Thanks a lot in advance, Pieter private void PrintCurrentListName(DataGrid myDataGrid){ CurrencyManager myCM = (CurrencyManager) BindingContext[myDataGrid.DataSource, myDataGrid.DataMember]; IList myList = myCM.List; ITypedList thisList = (ITypedList) myList; Console.WriteLine(thisList.GetListName(null)); } Private Function GetColumnCount() As Integer Dim intCount As Integer If TypeOf Me.DataSource Is DataTable Then intCount = DirectCast(Me.DataSource, DataTable).Columns.Count ElseIf TypeOf Me.DataSource Is DataView Then intCount = DirectCast(Me.DataSource, DataView).Table.Columns.Count ElseIf TypeOf Me.DataSource Is ArrayList Then intCount = DirectCast(Me.DataSource, ArrayList).Count '???? ElseIf TypeOf Me.DataSource Is Collection Then intCount = DirectCast(Me.DataSource, Collection).Count '???? ElseIf TypeOf Me.DataSource Is DataSet Then intCount = DirectCast(Me.DataSource, DataSet).Tables(0).Columns.Count Else intCount = 0 End If Return intCount End Function Tag: Store and retrieve an array of double into image field(sql server) Tag: 114505
  - 23
    - Filtering uncommited data ? If I do a select query with the hint WITH (NOLOCK) are uncommited reads marked somewhere in the dataset/datatable/datarow so I can filter them out ? I havent been able to find a flag to use for this. Thank you PL. Tag: Store and retrieve an array of double into image field(sql server) Tag: 114503
  - 24
    - Unspecified error: E-Fail (0x80004005) Hi All, We connected with OLEDBConnect to oracle database in a asp.net and C#. Database Server and WebServer is in a computer. This compputer is a Windows 2000 server with SP4 and installed Framework .Net 1.1 and IIS. When i try to connect to database i get error: System.Data.OleDB.OleDbException: Unspecified error: E-FAIL (0x80004005) How can i solve this error? Thanks Mad Tag: Store and retrieve an array of double into image field(sql server) Tag: 114500
  - 25
    - Howto specify which DataTables of a DataSet will be stored with WriteXml? Hello, I would like to save a DataSet to xml-file. But I only want to save some DataTables of the DataSet, not all. The DataSet.WriteXml(...) methods does not allow this. Does anyone knows a workaround? An additional requirement is, to store all DataTables in the same file. Thanks Gordian Tag: Store and retrieve an array of double into image field(sql server) Tag: 114490

I have a single dimensional array of double values which I want to store into
an image field of sql server database. I couldn't find any sample code to do
that, the sample code everywhere talks about reading and writing to a file.
I want to know how to store and retrieve an array of double from the image
field using vb.net. I would appreciate any inputs on this.

Thanks

Top