Binding data from DataReader to DataGrid

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
    - 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: Binding data from DataReader to DataGrid Tag: 69673
  - 2
    - 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: Binding data from DataReader to DataGrid Tag: 69672
  - 3
    - 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: Binding data from DataReader to DataGrid Tag: 69665
  - 4
    - 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: Binding data from DataReader to DataGrid Tag: 69658
  - 5
    - 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: Binding data from DataReader to DataGrid Tag: 69650
  - 6
    - 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: Binding data from DataReader to DataGrid Tag: 69645
  - 7
    - 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: Binding data from DataReader to DataGrid Tag: 69637
  - 8
    - 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: Binding data from DataReader to DataGrid Tag: 69636
  - 9
    - 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: Binding data from DataReader to DataGrid Tag: 69626
  - 10
    - 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: Binding data from DataReader to DataGrid Tag: 69625
  - 11
    - 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: Binding data from DataReader to DataGrid Tag: 69623
  - 12
    - 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: Binding data from DataReader to DataGrid Tag: 69618
  - 13
    - 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: Binding data from DataReader to DataGrid Tag: 69613
  - 14
    - 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: Binding data from DataReader to DataGrid Tag: 69600
  - 15
    - 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: Binding data from DataReader to DataGrid Tag: 69597
  - 16
    - 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: Binding data from DataReader to DataGrid Tag: 69596
  - 17
    - 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: Binding data from DataReader to DataGrid Tag: 69595
  - 18
    - 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: Binding data from DataReader to DataGrid Tag: 69593
  - 19
    - performance ADO.NET vs ADO Do u know articles about performance benchmark comparing ADO.NET vs ADO? Thanks Tag: Binding data from DataReader to DataGrid Tag: 69592
  - 20
    - 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: Binding data from DataReader to DataGrid Tag: 69588
  - 21
    - 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: Binding data from DataReader to DataGrid Tag: 69585
  - 22
    - 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: Binding data from DataReader to DataGrid Tag: 69582
  - 23
    - 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: Binding data from DataReader to DataGrid Tag: 69575
  - 24
    - 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: Binding data from DataReader to DataGrid Tag: 69573
  - 25
    - 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: Binding data from DataReader to DataGrid Tag: 69571
