84 Topics
![]() | |
Hi all, I've been having a problem adding a record to an Access database using datasets and da.update etc. I'm trying to create a simple program that displays the records of a database table in a series of text boxes. I've managed to get my next and previous buttons working … | |
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 … | |
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 … | |
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 … | |
Dear all, I have created project database in msaccessdatabase. It contail  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 … | |
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 … | |
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 … | |
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 … | |
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. … | |
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 … | |
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 … | |
I need to add the URL property to webbrowser1 (located on my form) from a dataset containing the URL, but am getting the error "Invalid cast from 'System.String' to 'System.Uri'. The column in datagridview1 is called link. I need the web browser URL to change with a corresponding textbox and … | |
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 … | |
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, … | |
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 … | |
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. … | |
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 … | |
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 … | |
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 … | |
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 … ![]() | |
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() | |
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 … | |
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. … | |
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 | |
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 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 … | |
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 | |
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 … | |
Hi guys, Needing some help here please. I have a 'Save button' setup on my form which seems to be working perfectly. It allows vales to be taken from text boxes and then presented on a datagrid view and also saved to the underlying databse. **The Code for this save … | |
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; … | |
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 … | |
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 … | |
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 … | |
I have a dataset (GrindItems) with 4 datatables successfully populated from dbf files. If I understand the concept of a dataset, I no longer need an open connection to the source db and I should be able to query my dataset. My first question is whether I need a Connection … | |
HI. I have a situation where we need to pull data from multiple data sources into one dataset. Once we have the data in one dataset we would like to somehow manage to execute some sort of [complex] select query on the data in order to generate a new DataTable … | |
Trying to figure out the best way to do create a CSV export file from my source files and need some input. I'm trying to build a CSV export file for import to an Accounting System where there are 3 different tables mapped to a single field in the main … | |
I am trying to save database after inserting the records into dataset from external file.... But when I insert records and then try to save it, it does not save...No error comes up though.??? Can you please look into the code and help?? If file_path = Nothing Then Msgbox.Show ("Database … | |
Imports System.Data.SqlClient Imports System Imports System.Data Imports System.Collections Imports System.Windows.Forms Imports System.Resources Imports System.Data.OleDb Imports System.Drawing Imports System.Net.Mail Imports System.Configuration Imports System.Web Imports System.Web.Security Imports System.Web.UI Imports System.Web.UI.WebControls Imports System.Web.UI.WebControls.WebParts Imports System.Web.UI.HtmlControls Public Class Form1 Inherits System.Windows.Forms.Form Dim counter As Int32 = 0 Private Sub Form1_Load(ByVal sender As System.Object, ByVal … | |
Hi In my program I have a Dataset that populates a Rdlc file and it was working Fine until I Encrypted the Accdb file and now when I run the App I get "Not a valid password" error at this line [CODE]Me.Services_QryTableAdapter.Fill(Me.CFIDataset.Services_qry, RprtID)[/CODE] I have tried Modifying the connection for … | |
In Visual Studio 2010, I have a windows forms application frmMain.cs with a ComboBox. From the form itself I can access its value with cmbxYear.SelectedValue. I also have a DataSet.xsd file to bind to an rdlc report to a TableAdapter to present view data. The TableAdapter has a SelectCommand that … | |
HI I am using - ASP.Net - C# - SQL Server Express 2008 R2 I have a table called customers which contains all customer details and a stored procedure which gets: - Total No Of Customers - Total No Of Customers in Region1 - Total No Of Customers in Region2 … | |
Hello This is my first post so I’m sorry if I ramble and don’t explain my issue clearly. I am binding a dataset (dsTest) with a table called “TempResult” to a datagrid (DatagridView1). The purpose of the datagrid is to display test labels (set elsewhere in the software) and to … | |
Hi again! I have a database and some tables filled with data. [code=c#] var club = Baza.Clubs; //Baza is dataset, and Clubs is table var schedule = Baza.Schedule; // same as above for (int i = 1; i <= 90; i++) { if(schedule[i].day == 2) // BOOM! Breaks at first … | |
Need help, I need to know on how can VB.net validates the format of each cell on the excel file that it opens, for example, the first row should only be numeric, or cannot be null, is it possible that vb.net can check it before it inserts it in the … | |
Hi all, I'm new to vb.net and Sql server... So it may be a newbie question, but i've searched many places and did't find the answer.. so, here i go: I've just installed sql server, and i want to databind some textboxes in a form... but i dont really know … | |
Hi All I am creating a program which will (in the end) help me quickly transfer products from one category into another within a MySQL Database. I have a database with TWO separate tables which are connected using INNER JOIN where the products have a categoryID as do the categories … | |
Hello masters! I have a project and need a bit of your help. I would like to access/get values from certain fields from a database and assing that value to a variable. Database is included into my project along with DataSet. Is there any simple way to access certain field? … | |
Hello I am having some trouble here, I created a Microsoft Access dataset (.accdb) It is being used with some listboxes, comboboxes etc. The problem is when I publish the whole thing the datasets do not publish along with it and my program opens but there are not values. Anyone … | |
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 … | |
I'm writing a program has access to a database (a database where an other software stores data that users type). This database has several colums, but in my code, i need to use the two columns that describes where the data is from, and the the date when the data … |
The End.