Hi I have writen a web service. this web service has a method that returnes a Table as XML format and I need to use it as a table. how can i use this web service as a table. is any way to convert XML format to Table format Thank you

Member Avatar
Member Avatar
+0 forum 5

I am creating one application visual basic and sqlce I have two forms name Form1 and Form2. I used Form1 to add data to database using OLeDb command and used Form2 to show data in datagridview by using dataset I used following code: FFORM1 CODE is as following [code] Private Sub Add_data() Try Dim DBConn As OleDbConnection Dim DBInsert As New OleDbCommand DBConn = New OleDbConnection(Myconnection_String) DBInsert.Connection = DBConn DBInsert.Connection.Open() DBInsert.CommandText = "INSERT INTO user(name, designation, age) VALUES (" + textbox1.text + "," + textbox2.text + "," + textbox3.text + ")" DBInsert.ExecuteNonQuery() MsgBox("Data added successfully.", MsgBoxStyle.OkOnly) DBConn.Close() DBConn.Dispose() Catch ex …

Member Avatar
Member Avatar
+0 forum 3

I am importing data from excel into datagridview its kind of working fine. my data is like this in excel 10001 MR NEW 10002 MR OLD 10003 MR CLEAN 1MB21 MR DIRTY 1BA12 MR DIXON 1EA12 MR RYDER When I load the data all is loaded untill it gets to the Alpha numeric data 10001 MR NEW 10002 MR OLD 10003 MR CLEAN blank MR DIRTY blank MR DIXON blank MR RYDER Dim MyConnection As System.Data.OleDb.OleDbConnection Dim DtSet As System.Data.DataSet Dim MyCommand As System.Data.OleDb.OleDbDataAdapter MyConnection = New System.Data.OleDb.OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source='I:\Sales Analysis\Vecta\vecta customersmb.xls';Extended Properties=Excel 8.0;") MyCommand = New System.Data.OleDb.OleDbDataAdapter("select * from [vecta …

Member Avatar
Member Avatar
+0 forum 1

Dear all, I have created project database in msaccessdatabase. It contail ![Msaccess.jpg](/attachments/large/4/a91d2278c08f244b439891bcf7c3b36e.jpg "align-center") form layout as shown in image & i have attached code for reference Imports System Public Class Form1 Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load 'TODO: This line of code loads data into the 'Project_DatabaseDataSet.Project_Data' table. You can move, or remove it, as needed. Me.Project_DataTableAdapter.Fill(Me.Project_DatabaseDataSet.Project_Data) Dim dt As New Project_DatabaseDataSet.Project_DataDataTable For Each col As DataColumn In dt.Columns col.AllowDBNull = True Next Me.Project_DataTableAdapter.FillByMountingType(dt) cbo_MountingType.DisplayMember = "Mounting Type" cbo_MountingType.DataSource = dt End Sub Public Sub BindCombox() BindComboBox1.DataSource = Project_DatabaseDataSet.Tables("Mounting Type") BindComboBox1.DisplayMember = "product Name" End Sub …

Member Avatar
Member Avatar
+0 forum 1

Hello. I have a SQL database called bd with a table called dados. I want to get one row from it. Web.config <add connectionString="Data Source=(local);Initial Catalog=bd;Integrated Security=True" name="bd" providerName="System.Data.SqlClient"/> variable declarations Dim DS As New bd Dim a1row As bd.dadosRow this code in the method won't return anything. In fact it throws a "object not set to an instance of an object" error. a1row = DS.dados.FindBycode(5440987) but if I perform a query I get the values: <img alt="snapshot" src="[https://www.flickr.com/photos/29661370@N04/21923636492/](https://www.flickr.com/photos/29661370@N04/21923636492/)"/> Where did I go wrong? Thanks

Member Avatar
Member Avatar
+0 forum 3

Dear all, I have created database like this. I have 2 manufacture . I would like to create 2 combobox. COmbox 1 -> Manufacture list combox 2 contain -> model no Can some one share example code where it explained. if particular manufacture selected display only his model in combobox 2. Based on manufacturer & model no. datashould be loaded into further calculation. if manufacture1 clicked model relevant to manufacture 1 only displayed. Similarly for manufacture 2

Member Avatar
+0 forum 0

Dear all, Here i have attached form window.I wanted to update form with relative data How to refresh the single form. When New project detail is clicked from loaded with project data , when panel button clicked form loaded with panel data. 1)I tried this method. I created a group box for indivual button ,Show & hide when particular button being pressed. for example below . When new button pressed only display groupBox_new, Or any other method available. Private Sub Button_New_Click(sender As Object, e As EventArgs) Handles Button_New.Click GroupBox_New.Show() GroupBox_Panel.Hide() GroupBox_inverter.hide() so on....... End Sub 2) If you have checked …

