one sql connection for multiple web forms

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
    - Need to return Data Across DataSet Tables... ... not sure what the best way to do this. What i need to do is return all the records in 1 table that don't exist in another table. scenio Table A contains a list of Tasks to work on. Table B contains a list of Tasks that are currently being worked on. So what I need returned is a list of all Tasks not being worked on. SELECT * FROM A WHERE (NOT (A_ID IN (SELECT A_ID FROM B))) I don't believe I can do a select across tables in a dataset. Ideas? Tag: one sql connection for multiple web forms Tag: 105319
  - 2
    - Sorting and Filtering dates in a Dataview I'm trying to filter a range of dates in a dataview. Problem is single digit days and months are getting mixed in with double digit days and months. eg) rowfilter='DT>03/25/2005 AND <03/27/2005' returns anything with a date of 03/2/2005 along with what it should return. any fixes? Tag: one sql connection for multiple web forms Tag: 105316
  - 3
    - Bind these ComboBoxes - Can it be done? I have 3 tables as follows: Table 1 - item list Table 2 - master table Table 3 - where selected values are stored and detail table to master. I want to Bind 8 ComboBoxes using these tables in pairs so there will be 4 pairs. Detail table def: masteridx pos value1 value2 Each ComboBox gets its list from Table1. When selected, the value goes to Table3. value1 and value2 from Table3 are a pair of values which go to the same record in Table3. masteridx in Table3 is the index or record id from Table2. Pos from Table3 is the pair of ComboBoxes to use. I hope I made this clear enough. It's really confusing. Thanks, Joe Tag: one sql connection for multiple web forms Tag: 105315
  - 4
    - Error when I using extended stored procedure : A severe error occurred on the current command. The results, if any, should be discarded Hi, I create a stored procedure to send email with an OLE instance (sp_send_mail). "EXEC @hr = sp_OACreate 'CDO.Message', @iMsg OUT ...etc." I have rigth to execute extended stored procedure sp_OACreate (and others in database master) After, in my DOTNET application, i execute my procedure with ExecuteNonQuery and i have a sql error : "A severe error occurred on the current command. The results, if any, should be discarded." Can you help me ? Thanks Tag: one sql connection for multiple web forms Tag: 105313
  - 5
    - Typed dataset and save? Hi, When using a typed dataset is it possible to do the following: 1 - force date values to get saved as just the date part... "2005-01-28" not "2005-01-28T00:00:00.0000000-00:00" type is defined as type="xs:date" in the schema. 2 - specify a style sheet so that it gets written to the xml that is generated by the DataSet.WriteXml method. Thanks Donal Tag: one sql connection for multiple web forms Tag: 105310
  - 6
    - Sort Order - Can it be preserved in this situation. Question. Is there a way I can get the order preserved (possibly with a SQL config option or such) using the folowing; Select ..... into #temptable where ... Order By ... then Select * from #temptable and have the order preserved in accordance with the select statements Order By clause used to build the temptable. .. using ADO.NET 1.1 with the MS_SQL Client - ExecuteReader() method. I am porting an application that used SQL 6.5 in this manor and it seememd to preserve the order using this pattern, however, Sql2000 does not. Thanks. Tag: one sql connection for multiple web forms Tag: 105309
  - 7
    - XML serialization exception with .NET 1.0 and 1.1 environment Sorry for the repost but I ddn't use my MSDN "handle" when I posted earlier.... Hi all I get an exception when trying to deserialize a simple configuration file using XML Serialization. The stacktrace can be seen at the bottom of this message. I've see other messages related a similar error but none of the solutions suggested are valid in case :/ I have tracked the problem down to the compilation of the temporary DLL that handles the actual serialization. The following commandline (all on a single line) is executed by the framework when trying to deserialize my configuration: "c:\windows\microsoft.net\framework\v1.1.4322\csc.exe" /t:library /utf8output /R:"c:\windows\assembly\gac\system.xml\1.0.5000.0__b77a5c561934e089\system.xml.dll" /R:"c:\program files\MyApp\MyConfig.dll" /R:"c:\windows\microsoft.net\framework\v1.1.4322\mscorlib.dll" /out:"C:\DOCUME~1\User\LOCALS~1\Temp\i2_6axn4.dll" /debug- /optimize+ /w:1 "C:\DOCUME~1\User\LOCALS~1\Temp\i2_6axn4.0.cs" Note that it uses the .NET 1.1 compiler and core lib but references the .NET 1.0 XML assembly. The result is that the assembly isn't created and hence cannot be loaded. I've specifeid the required runtime version in the .config file to be .NET 1.1 without any improvements. The problems occur on a Windows XP test machine with both .NET 1.0 and 1.1. The application is built using VS.NET 2003 on a machine with only .NET 1.1. The user running the code on the test machine has administrative rights. I've have tried the XmlSerialization precompiler and it works without problems... Anyone have any ideas why this happens? Kind regards, HakonB Exception: System.Configuration.ConfigurationException: Unable to load configuration from the XML configuration file: 'C:\Program Files\MyApp\MyApp.exe.config'. This can be caused by a number of problems, but the most common problem is an incorrectly configured Updater configuration file. The most probable sources of error are: missing nodes, incorrect attribute names, white space within attributes or within elements, white space between elements in the same sub-node, badly formed xml, or xml that does not conform to the ConfigSchema.XSD. ---> System.Configuration.ConfigurationException: Exception in configuration section handler (C:\Program Files\MyApp\MyApp.exe.config line 16) ---> System.IO.FileNotFoundException: File or assembly name _zdvwu31.dll, or one of its dependencies, was not found. File name: "_zdvwu31.dll" at System.Reflection.Assembly.nLoad(AssemblyName fileName, String codeBase, Boolean isStringized, Evidence assemblySecurity, Boolean throwOnFileNotFound, Assembly locationHint, StackCrawlMark& stackMark) at System.Reflection.Assembly.InternalLoad(AssemblyName assemblyRef, Boolean stringized, Evidence assemblySecurity, StackCrawlMark& stackMark) at System.Reflection.Assembly.Load(AssemblyName assemblyRef, Evidence assemblySecurity) at System.CodeDom.Compiler.CompilerResults.get_CompiledAssembly() at System.CodeDom.Compiler.CompilerResults.get_CompiledAssembly() at System.Xml.Serialization.Compiler.Compile() at System.Xml.Serialization.TempAssembly..ctor(XmlMapping[] xmlMappings) at System.Xml.Serialization.XmlSerializer..ctor(Type type, String defaultNamespace) at System.Xml.Serialization.XmlSerializer..ctor(Type type) at DSUpdater.UpdaterSectionHandler.System.Configuration.IConfigurationSectionHandler.Create(Object parent, Object configContext, XmlNode section) in C:\Projects\MyApp\MyApp\ConfigSectionHandler.cs:line 55 at System.Configuration.ConfigurationRecord.EvaluateRecursive(IConfigurationSectionHandler factory, Object config, String[] keys, Int32 iKey, XmlTextReader reader) === Pre-bind state information === LOG: Where-ref bind. Location = C:\DOCUME~1\User\LOCALS~1\Temp\_zdvwu31.dll LOG: Appbase = C:\Program Files\MyApp\ LOG: Initial PrivatePath = NULL Calling assembly : (Unknown). === LOG: Policy not being applied to reference at this time (private, custom, partial, or location-based assembly bind). LOG: Attempting download of new URL file:///C:/DOCUME~1/User/LOCALS~1/Temp/_zdvwu31.dll. --- End of inner exception stack trace --- at System.Configuration.ConfigurationRecord.EvaluateRecursive(IConfigurationSectionHandler factory, Object config, String[] keys, Int32 iKey, XmlTextReader reader) at System.Configuration.ConfigurationRecord.Evaluate(String configKey) at System.Configuration.ConfigurationRecord.ResolveConfig(String configKey) at System.Configuration.ConfigurationRecord.GetConfig(String configKey) at System.Configuration.DefaultConfigurationSystem.System.Configuration.IConfigurationSystem.GetConfig(String configKey) at System.Configuration.ConfigurationSettings.GetConfig(String sectionName) at DSUpdater.UpdaterConfiguration.Init() in C:\Projects\MyApp\MyApp\UpdaterConfiguration.cs:line 133 --- End of inner exception stack trace --- at DSUpdater.ApplicationUpdateManager..ctor() in C:\Projects\MyApp\DSUpdater\ApplicationUpdater.cs:line 98 at MyApp.Client.Services.SmartUpdateService.Initialize(Form form) in C:\Projects\MyApp\MyApp\Services\SmartUpdateService.cs:line 32 at MyApp.Client.MainForm.Handler_CheckForUpdates(Object sender, EventArgs e) in C:\Projects\MyApp\MyApp\MainForm.cs:line 570 at MyApp.Common.ActionHandler.ExecuteHandler(Object sender, EventArgs args) in C:\Projects\MyApp\MyCommon\General\ActionDispatcher.cs:line 252 at MyApp.Common.General.ActionDispatcher.Fire(String handlerName, Object sender, EventArgs args) in C:\Projects\MyApp\MyCommon\General\ActionDispatcher.cs:line 195 at MyApp.Client.MainForm.MainForm_Load(Object sender, EventArgs e) in C:\Projects\MyApp\MyApp\MainForm.cs:line 423 at System.Windows.Forms.Form.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) at System.Windows.Forms.ControlNativeWindow.OnMessage(Message& m) at System.Windows.Forms.ControlNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam) Tag: one sql connection for multiple web forms Tag: 105306
  - 8
    - DataView sort I have an xml from two different database source that I load into the dataset. one of the column is a date field and I want to sort the date. Its sorting the date as string as the datatype for the column is string. Can I change the datatype of the column ? since I cannot sort it on the database side can I do it in the dataview ? Please help... Thanks, Tag: one sql connection for multiple web forms Tag: 105304
  - 9
    - Why question not answered? I don't understand why the question below has not been answered here. I assume I am in the right newgroup. To me it seems a reasonable question. What gives? If reviewing how to get the DataRowVersion data from a row in a dataset I see no example of how to do this with a strongly typed dataset using dot notation. Below I have an example of how I get a value into a integer value called OrigStatus not using dot notation. OrigStatus = CInt(Me.DataSetQuoteDetail1.quote(0)("quote_status_id", DataRowVersion.Original)) As you see, in the example above it is necessary for me to supply the name of the column in quotation marks. Is there a way to do this in a strongly typed dataset using dot notation so that I don't have to supply the column name in quotation marks? Tag: one sql connection for multiple web forms Tag: 105297
  - 10
    - DataBinding to a combo box. Hi I have two tables... DataSources(id, Type, Name) DataSourcesTypes(id, TypeDescription) DataSourcesTypes contains lookup field data that will populate the Type field in the DataSource table. I would like to setup a comboBox with the following... DisplayMember = DataSourcesTypes.TypeDescription ValueMember = DataSources.Type The ultimate effect being a form that displays the description in a combo box but is altering the ID field in the dataSource table for the particular dataSource being edited. I understand that a relationship should be setup but I cannot get it to work ? thanks for any time on this Sharat Koya Tag: one sql connection for multiple web forms Tag: 105293
  - 11
    - Problem with sqlDataAdapter.fill performance Hi I am a newbie to the ADO .NET. I use a dataset as datasource for a web Crystal Report. I fill this dataset using a sqlDataAdapter. The selectCommand is quite complex and use many table and relations. The execution of the fill command is very long (it takes about 30 sec.), but if i run the select command in the query builder it takes about 2 sec, so i think that the problem is not the execution of the query by SQLServer. How can i speeed up the fill of this dataset ? Thank you - Daniele - Tag: one sql connection for multiple web forms Tag: 105286
  - 12
    - How to Get Year/Month/Date of a DateTime Column by Column.Expressi I mean to create a new column with Integer type, which is defined by its expression to be Year/Month/Date of a DateTime Column. Of course, It is simple to define such a new column by Substring(Convert(DateTimeColumn,"System.String"),x,y) to get Year/Month/Date of DateTime Column if we know the DataTable.Local when we code the expression. If not, how to do? Any suggestions are welcome. LI Ying Tag: one sql connection for multiple web forms Tag: 105285
  - 13
    - Event on record change I have some controls on my form which are bound to a dataset and some which are not bound. But whatever record is displayed on the form, I want to populate those control (datetime, combo, etc.) with the data in the current record. What event can I do this in ? PositionChanged of bindingContext - is this called before the record is current or after ? if it is after, I can use this. Please advise. HS Tag: one sql connection for multiple web forms Tag: 105267
  - 14
    - Connect to Exchange Server 2000 Hi all, Can anyone direct me to where I can find sample code on how to connect to an Exchange Server with .NET? The Exchange OLEDB Provider doesn't seem to work with ADO .NET? /kk Tag: one sql connection for multiple web forms Tag: 105259
  - 15
    - Database update help needed I am a newbie to the ADO .NET stuff. I am using Visual Studio 2003/ VB to develop an app. Been doing development for a long time, but having a tough time getting my hands around the new way of doing things. Hoping you can help. First, is there a site or book you can point me to that will describe this stuff in detail? I can't seem to get the stuff I am reading/trying to work. Second, can someone give me a basic idea on the "preferred" use of data adapters and datasets? Separate DS for each DA, or one DS for all DAs? Lastly, I have an issue of data not being saved. I have a DB connection to an Access DB, a DA with the necessary SQL statements for update and insert, and a group of text controls bound to the data. I open the form and the data is there. I make changes and then issue: MyDataAdapter.Update(MyDataSet) I get no errors, but nothing changes in the DB. Part of the issues for me are understanding the opening/closing of the connection and how the data in the DS gets back to the actual DB. Sorry for the long question/post and many questions. I appreciate any help!! Tag: one sql connection for multiple web forms Tag: 105258
  - 16
    - Addnew() I have a checkbox, date time picker & few comboboxes bound to the same dataset I know checkbox, datetimepicker won't let me have null when I call AddNew() Also because if I bind my combo boxes to the same dataset they all change automagically. So my theory: On Addnew(), before addnew is called, unbind the checkbox & datetimepicker & comboboxes and before endcommit is called, populate the new record with the value in these controls. sounds good eh ? Now can someone help me put that into code? Thanks :) HS Tag: one sql connection for multiple web forms Tag: 105257
  - 17
    - Having problem with typed dataset with multiple tables. I have a typed DataSet that contains 4 tables. I have mapped a data adapter to all of the tables in the DataSet. The select command for the data adapter has a multiple join on all four tables in the typed DataSet. When I try to do the Fill command, I get an InvalidOperationExcpetion. The message says that there is an invalid source mapping for one of my columns. If I change my select statement to only return rows from one table in the result set, it works fine. Not sure why the other table mappings are not working. My select string looks something like this: select top 500 * from tblEventImages left outer join tblEventOccurrences on tblEventImages.EventID = tblEventOccurrences.EventID left outer join tblImageAnnotations on tblEventImages.TimeDate = tblImageAnnotations.TimeDate left outer join tblEventTransactions on tblEventImages.EventID = tblEventTransactions.EventID Could someone please indicate how to do the data adapter table mapping for this? Maybe I am doing something wrong here, but I cannot figure out what it is. -- ----------------------------------- Ken Varn Senior Software Engineer Diebold Inc. EmailID = varnk Domain = Diebold.com ----------------------------------- Tag: one sql connection for multiple web forms Tag: 105254
  - 18
    - What happens when I change the RowUpdatedEventArgs? What I want to do is catch and dismiss expected errors during an update (resolve the problem and allow the update to continue) but have unexpected errors throw their exception normally (stopping the update). To accomplish this, I created a method and attached it to the SqlDataAdapter.RowUpdated event. It looks similar to this, private void errorHandler(object sender, SqlRowUpdatedEventArgs args) { if(args.Status != UpdateStatus.ErrorsOccurred) { return; } // determine if the error should be ignored if(ignoreError) { // error should be ignored args.Status = UpdateStatus.Continue; args.Errors = null; } } With this code in place, errors I've ignored still throw an exception and halt the update. This behavior leads me to the conclusion that changing properties on the SqlRowUpdatedEventArgs object in my method have no lasting effect. Should this be so? Can someone please tell me if I have a logical or conceptual flaw here? Thanks! Matt P.S. This is running on the CompactFramework Tag: one sql connection for multiple web forms Tag: 105253
  - 19
    - Error when using System.Data.Relations.Add Using an informix database, I'm retrieving two datasets and copying the data table from one dataset into the other, so I've got 1 dataset with 2 tables. This is just background because it might be part of the problem. After this, I simply want to create a data relation between the two tables, so I call the constructor for a new datarelation, which appears to work fine. I get an error when I'm trying to use the Add method of the dataset. The error is: "System.ArgumentException: This constraint cannot be enabled as not all values have corresponding parent values." Any ideas? Below is the code I'm using. Thanks! Diane Droubay ----------------------------- //copy the budget detail from the detail dataset, then add to the budget dataset DataTable dt = dsDetail.Tables[0].Copy(); dsBudget.Tables.Add(dt); dsBudget.Tables[0].TableName = "Budget"; dsBudget.Tables[1].TableName = "Detail"; DataColumn dcBudgetId; DataColumn dcBudgetDetailId; //budget_id is primary key in Budget table and foreign key in Detail table. dcBudgetId = dsBudget.Tables["Budget"].Columns["budget_id"]; dcBudgetDetailId = dsBudget.Tables["Detail"].Columns["budget_id"]; DataRelation rel = new DataRelation("Budget2Detail", dcBudgetId, dcBudgetDetailId); //crashes on the next call. dsBudget.Relations.Add(rel); Tag: one sql connection for multiple web forms Tag: 105248
  - 20
    - Datalist not displaying records from stored procedure Hi, I have created and tested a stored procedure with some input values and one output value. When I run it the page seems to come up but no data exists, and no errors. This is odd because there if definitely info ont he table/datbase. My code is below if anyone can see what I might be doing wrong. Dim MyConnection As New SqlConnection(ConfigurationSettings.AppSettings ("ConnectionString")) Dim cmd As New SqlCommand("uspSearch", MyConnection) cmd.CommandType = CommandType.StoredProcedure cmd.Parameters.Add("@suburbtown", SqlDbType.Varchar, 30) cmd.Parameters("@suburbtown").Direction = ParameterDirection.Input cmd.Parameters("@suburbtown").Value = "" cmd.Parameters.Add("@accountant_type", SqlDbType.Int) cmd.Parameters("@accountant_type").Direction = ParameterDirection.Input cmd.Parameters("@accountant_type").Value = 15 cmd.Parameters.Add("@keyword", SqlDbType.Varchar, 25) cmd.Parameters("@keyword").Direction = ParameterDirection.Input cmd.Parameters("@keyword").Value = "" cmd.Parameters.Add("@state", SqlDbType.Varchar, 3) cmd.Parameters("@state").Direction = ParameterDirection.Input cmd.Parameters("@state").Value = "TAS" cmd.Parameters.Add("@PageSize", SqlDbType.Int) cmd.Parameters("@PageSize").Direction = ParameterDirection.Input cmd.Parameters("@PageSize").Value = 10 cmd.Parameters.Add("@CurrentPage", SqlDbType.Int) cmd.Parameters("@CurrentPage").Direction = ParameterDirection.Input cmd.Parameters("@CurrentPage").Value = 1 cmd.Parameters.Add("@FullCount", SqlDbType.Int) cmd.Parameters("@FullCount").Direction = ParameterDirection.Output Dim adapter As New SqlDataAdapter(cmd) Dim ds As New DataSet() adapter.Fill(ds) ListResults.DataSource = ds ListResults.DataBind() -- Message posted via http://www.dotnetmonster.com Tag: one sql connection for multiple web forms Tag: 105240
  - 21
    - DataReader question Is the following code a valid way of passing a DataReader object back to calling code? I'm specifically concerned with the objConn object be explicitly set to Nothing. Does this cause the connection object to be garbage collected or does the connection object not get destroyed until the calling code closes the DataReader object (and thus the connection object)? Public Function GetDataReader(ByVal strSelect As String) As OleDbDataReader Try objConn = New OleDbConnection(strConnectionString) objCmd = New OleDbCommand(strSelect, objConn) objCmd.Connection.Open() GetDataReader = objCmd.ExecuteReader(CommandBehavior.CloseConnection) Catch ex As OleDbException GetDataReader = Nothing Finally objConn = Nothing objCmd = Nothing End Try End Function Tag: one sql connection for multiple web forms Tag: 105238
  - 22
    - Record Locking I was going to start a project in VB.net using ADO.net to a FoxPro database. Foxpro has a RLOCK function that allows you to lock a record while you are editing it. How can I achieve this with ADO.net?? Tag: one sql connection for multiple web forms Tag: 105237
  - 23
    - Can I use Query Builder from my application? Hi, Is there any way to use in my application Query Builder that Microsoft is using in SQL Server and DataAdapter Wizard where I can drag and drop tables, link them in graphical designer and run resulting sql statement? Is it possible or is it just part of SQL Server and VS? Thank you. Victor Tag: one sql connection for multiple web forms Tag: 105234
  - 24
    - How to manager empty string to null? How do I manage empty string to null? Do I have to code like following? if(txtBoxFirstName.text == "") cmd.Parameters.Add("@FirstName",DBNull.Value): else cmd.Parameters.Add("@FirstName",txtBoxFirstName.text): Or are there better ways? Also, I am curious about how to manage for integer as well. Tag: one sql connection for multiple web forms Tag: 105225
  - 25
    - what can cause a "object was open" error Hi, I am writing an ASP.NET appliction with C#. I also access a MSDE database with the OleDb Provider. I am using OleDb to have the option of easily changing the underlying database. That worked all well. But after some additions to my application I now have the following error: Exception: System.Data.OleDb.OleDbException Message: Object was open. at System.Data.OleDb.OleDbConnection.ProcessResults(Int32 hr) at System.Data.OleDb.OleDbConnection.InitializeProvider() at System.Data.OleDb.OleDbConnection.Open() This error does occur in some code snippets all the time, in some other it seems that it only happens sometimes. I tried to find out more about the error by investigating the problem in a code snippet where it always occurs. But it doesn't help. It is just an INSERT statement to one table. I already tried synchronizing the code snippet and commenting out all other accesses to the same table to avoid any collisions by multiple threads that try to access it, but it still doesn't work. The connection itself is closed, so "Object" must mean something else. But what? Any ideas? Regards Marco Tag: one sql connection for multiple web forms Tag: 105224
- Next
  - 1
    - DataRowVersion - Strongly typed dataset If reviewing how to get the DataRowVersion data from a row in a dataset I see no example of how to do this with a strongly typed dataset using dot notation. Below I have an example of how I get a value into a integer value called OrigStatus not using dot notation. OrigStatus = CInt(Me.DataSetQuoteDetail1.quote(0)("quote_status_id", DataRowVersion.Original)) As you see, in the example above it is necessary for me to supply the name of the column in quotation marks. Is there a way to do this in a strongly typed dataset using dot notation so that I don't have to supply the column name in quotation marks? Tag: one sql connection for multiple web forms Tag: 105223
  - 2
    - Binding to a bound grid Hi, This question is in relation to a System.Web.UI.DataGrid If I bind some data to a grid, then in a subsequent postback bind to it again, does the grid intrincially clear its contents before adding the new information. TIA Tag: one sql connection for multiple web forms Tag: 105222
  - 3
    - DataAdapter newbie question I have two questions regarding the use of DataAdapters: 1. If I am going to retrieve multiple tales to a DataSet using multiple DataAdapter Fill's is it best to create a separate DataAdapter for each table or to create one and change it's SelectCommand property between each Fill? 2. Related to number 1, is it best to explicitly open the connection before the series of Fill's and close after rather than allow each DataAdapter to implicitly open and close the connection. TIA, John Tag: one sql connection for multiple web forms Tag: 105221
  - 4
    - Comparing Dataset values with Strings I am creating a login screen wherein only certain users are granted permission. The names of those users,are copied into a dataset using dataadapter.Then the dataview is used. But the problem here is that the "Dv.Count" always evaluates ..to 0. Hence whenever I enter the valid names "Invalid User" is prompted on the screen I have writen the code below. OleDbDataAdapter dAdap1 = new OleDbDataAdapter("SELECT ..[EMPLOYEE ID] FROM EMPLOYEE;",con1); dAdap1.Fill(DtSet); Dv.Table=DtSet.Tables["EMPLOYEE"]; Dv.RowFilter.CompareTo(txtLogin.Text); if(Dv.Count==0) { txtLogin.Text="Invalid User"; } Kindly suggest, Tag: one sql connection for multiple web forms Tag: 105217
  - 5
    - Binding Data with TextBox I want add a new record using a text box, but when I click the new button it should clear the text of textbox and textbox should be binded to datasource. pls help! Tag: one sql connection for multiple web forms Tag: 105216
  - 6
    - Insert data from a Dataset into a SQL Database Hi guys my name is Ralph, i am kinda new to this so please bear with me. I have written a .net web service which accepts a stream of data see relevent source code). Public Function PutBondInfo(ByVal data As String) As DataSet Try Dim zh As New ZipHelper Dim sz As String Dim cn As SqlConnection Dim da As SqlDataAdapter Dim ds As New DataSet Dim xSet As New DataSet Dim sSql As String Dim mySerializer As XmlSerializer = New XmlSerializer(ds.GetType()) cn = New SqlConnection("server=HLSQL;uid=test;pwd=;database=test") cn.Open() da = New SqlDataAdapter("SELECT * FROM BondStatus", cn) 'da.TableMappings.Add("BondStatus", "NewDataSet") sz = zh.Decompress(data) zh = Nothing da.FillSchema(ds, SchemaType.Mapped, "BondStatus") 'da.MissingSchemaAction = MissingSchemaAction.AddWithKey da.Fill(ds, "BondStatus") Dim st As New MemoryStream(Encoding.UTF8.GetBytes(sz)) ' Create the object from the xml file xSet = CType(mySerializer.Deserialize(st), DataSet) xSet.Tables(0).TableName = ds.Tables(0).TableName ds.Merge(xSet, False, System.Data.MissingSchemaAction.Add) 'ds.AcceptChanges() Dim SqlCB As SqlCommandBuilder = New SqlCommandBuilder(da) da.Update(ds, "BondStatus") st.Close() da.Dispose() SqlCB.Dispose() cn.Close() Return ds Catch ex As Exception ex.Message().ToString() End Try End Function This data is compressed.I decompress the data and receive the xml which is then deserialized into a dataset. this part works great no problems. My problem is then taking that dataset and pushing the data into a table on my SQL server. The elements in the xml and the field names of my SQL table 'BondStatus' are exactly the same. The table names are different the xml has 'Table' as its table name and so on. As you can see from the code I have tried table mappings, assigns, merges etc with no luck. Ladies and gents if anyone has a clue as to what I am doing and can help me, it would be appreciated. Thanks in advance Ralph Tag: one sql connection for multiple web forms Tag: 105211
  - 7
    - Stored Procedure Hi, I've 2 stored procedures in Sql Server 2000 by name QA_User_Insert and QA_Insert_Candidate. Am using Oledb connection to connect to Sql server 2000. and i wrote following code in ASP.Net Dim MyConn As OleDbConnection = New OleDbConnection("uid=sa;Intial Catelog=Quiz;data source=server;pwd=thanks;provider=SQLOLEDB.1") Dim cmd As New OleDbCommand cmd.Connection = MyConn cmd.CommandType = CommandType.StoredProcedure cmd.CommandText = "QA_User_Insert" \\ Here i created paramentes and added to parameters collection of cmd object. \\ cmd.ExecuteNonQuery() then after running the application am getting Error "Can Not Found Stored Procedure QA_User_Insert" I 've checked sql server 2000 and i found that there is QA_User_Insert stored Procedure. why am getting this error ? plz can anybody tell me solution for this problem. Thanx in advance Jyothi Tag: one sql connection for multiple web forms Tag: 105205
  - 8
    - sqlexception error in system.data.sqlclient.dll Hi everyone, i'm a newbie to VB.NET programming and i need help here. I'm current doing an application for pocket pc and i get this sqlexception error when i try to retrieve stuff from the database. My guess is that the error lies with the connection string. I've tried serveral different connection string but i still get the error. Try cn = New System.Data.SqlClient.SqlConnection("DATA SOURCE=L311C007; Initial Catalog=HEALTHCARE; Integrated Security=SSPI;") cn.Open() cmd.CommandText = "SELECT * FROM PERSON" cmd.Connection = cn Catch ex As System.Data.SqlClient.SqlException result = "There was an SqlException.." & vbCrLf & "Details..." & vbCrLf & ex.ToString() MsgBox(result) End Try The connection strings that i have tried are: User id=sa;password=;database=HEALTHCARE;server=L311C007 Data Source=L311C007,14433;Initial Catalog=HealthCare;User id=sa;password=; Tag: one sql connection for multiple web forms Tag: 105204
  - 9
    - AdoHelper Dependency Problem Hi I'm using the GotDotNet.ApplicationBlocks.Data.AdoHelper class in one of my projects, and it's working fine on my development machine. the problem however arises when deploying the project to another machine. I get a FileNotFoundException in the type initializer of AdoHelper. It claims it can't find a dependency, although inspection of the AdoHelper source code seems to show that it doesn't depend on anything other than the .Net Framework. The specific line of code which fails is this: Additionally the stack trace shows that the error occurs within a System.Reflection class. AdoHelper adoHelper = AdoHelper.CreateHelper("GotDotNet.ApplicationBlocks.Data","GotDotNet.ApplicationBlocks.Data.SqlServer"); Interestingly it seems to work fine if I create the SqlServer helper directly. Anyone got any thoughts? Cheers Andrew Tag: one sql connection for multiple web forms Tag: 105194
  - 10
    - Cannot Delete Rows in Database Hi all, I am using the following to remove a row from a DataSet: myDataSet.Tables["Table1"].Rows.RemoveAt(indexSelected); followed by; myDataAdapter.Update(myDataSet); After this call, looking in the database, the row is not deleted. But debugging it I can see it remove the row. Also note that the following insert does insert into the database: myDataSet.Tables["Table1"].Rows.InsertAt(newRow, index); Strange how InsertAt works but not RemoveAt. Does anyone knows what the problem is???? Thanks for any help, Scott Tag: one sql connection for multiple web forms Tag: 105193
  - 11
    - This sqlTransaction has completed; it is no longer usable This issue is really frustating because it happens randomnly. This is the sample layout of my code. try { SQLConnection.Open(); trans = SQLConnection.BeginTransaction(); //Insert the data into tables using datasets trans.Commit(); } Catch (SqlException ex) { Console.WriteLine(ex.Message); trans.Rollback(); } Randomnly I get the error "This sqlTransaction has completed; it is no longer usable". This error occurs when it tried to execute "trans.Commit();" Anyone has any suggestions? Thanks Tag: one sql connection for multiple web forms Tag: 105192
  - 12
    - I want to execute a simple UPDATE command! I am pretty new to .NET, so can someone tell me why this doesn't work? It does not throw any exception but it doesn't update the record in the table either. All variables are populated correctly and the record DOES exist! Thanks in advance! SqlConnection loConnection = new SqlConnection(<connection string here>); SqlCommand loCommand = loConnection.CreateCommand(); loCommand.CommandText = "UPDATE NewUser SET Name = '" + lsName + "' WHERE NewUserID = " + liNewUserID; loConnection.Open(); SqlDataReader loDataReader = loCommand.ExecuteReader(); loDataReader.Read(); loDataReader.Close(); loConnection.Close(); Tag: one sql connection for multiple web forms Tag: 105189
  - 13
    - Is it bad to use transactions for read operations (keeps conn. ope Hi I am trying to find out if it is bad, and how bad, to start a database transaction on a set of read operations. By starting a transaction I can keep open the database connection...but is there significant overhead for transaction? Basically I am populating a set of objects and I may hit the database 5 to 10 times on any given set of parent/child objects. I cannot use stored procedures. What do you think? Tag: one sql connection for multiple web forms Tag: 105187
  - 14
    - updating a decimal 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 Tag: one sql connection for multiple web forms Tag: 105186
  - 15
    - 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: one sql connection for multiple web forms Tag: 105184
  - 16
    - 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: one sql connection for multiple web forms Tag: 105180
  - 17
    - 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: one sql connection for multiple web forms Tag: 105179
  - 18
    - 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: one sql connection for multiple web forms Tag: 105175
  - 19
    - 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: one sql connection for multiple web forms Tag: 105167
  - 20
    - 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: one sql connection for multiple web forms Tag: 105164
  - 21
    - 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: one sql connection for multiple web forms Tag: 105161
  - 22
    - 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: one sql connection for multiple web forms Tag: 105159
  - 23
    - 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: one sql connection for multiple web forms Tag: 105152
  - 24
    - 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: one sql connection for multiple web forms Tag: 105151
  - 25
    - store rtf in C# How I can store rtf format in SQL Server. (C#) Tag: one sql connection for multiple web forms Tag: 105147

Hello,

I am learning ADO.NET, so please bear with me.
Currently, I am coding in VB.NET and running a SQL Server
2000. My question is this, how do I use only one
SQLConnection for multiple web forms? Is this even
possible?

Thanks in advance,
-new2.NET

Top

RE: one sql connection for multiple web forms by KerryMoorman

KerryMoorman
Thu Feb 17 13:31:05 CST 2005

new2.Net,

Its possible, but not usually advisable.

Hanging onto an open connection will keep your app from scaling. After all,
there are only so many connections to go around, and each one uses resources
on the server.

Instead, get a connection right before you need it, use it, and then close
the connection as soon as possible.

ADO.Net will keep a pool of connections that your app will use.

Kerry Moorman

"new2.NET" wrote:

> Hello,
>
> I am learning ADO.NET, so please bear with me.
> Currently, I am coding in VB.NET and running a SQL Server
> 2000. My question is this, how do I use only one
> SQLConnection for multiple web forms? Is this even
> possible?
>
> Thanks in advance,
> -new2.NET
>

Top

Re: one sql connection for multiple web forms by Cor

Cor
Thu Feb 17 13:34:48 CST 2005

>
> I am learning ADO.NET, so please bear with me.
> Currently, I am coding in VB.NET and running a SQL Server
> 2000. My question is this, how do I use only one
> SQLConnection for multiple web forms? Is this even
> possible?
>

Why?

Beside that every datareader or whatever needs his own connection.

Cor

Top

Re: one sql connection for multiple web forms by Sahil

Sahil
Thu Feb 17 13:47:31 CST 2005

You don't need to and you shouldn't either. ADO.NET does all this under the
seams using connection pooling. Just keep creating new instances of the
SqlConnection object.

- Sahil Malik
http://codebetter.com/blogs/sahil.malik/

"new2.NET" <anonymous@discussions.microsoft.com> wrote in message
news:005b01c51525$5ed0c280$a501280a@phx.gbl...
> Hello,
>
> I am learning ADO.NET, so please bear with me.
> Currently, I am coding in VB.NET and running a SQL Server
> 2000. My question is this, how do I use only one
> SQLConnection for multiple web forms? Is this even
> possible?
>
> Thanks in advance,
> -new2.NET

Top