Lookup tables

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
    - Slef Referencing Data Relation Problem.. I've got a strongly typed dataset, one of the tables in the dataset has a UID column ( integer, primary key ) and a TIER_ID column ( integer, nullable ). TIER_ID references UID, but when I add a data relation to do this the fill method hangs.. The top level record has a TIER_ID of NULL it seems that this is causing the problem, if I update TIER_ID on this row so its not null it solves the problem, but causes alot of junk in the dataset as somewhere along the line you have to have a row with the same UID and TIER_ID, which means you end up withodd rows in the dataset. Has anyone ever come across this ? is there a solution ? TIA Mark Tag: Lookup tables Tag: 91286
  - 2
    - Server Error in '/test' Application. Hi, I am using an SQL parameter in my SQL statement, I have never done this before ans it seems to be retuning an error saying that the parameter '@ID' must be declared, I know I am close, could someone have a look at it form me please? cheers lads Moe Dim DS As New DataSet() Dim sqlCMD as new sqlCommand sqlCMD.parameters.add(New SqlParameter("@ID", SqlDbType.Int, 4)) sqlCMD.parameters("@ID").value = PersonID Dim strConnect As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) Dim objSQLAdapter As New SQLDataAdapter("SELECT FROM table WHERE person= @ID", strConnect) objSQLAdapter.Fill(DS, "table") Server Error in '/test' Application. ---------------------------------------------------------------------------- ---- Must declare the variable '@ID'. Tag: Lookup tables Tag: 91283
  - 3
    - Run ado.net application from network share requires FullTrust permission set? This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C462E0.D5FA17F0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there any way to get an assembly to run from a network share with = less than FullTrust permission set? I've tried adding SQL Client = permission to the permission set that's assigned to the LocalIntranet = but that I still get a SecurityException thrown for SqlClientPermission. Here's the error: An unhandled exception of type 'System.Security.SecurityException' = occurred in system.data.dll Additional information: Request for the permission of type = System.Data.SqlClient.SqlClientPermission, System.Data, = Version=3D1.0.5000.0, Culture=3Dneutral, = PublicKeyToken=3Db77a5c561934e089 failed. I've also tried signing the assembly and granting it LocalIntranet + SQL = Client, Everything or FullTrust permissions. The only way it will run = correctly is if I give it the FullTrust permission set. Is it possible = to run an ado.net application without assigning the FullTrust permission = set? ------=_NextPart_000_0008_01C462E0.D5FA17F0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.3790.118" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#d8d0c8 background=3D""> <DIV><FONT face=3DArial size=3D2>Is there any way to get an assembly to = run from a=20 network share with less than FullTrust permission set?  I've tried = adding=20 SQL Client permission to the permission set that's assigned to the = LocalIntranet=20 but that I still get a SecurityException thrown for=20 SqlClientPermission.<BR><BR>Here's the error:<BR>An unhandled exception = of type=20 'System.Security.SecurityException' occurred in = system.data.dll<BR>Additional=20 information: Request for the permission of type=20 System.Data.SqlClient.SqlClientPermission, System.Data, = Version=3D1.0.5000.0,=20 Culture=3Dneutral, PublicKeyToken=3Db77a5c561934e089 failed.<BR><BR>I've = also tried=20 signing the assembly and granting it LocalIntranet + SQL Client, = Everything or=20 FullTrust permissions.  The only way it will run correctly is if I = give it=20 the FullTrust permission set.  Is it possible to run an ado.net = application=20 without assigning the FullTrust permission set?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0008_01C462E0.D5FA17F0-- Tag: Lookup tables Tag: 91281
  - 4
    - Business Layer and Data Layer application blocks Hi, A doc about a set of components making a "Business Layer and Data Layer application blocks" is available at http://www.sabbasoft.com/myBlog/PermaLink.aspx?guid=070a8c55-b885-4b89-8f3a-a23801fb732e You might be interested in reading it to get new ideas for your development process. As return I'll appreciate if you post me back any comment you might have regarding this doc. Best Regards-- Enrico Sabbadin Mail: sabbadin@sabbasoft.com Website: http://www.sabbasoft.com ******** MTS - COM+ - VBCOM - Enterprise Services - Security FAQ .NET & COM+ books selected list ******** Blog: http://www.sabbasoft.com/myblog Affiliated Sites http://www.vb2themax.com http://www.codearchitects.com Tag: Lookup tables Tag: 91274
  - 5
    - Example Search Form Required Hi, I have a table named "Person" in a MSDE (2000) database, and am building a search form comprising of search fields on the top section (forename, surname, telephonenumber, etc) which all correspond to columns to search in the database. I'm relatively new to ADO.net and haven't the foggiest about where to start, and need a good example to take apart and learn relatively quickly. Does anyone have code or know of a good place to look? I've checked out MSDN and the free vb code sites, but no-one has a flexible search form that I could reuse. Any ideas? Kind Regards, -- Liddle Feesh *fap fap fap fap* <>< <>< <>< <>< ><> <>< <>< <>< <>< <>< <>< Tag: Lookup tables Tag: 91273
  - 6
    - Revisiting the issue of "Filling the dataset with a table with same name as in another class" My original post asked the question: what happens when you declare a datatable with the same name in Class1 as you used in Class2? As Miha pointed out, "DataSet won't be gc-ed until you drop all references to it .. while you have at least one living reference DataSet instance will be there." And Kevin Yu answered that, "If you still hold some reference to the object, you have to fill the DataTable with other names, because the original table is still in it." Excellent advice and duly noted. Here's the issue however. I fill the DS with a dtSupply table in lets say Class1. I clear this table out of the DataSet in Class2 before filling the DataSet with a table with the the same dtSupply name as I used in Class1. The schema for these two tables differs ... but the schema for the Class1 table stays in the DataSet ALSO! So while I can populate a table in Class2 with different data for the same table, the table SCHEMA itself remains in the DataSet despite being cleared from the DataSet. From a practical standpoint, this is a non-issue with what I am currently working on, as it is easy enough to simply use a different name for the tables. But I am curious if there is a "schema-clear" method for the datatables within the dataset? Tag: Lookup tables Tag: 91272
  - 7
    - Opening a backend database from two different applications I have a front end database application in MS Access 2000, which for purposes of discussion has an administrative part and a user part. I recently decided to experiment with trying to move the user part of the front-end, which services about 70 people to a .net application. I've implemented both a form and web version. My intent for the time being is to leave the administrative part which is more involved in MS Access which is used by only a couple of people. The problem I'm running into is that multiple instances of each application (.net or MS Access) can access the backend database using individual connections as long as only that application is used, however if either application tries to open the backend database while the other application has an open connection it will complain about the backend being locked (or file already in use). Does anybody understand why the files would only be locked files when accessed by different applications? Have I encountered a limitation with MS Access or is there a setting or work around that would allow me to use both front-end applications simultaneously? Thanks for any input Steven W Tag: Lookup tables Tag: 91271
  - 8
    - Problems configuring DataAdapter to use stored procedure This is a multi-part message in MIME format. ------=_NextPart_000_002D_01C46297.CB232B80 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to use the Data Adapter Configuration Wizard to configure a = sqlDataAdapter to access a SQL Server database via the "Use existing = stored procedures" option. On the "Bind Commands to Existing Stored = Procedures" page of the wizard, setting the "Select:" dropdown to this = stored procedure does not bring up a schema, and pressing the "Finish" = button to complete the configuration generates the following messages: = "Generated SELECT statement" and "Failed to get schema for this stored = procedure." =20 Is the fact that the stored procedure uses dynamic commands built from a = string (executed via EXEC) the problem here?=20 =20 Thanks, RD ------=_NextPart_000_002D_01C46297.CB232B80 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 6.00.2800.1400" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY> <DIV> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial = size=3D2>I am=20 trying to use the Data Adapter Configuration Wizard to configure a=20 sqlDataAdapter to access a SQL Server database via the "Use existing = stored=20 procedures" option. On the "Bind Commands to Existing Stored Procedures" = page of=20 the wizard, setting the "Select:" dropdown to this stored procedure does = not=20 bring up a schema, and pressing the "Finish" button to complete the=20 configuration generates the following messages: "Generated SELECT = statement=94 and=20 <SPAN style=3D"mso-spacerun: yes"> </SPAN>"Failed to get schema for = this=20 stored procedure."</FONT></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><?xml:namespace = prefix =3D o ns =3D=20 "urn:schemas-microsoft-com:office:office" /><o:p><FONT face=3DArial=20 size=3D2> </FONT></o:p></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial = size=3D2>Is the=20 fact that the stored procedure uses dynamic commands built from a string = (executed via EXEC) the problem here? </FONT></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><o:p><FONT = face=3DArial=20 size=3D2> </FONT></o:p></P> <P class=3DMsoNormal style=3D"MARGIN: 0in 0in 0pt"><FONT face=3DArial = size=3D2>Thanks,=20 RD</FONT></P></DIV></BODY></HTML> ------=_NextPart_000_002D_01C46297.CB232B80-- Tag: Lookup tables Tag: 91269
  - 9
    - Solid ODBC Connection thru XML Web Service I'm testing a SOLID connection using the ODBC .Net Provider, from a Windows Application i put two buttons, Local and Web Service. In local i put this code: Dim sCNX As String "dsn=WebODBC;uid=xxxx;pwd=xxxx;" Dim oC As New OdbcConnection(sCNX) oC.Open() oC.Close() This code executes without problems, from the Web Service button i create a proxy pointing to a XML WS with only one method, the code is: Dim sCNX As String = "dsn=tcp localhost 1313;uid=xxxx;pwd=xxxx;" Dim oC As New OdbcConnection(sCNX) oC.Open() oC.Close() But the open method generates the next error: Microsoft.Data.Odbc.OdbcException: ERROR [IM002] Couldn't find data source name or driver not specified. Please, if somebody can, helpme. T.I.A. *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Lookup tables Tag: 91268
  - 10
    - Data Type Help I am wirting a VB program, and use the following code in a form load event Dim prm38 As OleDb.OleDbParameter = _ dap3.UpdateCommand.Parameters.Add("@total_points", _ System.Data.OleDb.OleDbType.Integer, "total_points") prm38.SourceColumn = "total_points" And Receive the following Error: An unhandled exception of type 'System.InvalidCastException' occurred in microsoft.visualbasic.dll Additional information: Cast from string "total_points" to type 'Integer' is not valid. I am using an Access database field total_points is a number field type integer Help. Tag: Lookup tables Tag: 91267
  - 11
    - DataSet DataTable Question I have a winform with a text field in it. I would like to be able to save the value in the text field to a XML file so that the next time I open the Winform I can get the value from the XML file and populate my field. I am guessing as to exactly what to do but what I have done is as follows: I created a dataset in my project by right clicking on the project and selecting add, new dataset. I called it SaveParams01.XSD. There I added an element, called it CompanyName and called it a string. I put a button on my form where my intention is to get the value in a textbox on the form called TextBox1 and then write that value out to and XML file Called SaveParam.XML. I know how to get the value from the text box and how to write the dataset to an xml file. The code for doing so I list below. But I do not know how to do the rest. Do I need to create a table and somehow associate it with the dataset? Either to the dataset or to the datatable associated with the dataset I need to add a row I suppose and assign the value from TextBox1.text to it, but even after looking at the books I do not know how to write the code to actually do this. Could someone help me. Dim CompanyName As String CompanyName = TextBox1.Text ??????? DS.WriteXml("SaveParam.xml", XmlWriteMode.WriteSchema) Tag: Lookup tables Tag: 91254
  - 12
    - Help with Index is out of the bounds of the array issue. Hi There, I have been batleing with this now that I'm at the end of my rop here. What I'm doing here is this; 1 - retrieving some data from the database with a data reader (with a search criteria) 2 - Filling a listbox with the data retrieved with the data reader 3 - draging items out of the listbox and dropping them into a text box (simple names) The error I'm getting is on the mouse down event. When a press the left mouse button to start the drag event, it gives an error saying that the "index is outside the bounds of the array" now this is the code I'm using; Private Sub lstResultScheduler_MouseDown(ByVal sender As System.Object, ByVal e As System.Windows.Forms.MouseEventArgs) Handles lstResultScheduler.MouseDown If e.Button = MouseButtons.Left Then If lstResultScheduler.Items.Count = 0 Then Exit Sub 'invoke the drag and drop operation This is the line of code where is failing **** lstResultScheduler.DoDragDrop(lstResultScheduler.SelectedItem.ToString, DragDropEffects.Move Or DragDropEffects.Copy) ***** End If End Sub Does anybody knows why I'm getting this Problem? Thanks for your help. Manny Tag: Lookup tables Tag: 91253
  - 13
    - Naming the Tables in the DataSet returned by stored procedure Greetings I have a SQL Server stored procedure that performs several queries and therefore creates several "result sets". Wiring it up via ADO.NET I get a DataSet with a number of items in the Tables collection. This is exactly what I want, but I'd like to assign names to these "result sets" in the stored procedure so that I don't have to access these Tables by index number in the code. Apologies if this is really a SQL Server question. Thanks Stuart (gingerbbm) Tag: Lookup tables Tag: 91250
  - 14
    - Problem with updating database from a dataset (row recently deleted) Hi I'm using ASP.Net (VS2003). I think this is more an ADO Question. I've just deleted a row from a dataset and I want to update the database from the recently altered dataset. It's not working.... Can you skim down the code, look at the comments below please? Many thanks Alex ' 'SqlDeleteProducts ' Me.SqlDeleteProducts.CommandText = "DELETE FROM [Products Assigned to Contacts] WHERE (ProductContactID = @ProductContactID)" Me.SqlDeleteProducts.Connection = Me.SqlConnection1 Me.SqlDeleteProducts.Parameters.Add(New System.Data.SqlClient.SqlParameter("@ProductContactID", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "ProductContactID", System.Data.DataRowVersion.Original, Nothing)) CType(Me.DsContactsX1, System.ComponentModel.ISupportInitialize).EndInit() CType(Me.DsContactIndex1, System.ComponentModel.ISupportInitialize).EndInit() CType(Me.DsProductsAssignedToContacts1, System.ComponentModel.ISupportInitialize).EndInit() '''''''''''''''''' 'Find position in dataset Dim rowDelete As DSProductsAssignedToContacts.Products_Assigned_to_ContactsRowrowDelete = DsProductsAssignedToContacts1.Products_Assigned_to_Contacts.FindByProduct_ProductContactID(e.Item.Cells(2).Text) ' Find position in dataset rowDelete.Delete() DGProducts.DataBind() ' This works so far, row has now visibliy deleted from my datagrid DGProducts 'From here downwards it doesn't work, I am merely trying to update the ' database from the dataset 'I get error "Prepared statement '(@ProductContactID int)DELETE FROM '[Products Assigned to Contact' expects parameter @ProductContactID, 'which was not supplied." 'It seems to ignore the very next line, 'I've tried chopping it out and it doesn't work either. 'I'm supplying the correct parameter aren't I? SqlDeleteProducts.Parameters("@ProductContactID").Value = CInt(e.Item.Cells(2).Text.ToString) DAProductsAssignedToContacts.Update(DsProductsAssignedToContacts1) Please help! Thanks Alex Tag: Lookup tables Tag: 91249
  - 15
    - ADO.Net locking rows on read I have a VB .Net COM+ component running a stored procedure on a SQL Server 2000 DB. If the stored procedure is executed within Query Analyser it takes in the order of three seconds to complete, however when accessed from my component it hits a 5 minute timeout when retrieving the rows (in the order of 30,000 rows). Further investigation points the finger at ADO .NET locking/unlocking each row of data its returning (which Query Analyser isnâ??t doing). An example profiler from the database followsâ?¦ Lock:Acquired .Net SqlClient Data Provider user1 dom\user1 0 0 57 2004-07-05 13:29:03.380 Lock:Acquired .Net SqlClient Data Provider user1 dom\user1 0 0 57 2004-07-05 13:29:03.380 Is there some way of turning off this locking â?? it only needs to be a read-only query. Thanks Gavin Tag: Lookup tables Tag: 91245
  - 16
    - I need advice on disconnected clients Hi all I want to develop a client which only connects to a server in order to synchronize data. The idea is that the user will see a smaller view of the whole database (only items relevant to themself) and may then add new items, update, delete, etc. Eventually connecting to a middle tier which checks their changes and sync's with the main database. I don't want the user to be online and have to "check out" items first, they should just be able to edit them immediately and then go through some kind of reconciliation process. Is ADO .NET the technology to use? Can I enforce some minor business constraints on the client using ADO .NET? Does ADO .NET have a "prohibit" for a delete rule, I see cascade etc but no prohibit? Does anyone know of any good resources I can look at? Articles, components, etc? Thank you very much -- Pete ------- Read/Write .NET articles http://www.howtodothings.com/showarticles.asp?subcategory=132 Tag: Lookup tables Tag: 91238
  - 17
    - Full DataTime field not returned in DataSet Hi, I am filling a DataSet with a SQL command the selects certain columns from a table. One of the columns is a DataTime in SQL with a precision of 8. In the SQL Server database, the complete datatime structure is filled including hours, minutes and seconds. The problem is when I fill the dataset, the DateTime column's value is short datetime (i.e. no hours, mins, secs - only month, day , year) . Does anyone know why I'm not getting the complete datatime value? Thanks Tag: Lookup tables Tag: 91230
  - 18
    - connection.dispose() must i call connection.dispose() or the close() method is enough, on my sql server i see many connections created. TIA, z. Tag: Lookup tables Tag: 91228
  - 19
    - running msde200a When I attempted to run an example proved by FrameWork.NET SDK 1.1, I received this from the compiler: SQL Server does not exist or access denied. 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.Data.SqlClient.SqlException: SQL Server does not exist or access denied. Source Error: Line 38: Line 39: // Open the connection. Line 40: myConnection.Open(); Line 41: Line 42: // Assign the connection property. Source File: C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\QuickStart\howto\samples\adoplus\executingacommand\cs\executingacommand.cs Line: 40 Stack Trace: [SqlException: SQL Server does not exist or access denied.] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +484 System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +372 System.Data.SqlClient.SqlConnection.Open() +384 HowTo.Samples.ADONET.executingacommand.Run() in C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\QuickStart\howto\samples\adoplus\executingacommand\cs\executingacommand.cs:40 ASP.executingacommand_aspx.Page_Load(Object Src, EventArgs E) in C:\Program Files\Microsoft Visual Studio .NET 2003\SDK\v1.1\QuickStart\howto\samples\adoplus\executingacommand\cs\executingacommand.aspx:12 System.Web.UI.Control.OnLoad(EventArgs e) +67 System.Web.UI.Control.LoadRecursive() +35 System.Web.UI.Page.ProcessRequestMain() +731 This is what I receive when attempting run example. I am using virtual machine on a xp professional os. What must I do to have the the sample program see the sql database ? -- cool Tag: Lookup tables Tag: 91221
  - 20
    - Combo Box Problem Hi Guys, I Have some strange problem while adding items to the Combo Box=2E= it shows "System=2EData=2EDataRow" as diplay Memeber=2E I am getting= data into a DataTable from Database through query "Seelct= Source,SourceID from SourceTable" and setting Valuemember as= "SourceID" and Display member as "Source" of combobox through= VB=2ENET Designer=2E then I am adding data to Combo box through a loop for that= Datatbale because I have to add a Blank row first =2E=2Elike=2E=2E combobox=2Eitems=2Eadd("") for i=3D0 to dt=2Erows=2Ecount-1 ComboBox=2Eitems=2Eadd(dt=2Erows(i)) Next after that=2E I see three rows in ComboBox with display member as= "System=2EData=2EDataRow" Any help appreciated=2E Thanks in Advance Sudhir ----------------------- Posted by a user from =2ENET 247 (http://www=2Edotnet247=2Ecom/) <Id>CME5ItGPMEe1eDw7EX4Ngw=3D=3D</Id> Tag: Lookup tables Tag: 91218
  - 21
    - Unable to load DLL (oci.dll) I installed oracle client 9.2.0.1 on winxp.But when I open a connection to oracle server, there is an exception:DllNotFoundException: Unable to load DLL (oci.dll). I found oci.dll in "D:\oracle\ora92\bin". Can anyone help me out? Thanks. Tag: Lookup tables Tag: 91214
  - 22
    - How to populate DataTable/DataSet with Array? Hi, How do I populate a DataTable (or a DataSet) with values from an Array? [code] Dim myObject as String Dim myTable As New DataTable ReDim myObject (10, 10) ' Populate myObject with values here ' How to do the equivalent of the following command ' myTable.Data = myObject [/code] Is the only way to do this is using a loop to collect every element and update a DataRow and insert the DataRow into the DataTable? Thanks in advance. Madan ----------------------- Posted by a user from .NET 247 (http://www.dotnet247.com/) <Id>HHnqyc0th0KY59pfgiuMBQ==</Id> Tag: Lookup tables Tag: 91211
  - 23
    - Parameter Error I am writing a VB program, and on one particular form, I want to update a database based on a calculation, and the user inputting a number in a combo box on a form. In my table, the field names are name, 1-17, and total. Here is a sample of the parameter definitions Dim prm4 As OleDb.OleDbParameter = _ dap2.UpdateCommand.Parameters.Add("@name", _ System.Data.OleDb.OleDbType.VarChar, 25, "name") Dim prm5 As OleDb.OleDbParameter = _ dap2.UpdateCommand.Parameters.Add("@1", _ System.Data.OleDb.OleDbType.Integer, "1") all the way to 17, and total. 1st question: When I run the program, the user enters 1 in the combo box, I receive: Parameter ?_2 has no defaut value. I want the program to leave the value in field 2 in the database alone. 2nd question: I dont want to write 17 sets of code for the 17 options a user can choose. I want to write a statement something like: drw2("1") = xx but I want the 1 to be cboChoice.Text, but I do not know how to format the command. Please help. Tag: Lookup tables Tag: 91209
  - 24
    - "Internal Error, not fully constructed" error Hello, I am having a problem connecting to SQL server from Visual Studio.NET. When making a data connection, in the "Data Link Properties" window I add the name of the server, my username and password and I select my database from the drop-down list. I click on "Test Connection" and it says "Test Connection succeeded". Good! I click "OK" and get the SQL Server Login window. I enter my username and password. Then when I click OK I get a message box saying: "Internal error, not fully constructed". I am running Visual Studio.Net Professional on Windows XP Home Edition. Any clues very much appreciated. Andrew. Tag: Lookup tables Tag: 91206
  - 25
    - unable to connect to Database over a network Hi, I am trying to connect to a remote SQL Server 2000 on a local lan in C#. I have tried the following connection string: connectionString = "DSN=empex;SERVER=SARK011/Test;DATABASE=empexchange;Network=DBMSSOCN;Address=172.21.1.11;UID=anair;PWD=anair;"; and connectionString = "Provider=SQLOLEDB;Data Source=empex;Initial Catalog=panchayatNetwork=DBMSSOCN;;User Id=panchayat;Password=panchayat" With both of this I get the following error: Index#0 Message:[DBNETLIB][Connection open(Connect()).]Specified SQL server not found. Native:6 Source:Microsoft OLE DB Provider for SQL Server SQL:08001 I am able to connect to both the database thru the ODBC Data Source Administrator tool. What am i doing wrong? I able to connect to the NorthWind database with any problem. I am able to connect to the other two databases from VB6 and Java thanks, Arun Tag: Lookup tables Tag: 91202
- Next
  - 1
    - DataRelation does not support LEFT JOIN. Is this true? Hello folks, we have been trying to use DataRelation that returns LEFT JOIN result instead of INNER JOIN which seems to be the default behaviour. Is there a way to do this? TIA, Toni Tag: Lookup tables Tag: 91200
  - 2
    - determine metadata for detached DataRow is it possible to determine the metadata of a DataRow for the case DataRow.RowState = DataRowState.Detached Of course, in other cases DataRow.Table can be accessed .... Tag: Lookup tables Tag: 91199
  - 3
    - identities and dataset... Hi all... got a quick question. I read in XML to a application dataset variable. since i dont have access to SQL server i decided to avoid Access and go strait to XML. Problem i'm having is that when adding a new row i get a constraint issue. I havent found how to get the PK stored in XML to the point the dataset recognizes so i do the following after the XML load. x[0] = theDataStore.Tables["tblArticles"].Columns["ArticleID"]; x[0].AutoIncrement = true; x[0].AutoIncrementSeed = 0; x[0].AutoIncrementStep = 1; theDataStore.Tables["tblArticles"].PrimaryKey = x; When i try a "newrow()" i get the following. Column 'ArticleID' is constrained to be unique. Value '1' is already present. I didnt get this when i added articleID 1, or when i did articleID 0... but it seems that the dataset object doesnt see that ArticleID 1 is already in the DataSet... Here is the insert code... public zArticle addArticle(int UserID, int CategoryID) { DataRow DR; zArticle theArticle; DR = theDataStore.Tables["tblArticles"].NewRow(); DR["UserID"] = UserID; DR["CategoryID"] = CategoryID; DR["Headline"] = ""; DR["Body"] = ""; DR["Date"] = DateTime.Now.ToString(); theArticle = new zArticle(int.Parse(DR["ArticleID"].ToString()), int.Parse(DR["UserID"].ToString()), int.Parse(DR["CategoryID"].ToString()), DR["Headline"].ToString(), DR["Body"].ToString(), (DateTime) DR["Date"]); theArticle.update += new zArticle.updateObject(this.updateArticle); theDataStore.Tables["tblArticles"].Rows.Add(DR); saveDataStore(); return theArticle; } Tag: Lookup tables Tag: 91198
  - 4
    - Do TableStyles and DataView conflict?? Using design i created several tablestyles for a datagrid whose source was originally set to DataSet. Later i decided to put in a dataView instead as the source, but now the designer does not allow for selecting among different tableMappings as long as the DataView is the Source (the original ones are still there). Will this create a problem? should the dataview be bound programmatically instead? Tag: Lookup tables Tag: 91197
  - 5
    - Strange Index out of range exception Hi all, i have a strange index out of range exception Stack Trace "System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index at System.Collections.ArrayList.get_Item(Int32 index) at System.Data.DataTable.RecordStateChanged(Int32 record1, dataViewRowState oldState1, DataViewRowState newState1, Int32 record2, DataViewRowState oldState2, DataViewRowState newState2) at System.Data.DataTable.SetNewRecord(DataRow row, Int32 proposedRecord, DataRowAction action, Boolean isInMerge) at System.Data.DataTable.DeleteRow(DataRow row) at System.Data.DataRow.Delete() How Im using a win grid that is bound to a datatable with a child related to it, it happens when i modify something in the row of the grid the execution enter in an event handler of the aftercellupdate, this sub delete all the rows of the child and after insert new rows with the data related to the selection that was made. The Code /***********************************************************/ grdRubros.UpdateData() Try For i = Me.ds.ItemsTable.Count - 1 To 0 Step -1 If Me.ds.ItemsTable(i).RowState <> DataRowState.Deleted Then Me.ds.ItemsTable(i).Delete() End If Next ' Then i get the items from the database For contUN = 0 To dsMetodoDistribucion.MetodoUnidadNegocio.Count - 1 Dim drUnidad As ItemsTableRow = ds.ItemsTable.NewItemsTableRow drUnidad.SetParentRow(drAbonoRubro) drUnidad.IdAbonoRubro = drAbonoRubro.Id drUnidad.IdUnidadNegocio = Me.dsMetodoDistribucion.MetodoUnidadNegocio(contUN).IdUnidadNegocio drUnidad.Porcentaje = Me.dsMetodoDistribucion.MetodoUnidadNegocio(contUN).Porcentaje drUnidad.SubTotal = Decimal.Round(CType(drUnidad.Porcentaje * TotalLinea / 100, Decimal), 2) drUnidad.TotalImpuestoPorPagar = 0 drUnidad.TotalImpuestoPorRetener = 0 drUnidad.TotalPagado = 0 drUnidad.TotalPagadoBase = 0 drUnidad.Total = drUnidad.SubTotal drUnidad.TotalPorPagar = drUnidad.SubTotal drUnidad.FechaRegistro = Now drUnidad.Usuario = SIEnviroment.Login Me.ds.ItemsTable.AddItemsTable(drUnidad) Next Catch ex As Exception Throw ex End Try Strange!!!!!! When i debug this code the table always is in range, but sometimes throw an exception in the delete. when the exception is thrown the state of row that is actually deleting change from added to detached Thank for the help Tag: Lookup tables Tag: 91194
  - 6
    - Binding to custom data class I am relatively new to .net programming and am developing a client/server app for a client and have a question concerning databinding controls. My question is can I write a custom class to handle database operations and still be able to bind controls to the datasets contained in the custom class much the same way that I can bind a control to a dataset that I have embedded in the form. TIA, Bill Youngman Tag: Lookup tables Tag: 91193
  - 7
    - Dataset disappearing?? why?? after making changes in the properties window of a dataset.table, i lose dataset. " Could not find type 'DataSet1'. Please make sure that the assembly that contains this type is referenced. If this type is a part of your development project, make sure that the project has been successfully built." Tag: Lookup tables Tag: 91192
  - 8
    - manipulating DataTable for manipulating a (disconnected) DataTable , how to iterate through the rows ? how to insert a row ? update a row ? delete a row ? how to perform queries of the DataTable , such as filters and sorts , to return another DataTable ? Tag: Lookup tables Tag: 91186
  - 9
    - Catching A Db Timeout Exception Is there a specific exception thrown for timeouts occurring from a database call? If not, does anyone have a recommendation on how I can write a loop to run say three times if a timeout does occur. Thanks Tag: Lookup tables Tag: 91181
  - 10
    - SQL Desktop Engine and ADO.NET question Hello, I recently installed MSDE and the .NET QuickStart tutorials. I'm trying to write an app that uses the Northwinds database installed on my local host. As I understand it, I should be able to drag the database from the Server Explorer to my form. Is this incorrect? I've also tried dragging the SqldataAdapter object from the tool box to my form and opening a connection that way, but the wizard is never able to find the database. I'm using the SQL OLEDB provider. What am I missing or doing wrong? Thanks in advance. Tag: Lookup tables Tag: 91175
  - 11
    - datetime Hi How can I separate a datetime field value into date & time values? Conversely how can I combine date & time values into a value for a datetime field? Thanks Regards Tag: Lookup tables Tag: 91171
  - 12
    - HERE WE GO AGAIN, Visual Web Developer 2005 Express SCREWS UP YOUR CODE on PURPOSE...STOP TOUCHING MY CODE, MICROSOFT!!!! DEAR MICROSOFT: STOP TOUCHING MY CODE!!!!!! Stop ADDING these attributes to my tags meta:resourcekey="LiteralResource3" Your Web Developer 2005 express added that crappy and unneeded attribute to all my tags on my aspx page...you even added that attribute to the @page directive. The people who actually do work might have to to bounce back to a better HTML editor and NOT use 2.0 OR I don't even want that attribute in the first place as I don't place to use .resx files anyway..... GET IT THROUGH YOUR STUPID HEAD THAT YOU ARE NEVER TO PUT CODE WHEN I DON"T KNOW ABOUT IT, NOR SHOULD I HAVE TO GO ON A SCAVENGER HUNT TO FIND IT IN THE SETTINGS JUNGLE. Who has responsible for doing this on the Microsoft team? ONe of number one things Microsoft market was trumpeting was that VS.NET 2005 wasn't going to touch your code............... DON'T DO THAT!!! GOT IT!!!!!! NOW I HAVE TO GO AND REMOVE IT FOR ALL THE TAGS ON MY PAGE IF I WANT TO USE .NET 1.1 COMPRENDE!!!!!!! IT'S NO WONDER WHY ASP.NET hasn't been embraced by a significant number of asp developers, Old ASP developers can get more done using NON-MICROSOFT TOOLS..... DROP THE CRAPPY WEB PORT AS WELL..that's stupid, takes up resources and just make debugging that much more difficult. LOCALHOST:12345 <-- do we have to do it this way? Just show them how to set up IIS correctly. PHP, ASP, ColdFusion, Java all know how to do this manually, Why does microsoft have to screws things up again.. Tag: Lookup tables Tag: 91160
  - 13
    - Datetime to date & time & back Hi I am using and access datetime field to store both date & time. How can I split it into date & time after reading the field and then combine the date & time back into datetime when storing it? Thanks Regards Tag: Lookup tables Tag: 91158
  - 14
    - Populating a dataset with a single select (with join) I have the following datamodel (implemented in SQL Server) header -< detail That is, I have two tables, "header" and "detail". There is a foreign key from detail to header so that for each header there can be many details. I have created a corresponding (strongly typed) dataset, with the two tables and the relationship. (To be perfectly clear: one dataset containing two tables) Now, due to programmatic and performance reasons, I would like to populate BOTH the tables in the dataset with a SINGLE sql select statement (containing a join and further conditions). That is, I would like to populate both tables using a single select statement similar to this: SELECT Header.*, Detail.* FROM Header INNER JOIN Detail ON Header.ID = Detail.ID WHERE (Detail.Foo > 52) Is this possible using ADO.NET (or DAL for that matter)? How? Thanks, Klas Mellbourn Tag: Lookup tables Tag: 91154
  - 15
    - Find out which row/constraint triggers the constraint exception When a dataset is modified and a constraint is violated, then there seems to be no way to find out which row/constraint violated the constraint. I get a System.Data.ConstraintException. However, there is no Row or Constraint property that informs which row violated which constraint. This is especially hard, when you need to debug complex queries that are used in a DataAdapter. Is there a workaround to find out, which row/constraint triggers the constraint exception? It would be a great addition for the new ADO.NET v2.0 when this information will become available. -- Greetings, Ramon de Klein Tag: Lookup tables Tag: 91151
  - 16
    - Static methods and local data (Again) Hi everyone, I'm still abit confused about static methods accessing locally declared variables. For example public static bool executeNonQuery(){ SqlCommand cmd; SqlConnection con; .... } Is the above threadsafe? Can the cmd or con object be accessed by more than one thread at the same time. What if the code was: public static bool executeNonQuery(SqlCommand cmd){ SqlConnection con; cmd.Connection = con; .... } Where the command object is also created in a static calling method? Many thanks all Simon Tag: Lookup tables Tag: 91149
  - 17
    - connection pooling on NT 4.0 Hi, we have a VB.NET application that connects to an Oracle 9i database with no problems using windows XP. On an NT 4.0 (sp6a) box however we get an error in the application "ResourcePool not supported on this platform". We have worked around this problem by using pooling=false in our connection string. 1) Is there any way we can "enable" pooling to work on NT4? (i.e. any addon software we are missing for NT4). 2) Are there any other known problems deploying to NT4 that we should be aware of? Many Thanks Carlo *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET...get rewarded for it! Tag: Lookup tables Tag: 91147
  - 18
    - ADO.NET DataSet to ADO RecordSet I have an DLL developed in VB.NET which returns Dataset and DataSet with Relations. Through InterOp I am using that DLL in VB 6 and the Return Parameter for the DLL function showing as UNKNOWN ( Actually DataSet ). Can any one help me how to assign DataSet returning from function to Record Set. Thanks in advance Sreekanth D Tag: Lookup tables Tag: 91143
  - 19
    - Visual Web Developer 2005 Express SCREWS UP YOUR CODE on PURPOSE...STOP TOUCHING MY CODE, MICROSOFT!!!! DEAR MICROSOFT: STOP TOUCHING MY CODE!!!!!! Stop ADDING these attributes to my tags meta:resourcekey="LiteralResource3" Your Web Developer 2005 express added that crappy and unneeded attribute to all my tags on my aspx page...you even added that attribute to the @page directive. The people who actually do work might have to to bounce back to a better HTML editor and NOT use 1.1 OR I don't even want that attribute in the first place as I don't place to use .resx files anyway DON'T DO THAT!!! GOT IT!!!!!! NOW I HAVE TO GO AND REMOVE IT FOR ALL THE TAGS ON MY PAGE IF I WANT TO USE .NET 1.1 COMPRENDE!!!!!!! Tag: Lookup tables Tag: 91141
  - 20
    - update using relationships Hi all, I have 2 tables and a relatioship. Clients, house, clientshouse I also have a form with many text controls bound to the relationship. THis controls are fields of table house. After I made changes to the data I want to update the table house this.daHouse.Update(this.dsCM1,"house") But it didn't update the table??? am I missing something???? Tag: Lookup tables Tag: 91136
  - 21
    - Exceptions in IConfigurationSectionHandler.Create() Hi all, I'm writing my own custom config section handler. Since I'm parsing my custom part of web.config in Create(), I'd like to throw some meaningful errors if a user has made a mistake. However, no matter what kind of exception I throw, the ASP.NET application will always show some generic error message, such as: "Exception in configuration section handler" Is this by design? Thanks. -Oleg. Tag: Lookup tables Tag: 91135
  - 22
    - Trying to edit a DataRow Can anyone tell me why I am getting this error? Dim dr1 As DataRow = das2.Tables(0).Rows.Find("Baltimore") dr1("[1]") = ascore Try dap2.Update(das2, "teamscores") Catch MsgBox(Err.Number) MsgBox(Err.Description) End Try An unhandled exception of type 'System.FormatException' occurred in mscorlib.dll Additional information: Input string was not in a correct format. Tag: Lookup tables Tag: 91133
  - 23
    - Returning SqlCommand Rows Affected and/or Result Set I am creating a custom SQL Server Query Analyzer application. I have a dilemma whereby I need to execute SQL batch files in dotnet (C#). I have no problem splitting the batch file out into a collection of commands based on the "GO" keyword. The problem is that some commands return rows (e.g. "SELECT * FROM CUSTOMER") while other commands modify data (e.g. "EXEC SP_PURGEOLDCUSTOMERS"). In the first case, I like to capture the result set rows for display. In the second case, I like to list the rows affected count. The first case can be accomplished via SqlDataAdapter.Fill(dataset). The second via ExecuteNonQuery. The issue is that there is no way (that I know of) to execute a sql command that both returns the number of rows affected and/or the result set rows. It's one or the other. In my app, I attempted to parse the command text to determine whether it required the first or second approach, but with commands like "SP_FLAGOVERDUEINVOICES" there's no way of knowing whether it will return rows or a rows affected count. I would like to execute the command text in a way that works regardless of whether the command returns rows or a rows affected count or both. Any ideas? Mario T. Lanza Clarity Information Architecture, Inc. 2004.07.01 Tag: Lookup tables Tag: 91129
  - 24
    - Data Tables ColumnNames not seen I've created a AlertDataClass below within the class I have tables and column that I've create. In the AlertDataAccess class I'm trying to insert data into my tables. AlertDataAccess is a Module that is trying to insert data into the tables. Within the AlertDataClass is subroutine that init and creates ColumnNames. In invoke the AddDataColumnNames() sub to create the column headers. Why can't I see the column names in my module that I'm trying to insert data into? It appears that CriteriaAlert subroutine can not see the table column that have been created. I do initisate the AlertDataClass Public Class AlertDataClass ' create Dataset and Tables Public AlertDS As DataSet = New DataSet("AlertTables") Public EventCriteriaTable As DataTable = AlertDS.Tables.Add("EventCriteria") Public MinGPSHistoryTable As DataTable = AlertDS.Tables.Add("MinGPSHistory") Public EventLogTable As DataTable = AlertDS.Tables.Add("EventLog") Dim AlertVar As New AlertVariables Public Sub AddDataColumnNames() 'Add Column Names for Criteria and Command Data 'Set Column Properties Dim CriteriaColumnHeader As DataColumn = New DataColumn CriteriaColumnHeader.DataType = System.Type.GetType("System.String") CriteriaColumnHeader.AllowDBNull = False ' Add the Column Header to the table. CriteriaColumnHeader.ColumnName = "CriteriaID" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) CriteriaColumnHeader.ColumnName = "Min_Num" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) CriteriaColumnHeader.ColumnName = "ReportingFrequenecy" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) CriteriaColumnHeader.ColumnName = "TimeToLiveStartDate" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) CriteriaColumnHeader.ColumnName = "TimeToLiveStartTime" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) CriteriaColumnHeader.ColumnName = "TimeToLiveStopDate" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) CriteriaColumnHeader.ColumnName = "TimeToLiveStopTime" EventCriteriaTable.Columns.Add(CriteriaColumnHeader) end class Module DataAccessClass Dim AlertData As New AlertDataClass Dim AlertVar As New AlertVariables Dim Alerts = AlertData Dim MessageProcessing As New SageQuestMailer Sub CriteriaAlert AddDataColumnNames() CriteriaDBConnection.Open() Dim CriteriaReader As SqlDataReader = CriteriaCMD.ExecuteReader(CommandBehavior.CloseConnection) If CriteriaReader.HasRows Then NoData = False 'Data is available While CriteriaReader.Read() ' Add Column Names and Row Data to Table CriteriaRow = AlertData.EventCriteriaTable.NewRow() ' Create a New Row CriteriaRow("CriteriaID") = CriteriaReader.GetSqlValue(0) CriteriaRow("Min_Num") = CriteriaReader.GetSqlValue(1) CriteriaRow("ReportingFrequenecy") = CriteriaReader.GetSqlValue(2) CriteriaRow("TimeToLiveStartDate") = CriteriaReader.GetSqlValue(3) CriteriaRow("TimeToLiveStartTime") = CriteriaReader.GetSqlValue(4) CriteriaRow("TimeToLiveStopDate") = CriteriaReader.GetSqlValue(5) CriteriaRow("TimeToLiveStopTime") = CriteriaReader.GetSqlValue(6) end sub end Module Thanks Tag: Lookup tables Tag: 91126
  - 25
    - Cannot connect to sql server over the network. This is really weird. Basically I have the website(asp.net 1.1, written in vb) and sql server 2000 running on my machine. I have to copy the database over to another server for testing. So i change the connection string to point to that database, and it doesn't work. I've tried it on 3 different machines now. Changing the connection string correctly each time. And nothing. But it always works when connecting to the database thats local, not remote. Can anyone help? Cheers Mark Tag: Lookup tables Tag: 91117

Hi There

I have 3 dataadapters each relating to a table - daCompany, daAccountant, daCompanyType. These tables have foreign constraints set in the dataset schema.
(Company many to Accountant, CompanyType many to CompanyType)
I've databound all relevant text boxes and comboboxes however when modifying the textboxes etc. the dataset does not detect any changes.

Please help!

Top

Re: Lookup tables by Miha

Miha
Tue Jul 06 04:12:58 CDT 2004

Make sure you call CurrencyManager.EndCurrentEdit to save data into the
dataset.

--
Miha Markic [MVP C#] - RightHand .NET consulting & development
miha at rthand com
www.rthand.com

"JPretorius" <JPretorius@discussions.microsoft.com> wrote in message
news:F1D862F4-45E3-45BE-AB9D-794F7D36C055@microsoft.com...
> Hi There
>
> I have 3 dataadapters each relating to a table - daCompany, daAccountant,
daCompanyType. These tables have foreign constraints set in the dataset
schema.
> (Company many to Accountant, CompanyType many to CompanyType)
> I've databound all relevant text boxes and comboboxes however when
modifying the textboxes etc. the dataset does not detect any changes.
>
> Please help!

Top