Member Avatar
+0 forum 0

Dearl all, Is there any way or codes for export dataset or datatabe to excel file. Whenever I use click event in the button, it will save my report in an excel file. My information inside in datatable (dataset) from database and I want to save it in excel file. Thank you for attend... Have a nice weekend...

Member Avatar
Member Avatar
+0 forum 6

Hello, I am trying to learn c# and sql server and I am not sure how should I proceed in the following situation: I have a database with 2 tables: Clients and OrdersFromClients I am trying to make a form with a listbox in which I will display all the clients found in Clients table. When I select one client in the listbox I need to display all the orders made by that client and also I want to be able to edit them. Using SqlDataAdapter and DataSet I know how to retieve the clients from Clients table, BUT I …

Member Avatar
Member Avatar
+0 forum 1

Hi, I have a DataGridView with a table loaded onto it. I have nine textboxes which will serve as a search feature for the DataGridView. What I want is that once text is entered, it goes through the relevant column filtering data as per what is inputed. This works perfectly and have severally typed code that still worked well despite not being exactly same code. My problem arises from the fact that after filtering using one textbox, when I enter the text in another textbox in order to filter results I had, it instead discards the previous filter and searches …

Member Avatar
Member Avatar
+0 forum 3

I don't know what i doing wrong. I have been on several forums trying to figure out how to sort a table in visual basic. I have treid with and with out a dataview, but noting seams to work. I have a logg that the user can do new inserts in. It has 3 columns. "Date", "Tool", "Comment". When my VB application loads the program reads the table from a Access database and i get my sorting just fine by the sql phrase: "select * from Logg ORDER BY Logg.Datum DESC" After a user have uppdated the table i whant …

Member Avatar
Member Avatar
+0 forum 1

Hi guys, I'm using a very simple database and dataset and it appears to be working, except I can't actually save any data. Here's what I did: I created an empty database with a corresponding empty dataset. I filled it in with 4 rows of dummy data (ID, name, address, etc). I dragged the table (called Lawyer) to the dataset. This created the update and insert methods. I then created a class, which has two methods. One to count the records, and one to add new data. This should be simple, and I've done it before, but for some reason …

Member Avatar
Member Avatar
+0 forum 6