- Next
  - 1
    - 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: Binding data from DataReader to DataGrid Tag: 69570
  - 2
    - 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: Binding data from DataReader to DataGrid Tag: 69564
  - 3
    - 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: Binding data from DataReader to DataGrid Tag: 69562
  - 4
    - 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: Binding data from DataReader to DataGrid Tag: 69559
  - 5
    - .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: Binding data from DataReader to DataGrid Tag: 69558
  - 6
    - 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: Binding data from DataReader to DataGrid Tag: 69557
  - 7
    - 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: Binding data from DataReader to DataGrid Tag: 69553
  - 8
    - 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: Binding data from DataReader to DataGrid Tag: 69551
  - 9
    - DataSet V/s Data Objects Hi Friends I have few questions about using DataSets as data storage and using User defined classes (Data Objects) as data storage. Suppose I have plain functionality of retrieving data from data source and updating data into data source and no other complex functionality then how good is idea of using Data Objects instead of DataSets (for better performance)? Can I measure the performance in both the cases if yes how can I do this. Any help on this will be appreciated Regards Makarand Tag: Binding data from DataReader to DataGrid Tag: 69550
  - 10
    - CAN ANYBODY HELP?! Could anyone help me with the following problem! I open an SqlConnection. Then: 1. execute a reader on SqlCommand and get data through that reader; 2. in a certain time I call Cancel() method on SqlCommand and SqlDataReader.Close(). If I perform steps 1 and 2 several times (sometimes it happens even from the first time) I get the error which says that SqlConnection is closed. And it is. So, seems that SqlCommand.Cancel() in combination with SqlDataReader.Close() forces the connection to close. I can't determine the reason why it happens. Can I control somehow this behaviour, because I need the connection to be opened. Thank you in advance, Sergey. Tag: Binding data from DataReader to DataGrid Tag: 69549
  - 11
    - ADO.NET/SQL Mystery In using two different SQL Database server (one for development and one for production) a call to a stored procedure is storing incorrect data. We use ADO.NET SQL Data Adpaters and have set the stored procedure parameters. Tracing through on the debugger shows the correct data in the dataset but the SQL Profiler shows that the second parameters is coming in as a -1 (which is not the data in the dataset). To make matters worse this only occurs on the Development sever with the production server executing without error. What could be the difference in the two servers that parses the ADO.NET interface parameters? Tag: Binding data from DataReader to DataGrid Tag: 69548
  - 12
    - DB2 Connection I am trying to connect DB2. But, I can't not find DB2 in oledb provider list in vs.net 2003. Is there anying additionally required software to connect DB2? Tag: Binding data from DataReader to DataGrid Tag: 69546
  - 13
    - Nullvalued doubles in a strong typed dataset I have a strong typed dataset with some double values. In my database, from where I fill the dataset, I have numbers for these doubles, but they can also bee empty (NULL). I need this to know if the user has typed in 0 or hase typed in nothing. If I set the nullvalue for the doubles in my dataset to (NULL), I get an exception. How can I pass the System.DBNULL value from my database to my doubles? Thanks Thomas Tag: Binding data from DataReader to DataGrid Tag: 69545
  - 14
    - Validations inside datagrid Pleas advise me how to do validations in side datagrid before updating the details into database. I am using VB.NET and updating the datagrid using sqlcommandbuilder. I want to validate the data that user changhes inside the grid. How can I do this? Pls help... Regards, Omav Tag: Binding data from DataReader to DataGrid Tag: 69536
  - 15
    - ASP.NET using ADO.NET connection runtime error I created a simple ASP.NET using ADO.NET application to connect to SQL Server. However, it produces the following run-time error. I think ASPNET is the ASP.NET machine account created by VS.NET, and I already added ASPNET in IIS Manager in directory security tab, and disable the checkbox of anonymous access. Unfortunately, it still not able to solve the problem. Any good suggestions?? Thanks! Exception Details: System.Data.SqlClient.SqlException: User 'MYComputerName\ASPNET' Registered Failure. Source Error on line 37: Line 35: Dim cs As String = "Data Source=MyComputerName;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=autoattendant;Trusted_Connection=yes" Line 36: Dim cn As New SqlConnection(cs) Line 37: cn.Open() Line 38: Response.Write("string = " & cn.ConnectionString) Line 39: End Sub Source File: E:\web\WebApplication2\WebForm1.aspx.vb Line: 37 Stack Trace: [SqlException: User 'TRUSTGOD\ASPNET' Registered Failed] System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnec tionString options, Boolean& isInTransaction) System.Data.SqlClient.SqlConnection.Open() WebApplication2.WebForm1.Submit1_ServerClick(Object sender, EventArgs e) in E:\web\WebApplication2\WebForm1.aspx.vb:43 System.Web.UI.HtmlControls.HtmlInputButton.OnServerClick(EventArgs e) System.Web.UI.HtmlControls.HtmlInputButton.System.Web.UI.IPostBackEventHandl er.RaisePostBackEvent(String eventArgument) System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) System.Web.UI.Page.ProcessRequestMain() Tag: Binding data from DataReader to DataGrid Tag: 69532
  - 16
    - NewRow method changes values in a reference to another row?! Using .NET Framework 1.1. I do a select for a row, assign a strongly typed var to reference/change the row thuought the rest of the code(OrigRow). After various responses from the user that change some column values of OrigRow, I begin a transaction and select(By PK) for the row again to bring it into the transaction. I use the strongly typed NewRow method of the datatable and assign it to another variable(NewRow) to add a new row based on some of the user responses. Right after the newrow method is executed, the column values of both OrigRow and NewRow change to the original db values of OrigRow!!!??? DA.Fill(DS.DT) 'select * OrigRow as DTRow = DT.rows(0) 'here, OrigRow.Qty = 10 .... do some work, OrigRow.Qty += 10 'proposed value = 20 ... 'now work is done, start a transaction... conn.open conn.BeginTransaction 'change cmd obj for PK DA.Fill(DS.DT) 'select where ID = OrigRow.ID, assigned to Txn 'In retrospect, shouldn't this reset values of OrigRow? Another thread! 'now create a new row for another reason NewRow as DTRow = DT.NewRow 'RIGHT HERE, OrigRow Values AND NewRow Values change to pre-work values of OrigRow!!!!???? e.g., OrigRow.Qty = 10 AND NewRow.Qty = 10, NOT NULL!!?? Anybody else see this or able to explain what I'm seeing, I'm going CRAZY! Thanks for any help, Dwaine Tag: Binding data from DataReader to DataGrid Tag: 69531
  - 17
    - Need help with data relations I need to establish a relationship that looks like this: One Payment can have many PaymentLine One PaymentLine can have one Payer One PaymentLine can have many PaymentLine Details The relationships that I create between Payment and PaymentLine work, and the one between PaymentLine and PaymentLine detail work. Whenever, I bind the dataset to a grid, it will never pick up the auto-identity for a payment and payer on a payment line. How can I make this work? Any help or insight would greatly be appreciated. Here is some of the code that I built into a winform testing application: Imports System.Data.SqlClient Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents Button1 As System.Windows.Forms.Button Friend WithEvents DataGrid1 As System.Windows.Forms.DataGrid <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.Button1 = New System.Windows.Forms.Button Me.DataGrid1 = New System.Windows.Forms.DataGrid CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).BeginInit() Me.SuspendLayout() ' 'Button1 ' Me.Button1.Location = New System.Drawing.Point (16, 16) Me.Button1.Name = "Button1" Me.Button1.TabIndex = 0 Me.Button1.Text = "Button1" ' 'DataGrid1 ' Me.DataGrid1.DataMember = "" Me.DataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText Me.DataGrid1.Location = New System.Drawing.Point (24, 56) Me.DataGrid1.Name = "DataGrid1" Me.DataGrid1.Size = New System.Drawing.Size(680, 240) Me.DataGrid1.TabIndex = 1 ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(712, 318) Me.Controls.Add(Me.DataGrid1) Me.Controls.Add(Me.Button1) Me.Name = "Form1" Me.Text = "Form1" CType(Me.DataGrid1, System.ComponentModel.ISupportInitialize).EndInit() Me.ResumeLayout(False) End Sub #End Region Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim myPmtTable As New DataTable("Pmt") Dim myColumn As New DataColumn Dim ds As New DataSet myPmtTable.Columns.Add(AddColumn ("Pmt_id", "System.Int32", True)) 'Add table to dataset ds.Tables.Add(myPmtTable) Dim myPmtLnTable As New DataTable("PmtLn") myPmtLnTable.Columns.Add(AddColumn ("PmtLn_id", "System.Int32", True)) myPmtLnTable.Columns.Add(AddColumn ("Pmt_id", "System.Int32", False)) myPmtLnTable.Columns.Add(AddColumn ("Payer_id", "System.Int32", False)) 'Add table to dataset ds.Tables.Add(myPmtLnTable) Dim myPmtLnDetTable As New DataTable("PmtLnDet") myPmtLnDetTable.Columns.Add(AddColumn ("PmtLnDet_id", "System.Int32", True)) myPmtLnDetTable.Columns.Add(AddColumn ("PmtLn_id", "System.Int32", False)) myPmtLnDetTable.Columns.Add(AddColumn ("PmtLnDet_amount", "System.Double", False)) 'Add table to dataset ds.Tables.Add(myPmtLnDetTable) Dim myPayerTable As New DataTable("Payer") myPayerTable.Columns.Add(AddColumn ("Payer_id", "System.Int32", True)) myPayerTable.Columns.Add(AddColumn ("Payer_name", "System.String", False)) ds.Tables.Add(myPayerTable) 'Create another dataset, just to see what happens Dim myDatasetWithRelations As DataSet = BuildPaymentDataRelations(ds) DataGrid1.DataSource = myDatasetWithRelations End Sub Public Function AddColumn(ByVal ColumnName As String, ByVal DataType As String, ByVal autoIncrement As Boolean) As DataColumn Dim myColumn As New DataColumn myColumn.ColumnName = ColumnName myColumn.DataType = Type.GetType(DataType) myColumn.AutoIncrement = autoIncrement If autoIncrement Then myColumn.AutoIncrementSeed = -1 End If Return myColumn End Function Private Function BuildPaymentDataRelations(ByVal dataset As DataSet) As DataSet 'blnRelationsCreated = True Dim parentCol, childCol As DataColumn parentCol = dataset.Tables("Pmt").Columns ("pmt_id") childCol = dataset.Tables("PmtLn").Columns ("pmt_id") dataset.Relations.Add("Pmt_PmtLn", parentCol, childCol) parentCol = dataset.Tables("Payer").Columns ("payer_id") childCol = dataset.Tables("PmtLn").Columns ("payer_id") dataset.Relations.Add("Payer_PmtLn", parentCol, childCol) parentCol = dataset.Tables("PmtLn").Columns ("pmtln_id") childCol = dataset.Tables("PmtLnDet").Columns ("pmtln_id") dataset.Relations.Add("PmtLn_PmtLnDet", parentCol, childCol) Return dataset End Function End Class Tag: Binding data from DataReader to DataGrid Tag: 69530
  - 18
    - newB trigger question, hello I have 2 table and I want to create a trigger and when ever I add a row in parent table the row insert in child table with the same id. creating tables : create table parent ( table_id integer not null primary key, dummycol integer ) create table child( table_id integer not null, dummycol2 integer , foreign key (table_id ) references parent(table_id) ON DELETE CASCADE ON UPDATE CASCADE ) and the trigger Í tried but couldn't fix : create trigger copyrow on parent after insert as insert into child (table_id) values (parent.table_id) the error message says it accepts only variables and constants, then how can i assign the value to the row? thanks in advance Tag: Binding data from DataReader to DataGrid Tag: 69528
  - 19
    - Hepl! Can't update one data source from another using DA I'm trying to move a data set filled from an OLEDB data source into a SQL Server using the routine below. I get no errors, but when I look, there are no records in the SQL server table, "test". I know that there are records in the data set (ds.Tables(0).Rows.Count = 69) so why are the records not moved into the "test" table? Any help would be greatly appreciated. Dim cnSource As OleDbConnection Dim cnDest As SqlClient.SqlConnection Dim strSQL As String cnSource = New OleDbConnection("Provider=IBMDADB2.1;Password=123;User ID=USR;Data Source=DB2DB;Mode=Read;Extended Properties=''") cnSource.Open() Dim daSource As New OleDb.OleDbDataAdapter("SELECT DISTINCT DBSVR.TABLE1.SITE_CD FROM DBSVR.TABLE1", cnSource) Dim ds As DataSet = New DataSet() daSource.Fill(ds, "test") cnSource.Close() cnDest = New SqlClient.SqlConnection("Server=SQLSVR;database=test;UID=testUSR;PWD=123") Dim daDest As New SqlClient.SqlDataAdapter("SELECT * FROM test", cnDest) Dim cmB As SqlClient.SqlCommandBuilder = New SqlClient.SqlCommandBuilder(daDest) cnDest.Open() daDest.Update(ds, "test") cnDest.Close() Tag: Binding data from DataReader to DataGrid Tag: 69521
  - 20
    - Why can't open the second DataReader ? our C# program: SqlCommand cmd = new SqlCommand(); SqlCommand cmd2 = new SqlCommand(); cmd.Connection = this.sqlConnection1; cmd2.Connection = this.sqlConnection1; cmd.CommandText = "select * from table1"; dr = cmd.ExecuteReader(); while(dr.Read()) { cmd2.CommandText = "select * from table2 where myid=" + dr[0].ToString(); dr2 = cmd2.ExecuteReader(); ... ... ... ... the cmd.ExecuteReader() can open DataReader, but cmd2.ExecuteReader can't why? Tag: Binding data from DataReader to DataGrid Tag: 69511
  - 21
    - Selecting from DataGrid and passing to... Here's my situation. I have a data reader and datacommand (ASP.NET and SQL database). I have a search form which gives me the results in a data grid. Usually 2 or 3 results (persons) with various information (Name, Surname, Address...) What I want to do is to select a row in that datagrid (after I do the search and get results in a Datarid) and transfer the selected row to to next page and insert the selected data from that row in a text boxes. I need you to point me in the right direction on how to do that. Thanks. Tag: Binding data from DataReader to DataGrid Tag: 69508
  - 22
    - dataform wizard problems I've used the dataform wizard any number of times, and it works on all but one kind of microsoft access database. The style I use is text boxes for each column, with all the buttons. I just used the wizard on the customers table in the northwind.mdb that comes with office 11. Worked fine. Most importantly, when I clicked the add button, all the text boxes were cleared and and record count says 92 of 92 records(there are 91 records to start in the customers table). I created an mdb (access 2003) with one table from a larger database. It's called datetypes, and the table is called datetype. It has 5 columns. ID autoincrement integer DateType string 255 characters CreateDate Date default Now ChangeDate Date default Now Active Boolean default True All fields are required. When I run the form created by the dataform wizard on this table, the behavior is different. If I click Add, the text boxes(and checkbox for the boolean column) do not clear. Furthermore the recordcount (there are 9 records to start), says 1 of 10. If I press cancel, nothing happens, it still says 1 of 10. If I remove the faults, the same thing happens. If I remove required for all the columns except the ID autoincrementing key field, the same thing still happens. Furthermore, this happens with any of my tables in which the primarykey is an autoincrementing integer. Any ideas? Dennist Tag: Binding data from DataReader to DataGrid Tag: 69505
  - 23
    - Reading from DB2 and Writing to SQL Server I need to be able to query a DB2 database and append the results to a similarly structured table in SQL Server 2000. What would be the best method to achieve this? Could someone provide some specifics? Tag: Binding data from DataReader to DataGrid Tag: 69504
  - 24
    - Error in INSERT INTO statement When I run the simple code below I get the following error message: Type = System.Data.OleDb.OleDbException Message = Syntax error in INSERT INTO statement I've tweaked the insert to statement every which way. All the other ways create earlier error messages. I've compared this insert to statement to many I've seen in the book ado.net core reference, as well as other books. For the life of me I can't see what's wrong with it. Perhaps one of you can help me. Imports System.Data Imports System.Data.OleDb Public Class Form1 Inherits System.Windows.Forms.Form #Region " Windows Form Designer generated code " Public Sub New() MyBase.New() 'This call is required by the Windows Form Designer. InitializeComponent() 'Add any initialization after the InitializeComponent() call End Sub 'Form overrides dispose to clean up the component list. Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean) If disposing Then If Not (components Is Nothing) Then components.Dispose() End If End If MyBase.Dispose(disposing) End Sub 'Required by the Windows Form Designer Private components As System.ComponentModel.IContainer 'NOTE: The following procedure is required by the Windows Form Designer 'It can be modified using the Windows Form Designer. 'Do not modify it using the code editor. Friend WithEvents btnBuild As System.Windows.Forms.Button <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent() Me.btnBuild = New System.Windows.Forms.Button Me.SuspendLayout() ' 'btnBuild ' Me.btnBuild.Location = New System.Drawing.Point (16, 24) Me.btnBuild.Name = "btnBuild" Me.btnBuild.Size = New System.Drawing.Size(72, 24) Me.btnBuild.TabIndex = 0 Me.btnBuild.Text = "Build" ' 'Form1 ' Me.AutoScaleBaseSize = New System.Drawing.Size(5, 13) Me.ClientSize = New System.Drawing.Size(292, 266) Me.Controls.Add(Me.btnBuild) Me.Name = "Form1" Me.Text = "Form1" Me.ResumeLayout(False) End Sub #End Region Private Sub btnBuild_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnBuild.Click Dim strConn, strSQL As String strConn = "Provider=Microsoft.Jet.OLEDB.4.0;OLE DB Services=-4;Data Source=H:\HasbaraNET\ado.net tests\DateTypes.mdb;" Dim cn As New OleDbConnection(strConn) strSQL = "SELECT * FROM DateType ORDER BY DateType;" Dim da As New OleDbDataAdapter(strSQL, cn) Dim ds As New DataSet ds.DataSetName = "ds1" cn.Open() da.FillSchema(ds, SchemaType.Source, "DateType") 'cn.Close() ds.WriteXmlSchema("H:\HasbaraNET\ado.net tests\CodeUpdate\ds.xsd") Dim dsA As New ds1 da.Fill(dsA, dsA.Tables(0).TableName) Dim tblDateType As ds1.DateTypeDataTable = dsA.Tables(0) Dim rowDateType As ds1.DateTypeRow rowDateType = tblDateType.NewDateTypeRow rowDateType.DateType = "xxx" rowDateType.CreateDate = Now rowDateType.ChangeDate = Now rowDateType.Active = True rowDateType.ID = Integer.MaxValue tblDateType.AddDateTypeRow(rowDateType) da.InsertCommand = New OleDb.OleDbCommand("INSERT INTO datetype(ID,DateType,CreateDate,ChangeDate,Active) (?,?,?,?,?)", cn) 'INSERT INTO [Order Details] (OrderID, ProductID, Quantity, UnitPrice) VALUES (?, ?, ?, ?) 'Try ' da.InsertCommand.Parameters.Add("@ID", OleDb.OleDbType.Integer,4, "ID") 'Catch er As Exception ' MessageBox.Show("Type = " & er.GetType.ToString & vbCr & "Message = " & er.Message) 'End Try da.InsertCommand.Parameters.Add("@DateType", OleDb.OleDbType.VarChar, 255, "DateType") da.InsertCommand.Parameters.Add("@CreateDate", OleDb.OleDbType.Date, 8, "CreateDate") da.InsertCommand.Parameters.Add("@ChangeDate", OleDb.OleDbType.Date, 8, "ChangeDate") da.InsertCommand.Parameters.Add("@Active", OleDb.OleDbType.Boolean, 2, "Active") Try da.Update(dsA, "DateType") Catch er As System.Exception MessageBox.Show("Type = " & er.GetType.ToString & vbCr & "Message = " & er.Message) Finally cn.Close() End Try End Sub End Class Tag: Binding data from DataReader to DataGrid Tag: 69502
  - 25
    - loading datagrid with calculated column Hi I've figured out how to add a calculated column to a datagrid and update that column when a specific cell in the row changes, however I cannot figure out how to populate the calclated column when the form loads or moves from record to record any help appreciated Thanks Tag: Binding data from DataReader to DataGrid Tag: 69501

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

Top

Re: Binding data from DataReader to DataGrid by Sergey

Sergey
Tue Oct 28 08:17:17 CST 2003

I think it's not possible to bind SqlDataReader to a Win control.
You can bind DataSet or DataTable.

"Makarand" <anonymous@discussions.microsoft.com> wrote in message
news:0d2d01c39d56$601282c0$a301280a@phx.gbl...
> 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

Top

Re: Binding data from DataReader to DataGrid by William

William
Tue Oct 28 10:06:03 CST 2003

You can only do it with the asp.net datagrid...

myASPDataGrid.Datasource = myReader.ExecuteReader();
myASPDataGrid.DataBing();
"Makarand" <anonymous@discussions.microsoft.com> wrote in message
news:0d2d01c39d56$601282c0$a301280a@phx.gbl...
> 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

Top