[datatable] Forum Topics

I would like to give me your help please.. I have connected my sql db with vb and I m trying to make a UI. My question is that when I write code in order to create datatables and I fill them with the results of queries I've created, where …

Hi guys, Im writing a windows c# form at the moment and after all the headaches of gettin my stored procedure to combine 2 tables from 2 databases from 2 servers that had different collations(.....yeh MASSIVE headache)ive hit another snag! here's my form1 code, no where near completed, missing my …

Hello. I have a datagrid with 9 columns. I want to add a one row from data table who is that same. I believs I can do it that: [CODE]DataGridViewRow drow = new DataGridViewRow(); foreach (DataRow wiersz in dTable2.Rows) { for (int i = 0; i <= ilosckolumn - 1; …

I am trying to populate an ArrayList using the elements from a DataTable. I know I could do this using Loop, but I am trying to figure out how to using AddRange. Here's my code: [CODE]SomeArrayList.AddRange(SomeDataTable.Rows.Item(0).ItemArray)[/CODE] The problem is that I can pass the collection except for the Zeroth element. …

I'm doing connectivity of my sql server database with C sharp code. In sql server 2005 i made two tables person(empid,citycode,name,salary) and city(name,citycode)and entered few records. i haven't set any constraint on any column. Person 11 Ashish 101 99000 12 XYZ111 110 993939 13 yuuuuu 101 88484 14 hdhfhh 101 …

Hi! I have datatable name myTable with columns and row. Can someone give me solution on how to multiply/repeat the first row data to the succeeding row depending on the inputted copies by user in a textbox? Please help me with this one.

Dear All , The question is simple , but may be It is very simple for me that I can not see it . I have two dataset , each with with table . each datasets is connected to a separate dataadapter to get data from sql server database file …

Hello, I'm curious as to what the "key" for a DataTable Row collection is. And if there is a better way of executing what I'm trying to do. My situation is this. I have a DataTable populated with different data from multiple databases, for the sake of this thread let's …

Hi there, Does anybody know how to refresh a windows form after inserting into a database using a dataTableAdapter or any other method for that matter without having to close the form or use the fill method to reload the form? The problem with this is that you are taken …

hi all, am just curious to know...which is the better or more efficient way of these two? Note: tblOD is a DataTable [CODE] For dtrows As Long = 0 To tblOD.Rows.Count - 1 dgv1.Rows.Add(tblOD(dtrows)(0), tblOD(dtrows)(1), _ tblOD(dtrows)(2), _ tblOD(dtrows)(3), tblOD(dtrows)(4), _ tblOD(dtrows)(5), tblOD(dtrows)(6), _ tblOD(dtrows)(7)) Next dtrows [/CODE] OR [CODE] …

Code shows how to bind the data from a database`s table to dataTable and populate dataGridView with it. And then how to pass the modified (or not) data from dataGridView back to dataBase`s table.

I have a DataGridView control that is bound to a DataTable, and I am using the DataTable to add rows to the DataGridView. I am not using a database in any way, but need to add data to the DataTable/DataGridView using code alone. I need to replace certain columns with …

Hello everyone, I wanna Update a Table schema having a DataTable. How can I do that? Thanks!:icon_mrgreen:

Hi! I have 3 columns, that i join in new column, but after that i must remove old columns... How can i do that??? Thanks for your answers! Gregor

Hi all. I attached a code creating file from datatable. I have a problem saving Excel file in c# using Microsoft.Office.Interop.Excel. When I'm saving the file as Exsel 2003 (xls) format the file is OK. When I'm saving the file as Excel 2007 (xlsx) format I get error massage from …

hi. I am working on a project which keeps its data access, business logic and UI in separate projects of a solution. Is there a way to access a strongly typed dataset in one project of a solution from another project of the same solution? I need these to fill …

Can someone provide sample code on how to create and fill a DataTable with the table schema and data from a mySQL database? I found examples where you set up columns and other information programmatically. But i wanted to know if there a way to "sync" the schema in the …

Friends I m working with RowFilter, its working good with String Data, and like statements, specially its Autometed functuallity with string data is good, just like in follwing code (it is written in Textbox "txtSearch"s TextChanged Event) [CODE] Private Sub txtSearch_TextChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles txtSearch.TextChanged …

I have created simple database project, using vb.net, ado.net, oledb, datatable, datagridview. My program is working nice, I just need Help with how to add, delete, update and edit records. Can any one please and please help me in this case, or can provide any good tutorial or source code …

Help With Add, Delete, Edit and Update Record (with Datatable Method) I Created a Software with OleDb .mdb database previously Using Dataset Method, but I was unable to Connect Datagrid with it on real Basis, I mean when I Clicked Next Record Button it only Moves in TextBoxes (Which were …

[code] Dim da2 As OleDb.OleDbDataAdapter Dim cols As Integer = Attendance_QueryDataGridView.ColumnCount Dim rows As Integer = Attendance_QueryDataGridView.Rows.Count Dim a(cols) As String Dim dt As New DataTable("Attendance") da2 = New OleDb.OleDbDataAdapter(sql, con) da2.Fill(ProjectDataSet, "Attendance") Dim NewRow As DataRow NewRow = ProjectDataSet.Tables("Attendance").NewRow For z = 0 To cols - 1 a(z) = …

hi i m new c# and this is my very 1st project ,here i want to add or view data and this is the code i have used.everything works fine but i cant navigate through records properly,i m working with 2 tables i.e BankMaster and BranchMaster [ICODE] private void branchmaster_Load(object …

Hi, Any advice please. I have various forms (e.g. frmCustomers, frmProducts), each having bindingSources and tableAdapters. The forms have the required Fill methods triggered from their constructors. It appears that the DataTable filled only exists in the App for as long as the form does. What I want is a …