Set Default Value SqlParameter

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
    - OleDbDataAdapter Losing Leading Zeros When importing csv into typed dataset Hi, I am a csv file into a typed datset using the OLEDB provider. However when the file is read into the dataset via the dataadapter fill method my field lose there leading zeroes. I have set the columns in the typed dataset to strings to avoid a conversion to a numeric value but it seems to drop the zeroes anyway before placing the data into the dataset. I have tried using a schema.ini file which works if i pass the data into a generic dataset but fails if i try to use my typed dataset. I would have thought as I was using a typed dataset I would not need a schema.ini anyway? Any Ideas how to prevent the dropping of leading zeroes? My code is as follows: ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\\CSVTest\\;Extended Properties='text;HDR=Yes;FMT=Delimited;'"; System.Data.OleDb.OleDbConnection Conn = new System.Data.OleDb.OleDbConnection(ConnectionString); Conn.Open() ; System.Data.OleDb.OleDbDataAdapter da = new System.Data.OleDb.OleDbDataAdapter("SELECT * FROM Test.csv", Conn) ; //TestTypeDataset is a typed datset matching data in test.csv TestTypeDataset FileResults = new FileResults; da.Fill(FileResults, "FileData"); Conn.Close(); Thanks in advance. Tag: Set Default Value SqlParameter Tag: 116676
  - 2
    - Connection as a static class Is it alright if I took a static class that wrapped around a SQLConnection object on a web application? Or should I make it an instance class? If I have a static class, would there be just one code instance of the class in the server process/app domain for all the clients/browsers? So, if a page on a particular request/context does a MyConnectionClass.Close() in its Unload event handler for the Page, would this close the connection for all clients if it were implemented as a static class? Tag: Set Default Value SqlParameter Tag: 116656
  - 3
    - What's the better way to modify rows in a table? What's a better way to add a new row to a table: (1) An Insert SQLCommand object? or; (2) Through the DataRows collection doing it manually and then calling Update on the Adapter? Tag: Set Default Value SqlParameter Tag: 116655
  - 4
    - Disconnected architecture on SQL IDENTITY Let's say I have a table with an IDENTITY column, create table Foo ( id int IDENTITY not null primary key, SomeThingElse varchar(50) null ) Since DataSet(s) are disconnected, what impact would two concurrent statements have on the IDENTITY column: Dim dr as DataRow = New DataRow dr("SomeThingElse") = "This value is for the something else column; the second one." Dim dt As DataTable = ObjDataSet.Tables("Foo") dt.Rows.Add(dr) DataAdapterObject.Update(ObjDataSet, "Foo") Would it have any negative side affects on the identity column? Tag: Set Default Value SqlParameter Tag: 116654
  - 5
    - Is the DataReader disconnected? Like the dataset, is the datareader also a disconnected datasource? It doesn't look like because of two reasons: (1) It is forward only. Having a connected stream would make more sense to reflect recent updations to the original database from other connections of other users. (2) It would be more performance intensive if it were to be disconnected. (3) It has a Close() method on it. It implies it is connected. What's the truth? Tag: Set Default Value SqlParameter Tag: 116646
  - 6
    - Hwo to use mySQL database with .Net Compact Framework Hi Everybody, I am new at this group/forum. I am a .Net Programmer from Manila, Philippines. I like to ask anyone who can help me how to use mySQL database in programming Visual Studio .Net Smart Device Application (.Net Compact Framework). Specific question is it seems the System.Data namespace at this application does not have the ODBC or OleDB namespace classes/objects. It offers only for MS SQL CE. How can I go around this to be able to access and do data processing with mySQL with .Net Compact Framework? Thanks den 2005 -- MCP Year 2005, Philippines Tag: Set Default Value SqlParameter Tag: 116645
  - 7
    - Dynamic retrieval of MS-Access Tables and Relationships Hi, I would like to retrieve MS-Access database tables, columns and relationships dynamically from .NET. However I could not find any article/help material to do that. Could any one help me in this regard? Tag: Set Default Value SqlParameter Tag: 116642
  - 8
    - Error when uploading file I am trying to write code to allow my users to upload a file. The code I am using is as follows: Dim upfilename As String = "" If fileDetails.Value <> "" AndAlso fileDetails.PostedFile.ContentLength > 0 Then Dim dir As String() = fileDetails.PostedFile.FileName.Split("\".ToCharArray()) upfilename = dir(dir.GetUpperBound(0)) fileDetails.PostedFile.SaveAs(Server.MapPath("/eventdetails/") & upfilename) End If When I run this code, I recieve an error similar to the following: Server Error in '/lvbeporgtest' Application. -------------------------------------------------------------------------------- Could not find a part of the path "D:\Webdev_Site\eventdetails\resume.pdf". 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.IO.DirectoryNotFoundException: Could not find a part of the path "D:\Webdev_Site\eventdetails\resume.pdf". Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [DirectoryNotFoundException: Could not find a part of the path "D:\Webdev_Site\eventdetails\resume.pdf".] System.IO.__Error.WinIOError(Int32 errorCode, String str) +287 System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, Boolean useAsync, String msgPath, Boolean bFromProxy) +888 System.IO.FileStream..ctor(String path, FileMode mode) +52 System.Web.HttpPostedFile.SaveAs(String filename) +48 createevent.btnSubmit_Click(Object sender, EventArgs e) in C:\Documents and Settings\Nathan Sokalski\VSWebCache\www.webdevlccc.com\lvbeporgtest\createevent.aspx.vb:114 System.Web.UI.WebControls.Button.OnClick(EventArgs e) +108 System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +57 System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +18 System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33 System.Web.UI.Page.ProcessRequestMain() +1292 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:1.1.4322.2300; ASP.NET Version:1.1.4322.2300 I have used this same code before without any problems, what do I need to do differently? -- Nathan Sokalski njsokalski@hotmail.com http://www.nathansokalski.com/ Tag: Set Default Value SqlParameter Tag: 116637
  - 9
    - SQLClient Data access errror I have the following code: private int buildetcsforacctperiod(int iAcctPeriod, string szSEMS_User_ID) { SqlDataReader Reader; int iCounter; int iRows; int rtn; string szWBS_Number; iCounter = 0; szSQL = "sp_FCT_099_GetJobList " + "'" + szSEMS_User_ID + "', " + aryAPs[this.cmbAcctPrd.SelectedIndex].ToString() + ", 1"; cmd.CommandText = szSQL; da.SelectCommand = cmd; da.Fill(ds); iRows = ds.Tables[0].Rows.Count; if (iRows > 0) { cmd.CommandTimeout = 30; this.progressBar1.Maximum = iRows; while (iCounter < iRows) { this.progressBar1.Value = iCounter; szWBS_Number = ds.Tables[0].Rows[iCounter]["WBS_Number"].ToString(); if (szWBS_Number != "ABC-01-0000") { writelogfileentry("Creating ETC for: " + szWBS_Number); this.Text = "ETC Create - " + szWBS_Number; szSQL = "sp_FCT_099_GetWBSEstimate " + "'" + szWBS_Number + "', " + iAcctPeriod.ToString() + ", " + "'" + szSEMS_User_ID + "', " + "1"; writelogfileentry(szSQL); cmd.CommandType = CommandType.Text; cmd.CommandText = szSQL; oConn.Open(); cmd.ExecuteNonQuery(); oConn.Close(); } iCounter = iCounter + 1; } } this.Text = "ETC Create - Finished!"; writelogfileentry("ETC Create - Finished!"); return iCounter; } When the system encounters the line with the "ExecuteNonQuery" I get the following error: An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Any ideas as to why? Thanks, John Tag: Set Default Value SqlParameter Tag: 116631
  - 10
    - SQLClient Data Access Error An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. Tag: Set Default Value SqlParameter Tag: 116628
  - 11
    - How to get Number of columns in a dataset How do you get the number of columns in a dataset? I know that I can get the number of rows by: DataSetObj.Tables(0).Rows.Count. Also, how do I get the name of the column. I can get to the data by name DataSetObj.Tables(0).Rows(ktr).Item("Name") Is there a way to find out what the of a column(item) is if you don't know it? Thanks, Tom Tag: Set Default Value SqlParameter Tag: 116627
  - 12
    - getting the value of a datacolumn I have a combobox that list two items. Lets call it cbxCombo. I have a table extracted from an MS SQL database. This table has a column that will either be 1 or 2. If the value in the table is 1, the cbxCombo.SelectedIndex = 0. If the value in the table is 2 the cbxCombo.SelectedIndex = 1. How do I go about extacting that value from the column so that I can test it in an if statement. I'm using C# Ideally it would look something like this. if(dataset.datatable.Columns["column"] == 1) { cbxCombo.SelectedIndex = 0 } The data types in the "if" statements are different and I understand why it doesn't work. Question is how does one make it work. Tag: Set Default Value SqlParameter Tag: 116625
  - 13
    - HELP PLEASE - SQLDMO ERROR Hi, I am using SQLDMO in my application to create data tables, full-text catalogs and jobs to populate the catalogs. My datatables are created successfully but I get error on line where it says : Dim oSQLServer as SQLDMO.SQLServer oSQLServer = new SQLDMO.SQLServer I have added reference to SQLDMO library (Name: Interop.SQLDMO) in my project (VB.NET 2003, Framework 1.1) The error message is: System.RuntimeInteropServices.COMException (0x80040154) COM Object with CLSID {classId} is either not valid or not registered. Stack Trace points to line oSQLServer = new SQLDMO.SQLServer How do I fix this problem? (i.e. how do I register this COM object) I dont have this problem when I run my app from VS.NET Studio (so with machine with installed VS.NET) but it occurs on a machine without VS.NET) when I run the executable file inside bin directory (which also contains Interop.SQLDMO.dll file) Any help will be appreciated _dino_ Tag: Set Default Value SqlParameter Tag: 116624
  - 14
    - Getting Xml Data from String I have a proceedure that reads data from a Web Service. The data is sent back in a string. I can put this string into a Textbox, which works fine. I now need to get the data without the tags and was trying to use the ReadXml method of a DataSet object. Apparently, this only works with reading a file or datastream. How do I get the data into my DataSet from a string? Here is the program: *************************************************************************************** Dim GetInfo As New localhost.Service1 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Try Dim Companies As String Dim ktr As Integer Dim DataSetObj As New DataSet TextBox1.Text = GetInfo.GetCompanyInfo() DataSetObj.ReadXml(TextBox1.Text) Catch ex As Exception TextBox1.Text = ex.Message End Try End Sub ************************************************************************************** I get an error here that says: "The path is too long after being fully qualified. Make sure path is less than 260 characters." I thought that I could just pass the string, but this isn't the case (obviously). It thinks the xml is the file name. Is there a way to get the XML data (from the web service) directly into a string (or textbox as I have done) and then move it into the DataSetObj or directly from web Service into the DataSet Object? Thanks, Tom Tag: Set Default Value SqlParameter Tag: 116623
  - 15
    - using dataadapter.update changes the insertcommand.commandtext I have a dataadapter where i have changed the insertcommand.commandtext to have the following insert and select: "INSERT INTO my_table (col1) values (@p1); select scope_identity() as pk" I modify the dataset and perform an update on the dataadapter so the changes are reflected in the database like so: da.update(ds.tables("my_table").select(nothing, nothing, DataViewRowState.Added)) When I debug it, the dataset's identity column (pk) is not updated with what is in the database, and when I inspect the insertcommand.commandtext right after the update, I noticed that it has been truncated!! "INSERT INTO my_table (col1) values (@p1)" The select scope_identity portion is gone and hence my dataset's identity column is not updated. What's going on? Thanks! -Jerry Tag: Set Default Value SqlParameter Tag: 116613
  - 16
    - Adapter.Fill error I'm getting the following error on the Adapter.Fill method: A first chance exception of type 'System.NullReferenceException' occurred in system.data.dll Additional information: Object reference not set to an instance of an object. Here's the snippet of code: Friend Function Load(ByVal strSQL As String, ByRef DataSet As System.Data.DataSet, Optional ByVal strTableName As String = "") As Boolean Implements IBackendDataProvider.Load Dim SqlCommand As System.Data.SqlClient.SqlCommand Dim Adapter As New System.Data.SqlClient.SqlDataAdapter Dim DoWeClose As Boolean If Parent.ConnectionString.Length <> 0 Then DoWeClose = Parent.OpenConditional() If (DataSet Is Nothing) Then DataSet = New System.Data.DataSet End If SqlCommand = GetSQLCommandObject(strSQL) SqlCommand.CommandTimeout = Parent.CommandTimeout Adapter = New System.Data.SqlClient.SqlDataAdapter(SqlCommand) AddHandler Adapter.FillError, AddressOf FillError Try If strTableName.Length <> 0 Then Adapter.Fill(DataSet, strTableName) Else Adapter.Fill(DataSet) ' FAILS HERE - HIGHLIGHTED GREEN WITH ERROR ABOVE End If Catch Throw End Try RemoveHandler Adapter.FillError, AddressOf FillError Adapter = Nothing SqlCommand.Dispose() SqlCommand = Nothing Parent.CloseConditional(DoWeClose) End If End Function The Adapter.SelectCommand.Connection.State property is set to Open, so I am assuming that I infact have a valid SelectCommand, and that the connection is valid. I have even setup an event handler for the Adapter.FillError event (using AddHandler), but it doesn't step into that code - it simply throws the error. I can duplicate the error, but it doesn't happen the first time the method is called. I'm thinking it may be connection pool related, or maybe the connection is opened twice. However, the error is obscure. Tag: Set Default Value SqlParameter Tag: 116597
  - 17
    - ADO.NET, connection pooling and ASP.NET We're getting an occasional occurrence of the following error when two users try and open the same record in our ASP.NET app: "There is already an open DataReader associated with this Connection which must be closed first." As suggested, I was closing the connection in the Finally part of the outer Try but I wasn't closing the data reader as well so I assume that if the following happens, the above error could occur Try Open connection Open data reader Some operation causes the exception to fire Catch ex As Exception .. handle exception Finally Close the connection [data reader is still open here] End Try I've modified this to close the data reader as well in the Finally section but will have to wait until the next release to see if this resolves it. However, it raised a question about connection pooling, hence the post: Is connection pooling done in ASP.NET at a session, application or other level? When we look in SQL, we see various connections from the web server called ".Net SqlClient data provider". I understand the concept of connection pooling but what happens in the following situation: 1. User A opens web page causing an open connection, data read and close connection 2. Connection goes into the pool 3. User B opens same web page causing identical open connection, data read and close connection Does (3) re-use the connection opened by User A that's been put in the pool? Is the pooling by the aspnet_wp.exe process or against the user's session? Thanks, Rob. Tag: Set Default Value SqlParameter Tag: 116592
  - 18
    - Executescalar, retrieving a value From MSDN: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfSystemDataIDbCommandClassExecuteScalarTopic.asp Use the ExecuteScalar method to retrieve a single value (for example, an aggregate value) from a database. Public Sub CreateMySqlCommand(myScalarQuery As String, myConnection As SqlConnection) Dim myCommand As New SqlCommand(myScalarQuery, myConnection) myCommand.Connection.Open() myCommand.ExecuteScalar() myConnection.Close() End Sub 'CreateMySqlCommand ... Thanks Billy...ExecuteScalar is used to retrieve a single value, and then your example doesn't even reflect retrieving a value...hello! Anyone home? Ok, sarcasm aside, could someone expound on this flawed example that shows how a value returned from a stored procedure could be assigned to a variable expression? Thank you! :) Tag: Set Default Value SqlParameter Tag: 116586
  - 19
    - Form Load -> show form... then do stuff Right now I have a vb.net windows form project that does a whole bunch of things on the form.load event. The problem with this is that the user does not see the form until all the those things are done. Is there a way for a form to be shown first AND THEN have it automatically start to run through my code? (perhaps a different event??? form.paint, form.activate) Right now... the form is running but the user can't see it, and so they end up clicking on the application to run again and the user thinks the program is slow... AND WE CAN'T HAVE THAT!!!! :) I would like: Basically the form would load i would have a status bar that says "loading data"... and then the form would then show the data once it's loaded Any help would be greatly appreciated! Chris Thunell cthunell@pierceassociates.com Tag: Set Default Value SqlParameter Tag: 116578
  - 20
    - File format for a new application (I know it's a seond post, but I think I explain it better this way) -- On my own I'm writting an application for the general public. (a bit like word, except it has nothing to do with word ;-) So far I used an embeded database engine to store the data (SQLite), I like the concept because this way I could load/delete/updata whatever data I need incrementally on demand. And I could also easily perform search. What gets me more and more concerned is that creating a new (empty) file (with just about 10 table, 30 index & triggers) takes up to 7 seconds! Very bad user experience. I'm considering my options and will gladly takes advice as I'm a bit daunted by the work involve just to test. - I was thinking to try an other embeded database engine, such as Firefox. - I was thinking to use tar-gzipped serialized file (think XML serialization should be better as it would be probably be better at version resistance (but worst perf?)), but I was wondering about the wisdom of having all my data in memory... - any other ideas? Tag: Set Default Value SqlParameter Tag: 116569
  - 21
    - Request For Opinion (data file performance). I'm writing a program at home for general public which store its data in a datafile. Fearing the data loading could be long, I used an embeded datafile engine (SQLite), because this way I could read/write/delete file incrementally (unlike what I could do with tar-gzipped XML file for example). Now I'm hitting a problem: When I create a new (empty) file, the (embeded) 'database engine' tooks about 7 seconds to create a new database file with about 10 tables & 30 indexes & trigger. That's wayyyy too long. So here is what I'm considering and would appreciate input on: - maybe try the firefox embeded version to see if it's faster - maybe used a plain tar-gziped XML serialized file - maybe used a plain tar-gzipped-serialized data file - use an other (free or cheap and royalty free) embeded database engine my concerns are the following: - if I use serialization I want a given version of the application to be able to read file created by previous and later version, which comdemn to XML serialization, I believe - If I use serialization I am concern about long startup if I have a lot of data, and heavy memory usage. - If I choose a DB, I don't want MSDE.. I already would have a 20MB dependency on .NET 2.0, I find it overkill to bloat it even more with: 20 more MB, a server based product, where as I would like a zero-config, zero install concerns, embeded DB engine as a simple DLL. - I though of Firebird, will table & file creatin be fast? Well in fact I'm a bit in the dark.. but I hope you guys see my problem and if any of you has experience on similar topic I will appreciate feedback... Tag: Set Default Value SqlParameter Tag: 116567
  - 22
    - DataSet and MappingType Hi there, I've a problem with a DataSet in framework 2.0. In VS2003 I create a schema from my DataSet. For one attribute I used my own type. In VS2003 this works fine and I am able to load all corresponding xml-files. When I try to create the same DataSet in framework 2.0 I always get the error "Datatype myowntype should be mapped to MappingType.Element". Does anybody know what to do, to map a custom type to attribute? I dont't want to convert all corresponding xml-files. Thanks. Betina Tag: Set Default Value SqlParameter Tag: 116566
  - 23
    - I would learn ADO.NET 2.0 - There are Tutorials or online books? Dear friends I have installed visual basic 2005 beta 2 and sqlexpress 2005 and by video tutorial downloaded from visual basic express site I have created a very simple database application. This tutorial create database application utilizing IDE Wizard, instead I would learn to created it by program in VB.NET language. 1)Do you know the existance of free tutorial or book on ADO.NET 2.0? 2)Is SQLServer 2005 Online book good for my pourpose? 3)Is an old ADO.NET book good or ADO.NET 2.0 is very different Please reply me soon .... Thank for your patience Tag: Set Default Value SqlParameter Tag: 116565
  - 24
    - Thru Windows Service connecting to SQL server database using windows authentication Hi I am trying to connect to SQL server data base using NT authentication from my window service code. _bstr_t bstrConn = _bstr_t("PROVIDER=SQLOLEDB;SERVER=SD1;DATABASE=MEDICAPT;TRUSTED_CONNECTION=YES;"); m_pConnGenGuiDB->ConnectionString = bstrConn; m_pConnGenGuiDB->CommandTimeout = 600; m_pConnGenGuiDB->Open("","","", adConnectUnspecified); I am getting error Description = Login failed for user 'NT AUTHORITY\SYSTEM' The same code works fine in any MFC application. Any body have clue abt that Tag: Set Default Value SqlParameter Tag: 116564
  - 25
    - Problem getting table schema with OracleDataAdapter.FillSchema Hi, I'm getting table schema of all my database tables by calling FillSchema method of OracleDataAdapter class with SchemaType.Source option. It works correctly for all tables but one: debugging, the execution rests inside FillSchema method and never finishes (no exceptions, no timeout). Does anybody know any reason that makes happen this? Thank. Tag: Set Default Value SqlParameter Tag: 116562