Hi Everyone, I really require your assistance on the issue. I was debugging my code [C# console application] and i step down to the place where there is DATASET in my code and i clicked on the magnifying glass to see the data inside the DATASET. after clicking on the magnifying glass, i have an error which is attached below Can you guys help me to understand what's the error all about? Thank You so much! See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Exception: Function …

Member Avatar
Member Avatar
+0 forum 1

i am using employee table to test if i am doing the whole program correct. I have 5 buttons. one is to add records and another to save(commit), to update, to delete and to clear. I am having trouble with the code to save the record to the data set. when i click add, it lets me add the new name but when i press save(commit), it wont save. i already added the data adapeter. this is my code: Public Class Form1 Dim inc As Integer Dim MaxRows As Integer Dim con As New OleDb.OleDbConnection Dim dbProvider As String Dim …

Member Avatar
Member Avatar
+0 forum 2

I have 2 forms. One is a typed list having 3 controls (fields) loaded from access database (copied to project as part of .xsd). The values in this list represent recommended values of items and will also be applied to another 3rd form eventually. In the 2nd form there are 3 values which are populated (a) from dropdown lists, (b) with required input or (c) can be taken from form 1. Can anyone offer some help as to how to do option (c) without losing other two options? I hope this makes sense.

Member Avatar
Member Avatar
+0 forum 8

I have a large data set (12,000 rows X 14 columns); the first 4 rows as below: x1 y1 0.02 NAN NAN NAN NAN NAN NAN 0.004 NAN NAN NAN NAN x2 y2 NAN 0.003 NAN 10 NAN 0.03 NAN 0.004 NAN NAN NAN NAN x3 y3 NAN NAN NAN NAN NAN NAN NAN NAN NAN NAN NAN NAN x4 y4 NAN 0.004 NAN NAN NAN NAN 10 NAN NAN 30 NAN 0.004 I need to remove any row with "NAN" in columns 3-14 and then output the rest of the dataset. I wrote the following code: #!usr/bin/perl use warnings; …

Member Avatar
Member Avatar
+0 forum 4

Hello, I'm trying to program a basic program at the moment and have run into some difficulties. I have a method as follows: public static void loadDB() { // load data into datasets - this will be called on form2 the login screen loadTblStaff(); loadTblCars(); } the method is called on another form on load. The methods its supposed to call are as follows: public static void loadTblStaff() { // prepare, open and load the staff table into dataset ds2 con.ConnectionString = dbProvider + dbSource; MessageBox.Show("loadTblStaff() called"); con.Open(); MessageBox.Show("load table staff connection opened"); sql = "SELECT * FROM tblStaff"; ds2 …

Member Avatar
Member Avatar
+0 forum 12

In a table,in first row consist of static html control (1 select control and 5 textboxes).From second row onwards i created the rows dynamically(consist of 1 select control and 5 textboxes) on click of html button.Creation is successfull.But problem arised when i wanted to attach dataset table data to html select control at runtime. I also tried to use runat="server" in jscript code to refer them in code behind. How to attach dataset table data(only one column) to dynamically created html select control.with static control , i able to do it,but not with dynamic control.

Member Avatar
Member Avatar
+0 forum 1

I have limited knowledge in coding. can anyone tell me what is worng with my code? the firstrow result in the database is not updated, but it is updated in datagridview. For i As Integer = 0 To DataGridView1.RowCount - 1 DataGridView1.Rows(i).Cells(11).Value = "true" Next SmsdDataSet.AcceptChanges()

Member Avatar
Member Avatar
+0 forum 2

Hi Guys... Putting together a Tiny little app which shows VPN Details for use 'In-House' but for some strange reason my DataSet won't fill? Can anyone spot the mistake? :S private void Form1_Load(object sender, EventArgs e) { //XML Load of Document. This loads the XML Document and the value of a Single Node then inputs this to a text box// XmlDocument doc = new XmlDocument(); doc.Load("C:\\vpn.xml"); XmlNode node = doc.SelectSingleNode("/DataBases/VPN_Access/vpn_DB"); this.txtBoxDebug.Text = node.InnerText; //Creates new versions of the Connection string and Data Set// con = new System.Data.OleDb.OleDbConnection(); ds = new DataSet(); //The actual connection to the database// con.ConnectionString = "PROVIDER=Microsoft.ACE.OLEDB.12.0;Data …

Member Avatar
Member Avatar
+0 forum 11

Hi, I have a Vb.Net solution that contains several forms that read/write to an MS Access database. My problem: When I copy my Vb.Net solution and Access database to a new computer, the data source connection string needs to be changed. Currently the data sources wizard sets the connection string. Is it possible to allow the user specify the connection string of the dataset or is there a different, better solution available? Thanks for your time.

Member Avatar
Member Avatar
+0 forum 6

Hi, I want to know what code should be used in order for me to import data from an excel file to dataset and then adding it to the database, how can it be done? thanks

Member Avatar
Member Avatar
+0 forum 8

Being somewhat new to VB.NET, I built a data solution by using wizards and drag-and-drop on forms. My data is in an Access DB and I opened up those tables with Server Explorer and dragged them into my dataset. I connected the tables to datagridviews. Worked like a charm. Then I found out the project needs to be able to dynamically create tables. "No problem" I thought. I would just find out how to create a table dynamically in VB.NET to put into Access. Again, worked like a charm. Then I realized that my method of querying the data through …

Member Avatar
Member Avatar
+0 forum 3

I am trying to search a dataset I have populated from several XML files for certain words in each column. The dataset table is "item" and the columns I want searched is "descritption". "description" are several articles from an rss feed. I want to search the articles for sports players names. For example in the article "Jimmy Graham returns to a limited practice - Jimmy Graham | NO" I would like to search for "Jimmy Graham" and once found I want the entire article description to be displayed in a listbox. I am essentially searching for player names which the …

Member Avatar
Member Avatar
+0 forum 1

hi every one, ihave to develop one code that need to update gata grid using simple dataset with out any db connection. can any one suggest

Member Avatar
Member Avatar
+0 forum 1

Hi, i have a dataset with 2 columns. 1 column is in String datatype and another one is in Timespan. Now i want to generate a chart from the dataset. While i'm trying to generate the chart, it has error: *"Series data points do not support values of type System.TimeSpan only values of these types can be used: Double, Decimal, Single, int, long, uint, ulong, String, DateTime, short, ushort. "* Do I need to convert my timespan column to another type first? Can someone help me how to solve this error?

Member Avatar
Member Avatar
+0 forum 20

Hi Guys.. I've found a little tutorial which seems to show exactly what I have been trying to do which seems to work upto a certian extent. The code I am using is the following: **Code:** using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace WindowsFormsApplication1 { public partial class Form1 : Form { public Form1() { InitializeComponent(); } System.Data.OleDb.OleDbConnection Conn; private void Form1_Load(object sender, EventArgs e) { //Create DataSet Object & New DataSet Conn = new System.Data.OleDb.OleDbConnection(); //The Connection Below is for Access 2010 DataBase Conn.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:/DemoDB1.accdb"; …

Member Avatar
Member Avatar
+0 forum 1

Hi Guys, I have a form with a DGV and some text boxes.. I am trying to get the program to update the rows shown on the DGV by using the values in the text boxes. Below is my code so far: private void btnOrderEdit_Click(object sender, EventArgs e) { System.Data.OleDb.OleDbCommandBuilder cb; cb = new System.Data.OleDb.OleDbCommandBuilder(cashDA); System.Data.DataRow dRow2 = cashOrdersDS.Tables["cashOrders"].Rows[0]; dRow2[1] = Int64.Parse(txtOrderQTY.Text); dRow2[2] = txtBoxDescrip.Text.ToString(); dRow2[3] = txtBoxSupplier.Text.ToString(); dRow2[4] = dateTimePicker1.Value.ToString(); dRow2[5] = Convert.ToDouble(txtBoxCost.Text); dRow2[6] = Convert.ToDouble(txtBoxSell.Text); dRow2[7] = Int64.Parse(textBox1.Text); cashDA.Update(cashOrdersDS, "cashOrders"); MessageBox.Show("Data Updated"); } Any help would be great!

Member Avatar
Member Avatar
+0 forum 8

Hi Guys, **<-- Newbie Here!** I seem to have an issue with an INSERT INTO statement when trying to add some textbox data into a DataSet and then update the backend table called 'cashOrders' in a Access Databse. The Following code is being run from the 'Save Button' private void btnOrderSave_Click(object sender, EventArgs e) { System.Data.OleDb.OleDbCommandBuilder cb; cb = new System.Data.OleDb.OleDbCommandBuilder(cashDA); cashOrdersTable.TableName = "cashOrders"; DataRow DRO = cashOrdersDS.Tables["cashOrders"].NewRow(); DRO["QTY"] = Int64.Parse(txtOrderQTY.Text); DRO["Description"] = txtBoxDescrip.Text.ToString(); DRO["Supplier"] = txtBoxSupplier.Text.ToString(); DRO["Date"] = dateTimePicker1.Text.ToString(); DRO["Cost"] = decimal.Parse(txtBoxCost.Text); DRO["Sell"] = decimal.Parse(txtBoxSell.Text); DRO["cashAccountRef_FKID"] = Int64.Parse(textBox1.Text); cashOrdersDS.Tables["cashOrders"].Rows.Add(DRO); cashDA.Update(cashOrdersDS.Tables["cashOrders"]); MessageBox.Show("Added"); } Currently when Debugging and stepping through the …

Member Avatar
Member Avatar
+0 forum 4

I have written a program which allows agents of a call centre the ability to access a database (ms access) containing names of solicitors to allocate to. the database is stored centrally and i need a way to update the local dataset on the agents machine when a change is made to the database. I understand how to add, remove, update fields to the database using a OleDbDataAdapter but I need something that does the reverse. Thanks in advance.

Member Avatar
Member Avatar
+0 forum 3

The End.