updating a decimal

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
    - Switch Columns And Rows Hi, I wander if it's possible to retrieve a recordset but switch rows and columns I've a table with the fields ar_id, cr_id, ar_st the table is filled with the folowing records [1], [01], 0 [1], [02], 1 [1], [03], 1 [2], [02], 0 [2], [03], 1 I want to transform this somehow into [1], [01], 0, [02], 1, [03], 1 [2], [02], 0, [03], 1 Is this possible via sql or ado.net? Kind Regards Tag: updating a decimal Tag: 105184
  - 2
    - Reading a dataset into XML I have a table in my SQL Server that I am loading into a datatable. I am then saving the dataset that this table is a member of (it's the only table in the dataset) to an XML file so that I can use it offline in another part of my program. The code I use for this is: ds.WriteXML("c:\clients.xml") 'DS is my dataset object This generates an XML file like the following (the entire XML file is included in this post at the end of the message) <?xml version="1.0" standalone="yes"?> <ClientData> <Clients> <c_recordid>1</c_recordid> <c_name>NOL</c_name> </Clients> <Clients> <c_recordid>2</c_recordid> <c_name>TCG</c_name> </Clients> .more clients. </ClientData> In another part of my program, which is designed to use when you're offline and can't connect to the SQL server, I want to reload this information back into a datatable. I do so using the following code: ds = New DataSet("ClientData") ds.ReadXml("c:\clients.xml") dt = ds.Tables("Clients") Next, I try to refer to a specific row in the Clients data table in the following manner: Dim rows as datarow() = dt.select("c_recordid=" + clientid.tostring) 'ClientID is an integer being passed to the subroutine Try Dim row as datarow = rows(0) Catch ex as Exception Msgbox ex.tostring End Try Because c_recordid is the unique key for the table, I know that only one row will be returned - hence I can logically refer to row(0). However, when I call the subroutine setting the ClientID variable to 2,3.10, or 11, I get the following exception when referring trying to access rows(0): System.IndexOutOfRangeException: Index was outside the bounds of the array. This does not happen when I set ClientID = 1,4,5,6,7,8, or 9. I know all of these are valid because I've looked at the XML file in it's entirety. I've checked for strange characters that might be messing it up and haven't found anything - all in all, I thought it would be an easy process, but the only thing that is consistent is the ClientID's I can't access. Can anyone direct me to what I'm doing wrong, or what might be causing this thing to blow up? I'd appreciate any help. One last thing. I HAVE written a little subroutine to loop through each row in the datatable. Dim r as datarow For each r in dt.rows Msgbox r(0) 'Msgbox's the clientid column (1-11) Next r This works fine. I see all 11 clients when I loop through them, but cannot use the .select method to consistently get a particular one. Thanks, Chet Here is the XML file in it's entirety: <?xml version="1.0" standalone="yes"?> <ClientData> <Clients> <c_recordid>1</c_recordid> <c_name>NOL</c_name> </Clients> <Clients> <c_recordid>2</c_recordid> <c_name>TCG</c_name> </Clients> <Clients> <c_recordid>3</c_recordid> <c_name>CHN</c_name> </Clients> <Clients> <c_recordid>4</c_recordid> <c_name>CNT</c_name> </Clients> <Clients> <c_recordid>5</c_recordid> <c_name>CityNet</c_name> </Clients> <Clients> <c_recordid>6</c_recordid> <c_name>IFN</c_name> </Clients> <Clients> <c_recordid>7</c_recordid> <c_name>IU</c_name> </Clients> <Clients> <c_recordid>8</c_recordid> <c_name>Lilly</c_name> </Clients> <Clients> <c_recordid>9</c_recordid> <c_name>Plainfield</c_name> </Clients> <Clients> <c_recordid>10</c_recordid> <c_name>St. Vincent</c_name> </Clients> <Clients> <c_recordid>11</c_recordid> <c_name>IFW</c_name> </Clients> </ClientData> Tag: updating a decimal Tag: 105180
  - 3
    - Values being formatted differently when opening spreadsheet using ado.net I have a some-what simple app for importing data from excel to our database. The app is written in C# and uses ado.net. When I open the xls file, it displays in a grid to show the values. The problem is values are formatted differently depending on the machine. I have 2 machines. One the first one (excel installed) I open the xls file and all values display as decimal even though in excel there displayed as percents. This is fine and how I want it. On the second machine (excel not installed) the values display as percents. What can cause the difference in formatting? Thanks, Joe Tag: updating a decimal Tag: 105179
  - 4
    - How to display different data Here is what I'm trying to do, I have a database table with columns: ColA ColB ColC ColD ColE 1 AAA BBB xxx yyy x 2 111 xxx 222 yyy y ... I want to display in a web form ColA, ColB if the ColE of the row I'm getting having value "x", display ColA, ColC if ColE="y". So if user searches for row 1: ColA AAA ColB BBB if user searches for row 2 ColA 111 ColC 222 ColD yyy What is the best way to make it work? Do I need to have different data controls and display one of them depending on the data returned (my real problem will consist of quite a few cases)? (Is there a way of displaying the data at the run time?) This just seems to be someting that is easy accomplished in ASP but I don't know how to do it in aspx. Give me some example code will really help. TIA. Tag: updating a decimal Tag: 105175
  - 5
    - Concurrency Violation Help I have a dataset that contains 2 datatables. When I change a record and try the update command it gives me this error... Concurrency violation: the UpdateCommand affected 0 records. at System.Data.Common.DbDataAdapter.Update(DataRow[] dataRows, DataTableMapping tableMapping) at System.Data.Common.DbDataAdapter.Update(DataTable dataTable) Here is the code: SqlConnection con = new SqlConnection(strCon) ; try { con.Open() ; daAllSigns = new SqlDataAdapter(sqlAllSigns,con) ; SqlCommandBuilder cb = new SqlCommandBuilder(daAllSigns) ; daAllSigns.Fill(dsGrids,"AllSigns") ; daQueSigns = new SqlDataAdapter(QueSigns,con) ; daQueSigns.Fill(dsGrids,"QueSigns") ; // Change record dsGrids.Tables["AllSigns"].Rows[3]["Sign_Brand"] = "TEST BRAND" ; dsGrids.Tables["AllSigns"].Rows[3]["Sign_SignDesc"] = "TEST DESC" ; daAllSigns.Update(dsGrids.Tables["AllSigns"]) ; catch(Exception exc) { Debug.WriteLine(exc.Message + " " + exc.StackTrace) ; } Does anyone know why this error could be coming up, the code seems pretty straight forward to me.... Tag: updating a decimal Tag: 105167
  - 6
    - getting return values from stored procedures I need to get a return value from the procedure that follows. For some reason I am not able to asign a value to @returnval and get it back to the C# code executing it. The procedure does not return any errors. Here is the code: ALTER PROCEDURE gradeTest2 @empid int, @testid int AS set nocount on declare @returnval int set @returnval=1 declare @correct int declare reader cursor fast_forward for select answercorrect from questionsanswered where (empid=@empid) and (testid=@testid) open reader fetch next from reader into @correct while @@Fetch_Status=0 begin if @correct=0 set @returnval=0 fetch next from reader into @correct end close reader deallocate reader begin if @returnval=1 if not exists (select testid from testresults where (empid=@empid) and (testid=@testid)) insert into testresults (testid,empid,results,testdate) values (@testid,@empid,@returnval,getdate()) else update testresults set results=@returnval,testdate=getdate() where (empid=@empid) and (testid=@testid) if @returnval=1 delete from questionsanswered where (empid=@empid) and (testid=@testid) return @returnval end *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! Tag: updating a decimal Tag: 105164
  - 7
    - SQLClient Exception - Retrying Upon executing a stored procedure using the Data Access application block's SQLHelper class, I would like to continually retry to execute it every 1 second up to 3 times if an exception occurs. For example, if for some reason the database server is down, a timeout occurs, etc. I would like to automatically retry a certain number of times before giving up. What is the best way to accomplish this? Below is what I envision (pseudo-code): Dim Retries As Integer = 0 Dim Try '// execute database command here SQLHelper.ExecuteNonQuery(...) Catch ex AS SQLException If Retries <= 3 Then Sleep(1000) SQLHelper.ExecuteNonQuery(...) End If End Try The problem I have with the code above is that I have duplicate code (SQLHelper.ExecuteNonQuery(...)). The other problem I have, is what happens when an exception occurs in the Catch block? Any help would be greatly appreciated. Thanks, Shawn Tag: updating a decimal Tag: 105161
  - 8
    - too much for stored procedure execution Hi, I'm trying to write efficient C# code to execute a stored procedure. The stored procedure takes in 5 arguments. I'm doing a foreach loop to write a lot, and I mean a lot of data to the DB. Is the following the most efficient and best way to write tons and tons of data into the DB using a stored procedure that required 5 arguments? Remember the code below is called numerous times. foreach (MyClass obj in CollectionOfObjects) { try { SqlCommand cmd = new SqlCommand("MyStoredProcedure",sqlcon); cmd.CommandType = CommandType.StoredProcedure; SqlParameter param; param = cmd.Parameters.Add("@first_name", SqlDbType.VarChar); param.Value = obj.first_name; param = cmd.Parameters.Add("@last_name", SqlDbType.VarChar); param.Value = obj.last_name; param = cmd.Parameters.Add("@a", SqlDbType.Int); param.Value = obj.a; param = cmd.Parameters.Add("@b", SqlDbType.Int); param.Value = obj.b; param = cmd.Parameters.Add("@c", SqlDbType.Int); param.Value = obj.c; cmd.ExecuteNonQuery(); } catch {} } Thanks Tag: updating a decimal Tag: 105159
  - 9
    - Patterns And Practices [Copied from microsoft.public.dotnet.languages.csharp, no answer up to now and probably was wrong group anyways] I downloaded the patterns and practices enterprise library and found that it is much different for the Data library that I am used to (SqlHelper)..It's not just an update but a total rewrite. Anywho, figured out how to get it to work which wasn't too hard. What I haven't found and am having trouble with is updating and inserting into a database. In the SqlHelper library, there were methods such as ExecuteScalarTypedParams and such which allowed all parameters to be inside a dataset and you just passed the dataset. This was great because all of our data access routines returned a dataset. We would just modify the data and pass this same dataset/table/row back to the SqlHelper method and it would get updated using our stored procedures in Sql Server. Now, afaik, there are no methods which take a dataset for parameters. I have to manually created the parameters, one by one and then add them to the collection. Is there a better way, maybe they do exist but I haven't seen them? Anywho, I could always write a method in my applications that would take a dataset and build the parameters based on column name, column data type, and compare vs the stored procedures, but if it already exists, I don't want to reinvent the wheel. Thanks in advance, Mythran Tag: updating a decimal Tag: 105152
  - 10
    - Unknown Query Engine Error Forgive me if this is the wrong forum for this question, but I'm not really sure where I should ask it. I am using Crystal Reports to produce a report against a SQLServer database. Up until 2 weeks ago, the report worked fine. No event was noticed that might explain why the report stopped working, but now running it produces an error "Unknown Query Engine Error". The datasource is a stored procedure joined to a view and 2 tables. I don't know the EXACT connection string that Crystal Reports is generating, but it would be you should be able to get the idea from this: SELECT vwCurrentFacilityInfo.FacilityName, tblItem.DecalNumber, tblPerson.LastName FROM dbo.spPropertyTagLetterItems() LEFT OUTER JOIN dbo.tblItem ON dbo.spPropertyTagLetterItems.ItemID = dbo.tblItem.ItemID LEFT OUTER JOIN dbo.vwCurrentFacilityInfo ON dbo.spPropertyTagLetterItems.ParentID = dbo.vwCurrentFacilityInfo.FDEPFacilityID LEFT OUTER JOIN dbo.tblPerson ON dbo.vwCurrentFacilityInfo.SiteManagerID = dbo.tblPerson.PersonnelID As I said, this worked until 2 weeks ago, and STILL works if I try generate the report against the a copy of the database residing on a different server ((local) on my development machine). Any ideas? Thanks, Pat Tag: updating a decimal Tag: 105151
  - 11
    - store rtf in C# How I can store rtf format in SQL Server. (C#) Tag: updating a decimal Tag: 105147
  - 12
    - OleDbDataAdapter.Fill Error ("The provider could not determine the Object value) ADODB.Recordset Hi, I am trying to fill a DataSet using an ADODB.recordset: OleDBDataAdapter.Fill(DataSet, Recordset, "Table1") This works fine in most part but on other occasions I get the error below: "The provider could not determine the Object value. For example, the row was just created, the default for the Object column was not available, and the consumer had not yet set a new Object value." This seems to be a data issue, as when the recordset is empty then no error occurs but the the fields are correct in the DataSet. What does this error mean and are there any ways around it? Help is appreciated, Leroy. Tag: updating a decimal Tag: 105143
  - 13
    - Using apostrophe in DataTable.Select() Hi, I'm using the dataTable.Select() method in my code. This is my code: dft.Tables[0].Select("fieldName='" + @fieldName + "'") ; This works fine until there is an apostrophe in the fieldName variable - then i get error message: "Syntax error: Missing operand after ...". How can i use queries with apostrophe inside? Thanks. Tag: updating a decimal Tag: 105132
  - 14
    - Big Problem Hi, Hi testing the Visual Studio 2005 Beta 2, i'm developed one application and save this project, when close the visual studio and reopen in another time with the application i produce this error OBJECT REFERENCE NOT SET TO AN INSTANCE OF AND OBJECT LINE 0 COLUMN 0 And not is possible open the project Thanks in advance Euclides Tag: updating a decimal Tag: 105130
  - 15
    - single large vs multiple small SP calls - speed + efficiency I have a collection of objects (eg Forms) , each of which contains another collection (eg Controls). When I come to fill the Control collections at startup, I fill each one in turn using a Form.GetControls(FormID) call. This puts the call where I think it is best placed (In the Form class), but am unsure about the efficiency of it. Would I be better off making one "global" call, retuning all the Controls and then filling each of the Form.Controls collections. I know I could probably test it somehow, but does anyone know what the best way to do it would be? Ideas welcome. Thanks Tag: updating a decimal Tag: 105129
  - 16
    - Exception raised by the DataAdapter Configuration Wizard Hi, For a few days now, I've been unable to complete the Sql/OleDataAdpater = conf wizard on VS .NET 2003 Architect. The message is : "the object = reference is not defined on an object instance". Exception is raised by = function = Microsoft.VSDesigner.Data.VS.VsConnectionManager.CheckConnection(Int32 = index, ProviderNameInfo)... Any hint ? Oriane Tag: updating a decimal Tag: 105123
  - 17
    - DataSet with multiple relations to Hi! I'm using a typed dataset where I have a common address table which is related to several other tables in the dataset, see below: Table Incident: - PK - FK_incidentAddress - relation to Address.PK - FK_destinationAddress - relation to Address.PK ... Table Person: - PK - FK_homeAddress - relation to Address.PK ... Common table Address - PK - Street - City .... If I use one Address entity in the dataset, I guess that I'll get problems as one row in Address can not satisfy all the relations specified. If I instead create multiple Addresses which I give different names, and the relate each of them to their parent, I get ConstraintExceptions when trying to enable constraints in the dataset after merging the child rows. It seems like it is the rename of a Address table that creates my problem. Any tips? Brgds Jonas Tag: updating a decimal Tag: 105122
  - 18
    - Access Security Issue I get the following error message when I attempt to called query which resides in my Access DB (Stored procedure), "Operation must use an updateable query". I looked at the KB article which addresses this error and it indicates that I need to change the security on the folder and the file which contains my access Db. I went into the folder and and the file and change the "IUSR" account to "Full access". But this did not resolve the issue. When I look at the file permissions of the directory, I see the "Deny" greyed out but checked for "Special Permissions" and "Write". the "Special Permissions" is not checked for "Allow" and it is checked for "Special Permissions". Is this the way it is suppose to be? Any ideas as to what else I should look at so that I can do an update on the Access DB? Thanks in advance for your assistance!!! Tag: updating a decimal Tag: 105113
  - 19
    - constraint message box Hi, I have a dataset containing constraints. (not null, and size constraints on table columns). When the constraint is violated, a message box appears showing the constraint violation. Is there any way to catch these constraint violations WITHOUT doing one of the following: 1) disabling the constraints and manually checking - because what is the point of that? If I wanted manual checks I wouldn't bother with fillschema or specifying the constraints at all. 2) installing a thread exception handler and parsing the exception message, because different database languages and collation orders will break it, not to mention foreign windows versions (A requirement in our case). Is there any way of handling these constraints, I am even happy to inherit and override the dataset. What method in the dataset actually pops up this rediculous message without providing a developer hook to customise or handle the error? Surely the clever boys at Microsoft did not just write code to pop up a message without thinking that we might have other plans for the error message. Regards Craig Tag: updating a decimal Tag: 105111
  - 20
    - OleDb Namespace I have one web project in which I have OleDb Namespce listed with intellisence and in other projects my variables have to be declared using the entire namespace (i.e. System.Data.OleDb.OleDbConnection). All projects have sytem.data.dll reference. I just can't figure out what I have done to make the OleDb namespace readily available in the one project? I'd like to do it for all. Tag: updating a decimal Tag: 105104
  - 21
    - dr.Read() Hello Everyone: I have a feeling this is very basic, and something I am just overlooking. The dr.Read() ALWAYS is being translated to false in the code below. I print out the sSQL statement using the watch window, and paste that into Query Analyzer: and I confirm the data does indeed exist. What am I missing? Why, regardless of the data, does my dr.Read() alway equal false? ----------------------------------------------------------------------------------------------- CODE SNIPPE ----------------------------------------------------------------------------------------------- sSQL = "SELECT i_OrderID FROM tOrder WHERE sPOrder = " + sPONumber; SqlConnection oConn = new SqlConnection(connStr()); SqlCommand oCommand = new SqlCommand(sSQL, oConn); oConn.Open(); SqlDataReader dr = oCommand.ExecuteReader(); if(dr.Read()) { ...Code Removed } else { ...Code Removed } Tag: updating a decimal Tag: 105091
  - 22
    - DataSet object not releasing memory Hi, I'm encountering a strange phenomenon whereby a DataSet object is not releasing its memory when it's being disposed and/or set to Nothing. It is part of a Windows service written in VB.NET which fetches data out of a mySQL database, interrogates each row individually and takes various actions accordingly. It can fetch upwards of 300,000 rows, each of which vary between 1k and 2k in size, making the resulting DataSet object almost 500Mb in size. This in itself is not much of a problem, except that when the service has finished working with the DataSet, it does not release the memory it has been using. I'm using it in what appears to me at least to be a fairly standard way (code at the end of this post). What do I have to do to free up the memory allocated to the DataSet object? I've even tried running System.GC.Collect(), though that expectedly made no difference. Any assistance gratefully received. Mark Rae Option Explicit On Option Strict On Imports CoreLab.MySql Imports System.Collections Imports System.Data Imports System.Xml Public Function Import(pstrMySQLConnectString As String, pstrSQL As String) As Boolean Dim objMySQL As New CMySQLCoreLab(pstrMySQLConnectString) Dim objMySQLDS As DataSet objMySQLDS = objMySQL.GetDataSet(pstrSQL) For Each objRow As DataRow in objMySQLDS.Tables(0).Rows ' ' do the processing ' Next objMySQLDS.Dispose objMySQLDS = Nothing objMySQL.Dispose objMySQL = Nothing End Function Tag: updating a decimal Tag: 105090
  - 23
    - Changes in a DataGrid don't always take Why is it when a new row is added in the datagrid and the user clicks a save button that GetChanges() returns null unless they move to another record first? Tag: updating a decimal Tag: 105088
  - 24
    - MS Access DB structure I need to find out the structure of MS Access database; tables, queries and so on. How can I do that? Direction or sample code would work. Thanks to everyone in advance. Tag: updating a decimal Tag: 105083
  - 25
    - AutoCommit - Oracle. If you call a stored procedure which is an update procedure, is it autocommitted by default? Is the same true for an Oracle Stored procedure? If you call an Oracle Stored procedure with the defaults for the connection, and the stored procedure has a rollback, I am getting an error which indicates that I can not do a rollback on a distributed transaction. How can I call a stored Oracle Procedure and be able to issue a rollback within the stored procedure without getting and error in ADO.Net when I do this? Tag: updating a decimal Tag: 105076
- Next
  - 1
    - Cant connect to local sql server 2000 from VB.NET running WinXP Pro SP2 Hi I just installed SQL Server 2000 to run locally on a WinXP Pro SP2 PC. When I run the following VB.NET code: Protected Const SQL_CONNECTION_STRING As String = _ "Server=localhost;" & _ "DataBase=Northwind;" & _ "Integrated Security=SSPI" Dim connectionString As String = SQL_CONNECTION_STRING Dim cnnNW As New SqlConnection(connectionString) I can't connect to sql server. This code works fine on a Windows 2000 Pro SP2 pc. Thanks. Dee Tag: updating a decimal Tag: 105075
  - 2
    - Remote connection to access database Is it possible to connect remotely to access database? If is, how? Any idea is appricited. Tag: updating a decimal Tag: 105044
  - 3
    - Retrieving data from dataset with multiple tables Hi! Having problems with retrieving data from MS Access through a dataset with multiple tables. It works fine when I'm only using two tables in the dataset, but when I want to access data through a second table (three tables in all) it doesn't work! This is the error message I get: "An unhandled exception of type 'System.Data.OleDb.OleDbException' occurred in system.data.dll Please help Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: updating a decimal Tag: 105040
  - 4
    - renaming a access table in ado .net hi, i need to rename a table in a access database, within ado .net. is that doable with a ExecuteNonQuery sql command applied to a OleDbConnection, if so what would the command be, i can't find any documentation for it? is it done thru a SchemaTable? what then would be code. i tried SchemaTable.Rows(RowCount)!TABLE_NAME = "tblNewName", but it is read only. thanks for any help ray Tag: updating a decimal Tag: 105038
  - 5
    - Auto Number Seed ? How can I reset or change the value of autonumber in MS Access ? Doesn't it have the function like NEXTVAL or CURVAL as in Oracle ? Or is autonumber field more rigid ? Or is it possible to make sequence in Access so I can manually do it ? Tag: updating a decimal Tag: 105032
  - 6
    - Enterprise Library, DataSets, and Windows Forms binding. Okay so I'm using the Data Access application block in the Enterprise Library. I'm using it to return a DataSet from an SQL Server (well, MSDE) stored procedure. So that's an untyped DataSet. I have no access to the DataAdapter used to retrieve the DataSet (the Enterprise Library classes don't expose it AFAIK), so I can't create any TableMappings. I want to bind the DataSet to Windows Forms controls, but I'm getting the old 'cannot create child list' errors because there's no schema attached to the DataSet. I can manually name tables and columns in the DataSet via the Tables collection, and then bind. This is messy though, so: 1) Is that the only way to do it? 2) If I retrieve the DataSet, then use WriteXMLSchema, can I subsequently use that saved schema against the returned DataSet? 3) This must be a very common thing that people need to do - why is is such a pain in ADO.NET? Tag: updating a decimal Tag: 105031
  - 7
    - Default value of a Table in Sql server To default value in DataSet scheme hello I wanted to ask how to get the default value defined in the DataBase, to be defined as the default value in the DS scheme? and if there isn't a way, how else can i do that? thanks. Tag: updating a decimal Tag: 105030
  - 8
    - Oracle and ASP.NET I have a Solution with 3 projects: 1- Data Access: A library with all class to acces to the DataBase 2- A Windows Forms Project that uses the library 1 to view data from the Data Base. 3- A ASP.NET project like the windows project. The problem is that the project 2 works but not he 3. In the ASP.NET project show this error: ORA-12154: TNS:no se ha podido resolver el nombre de servicio It can't be a problem with the Connection String neither the TNSNames because the windows project works. The Oracle directory allow Execute, Read and list to the users ASPNET, IWAM and IUSR Sorry for my English and many thanks Tag: updating a decimal Tag: 105023
  - 9
    - Using Interfaces I am still struggling to understand the usage of Interfaces in an attempt to make a provider independent data access layer. My question is this...if I create a connection from an interface that is specfic to a data prvoider, will the remaining objects created from interfaces and based on the connection object automatically be of the same provider type? For example, does this work.... (Note: strConnect and strSql set elsewhere based on the desired dbType and action) Dim conn As IDbConnection Dim cmd As IDbCommand Dim da as IDbDataAdapter dim ds as DataSet Select Case dbType Case "SQL" conn = New SQLCommand(strConnect) Case "OleDB" conn = New OleDBCommand(strconnect) End Select cmd = New IDbCommand(strSql, conn) da = New IDbDataAdapter(cmd) da.Fill(ds, "SomeTable") TIA, John Tag: updating a decimal Tag: 105018
  - 10
    - sp returns wrong value with VB.net function I don't know what's happening here. I can run the sp in query analyzer and (using PRINT) see that it returns a positive record number (ie., user is authenticated). But when I run this function on that sp it returns -1. I used EM's SQL profiler and can see that it's returning -1, there, too. But the same inputs in query analyzer returns 2, a passing authenticate. How can I see what's being sent to SQL server? I have SQL debugger turned on, but ... Function DBAuthenticate( strUsername As String, strPassword As String ) As Integer Dim conMyData As SqlConnection Dim cmdSelect As SqlCommand Dim parmReturnValue As SqlParameter Dim intResult As Integer conMyData = New SqlConnection("workstation id=W2000;packet size=4096;integrated security=SSPI;data source=W2000;" & _ "persist security info=False;initial catalog=trythis") cmdSelect = New SqlCommand( "DBAuthenticate", conMyData ) cmdSelect.CommandType = CommandType.StoredProcedure parmReturnValue = cmdSelect.Parameters.Add( "RETURN_VALUE", SqlDbType.Int ) parmReturnValue.Direction = ParameterDirection.ReturnValue cmdSelect.Parameters.Add( "@username", strUsername ) cmdSelect.Parameters.Add( "@password", strPassword ) conMyData.Open() cmdSelect.ExecuteNonQuery() intResult = cmdSelect.Parameters( "RETURN_VALUE" ).Value conMyData.Close() If intResult < 0 Then If intResult = -1 Then lblMessage.Text = "Username Not Registered!" Else lblMessage.Text = "Invalid Password!" End If End If Return intResult End Function This code is from Sam's ASP.Net Unleashed 2nd edition. I've had to tweak a few other things, but this looks like it should work. TIA, Patrick psully at eatel dot net ps: here's the sp CREATE PROCEDURE DBAuthenticate ( @username Varchar( 100 ), @password Varchar( 100 ) ) As DECLARE @ID INT DECLARE @actualPassword Varchar( 100 ) SELECT @ID = IdentityCol, @actualPassword = u_password FROM UserList WHERE u_username = @username IF @ID IS NOT NULL IF @password = @actualPassword RETURN @ID ELSE RETURN - 2 ELSE RETURN - 1 GO Tag: updating a decimal Tag: 105017
  - 11
    - sp does not return right value but query analyzer does sorry if this is a repsot, but I can't see my 1st post. Lost my connection in the middle of posting I don't know what's happening here. I can run the sp in query analyzer and (using PRINT) see that it returns a positive record number. But when I run this function on that sp it returns -1. I used EM's SQL profiler and can see that it's returning -1, there, too. But the same inputs in query analyzer returns 2, a passing authenticate. How can I see what's being sent to SQL server? I have SQL debugger turned on, but ... Function DBAuthenticate( strUsername As String, strPassword As String ) As Integer Dim conMyData As SqlConnection Dim cmdSelect As SqlCommand Dim parmReturnValue As SqlParameter Dim intResult As Integer conMyData = New SqlConnection("workstation id=W2000;packet size=4096;integrated security=SSPI;data source=W2000;" & _ "persist security info=False;initial catalog=trythis") cmdSelect = New SqlCommand( "DBAuthenticate", conMyData ) cmdSelect.CommandType = CommandType.StoredProcedure parmReturnValue = cmdSelect.Parameters.Add( "RETURN_VALUE", SqlDbType.Int ) parmReturnValue.Direction = ParameterDirection.ReturnValue cmdSelect.Parameters.Add( "@username", strUsername ) cmdSelect.Parameters.Add( "@password", strPassword ) conMyData.Open() cmdSelect.ExecuteNonQuery() intResult = cmdSelect.Parameters( "RETURN_VALUE" ).Value conMyData.Close() If intResult < 0 Then If intResult = -1 Then lblMessage.Text = "Username Not Registered!" Else lblMessage.Text = "Invalid Password!" End If End If Return intResult End Function This code is from Sam's ASP.Net Unleashed 2nd edition. I've had to tweak a few other things, but this looks like it should work. TIA, Patrick psully at eatel dot net ps: here's the sp CREATE PROCEDURE DBAuthenticate ( @username Varchar( 100 ), @password Varchar( 100 ) ) As DECLARE @ID INT DECLARE @actualPassword Varchar( 100 ) SELECT @ID = IdentityCol, @actualPassword = u_password FROM UserList WHERE u_username = @username IF @ID IS NOT NULL IF @password = @actualPassword RETURN @ID ELSE RETURN - 2 ELSE RETURN - 1 GO Tag: updating a decimal Tag: 105015
  - 12
    - What's the best way to insert new records only Hi, Every morning a .NET application downloads a file with cumulative data which needs to be appended to SQL Server table. This program needs to identify records that have not been previously inserted (there's a unique identifier field) and only insert those. Also I must reuse our class that does updates, it basically can update any table by using SqlDataAdapter .update method. So I have to rule out bulk inserts, DTS, etc... I think I have little choice but to load all records first to a "temp" table and then append only new records (where not exists) to a "real" table. Can anyone think of a better solution? Thank you. Tag: updating a decimal Tag: 105003
  - 13
    - Need to suppress DataColumnCollection Events during construction of typed DataSet We have a wide typed dataset and we profiled our app that constructs it many 1000s of times and it turns out that the constructor is the most expensive part of our app. We dug in deeper and it seems the constructor spends most of its time in the datacolumncollection and especially in the events that fire as columns are added. I need some ideas on how to construct the typed dataset faster. Either suppress the event or some other trick. Thanks Costas Tag: updating a decimal Tag: 104990
  - 14
    - ResultSet size (in KB) In my DB layer, I have a monitoring tool. This tool logs every access to the database, and writes out the SQL and the time it takes to get the results. I want to add another important figure: the size of the result. It's obvious that an answer of one single integer is completely different from a dataset of thousends of rows with several columns. So far, I only found the "RowSize" attribute of OracleCommand, which is not enough for my need. Any idead how to obtain this data ? Posted Via Usenet.com Premium Usenet Newsgroup Services ---------------------------------------------------------- ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY ** ---------------------------------------------------------- http://www.usenet.com Tag: updating a decimal Tag: 104988
  - 15
    - problem updating Access database with values from formatted cell Hello, I have a DataGridView with a textbox column which is bound at design time to a DateTime field from a database. Also at design time I set the Format value of this CellStyle like "yyyy", so that I only get the year displayed. How can I write only the year in the textbox and push a newly generated DateTime variable back to database? (like DateTime dt = new DateTime(int.Parse(e.Value.ToString()), 12, 12);). Everything that I tried resulted in an exception in PushFormattedValue (at the bottom). Currently the code that handles cell parsing is: if (dataGridView1.Columns[e.ColumnIndex].Name == "DateYear") { DateTime dt = new DateTime(int.Parse(e.Value.ToString()), 12, 12); string s_Date = dt.ToShortDateString(); dataGridView1.CurrentCell.Style.Format = null; e.Value = s_Date; MessageBox.Show(e.Value.ToString()); (here it shows a normal string like 12/12/2005 which if it is inserted like this it doesn't generate any error!) e.ParsingApplied = true; } even if this executes ok I still get the data error to fire... Any ideas? Tag: updating a decimal Tag: 104983
  - 16
    - connection error, user data wrong I installed the Community Starter kit earlier today and fooled around with it. And I also reinstalled the dot net framework sdk. I already had MSDE installed as w2000\netsdk, but have it disabled, set for manual startup. I have sql server 2000 installed as default (local) and always on. Now I am trying to get an aspx page to check website login and/or registration info through SQL2k stored proceedures, and get a failed login for "user w2000\netsdk", but my login is supposed to be integrated security, user = "". This is a little confusing, I am not having problems with the asp.net login page, just the connection to SQL server to CHECK the saved user names/passwords in database "trythis." I've never seen this problem before. I uninstalled Community Starter and deleted the w200\netsdk login on sql server, but it still tries to use it. Here is my login string: connData = New SqlConnection("workstation id=W2000;packet size=4096;integrated security=SSPI;data source=W2000;" & _ "persist security info=False;initial catalog=trythis") TIA Patrick psully at eatel dot net Tag: updating a decimal Tag: 104978
  - 17
    - problem with insert stored procedure I'm getting a syntax error on the following stored procedure and I need another set of eyes. It's bombing at the @SurveyNameID=SurveyNameID line Any help would be appreciated. CREATE PROCEDURE insAnswers @SurveyNameID int, @SurveyQuestionID int, @firstName varchar (50), @lastName varchar (50), @email varchar(50), @questionOneText varchar(100), @questionOneValue int, @questionOneComments text, @questionTwoText varchar(100), @questionTwoValue int, @questionTwoComments text, @questionThreeText varchar(100), @questionThreeValue int, @questionThreeComments text AS insert into SurveyAnswers VALUES ( @SurveyNameID=SurveyNameID, @SurveyQuestionID=SurveyQuestionID, @firstName=firstname, @lastName=lastName, @email=Email, @questionOneText=QuestionOneText, @questionOneValue=QuestionOneValue, @questionOneComments=QuestionOneComments, @questionTwoText=QuestionTwoText, @questionTwoValue=QuestionTwoValue, @questionTwoComments=QuestionTwoComments, @questionThreeText=QuestionThreeText, @questionThreeValue=QuestionThreeValue, @questionThreeComments=QuestionThreeComments ) GO Tag: updating a decimal Tag: 104970
  - 18
    - Passing in SqlConnection by ref Hello, Here's the scenario: Object A opens a Sql Db connection to execute number of SqlCommands. Then it needs to pass this connection to a constructor of object B which in turn executes more commands on the same connection. I have an understanding that if SqlConnection is passed as "value" (unboxed), object B will create its own copy of SqlConnection, so when object A closes its connection, it remains open for object B's copy. Is this correct? Is not the right way to pass it by ref? What are "the best practices"? Thank you. Tag: updating a decimal Tag: 104969
  - 19
    - referenceing non asp: items in code behind I'm writing a html file upload using Visual Studio and asp.net VB and using code behind. The vb file is not reconizing the html elements as it does the <asp: element. I know the studio is generating the references for the asp item and not the html items. How and where do i define them so that i can compile the source? thanks!!! kes Tag: updating a decimal Tag: 104966
  - 20
    - DataBindings and SelectedValue Hi, I use VS2003 and C# with windows form. I have one combobox bind to an Objsourcelist (CollectionBase) who contains some ObjSource object with "Description" and "ID". -------------------------------------------------------------------------- cmbFLSOURCE.DataSource = Objsourcelist; cmbFLSOURCE.DisplayMember = "Description"; cmbFLSOURCE.ValueMember = "ID"; --------------------------------------------------------------------------- When I run the form, everything is display ok, so I can see objsource description values. However, when I add binding to the dataset for the SelectedValue using my dataset table "Expense.fl_source" which match the valueMember "ID", it never display the corresponding value Description, and display blank value. Others fields bind to the same dataset show the right information. ---------------------------------------------------------------------------- Binding b; b = cmbFLSOURCE.DataBindings.Add("SelectedValue", myDSexpense, "Expense.fl_source"); ----------------------------------------------------------------------------- Is there anything missing? Thanks in advance. CB Tag: updating a decimal Tag: 104961
  - 21
    - Wrraping Command Object I'm Working on generic DAL component which can deal with all kind of providers like SqlClient, SqlCe, OleDB, Odbc. I was wrapping the command object with my own class that inherit from IDBCommand and this class is holding instance of real command object (like SqlCommand, OleDbCommand). The problem is when I want to perform an update operation using DataAdapter and equivalent command object the DataAdapter reject my IDBCommand object with the following exception: "Update requires a valid InsertCommand when passed DataRow collection with new rows." I thought to inherit the concrete command (class MyCmd: SqlCommand) but all those command are sealed. Does anyone have any idea? Thanks. Bnaya Eshet C.T.O Wise Mobility. Tag: updating a decimal Tag: 104957
  - 22
    - cmd.Parameters.Add(new OleDbParameter NOT TAKING ??? Hello, I can't get the below update to work. Here's what I know.. If I enter fixed strings in the update it works. The response.write displays show good and updated values in the s strings. However, only the @chain cmd.Param gets set, all others,like @responsible either never get set or remain as they were. Strangley, I have this code in another subroutine whree I'm adding a brand new record and it works fine. I've copied the block of working text in and view the source in hex and everything looks fine. I need another pair of eyes. THANK YOU. Public Sub UserGrid_Update (Source As Object, E As DataGridCommandEventArgs) Dim objConn as new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=x.mdb") Dim cmd As OleDbCommand = new OleDbCommand ("UPDATE tbl SET status=@status, responsible=@responsible WHERE chain=@chain", objConn) Dim schain As String = e.Item.Cells(2).Text Dim sresponsible As String = CType(e.Item.Cells(3).Controls (0), TextBox).Text Dim sstatus As String = CType(e.Item.Cells(4).Controls (0), TextBox).Text Dim swaitingon As String = CType(e.Item.Cells(5).Controls (0), TextBox).Text Dim scomments As String = CType(e.Item.Cells(6).Controls (0), TextBox).Text response.write(schain+"-"+sresponsible+"-"+sstatus+"-"+swaitingon+"-"+scomments) cmd.Parameters.Add(new OleDbParameter("@chain", schain)) cmd.Parameters.Add(new OleDbParameter("@responsible", sresponsible)) cmd.Parameters.Add(new OleDbParameter("@status", sstatus)) cmd.Parameters.Add(new OleDbParameter("@waitingon", swaitingon)) cmd.Parameters.Add(new OleDbParameter("@comments", scomments)) objConn.Open() cmd.ExecuteNonQuery() objConn.Close ' UserGrid.EditItemIndex = -1 BindData() End Sub Tag: updating a decimal Tag: 104952
  - 23
    - Search for SQL servers Every one has different SQL database path. How do you make your application adaptable to this. Is there a way a program can automatically search for sql server on the network? Thanks HS Tag: updating a decimal Tag: 104946
  - 24
    - Update more than 1 table in a DataSet using SqlDataAdapter.Update Hello, In the past I used SqlCommandBuilder and SqlDataAdapter .Update method to apply changes in a DataTable back to its table source in SQL Server. It worked fine when DataSet had only 1 table, this time I have 2 tables in a dataset and I want to update them all at once. However it only updates the first one and fails when attempts to update 2nd table.. Has anyone done anything like that? It looks like SqlCommandBuilder generates insert command only for the first table. Here's the most relevant code, if it helps: //command that gets 2 tables structure SqlCommand commandClosedEnd = new SqlCommand("select f1, f2 from table1 where 1=2\r\nselect f1, f2 from table2 where 1=2", connClosedEnd); commandClosedEnd.CommandType = CommandType.Text; DataSet dsClosedEnd = new DataSet(); SqlDataAdapter daClosedEnd = new SqlDataAdapter(); daClosedEnd.SelectCommand = commandClosedEnd;//select command daClosedEnd.Fill(dsClosedEnd); //gets 2 tables /* Code inserts new rows to both tables */ //Generate insert command SqlCommandBuilder cmndBuild = new SqlCommandBuilder(daClosedEnd); daClosedEnd.InsertCommand = cmndBuild.GetInsertCommand(); //should genereate for 2 tables, but it doesn't //update all 2 tables -- updates the first 1 and breaks on the second foreach (DataTable tblUpdate in dsClosedEnd.Tables) { daClosedEnd.Update(dsClosedEnd); } Please help!!!! Tag: updating a decimal Tag: 104944
  - 25
    - Opening Excel worksheet missing cell values When I open a worksheet and display it in a grid some cells are empty that are populated when opening it in Excel. First I noticed that some of these cells had formulas so I tried saving the xls as csv and opening it but then I get the missing ISAM error. I then resaved it as a xls file. This got rid of the formulas but the cells are still empty in the DataGrid yet populated in Excel. Any ideas? Tag: updating a decimal Tag: 104943

Hallo,

could you help with this problem?
Updating an integer, as tring ok, but a decimal ??
Update tblprice Set article = ' " & this & " ' WHERE ...
what signs do I have to put?
Thx for helping me

Hyphessobrycon

Top

Re: updating a decimal by Miha

Miha
Tue Feb 15 15:13:07 CST 2005

Hi,

You should really learn to use parameters - just google for them or check
out .net help files - from both ease of use and security perspectives.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
www.rthand.com
SLODUG - Slovene Developer Users Group www.codezone-si.info

"Hyphessobricon" <symphysodon@telenet.be> wrote in message
news:%23vobOF6EFHA.2600@TK2MSFTNGP09.phx.gbl...
> Hallo,
>
> could you help with this problem?
> Updating an integer, as tring ok, but a decimal ??
> Update tblprice Set article = ' " & this & " ' WHERE ...
> what signs do I have to put?
> Thx for helping me
>
> Hyphessobrycon
>

Top