- Next
  - 1
    - read only data fetching hi all i have some modules in my app.. reads data (always) i am using datareader and should i set any transaction and isolation level so that like specified in MSDN, lower isolation level will give lot of performance.. should i include a "select * from.." inside a transaction? i thought single sql statement does not require any transaction decl. pls clarify me regs sahridhayan Tag: Set Default Value SqlParameter Tag: 116561
  - 2
    - .net & Visual FoxPro error Hi Everyone, This is my code for making a connection to a Visual FoxPro free table and querying it. I get the following error message File iddxstrippunc.prg does not exist I have tested the dsn through access link tables and it seems to work fine. Any help would be appreciated. Thanks, V.V. ********************************************************* Dim oConn = CreateObject("adodb.connection") Dim mdconnString As String Dim MDWSql As String Dim oRS As ADODB.Recordset mdconnString = "Provider=vfpoledb;DSN=vfxpdsn" oConn.ConnectionString = mdconnString Try oConn.Open() ' Open VFP Connection If oConn.State = ADODB.ObjectStateEnum.adStateOpen Then MsgBox("Connection was Successful") Else MsgBox("Connection Failed") End If oConn.BeginTrans() MDWSql = "SELECT * FROM patients where externalid = ""CB1855""" oRS = oConn.Execute(MDWSql) Catch ex As Exception MsgBox(ex.Message) Close() End Try Tag: Set Default Value SqlParameter Tag: 116550
  - 3
    - Grouping?? Hello, I have a dataset that has rows with data that are all different. In some of the rows the "DescID" and "PlaceID" are the same, but primarilly they are all different. What I am trying to do is group all the rows that have the same DescID and PlaceID. If there are multiple rows with these two colomns being the same I need the Quantity Field to be increased by 1. IE ID DescID PlaceID Quantity 1 34D 81C 1 2 36P 81C 1 3 34D 81C 1 4 32F 14T 1 This should be the result after grouping them ID DescID PlaceID Quantity 1 34D 81C 2 2 36P 81C 1 3 32F 14T 1 Any suggestions will be greatly appreciated. The data will be saved to a SQL Database after this is accomplished. Thanks, Chuck Tag: Set Default Value SqlParameter Tag: 116540
  - 4
    - HasChanges does not change even after EndCurrentEdit() is called HELP! I am losing my mind. I can't figure this out. I have a dataset and a textbox that is bound to it. I edit the textbox value and click a button to submit the changes to SQL CE server. I call EndCurrentEdit(), and then I check the value of HasChanges(). I always get a false. What am I doing wrong? Here is the trimmed down version of the code. Please don't worry about the data adapter and changes to the DB. If I can get the HasChanges to work, then I think the data adapter will also work. ------------Begining of Code------------ ' In my form load sqlCnn =3D New SqlCeConnection("Data Source=3D" & mPath & file & "; Password=3D;") sqlCnn.Open() sqlCmdText =3D "Select * from TblClasses where termKeyID =3D 1 Order by class" sqlCmd =3D New SqlCeCommand(sqlCmdText, sqlCnn) da.SelectCommand =3D sqlCmd sqlCmdBld =3D New SqlCeCommandBuilder(da) da.UpdateCommand =3D sqlCmdBld.GetUpdateCommand da.InsertCommand =3D sqlCmdBld.GetInsertCommand da.DeleteCommand =3D sqlCmdBld.GetDeleteCommand da.Fill(ds, "TblClasses") TextBox1.DataBindings.Add("Tex=ADt", ds.Tables("TblClasses"), "class") ' End of Form ' My Button even Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click TextBox1.BindingContext(ds).En=ADdCurrentEdit() MessageBox.Show(ds.HasChanges(=AD)) End Sub ------------End of Code------------ I edit the text box, and click the button. The messagebox.Show(ds.HasChanges(=AD)) always returns a false. I can't get it work no matter what I do.=20 Please HEEEELP! Tag: Set Default Value SqlParameter Tag: 116534
  - 5
    - Connection to Oracle - Help Hi I'm new in ASP.NET I have TNSNAMES.ORA with all information I need I have the path of TNS_ADMIN correctely pointing to TNSNAMES.ORA folder This is true because I have no problems conecting to Oracle using VB 6 or VBA With ASP.NET I get always TNS error Did I miss something ? what's worng ? do I need a Project Reference like VB 6 ? thank you very much for any help My sample code is as follow : Imports System Imports System.Data Imports System.Data.OleDb Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim sConnectionString As String = "Provider=MSDAORA.1;User ID=v0efalm;password=cila01;Data Source=CEN;Persist Security Info=False" Dim mySelectQuery As String = "SELECT sysdate FROM dual" Dim myConnection As New OleDbConnection(sConnectionString) Dim myCommand As New OleDbCommand(mySelectQuery, myConnection) 'Set the parameter value. 'myCommand.Parameters.Add("@p1", OleDbType.Char, 5).Value = "Test%" 'Open connection to Oracle database. myConnection.Open() 'Populate the DataReader. Dim myReader As OleDbDataReader = myCommand.ExecuteReader() Dim RecordCount As Integer Try While myReader.Read() RecordCount = RecordCount + 1 Console.Write(myReader.GetString(0).ToString()) End While If RecordCount = 0 Then Console.Write("No data returned") Else Console.Write("Number of records returned: " & RecordCount) End If Catch ex As Exception Console.Write(ex.ToString()) Finally 'Close all objects. myReader.Close() myConnection.Close() End Try End Sub Tag: Set Default Value SqlParameter Tag: 116533
  - 6
    - The conneciton in DataAccess block Thanks, There are many other convenient function in DataAccessBlock like ExecuteDataset, ExecuteScalar, they all return some object or dataset.. I think they all must open a connection in their funciton. When I call them like: string cnnStr="..."; sCmd="Select .."; DataSet ds=ExecuteDataset(cnnStr, CommandType.Text, sCmd); Will it close the connection after return value? Tag: Set Default Value SqlParameter Tag: 116530
  - 7
    - BUG Found : DB2 OleDB Connections not closing with Framework v1.1 Problem : Calling .Close() or using {...} (or any combination or these) with a OleDBConnection does not close the connection to DB2. Solution : Uninstall Framework v1.1 Service pack 1 Using : IBM OleDB Provider version ("DB2 v8.1.6.574") Reproducible on W2k and XP. Any solution to this problem would be appreciated as SP1 fixes some other issues that I had but violates the connections. This is working at another client who is using an UDB Gateway to their DB2 with Framework 1.1 sp1 Thanks Johan Tag: Set Default Value SqlParameter Tag: 116528
  - 8
    - SQL Error - PLEASE HELP Hi, My app (VB.NET, .NET Framework 1.1) intalls database tables for a database. Then it is supposed to create full-text catalogs. It works well on my machine but not on another machine. here is error message I get: An unhandled exception of type 'System.Runtime.InteropServices.COMException' occured in microsoft.visualbasic.dll Additional informatioN: [Microsoft][ODBC SQL Server Driver][SQL Server]The sepcified @server_name (IPAddress) does not exist. I use within my code : dim oSQLServer = CreateObject("SQLDMO.SQLServer") oSQLServer.Connect(strServer, strUserID, strPassword) to create sqlserver object and connect to it in order to proceed with creating my full-text catalogs. As mentioned previously, this application works perfectly on my machine, but not on another. Any help will be appreciated _dino_ Tag: Set Default Value SqlParameter Tag: 116518
  - 9
    - Wii close connection? I have a function call MyExecuteNonQuery(see bellow) When I call it with some Sql command like: MyExecuteNonQuery("Delete from myTable); Will it close the conneciton which opened in MyExecuteNonQuery? ---------------------------------------------------------------------------- public int object MyExecuteNonQuery(string sSql) { string cnnStr="...."; SqlConnection cnn = new SqlConnection(cnnStr); SqlCommand myCommand = new SqlCommand(sSql, cnn); cnn.Open(); int iRV=myCommand.ExecuteNonQuery; return iRV; } /* Tag: Set Default Value SqlParameter Tag: 116514
  - 10
    - Question about DataAccess Block I user DataAccess Block in my progrm. http://www.microsoft.com/downloads/details.aspx?FamilyId=F63D1F0A-9877-4A7B-88EC-0426B48DF275&displaylang=en I often uses the code: string sSql="Select..."; string cnnStr="...."; SqlDataReader dr=SqlHelper.ExecuteReader(cnnStr, CommandType.Text, sSql); .... dr.Close(); Dose it will colose the connection when I close the SqlDataReader with dr.Close()? Tag: Set Default Value SqlParameter Tag: 116513
  - 11
    - How to change the value of timeout in program When usr process some data in program, it will result in time out. How to change the value of timeout in program? Tag: Set Default Value SqlParameter Tag: 116509
  - 12
    - Anyone have a DAL Generator? Hello everyone, Anyone out there have a DAL Generator Utility for sale for free that mimics what happens in the IDE designer when you drag a dataadapter onto a component? I like what MS did here, I just don't like the instantiation of all the objects on New(). They Do: Sub Initialize() da1 = new dataadapter da2 = new dataadapter sqlconn = new connection(someconnectionstring) selectcommand1 = new command .... I want to do readonly property da1 as dataadapter get if m_da1 is nothing then m_da1 = new dataadapter m_da1.connection = GetConnection 'Add transaction support if m_intransaction then dim cb as commandbuilder .... 'Add event handlers addhandler m_da1..... I have 40 tables, that is a lot of copy and paste, and too many chances to get it wrong and wind up chasing redherrings. Plus if I make and schema changes, I would have to manually correct the changes in my DAL. I have been playing with creating my own generator, and realized that they is way too much I don't know and understand about what goes on to make a generic tool nor do I have the time to get the tool to a point where I can use it for my application. I spent 4 days manually setting up my DAL more consistent with a format that I wanted. Now the business has come back with some additional changes and I must begin this arduous process again. Thanks in advance Tag: Set Default Value SqlParameter Tag: 116494
  - 13
    - Batch Statements I have used simple batch statments with C# (ans SQL Server 2000).for example: string select = "select model from cars where id = ?;select * from trucks where model = ?"; where ? is a parameter whose value i have before running the bach statment. I was wondering if it possible to use the value retuned in the first statement for the where clause in the second in the statment? TIA, Vinny Tag: Set Default Value SqlParameter Tag: 116493
  - 14
    - DataAdapter with different SQL's Hello, Created dataadapter select with this command "select * from emp where empid IN (123,456,789)"; Filled and sent dataset to remote client. lost original dataadapter Remote client works with the dataset and sends it back Created a new dataadapter select with this command "select * from emp where 1=2; (effectively a null set) populate the update/insert/deletes commands on the dataadapter based on the 2nd above select Called the Update method of the dataadapter. All changes get affected to the database. Question 1 : Can/should i create the dataset with one select command and at time of update create another select command based on a different sql. (i use this method as when i pass the dataset to the remote site i dont pass the parameters used to create the original sql, so at time of return i dont know/unaware of the original sql). Question 2 : Does this mean that dataadapter works in such a way that it needs only to know the end table & fields without knowing the original data associated, i.e. the dataset set has all the intellegence of old rows/newsrows contained in it. Thanks Ivan Tag: Set Default Value SqlParameter Tag: 116489
  - 15
    - Rowfilter on child recorsd only works with Fill Hello everybody, I have a dataset containing two related tables : Master, Detail. I have used the designer to create a form with two DataGridView. I want to filter parent records so that only those which don't have child records are listed. In the Form_Load, I have created a DataView (dv) with filter : "ISNULL(Count(Child.ID),0)=0" (where ID is the primary key of Detail). I then Fill the datatables : Master, Detail. I then set the Master DataGridView's datasource property to dv. The problem that I have : When the Form is launched, the filtering is correctly done. Now, if I had a row in Master, then add a child row to Detail, the parent row in Master is still there !!! Does the rowfilter only work at Fill time ? It doesn't work with creations/deletions in Master !! Is this a known bug ? I would prefer have this solution work that the workarounds described in the article Q321896 !! Tag: Set Default Value SqlParameter Tag: 116479
  - 16
    - Auto update data on RowChanged Hello, i want to auto update a datatable (SQLDataAdapter.Update(myDatatable) ) during RowChanged event It is possible? thanks wgn Tag: Set Default Value SqlParameter Tag: 116478
  - 17
    - Save Table in MSSQL Hello Group, In my application I create new DataTable (name : myTable). How save this table on sql server as myTable. Thx PawelR Tag: Set Default Value SqlParameter Tag: 116472
  - 18
    - Hierarchical data Hi I'm a VB6 developer tasked with taking a VB6 application and turning it into a .NET application. I'm just doing a bit of reading up at the moment... The VB6 application does a lot of queries returning hierarchical ADO recordsets, sometimes this goes as far as 4 chapters deep... This data is not simply bound to a display control, but the data programmatically iterated through and either the data manipulated or other tasks stared based on the values found. I'm after a quick "beginners" tutorial for handling hierarchical data and manipulating it in a VB.NET environment. Any suggestions? All help greatly appreciated. Thanks Griff Tag: Set Default Value SqlParameter Tag: 116471
  - 19
    - MSDE help I'm looking for help getting started with MSDE. Anyone have any suggestions? Tag: Set Default Value SqlParameter Tag: 116469
  - 20
    - BindingContaxt I am trying to insert a new record into a sql table, that has a field that is a key field. Before I can insert the record I get a message when the statement with the '***' is executed. is there a way to code around this??? MESSAGE: "System.Data.NoNullAllowedException: Colume 'taskid' does not allow nulls". I know this. What I do not understand is how the 'BindingContact' really works. Some of the code follows: CODE: DataRowView drvDetail; DataView vueDetail; public void EditDetail(CurrencyManager cm) { try { LoadData(); cbServices.DataSource = dvServices; cbServices.DisplayMember = "service-description"; cbServices.ValueMember = "service-nbr"; drvDetail = (DataRowView) cm.Current; vueDetail = drvDetail.DataView; *** this.BindingContext[vueDetail].Position = cm.Position; *** txtSON.DataBindings.Add("Text", vueDetail, "service-order-number"); txtTaskID.DataBindings.Add("Text", vueDetail, "taskid"); txtServiceDesc.DataBindings.Add("Text", vueDetail, "task-desc"); txtCompDate.DataBindings.Add("Text", vueDetail, "complete-date"); txtServiceCost.DataBindings.Add("Text", vueDetail, "task-cost"); - Norm Bohana Tag: Set Default Value SqlParameter Tag: 116465
  - 21
    - Emergency! Too Busy A Connection! Hi. I have a problem with an OLEDBConnection object that is supposed to serve for a number of clients that need data from my Access(mdb) database. These clients are placed in different threads and try to load data from this connection. The problem is that when the connection is retrieving data for one of them, another one may ask for data. This throws an InvalidOperationException with the following message: "ExecuteReader requires an open and available connection. The connection's current state is Open, Executing." I fully understand its meaning, but what can I do to solve this issue? I tried a delaying loop, checking to see if the exception occurs again in the loop, and repeating the operation again. Although I used Application.DoEvents (you know what that does) , but a loop takes all the CPU time available, and it seems to me that the whole operation becomes very very slow and surprisingly, memory consuming! Any one got an idea? Thank you all. Tag: Set Default Value SqlParameter Tag: 116464
  - 22
    - FUNCTION as DATASET I am trying to create a function that passes a Dataset. I know the code works because if I cut and paste it on my file in code behind it works fine. The actual task is to create the Dataset from a SQLDataAdapter within a function. Then I want to call the function to fill a dropdown list on my .aspx page. Here is the current code that I am using in the function. I am unaware of what I should be using on the .aspx page. Any and all help is appreciated. Public Function ShowRootFolders(ByVal ClientID As String) As DataSet Dim Connect As String Dim CompanyDataSet As DataSet Dim GetCompanys As SqlClient.SqlDataAdapter Connect = ConfigurationSettings.AppSettings("THE_Connection") Dim Connection As New SqlClient.SqlConnection(Connect) Connection.Open() GetCompanys = New SqlClient.SqlDataAdapter("Select * from rootfolders where clientID = '" + ClientID + "'", Connection) CompanyDataSet = New DataSet GetCompanys.Fill(CompanyDataSet, "AllTables") DMConnection.Close() Return ShowRootFolders Tag: Set Default Value SqlParameter Tag: 116460
  - 23
    - transaction with unknown nbr of commands Using vb.net for code behind on a asp.net application. I need to run a number of sqlcommands, based on user input. The commands need to run as a single transaction. The commands are all stored procedures. How do I do this? I was thinking that I could build an array of the sqlcommands, but I do not see how to do it. I looked at arraylist, but still not sure. Maybe the question could be stated as: When I run a sqlcommand in a transaction, does the sqlcommand need to persist, or can I just reuse it to run another stored procedure within the same transaction? Tag: Set Default Value SqlParameter Tag: 116455
  - 24
    - SQL debugging I have setup my project for SQL debugging. I get the error message Unable to start SQL Debug session. Ensure SQLDBREG2.exe and Proxy/stub dllsqldbg.dll are registred on this machine. How do I get these registered? Tag: Set Default Value SqlParameter Tag: 116453
  - 25
    - Object reference not set to an instance of an object - Exception in System.Data.OracleClient Hello NG, We are facing sometimes the following exception ... Object reference not set to an instance of an object. ------------------------------ Stack Trace ------------------------------ at System.Data.OracleClient.DBObjectPool.GetObject(Object owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnectionPoolManager.GetPooledConnection(String encryptedConnectionString, OracleConnectionString options, OracleConnection owningObject, Boolean& isInTransaction) at System.Data.OracleClient.OracleConnection.OpenInternal(OracleConnectionString parsedConnectionString, Object transact) at System.Data.OracleClient.OracleConnection.Open() at Philips.Phoenix.PhoenixAgent.StandardWebForm.Page_Load(Object sender, EventArgs e) ... when executing this code: ... DbCon = New System.Data.OracleClient.OracleConnection(ConfigurationSettings.AppSettings("OracleConnectionString")) DbCon.Open() ... The exception only occours sometimes, but as soon as it occours once it's appearing more and more, with the result that the application is no longer responding. Is this a known issue? Are there any ideas to work arround that ? Thanks and Regards MBO Tag: Set Default Value SqlParameter Tag: 116452

Hi,

For any of the microsoft guys :
Is there a way to tell ADO.Net to use a default value from the stored
procedure ?
I know the only way to do it is to not create the default parameter at all
in the command but i am looking for an elegant solution to tag it to use the
default value from the sproc. Query analyzer supports the 'default' keyword
is there an equivalent in ADO.Net ?

Thanks!

Top

Re: Set Default Value SqlParameter by William

William
Thu Sep 01 16:33:14 CDT 2005

I'm only a former Microsoft guy, but I'll bet some of the Microsoft gals
could answer this as well... ;)
To get ADO.NET to get the SP to use the server-side defined default value
you need to either:
1) Skip the parameter and not add it to the Parameters collection.
2) Set the Value property of the Parameter object to Nothing in VB.NET or
Null in C#.

hth

--
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

"Vish" <Vish@discussions.microsoft.com> wrote in message
news:BF3249C0-4F50-4C43-8392-FF8D34E80C16@microsoft.com...
> Hi,
>
> For any of the microsoft guys :
> Is there a way to tell ADO.Net to use a default value from the stored
> procedure ?
> I know the only way to do it is to not create the default parameter at all
> in the command but i am looking for an elegant solution to tag it to use
> the
> default value from the sproc. Query analyzer supports the 'default'
> keyword
> is there an equivalent in ADO.Net ?
>
> Thanks!

Top