Auto-Created SqlParameter Definitions

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Ado
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - How to Sort ComboBox that has a DataSource? VB.net... MS Access data files Got 2 Comboboxes. Both are bound to a DataSet. One lists a groups of numbers. The other associated names. The current method is to list the Combobox with numbers (which they are in numeric order in the Access data file). What I want to accomplish is to give a user the method to toggle the associated names to be sorted or not (not at startup). When I try to Sort the Combobox of associated names (combobox2) I get the error: Can't sort a ComboBox that has a DataSource set. Sort the data using the underlying data model. How can this be accomplished? Many thanks Ralph Tag: Auto-Created SqlParameter Definitions Tag: 69734
  - 2
    - Datareader and Isolation Level Hi, I am using a datareader that has been filled with a whole table (select * from table). I am processing every record in a loop which takes some time (this is bad design I know, but its good enough for now) I think the default isolation level is "read committed" so during this period no updates/deletes are possible. Read committed is to strict for what I want so I rewrote the query like this : select * from table (nolock). Furthermore I found out that if an error occurs in the loop, so the connection isnt closed, the locks are held on the table until the .net garbage collecter kicks in. My question is : - Can I somehow change the default isolation level, in the connection string for example? - Is there a property in the ADO.NET command or datareader class that lets me set this programmatically. (I found the property isolationlevel but couldn't get it to work) All the best, Tom Tag: Auto-Created SqlParameter Definitions Tag: 69732
  - 3
    - Creating a subset table/view How can I crate a subset table or view from a table? I only want certain columns and all the rows? I do NOT want to loop through the rows and add those to my new table or view. I just want to specify a couple of columns and retrieve a subset table or view. Someone has an idea? Thanks, Sabine Tag: Auto-Created SqlParameter Definitions Tag: 69731
  - 4
    - Can't edit a field in a dataset I've created a dataset from a query that returns a column from an amalgamation of fields in the database. e.g. SELECT [FirstName] & ' ' & [LastName] AS [FullName] FROM [tblPeople] However, when I try to modify the value of this column ([FullName], in the example), I get an error saying it's read only. I can edit the other columns just fine, but I cannot modify this one. Is there any way to make the dataset allow me to modify data in this column? The dataset just contains throwaway data that I'm never going to write back to the database anyway. - Don Tag: Auto-Created SqlParameter Definitions Tag: 69728
  - 5
    - Connection Pool error. I am getting the following SQL exception: Error: ReadSessionData: Error 1 - Type: System.Data.SqlClient.SqlException Source: .Net SqlClient Data Provider Target Site: System.Data.SqlClient.SqlInternalConnection GetConnection(Boolean ByRef) Description: General network error. Check your network documentation. Stack Trace: at System.Data.SqlClient.ConnectionPool.GetConnection (Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledCon nection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at visa.dps.ppc.data.SessionInfoRequest.Execute() The root seems to be a General network error. Does anyone know the cause? I can connect with the database with Enterprise Manager and the database seems intact. I can't figure out why I am getting this error. It seems to occur the most when I install a new version of my application. Once the application runs once without error it seems that this error goes away. Any ideas? Thank you. Kevin Tag: Auto-Created SqlParameter Definitions Tag: 69727
  - 6
    - DataSet Merge Question/Problem Hi All I am working with a mailing database and I retrieve the mailing database and hang onto this information in a dataset. I'm then retrieving another dataset with more mailing addresses from a different database and merging it with the other dataset by calling the originalds.merge(newds); this works wonderfully and the new data shows up in my datagrid control. problem is when I call the update to write the newely merged rows back to the original database nothing gets written and when i do a retrival from the original database I loose all merged information. I've tracked the problem down to the rowstates of the merged rows... they have the state of unchanged??? shouldn't these be in the state of added ??? I noticed that you can't change a rowstate within a dataset using the property for the row. Whats the problem and how can I get around it? I've also tried messing around with the acceptchanges and getchanges functions for further testing but nothing worked? Any help is appreciated. Thanks Bryan Tag: Auto-Created SqlParameter Definitions Tag: 69725
  - 7
    - MSDE install -- help! I have downloaded the latest edition of MSDE and am trying to install it on my machine to work with Visual Studio .NET 2003. I ran the install program exactly as Microsoft specified, using the command: setup.exe /qb INSTANCENAME=VSDOTNET DISABLENETWORKPROTOCOLS=1 SAPWD="mypass" The installer starts to run, but then stops with the message: "The instance name specified is invalid." What gives? Thanks in advance. Tag: Auto-Created SqlParameter Definitions Tag: 69724
  - 8
    - Odd ExecuteReader Error Finally run out of ideas on this one.... Just to get it outta the way, the environment: 2 NLB Web servers (each Win2003, IIS6, 2G memory, 2 physical/4 logical CPU, 2 NICs, Unicast) 1 DB Server (Win2K, SQL2K, 2G memory, 2 physical/logical.. no hyperthreading) I'm periodically getting a "Timeout Expired..." error on SqlCommand.ExecuteReader for VERY simply INSERTs and UPDATEs (no stored procedures) ex. INSERT INTO MyTable (fields) VALUES(values), UPDATE MyTable SET... WHERE MyTableKey=@MyKeyValue It happens on a variety of tables, none of which have triggers. The SQLCommand timeout value is set to 60. SQL Server is showing no blocks, long lock wait times, or anything else that would indicate a problem on the DB server. No backups or replication snapshots at these time either. In fact, the DB server is humming along nicely. Also, using non-pooled connections or pooled connections does not seem to make a difference. There are some strange things: First, only seeing it at the top of the hour, but there is nothing specifically running at the top of the hour I can find. (no jobs, recycling of app pool, other services running) Doesn't seem to be related to load (sometimes happens at peak, other times off peak (ex. 8pm) Second, only happens on sites that are NLB... there is an asp.net site on one of the servers (same DB, similar C# code) which does NOT use NLB and does not see the errors. The only thing I can see that COULD be a problem is that the DB Server's Subnet is the same as Web Servers Virtual and Dedicated IPs on NIC #1 (versus our other subnet on Web Servers' NIC #2) I'd love to blame this, but doesn't explain the consistent time of day when I see this. Any ideas? Thanks, -- JD Tag: Auto-Created SqlParameter Definitions Tag: 69722
  - 9
    - Porting a data layer from SQL to OleDb/Access I'm quaking at the thought of doing this (it's against my will!), but are there any significant "gotchas" porting a data layer from the SqlClient to the OleDb classes for use with Access? I've got straight-forward SQL for all of the commandtext, generally with parameters for every query. Does Access speak the same language? Tag: Auto-Created SqlParameter Definitions Tag: 69709
  - 10
    - Create New DataTable From DataView I have a DataView but now I need a DataTable to pass into several routines I've created. Can I make a DataTable from a DataView? The DataView is now sorted and cleaned up and I don't want to reference the original table the DataView came from. Axe Tag: Auto-Created SqlParameter Definitions Tag: 69708
  - 11
    - Can't add data to DataSet from non-creating thread? Hi, My app receives data via an async socket. I need to put this data into a DataSet and display it via a DataGrid. If I add the data to the dataset when it arrives using the async created thread, my app crashes with a NullException inside Application.Run(). If I disconnect the DataSet from the DataGrid (dataGrid.DataSouce = null), then the app does NOT crash. It only crashes when I'm trying to display the data that I'm adding to the DataGrid. So what's the best way to solve this problem? How do you get data into a DataSet via the non-creating thread? I built a demo app below that demonstrates the problem which is listed below. THANKS! John using System; using System.Drawing; using System.Collections; using System.ComponentModel; using System.Windows.Forms; using System.Data; using System.Threading; namespace DataGrid { /// <summary> /// Summary description for Form1. /// </summary> public class DG : System.Windows.Forms.Form { Random random = new Random(); bool running = true; private System.Windows.Forms.DataGrid dataGrid; private DataGrid.MyDataset myDataset; private System.Windows.Forms.Timer timer; private System.Windows.Forms.CheckBox checkBox; private System.ComponentModel.IContainer components; public DG() { // // Required for Windows Form Designer support // InitializeComponent(); dataGrid.DataSource = myDataset; ThreadStart threadStart = new ThreadStart(listenThread); Thread thread = new Thread(threadStart); thread.IsBackground = true; thread.Start(); } private void listenThread() { while ( running ) { // How do I add data to myDataset from this thread? // If I add data to myDataset from this thread, while // myDataset is "connected" to the datagrid, then the // app will crash with a NullException // How do I use the "main" thread to add data to myDataset? // myDataset.MyTable.AddMyTableRow(DateTime.Now, random.Next()); Thread.Sleep(200); } } /// <summary> /// Clean up any resources being used. /// </summary> protected override void Dispose( bool disposing ) { if( disposing ) { if (components != null) { components.Dispose(); } } base.Dispose( disposing ); } #region Windows Form Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InitializeComponent() { this.components = new System.ComponentModel.Container(); this.dataGrid = new System.Windows.Forms.DataGrid(); this.myDataset = new DataGrid.MyDataset(); this.timer = new System.Windows.Forms.Timer(this.components); this.checkBox = new System.Windows.Forms.CheckBox(); ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).BeginInit(); ((System.ComponentModel.ISupportInitialize)(this.myDataset)).BeginInit(); this.SuspendLayout(); // // dataGrid // this.dataGrid.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.To p | System.Windows.Forms.AnchorStyles.Bottom) | System.Windows.Forms.AnchorStyles.Left) | System.Windows.Forms.AnchorStyles.Right))); this.dataGrid.DataMember = ""; this.dataGrid.HeaderForeColor = System.Drawing.SystemColors.ControlText; this.dataGrid.Location = new System.Drawing.Point(8, 48); this.dataGrid.Name = "dataGrid"; this.dataGrid.Size = new System.Drawing.Size(280, 216); this.dataGrid.TabIndex = 0; // // myDataset // this.myDataset.DataSetName = "MyDataset"; this.myDataset.Locale = new System.Globalization.CultureInfo("en-US"); // // timer // this.timer.Tick += new System.EventHandler(this.timer_Tick); // // checkBox // this.checkBox.Location = new System.Drawing.Point(8, 8); this.checkBox.Name = "checkBox"; this.checkBox.TabIndex = 1; this.checkBox.Text = "Timer Enabled"; this.checkBox.CheckedChanged += new System.EventHandler(this.checkBox_CheckedChanged); // // DG // this.AutoScaleBaseSize = new System.Drawing.Size(5, 13); this.ClientSize = new System.Drawing.Size(296, 271); this.Controls.Add(this.checkBox); this.Controls.Add(this.dataGrid); this.Name = "DG"; this.Text = "DataGrid Test"; ((System.ComponentModel.ISupportInitialize)(this.dataGrid)).EndInit(); ((System.ComponentModel.ISupportInitialize)(this.myDataset)).EndInit(); this.ResumeLayout(false); } #endregion /// <summary> /// The main entry point for the application. /// </summary> [STAThread] static void Main() { Application.Run(new DG()); } private void checkBox_CheckedChanged(object sender, System.EventArgs e) { timer.Enabled = checkBox.Checked; } private void timer_Tick(object sender, System.EventArgs e) { // NOTE: THIS WORKS // Console.WriteLine("Fire"); // myDataset.MyTable.AddMyTableRow(DateTime.Now, random.Next()); } } } Tag: Auto-Created SqlParameter Definitions Tag: 69701
  - 12
    - Datagrid with hyperlink columns, need to pass or hold multiple variables. I have a datagrid with hyperlink columns on my page Fill.aspx. I allow users to click on any column in a row. This triggers a lookup using the order#(SubON) which fills in various text boxes with further information. Right now my code looks like this: <asp:datagrid id="dgdList" style="Z-INDEX: 107; LEFT: 0px; POSITION: absolute; TOP: 0px" runat="server"Font-Names="Arial" Font-Size="Smaller" Width="480px" Height="136px" AutoGenerateColumns="False"> <SelectedItemStyle BackColor="PowderBlue"></SelectedItemStyle> <AlternatingItemStyle BackColor="#FFE0C0"></AlternatingItemStyle> <HeaderStyle Font-Size="X-Small" Font-Names="Arial" Font-Bold="True" BackColor="Orange"></HeaderStyle> <Columns> <asp:HyperLinkColumnDataNavigateUrlField="SubON"DataNavigateUrlFormatString="Fill.aspx?SubON={0}"DataTextField="SubON"HeaderText="Order #"> </asp:HyperLinkColumn> <asp:HyperLinkColumnDataNavigateUrlField="SubON"DataNavigateUrlFormatString="Fill.aspx?SubON={0}" DataTextField="Block"HeaderText="Block"></asp:HyperLinkColumn> <asp:HyperLinkColumnDataNavigateUrlField="SubON"DataNavigateUrlFormatString="Fill.aspx?SubON={0}" DataTextField="Quantity"HeaderText="Quantity"> </asp:HyperLinkColumn> <asp:HyperLinkColumnDataNavigateUrlField="SubON"DataNavigateUrlFormatString="Fill.aspx?SubON={0}" DataTextField="NPA"HeaderText="NPA"></asp:HyperLinkColumn> <asp:HyperLinkColumnDataNavigateUrlField="SubON"DataNavigateUrlFormatString="Fill.aspx?SubON={0}" DataTextField="RC"HeaderText="RC"></asp:HyperLinkColumn> <asp:HyperLinkColumnDataNavigateUrlField="SubON"DataNavigateUrlFormatString="Fill.aspx?SubON={0}" DataTextField="RDate"HeaderText="Date"></asp:HyperLinkColumn> </Columns> </asp:datagrid> What I need to do is carry another variable as well. Since I'm reloading the page: DataNavigateUrlFormatString="Fill.aspx?SubON={0}" I loose the variable on the page where I'm holding it in an invisible text box. So, I need a variable which I've been carrying by url string for several pages as well as the SubOn variable. I've tried adding to the UrlFormatString, but I don't know how to do so properly if it can be done. Another option would be to use postback instead of loading the page again (I think) but I can't figure out how to do that either. Can anyone help? Tag: Auto-Created SqlParameter Definitions Tag: 69698
  - 13
    - newbie transaction question Hello All: I am attempting to execute two statements as part of a single transaction using the Microsoft data access application block. The code, which is similar to what follows, returns this message when it attempts to execute the second "SqlHelper.ExecuteReader" statement: "The SqlCommand is currently busy Open, Fetching" I would greatly appreciate any insight! Thanks, Chris ---------------------------------------------------------------------------- - SqlConnection sqlConnection = new SqlConnection(DB("SPMS")); sqlConnection.Open(); SqlTransaction sqlTransaction = sqlConnection.BeginTransaction(IsolationLevel.Serializable); try { // Set parameters // Insert consumer SqlDataReader sqlDataReader = SqlHelper.ExecuteReader(sqlTransaction, CommandType.StoredProcedure, "ConsumerAdd", consumerParameters)); safeDataReader.Close(); // Insert consumer history SqlDataReader sqlDataReaderHistory = SqlHelper.ExecuteReader(sqlTransaction,CommandType.StoredProcedure,"Consumer HistoryAdd",consumerParameters)); sqlTransaction.Commit(); } catch(Exception Exception) { sqlTransaction.Rollback(); throw Exception; } finally { sqlConnection.Close(); } Tag: Auto-Created SqlParameter Definitions Tag: 69694
  - 14
    - Dataset Record Size Restriction Hi All, I was wondering.. do we have any restriction on 1. No of columns in a DataSet-Table 2. Record size restriction per row 3. Record size restriction Data Ste level I am asking this coz i am facing a funny problem. I execute a querry and it returns me some data. Now, some time the query gets executed but no records are returned and no exception is thrown. Now, when i reduce the record size, by removing some columns or reducing the text per column, i am able to get the results. Any pointers? I am using System.Data.Oracle client with Oracle 9i, 8.0 and i am using OracleDataAdapter to fill my DataSet. Tag: Auto-Created SqlParameter Definitions Tag: 69687
  - 15
    - DataBinding Question Hi, Right now in my app I am using databinding for some of my combo boxes. I only uses databinding to display the data to the user. Here is my question. Since, databinding keeps the dataset in memory is it better just to loop through the dataset table and add each item? Or should I create an array list from a datareader object to display the data? I would use the datareader object however I would have to pass the datareader from the database to the business component then to the UI. Any suggestions? Thanks Tag: Auto-Created SqlParameter Definitions Tag: 69686
  - 16
    - HOWTO: Insert New Row I want to write a funciton that has 2 parameters(string tableName and IDbDataParameter[] params). I can't seem to figure out how to create a new record using a combination of a Dataset/DataTable/DataRow. Or is there a better way to insert rows? Tag: Auto-Created SqlParameter Definitions Tag: 69685
  - 17
    - Binding data from DataReader to DataGrid Hi I have used SQLDataReader for fetching data(due to performance issue) and now I want to bind this data to DataGrid, How should I do this? Sample code is most welcomed :) Makarand Tag: Auto-Created SqlParameter Definitions Tag: 69677
  - 18
    - MDAC and .NET framework Hello all. I have a set up question. Here it is: I wrote ASP.NET application that uses ADO.NET (everything is managed code). Now I am going to deploy this app to my web server. I installed .NET Framework 1.1 Question: Do I need to install MDAC2.7 on my web server for ADO.NET to work? Thanks. Tag: Auto-Created SqlParameter Definitions Tag: 69673
  - 19
    - Calling AddNew on BindingContect (CurrencyManager) Calling AddNew on BindingContext creates a New DataRow. What is that DataRow's state and how do I retrieve that DataRow prior to a call to EndCurrentEdit? I want to pass that DataRow as a parameter. Tag: Auto-Created SqlParameter Definitions Tag: 69672
  - 20
    - How is this CurrencyManager persisting???? Hi, I have a DataGrid on a form (WinForms App) that has an event that opens another form containing a user control . The CurrencyManager from the form that contains the Grid is referenced in the form that is opened as well as in the user control . Everything works fine until I close the form, and click on another row in the DataGrid. The CurrencyManager_Position_Changed event is raised in the UserControl contained on the form that was just Disposed of! Is the reference of the CurrencyManager in the original form keeping it alive? When the form that opens from the DataGrid is closed, I want the CurrencyManager in that form and containing UserControl to be destroyed. How can I do this? Thanks! Dave Tag: Auto-Created SqlParameter Definitions Tag: 69665
  - 21
    - Access Related Query Hi, I am using Access as a backend to my project. From my front end I am issuing the queries, however I am finding it is too much slow. I wanted to execute multiple sql statement. My question here is how to execute these multiple statement?. Is it possible in acess 2000. can I have your suggestions?. TIA Kishor Tag: Auto-Created SqlParameter Definitions Tag: 69658
  - 22
    - Does WinForm UserControl inherit BindingContext of owner? Hi, Does a usercontrol placed on a form automatically inherit or acquire the parent forms' BindingContext? Thanks, Dave Tag: Auto-Created SqlParameter Definitions Tag: 69650
  - 23
    - Extract images from sql server Hi, I've got a column in a table which contains images (bmp and jpg, i guess sql server don't convent the jpg to bmp??). How can I extract these images from the table. I've tried something with a MemoryStream, but I don't know how to save it to a file because this stream is a byte array and I can't check the file type and other stuff like that. Is there anybody with the same problem? Thanks a lot Filip Tag: Auto-Created SqlParameter Definitions Tag: 69645
  - 24
    - HLP: Output Display Issues I'm slowly making my way through my project (this project being the first time I've ever tried working with a DB - Access file in this case using VB.net Standad). But now I've come to the part where I want to work on my 'visual' output format to the end user. The Access file is fixed and I can't modify it (which is too bad). But here is what I want to (hope to) have: The DB stores a Users weekly time sheet information. Each row represent a single project, date of one day of the week, and the number of hours for that project for that day. So a person could work on the same project each day and have 5 rows of time sheet entries. Then etc. for any other projects they work on that week. The DB has 14 columns overall. I want to only display a couple of them. And I want to add 7 additional columns (Saturday to Friday) to display calculated project hour values (each day for that week). Just like a typical time sheet would display... the Project + week days on ONE row. I've the DataAdaptors, DataSets and Filters in place and working fine bounded to a test DataGrid (just to see the raw data for now). The number of rows can be anywhere from none... to (say) 30+... depending upon the number of project the user worked on. A graphic display is thus: Typical Raw DB data Record row I would use (uneccessary columns omitted here): Project; WeekDate; DayHours; UserName; UserChargeOut Project; WeekDate; DayHours; UserName; UserChargeOut Project; WeekDate; DayHours; UserName; UserChargeOut The typical Final output row would look something like: Project; SatHrs; SunHrs; MonHrs; TuesHrs; WedHrs; ThurHrs; FriHrs Project; SatHrs; SunHrs; MonHrs; TuesHrs; WedHrs; ThurHrs; FriHrs Project; SatHrs; SunHrs; MonHrs; TuesHrs; WedHrs; ThurHrs; FriHrs Then I'll need to know how to retrieve the five days original data lines when a User clicks on one of the Final Output rows. This is so a user can edit/delete a record set. The two choices I believe I have is either a DataGrid or a ListView. Or... should I have a blank Access file of all the columns I want... bind the DataSet to it and work out on displaying my data? I'm probably asking for too much here. I don't know. But I really MISS a lot of the display methods that VB6 use to have :( Any help is muchly appreciated. Hopefully I've explained it clearly enough. Regards, Bruce Tag: Auto-Created SqlParameter Definitions Tag: 69637
  - 25
    - get record field value in ASP.NET In ASP 3.0, rs("field_name") is able to get the value of field_name in a recordset. In ASP.NET using VB.NET, I think SqlDataReader is the substitute of recordset? I don't quit understand how to use it. Here's my code attempts, but it yields run-time error "Invalid attempt to read when no data is present"on dr(i).ToString Dim cn As New SqlConnection(cs) Dim sql As String = "select * from [Admin] where UserName = '" & TextBox1.Text & "'" & "AND Password = '" & TextBox2.Text & "'" & ";" Dim cmd As New SqlCommand(sql, cn) cmd.Connection.Open() Dim dr As SqlDataReader dr = cmd.ExecuteReader() For i = 0 To dr.FieldCount - 1 strLine = strLine & dr.GetName(i).ToString & Chr(9) & dr(i).ToString Next Please advise! Thanks! Tag: Auto-Created SqlParameter Definitions Tag: 69636
- Next
  - 1
    - Active Directory Related Question. Hi, I like to know if there is any way we can use SQL Query syntax for getting values out of ADS. If there is any method pls let me know with example. Thanks Regards ARvind Rangan Tag: Auto-Created SqlParameter Definitions Tag: 69626
  - 2
    - ADS Related Query Hi, I like to know if there is any way we can use SQL Query syntax for getting values out of Active Directory Schema. If there is any method pls let me know with example. Thanks Regards ARvind Rangan Tag: Auto-Created SqlParameter Definitions Tag: 69625
  - 3
    - What's about the " PInvoke Meta data" error? I'm coding the test for testing my project ( which is combined with 2 dll files ) . When I call the function from the dll file , it's occur error display "PInvoke Meta data" error and the function cann't run in the right way. Aspite it can run smoothly when compile by step. Please suggest me how can I test ( or trace ) my program by simulate the working function and call inside code. Thanks. Tag: Auto-Created SqlParameter Definitions Tag: 69623
  - 4
    - ASP.NET SQL Server Please pardon my ignorance on this one, but here's what I'm trying to do: I have a table in a SQL Server 2000 DB called distributors. I've got an ASPX which has a text box, a button, and two labels. In the textbox, the user is to enter a "distributor id", then click the button. The button should query the distributors table for a matching distributor id, and return two prices, which is what the labels should reflect. Right now, though, I'm not even trying to match up the distributor id. The table has only one record in it at this time. This is what I'm doing right now: sqlConnection1.ConnectionString = blah blah blah; sqlSelectCommand1.CommandText = "SELECT distid, colorprice, blackprice FROM dbo.distributors"; sqlSelectCommand1.Connection = sqlConnection1; private void Button1_Click(object sender, System.EventArgs e) { sqlConnection1.Open(); sqlDataReader MyReader = sqlSelectCommand1.ExecuteReader(); Label1.Text = MyReader.getSqlMoney(1).ToString(); Label2.Text = MyReader.getSqlMoney(2).ToString(); sqlConnection1.Close; } As you can see, right now, I'm not even trying to match up the distributor id. I'm just trying to get the prices for the one record that's there. After I get that working I'll want to start matching up the distributor id. The error I'm getting is: Invalid attempt to read when no data is present. Any ideas? Thanks! Scott Tag: Auto-Created SqlParameter Definitions Tag: 69618
  - 5
    - Sql Joins Anyone have any experience working with middle tiers and Stored Procedures with INNER Joins and OUTER JOINS. If so, I need some suggestion on how you handled tables aliases. Thanks, - Rob Tag: Auto-Created SqlParameter Definitions Tag: 69613
  - 6
    - comparison error Hi I am getting the 'Operator is not valid for type 'DBNull' and string "".' error on the following line; If (mydatatable.Rows.Item(I).Item("Forenames") Is System.DBNull.Value) Then ' 'I' is the loop variable from 0 To mydatatable.Rows.Count - 1. Any ideas on what is the reason for this error? Thanks Regards Tag: Auto-Created SqlParameter Definitions Tag: 69600
  - 7
    - simple postback to a database In a .Net Asp application I am able to retrieve data from an Access db and display in on a web form. How ever during the update function after a page update, the update command does not throw an exception but it does not save out the changes either. It seems that upon the postback no data exists in the dataset. I must be missing something. How you post the data from an edited user page back to the database? if (!(Page.IsPostBack)) { this.oleDbDAUser.Fill(this.dsMain1,"Users"); this.lblUserID.DataBind(); this.txtFirstName.DataBind(); this.txtMiddleName.DataBind(); ......... } No error here, but no data is saved either: private void btnSave_Click(object sender, System.EventArgs e) { try { this.oleDbDAUser.Update(this.dsMain1); } catch (Exception oops) { this.txtUserMessage.Text = "Error occured!<BR>" + oops.ToString() ; } } } Thanks, Ray Tag: Auto-Created SqlParameter Definitions Tag: 69597
  - 8
    - DataAdapter.Fill method problem When I run following code it creates two connections to Sql Server database. I observed this from SQL Profiler. Can someone explain this behavior? SqlDataAdapter objAdpater = new SqlDataAdapter("SELECT * FROM TABLE", "Server=xyz;User ID=sa;Password="); DataSet objDS = new DataSet(); objAdpater.Fill(objDS); I am running windows 2000 SP3, SQL Server 2000 SP3. -Thanks -Vivek. Tag: Auto-Created SqlParameter Definitions Tag: 69596
  - 9
    - Overloading Update method I want to overload a userdefined method named update so that I pass in different typed datasets and through a case statement it would then update using the appropriate dataadapter. Is this possible and if so how would the check go to look for the particular typed dataset? Also how do I define the method? Tag: Auto-Created SqlParameter Definitions Tag: 69595
  - 10
    - 3RD POST- IS MICROSOFT READING THESE HELP! I am trying to produce a the column that contains an error after an sqldataadapter update. Just connect to a sql db get a dataset, set the column to a string greater than the field and try da.update. then catch it a sqlexception and pass it to this ms sample code: Private Sub GetAllErrs(ByVal myRow As DataRow) ' Declare an array variable for DataColumn objects. Dim colArr() As DataColumn ' If the Row has errors, check use GetColumnsInError. Dim i As Integer If myRow.HasErrors Then ' Get the array of columns in error. colArr = myRow.GetColumnsInError() For i = 0 to colArr.GetUpperBound(0) ' Insert code to fix errors on each column. Console.WriteLine(colArr(i).ColumnName) Next i ' Clear errors after reconciling. myRow.ClearErrors() End If End Sub here is the ms link http://msdn.microsoft.com/library/default.asp? url=/library/en- us/cpref/html/frlrfsystemdatadatarowclassgetcolumnsinerrort opic.asp the column array is 0 with no elements! Please help and thanks in advance . Tag: Auto-Created SqlParameter Definitions Tag: 69593
  - 11
    - performance ADO.NET vs ADO Do u know articles about performance benchmark comparing ADO.NET vs ADO? Thanks Tag: Auto-Created SqlParameter Definitions Tag: 69592
  - 12
    - 2 simple questions about ado/xml hi... 1. what is the quickest/most efficient way to get read-only records from an access table into an xml string? i have the following which works fine. is this the most efficient way? OleDbDataAdapter da = new OleDbDataAdapter(cmd); DataSet ds = new DataSet("Records"); da.Fill (ds, "Record"); return ds.GetXml(); 2. after i add/update/delete access record(s) i want the information of the record(s) in xml. how can i do this? thanks a lot. :) Tag: Auto-Created SqlParameter Definitions Tag: 69588
  - 13
    - Connection String vs DSN, what to use and why? Which is better to use a connection string or DSN? Why? It seems like using a connection string is recommended but what exactly are the reasons for this? Also, one of the nice things about DSN's is the ability to quickly change what database your app is pointing to. How is this done with connection strings? Registry entries? I thought I read somewhere connections strings being held in the registry should be encrypted, how should this be accomplished? Is there a semi-standard way of doing all this? Thanks for any help you may provide, Dan Tag: Auto-Created SqlParameter Definitions Tag: 69585
  - 14
    - Query Group Dataset I have a dataset / datatable in memory and i would like to run a query against that to create another in memory datatable or dataview. In this case I have a bunch of data... and i want to run a 'grouping' select query where i just get all items grouped together for example: Existing in memory datatable (2 fields, qty and desc): Record 1: Qty: 23 Desc: Bananas Record 2: Qty 10 Desc: Strawberries Record 3: Qty 23 Desc: Bananas Record 4: Qty 18 Desc: Grapes I want to run a group query on field 'Desc' to give me: Record 1: Bananas Record 2: Strawberries Record 3: Grapes Any ideas? I know how to do this if the data is in an sql database.. but how do i run a query against an in memory dataset? Thanks in advance! Chris cthunell@pierceassociates.com Tag: Auto-Created SqlParameter Definitions Tag: 69582
  - 15
    - DataAdapter.Fill very slow I am currently having a problem with a DataAdapter.Fill performing very slow or timing out. Our code is written in C#, platform Windows 2003 and the database is SQL Server 2000. However after reviewing other postings this seems to be an ado.net problem and not tied to SQL Server. groups.google.com search: DataAdapter Fill Slow We use Typed DataSets and stored procedures in our code. The query is very simple. It queries three tables that are left joined and has a where clause for an ID, and two dates. The tables have been indexed appropriately. I have tried multiple things to include: Changing from Typed DataSets to the regular DataSets. Creating performance counters to see what is happening on the machines. Running the query in Query Analyzer and Enterprise Manager runs in .5 seconds or faster. Changed databases and machines. Rebooted machines, refreshed SQL Server services, restart SQL Server. When I debug in DotNet it always points to the Fill of the DataAdapter. If anyone has any suggestions it would be appreciated. Tag: Auto-Created SqlParameter Definitions Tag: 69575
  - 16
    - newbie vb6 ADO to vb.net ado.net, paging Hi, I am converting an existing VB6 webclass app to VB.NET ADO.NET and I'm having a problem coming up with solution for paging the records returned from my stored procedures. As I understand it from the help I can use a dataadapters fill() method to specify a page size and tha page I want. However this will only return 1 page worth of data. Currently in my web pages I provide next/back links and a <SELECT> list of page numbers. If I use the dataadapters fill() method to do the paging how will my code be able to workout how many pages there are all together? I looked at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconpagingthroughqueryresult.asp ... but that doesn't seem to fit what I want to do. In ADO it was simple now it seems to be a lot harder. I realise that ADO.NET is built for performance and so doesn't come with as many built in features but some examples of ADO to ADO.NET in the area of paging would of been handy. Anybody done the same leap from ADO --> ADO.NET and done paging? Regards, Peter Tag: Auto-Created SqlParameter Definitions Tag: 69573
  - 17
    - Simple form postback to update a database In a .Net Asp application I am able to retrieve data from an Access db and display in on a web form. How ever during the update function after a page update, the update command does not throw an exception but it does not save out the changes either. It seems that upon the postback no data exists in the dataset. I must be missing something. How you post the data from an edited user page back to the database? if (!(Page.IsPostBack)) { this.oleDbDAUser.Fill(this.dsMain1,"Users"); this.lblUserID.DataBind(); this.txtFirstName.DataBind(); this.txtMiddleName.DataBind(); ......... } No error here, but no data is saved either: private void btnSave_Click(object sender, System.EventArgs e) { try { this.oleDbDAUser.Update(this.dsMain1); } catch (Exception oops) { this.txtUserMessage.Text = "Error occured!<BR>" + oops.ToString() ; } } } Thanks, Ray -- -- /\_Ray Valenti ____ http://www.quixor.com ______ \/ Quixor Flex Systems, Ltd. Tag: Auto-Created SqlParameter Definitions Tag: 69571
  - 18
    - Simple form postback to update a database In a .Net Asp application I am able to retrieve data from an Access db and display in on a web form. How ever during the update function after a page update, the update command does not throw an exception but it does not save out the changes either. It seems that upon the postback no data exists in the dataset. I must be missing something. How you post the data from an edited user page back to the database? if (!(Page.IsPostBack)) { this.oleDbDAUser.Fill(this.dsMain1,"Users"); this.lblUserID.DataBind(); this.txtFirstName.DataBind(); this.txtMiddleName.DataBind(); ......... } No error here, but no data is saved either: private void btnSave_Click(object sender, System.EventArgs e) { try { this.oleDbDAUser.Update(this.dsMain1); } catch (Exception oops) { this.txtUserMessage.Text = "Error occured!<BR>" + oops.ToString() ; } } } Thanks, Ray -- Tag: Auto-Created SqlParameter Definitions Tag: 69570
  - 19
    - Access Passwords Why am I having trouble getting the visual studio designer to accept an access database with a password? It keeps giving me an error that the database is being used by me but I am not. Tag: Auto-Created SqlParameter Definitions Tag: 69564
  - 20
    - Combobox vertical scroll position Does anyone know how to determine the slider position (i.e. relative to the min and max values) of a combobox's vertical scroll bar (i.e. maybe a win api call?). I am trying to feedback the list's value as the user's scrolls the combobox (the list is too large to fill the combobox). I can't find any way to get this information. I seem to recall that in VB 6.0 this was available in one of the scrolling functions. If there is no way to get this info in vb.net, I would like to build my own combobox with textbox, listbox and vertical scroll bar. However, the problem then becomes how to make the vertical scroll bar look like the combobox scroll bar (I like the appearance of the latter when running on XP). Tag: Auto-Created SqlParameter Definitions Tag: 69562
  - 21
    - Adding rows to dataset (a.k.a. can an MVP help me please!) I'm totally lost here.... I have a blank typed dataset designed to hold invoice data, OK? The dataset has two tables, InvoiceHeaders and InvoiceLines. The invoice data is generated by a system/36 emulator and therefore comes in as a comma-delimited text file. My task is to get the text into the dataset so I can bind it to a crystal report and print the invoices. SO: I open the header text file, and go into this loop to attempt to fill the header table: Dim Ivc as New IvcDataSet Do While Not EOF(1) Dim x As IvcDataSet.InvHeadersRow Input(1, x.InsuredNo) Input(1, x.Item("EntryMonth")) Input(1, x.Item("KeyerInit")).... Ivc.Tables("InvHeaders").Rows.Add(x) x = Nothing Loop When I run the code, I get an error on the first input line because x is not set to an instance of an object. Being familiar with this type error I change the Dim line to read: Dim x As New IvcDataSet.InvHeadersRow Now, I have a blue squigly under the x that says "Argument not specified for parameter 'rb'..." or something like that. I find out that the rb is a System.Data.DataRowBuilder object. So I turn to the MSDN library to find out about the DataRowBuilder class. My research reveals that, according to MSDN, "This type supports the .NET Framework infrastructure and is not intended to be used directly from your code." So how the hell am I supposed to add rows to my datasets???? Tag: Auto-Created SqlParameter Definitions Tag: 69559
  - 22
    - .NET Clr Data performance counters Hi. I have one asp.net application running on my server. I am playing with the .NET Clr DATA performance counters in order to control the connections created by the application. When I select the counter "sqlclient: current # connection pools", the instances listbox shows me several instances of the same asp.net application, each one with a different number. What are these numbers? TIA, Erik Cruz Tag: Auto-Created SqlParameter Definitions Tag: 69558
  - 23
    - DB Locking Hi, I have an application framework which consists of several webservices, webpages and application all of which use a couple of MS Access database. We are currently in the testing phase of the project so we don't want to have to upgrade to SQL Server yet. The problem is that when the webservices or applications open the connections to the databases they open it in single user mode. No matter what connection strings I use they still refuse to open in multi-user mode. This is the connection string I'm using: "Provider=Microsoft.Jet.OLEDB.4.0;Password='';User ID=Admin;Data Source=E:\BORG\TypeProcessor\TypeProcessor.mdb;Mode=Share Deny None;Jet OLEDB:System database='';Jet OLEDB:Registry Path='';Jet OLEDB:Database Password='';Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password='';Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False" Can you suggest anything? Thanks, Simon Stockdale Tag: Auto-Created SqlParameter Definitions Tag: 69557
  - 24
    - Assigning Hot Keys in Web Applications Hello, Can anybody help me to add a hot key to a web application button and have the text on the button underscored. I'm using C# within .NET e.g. assign Alt-C to a button with text "Click Me" where the "C" is underscored. Many Thanks Garfield Tag: Auto-Created SqlParameter Definitions Tag: 69553
  - 25
    - connection pooling problems with sqlconnection object Hi, I have the following code that gets run in my database wrapper class. If Not (m_conn Is Nothing) Then If m_conn.state = ConnectionState.Open Then m_conn.Close() End IF m_conn = Nothing End If I get the following error on the m_conn.Close() line: An unhandled exception of type 'System.InvalidOperationException' occurred in system.data.dll Additional information: A connection pooling error has occurred. The IF has already checked that the connection is open so why the hell is it saying the operation is invalid? It typically seems to produce this error after doing a couple of debug runs of the app. Regards, Peter Tag: Auto-Created SqlParameter Definitions Tag: 69551

Why is there a difference in the definition of sqlparameters that are
auto-created for insert,update or delete parameters when
the datatype is a decimal? For instance why is a ParameterDirection
property added to these and not others or why
is a DataRowVersion parameter added to these and nother others?

this.sqlInsertCommand1.Parameters.Add(new SqlParameter("@T1",
System.Data.SqlDbType.SmallInt, 2, "T1"));

this.sqlInsertCommand1.Parameters.Add(new SqlParameter("@D2",
System.Data.SqlDbType.Decimal, 5,
System.Data.ParameterDirection.Input, false, ((System.Byte)(8)),
((System.Byte)(2)), "D2", System.Data.DataRowVersion.Current, null));

Thanks

Eric

Top