2,634 Topics
 | |
| | Hi All, as per as I know dataset can do the work of datareader.Only the difference in connected and disconnected architecture.But Is there any area where we have to use only datareader without dataset? |
| | Pls see my code.Nothing is displaying in the grid [code]Private Sub MainForm_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load Dim connString As String = "Provider=SQLOLEDB;Data Source=MSALAMEEN;uid=sa;pwd=Sa1;Initial Catalog=Biometric" Dim myConnection As OleDbConnection = New OleDbConnection myConnection.ConnectionString = connString Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select ID from bdata", myConnection) …  |
| | Hai, I don know how to store data from datagrid to SQL database. I also don know how to find the number of records in dataset or datareader. for an example [B]myCommand = New SqlCommand("Select * from discounts", myConnection) dr = myCommand.ExecuteReader()[/B] How can I know whether there is any … |
 | Hi , I need to create a page that has databound controls . eg. Say i have a row with the following columns 1. TrackKey VARCHAR(50) 2. State VARCHAR(50) 3. Reason VARCHAR(50) 4. DateChanged DATETIME ------------------------------------------------------------ Now for each row in the table, the controls should be like this 1. … |
| | Hello all, I'm trying to add a new row to a new datatable. The following is my code,but I get the error of "Cannot find the column 0." Anyone can help me on this? [CODE] Imports System.Windows.Forms Imports System.Data Imports System.Data.OleDb Public Class Form1 Dim cn As New OleDbConnection Dim …  |
| | Hi, We have a Windows Server 2003 and Multiple Departments Publish their Websites on to this under Default Website. We are trying to verify if Dept1 Created theor application called app1 and Dept2 created their application called app2 ,then if the app1 puts any data in the cache . For … |
| | Hi! I am using Zedgraph in my ASP.NET application. I get a duplicate legend in my graph. How to remove? Please help! Here's my code: //Default.aspx.cs [code=c#]using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using System.Drawing; using ZedGraph; using System.Configuration; using System.Data; // using System.Data.SQLite; public … |
| | Hi there, When I add a new row into the DataSet, the first time it works good but after the first time I added another row it's not working instead it generate this error message : "Update requires a valid Insertcommand when passed datarow collection with new rows" This is … |
| | hi guys! i generated a report using crystal report on vb.net 2003 from a dataset. there are 2 columns in it. name and amount. like this one, name amount gigam 100.00 hershey 300.00 tony 97.00 my concern is: i want to have a total below the amount. like this: name … |
| | Hi everyone, I'm having the error msg. "ıbmdadb2" E_FAIL(0X800004005) when I try to delete a row on the dataset. I populate the table in many combination of selections, no problem. But when I try to delete a line, I can do it on gridview but I cannot do it on … |
| | I bound the Gridview to the database,Now I want that in each row edit link is there,When i click on dat,then the data of data row comes to edit mode... SOURCE TAB [code] <asp:GridView ID="GridView1" runat="server" onrowediting="GridView1_RowEditing" AutoGenerateColumns="False"> <Columns> <asp:BoundField HeaderText="SNo" DataField ="UID" /> <asp:BoundField HeaderText="First Name" DataField ="FirstName" /> … |
| | hey guys/girls i do need some help with my application(console) at the moment, im reading from my SQL DB, into classes for each table...(or to the respective classes) anyway... i cant seem to get the update part right, for instance i'd like to change someones surname... [CODE]public static DataSet ReadClientData(string … |
| | Hi guys please help with this i am trying to write my data from a table in a lis box but a always get the number of items inside the table. can some one come thru please. lstData.items.Add(dataAdapter.fill(dataset,"MyTable") all kinds of help will be appreciated |
| | Hi all, I've done plenty of searching through as many threads related to this issue and tried just about everything I've found, but to no avail. I am using the VB that is included with Visual Studio 2005 and I have a secured access database that I connected to using … |
| | this coding working. but this coding simple coding.. can anyone give idea how to make this coding looking nice ? [CODE]Imports System.Data Public Class frmANGGARANBARU Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As OleDb.OleDbDataAdapter Dim sql As String Private Sub frmANGGARANBARU_Load(ByVal sender As System.Object, ByVal … |
| | not too sure why this problem is happening. I can update the dataset from a textbox but then when I click the update button it is showing an error "Object reference not set to an instance of an object." The dataset is empty when I try to run the update. … |
| | In my application i have used DataGridView for displaying the data available in my table (SQL database). The form containing the datagridview is accisible from the menu in MDI Form. [COLOR="red"]Problem: [/COLOR]Every time i access the datagridview form, the same data gets appended to the old data in the datagridview … |
| | good eveninh sir/madam, error is :- An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in system.data.dll Additional information: System error. code is : - Dim a, b As Date a = Date.Now.Date b = a.Now.AddDays(-7) Dim dataset2 As New DataSet Dim myconn As SqlConnection = New _ SqlConnection("server=;database=project3;uid=;pwd=") Dim obj_deletecommand As … |
| | Hi, I am doing forum project. I have a doubt, tat how to count the value. that is, all the data which displays in gridview. in tat i need to show the reply value [count the value from database].it means in database i hv field lke pid,pstreplyid,uid,tit,sub ...., in tat … |
| | I have a main form with a combobox linked to a dataset when the user selects an account I have another form that opens the customers details on it. I can get it to display the first customer in the combobox but if select a different customer the form loads … |
| | I need to connect to a foxpro database and fill a dataset with the tables within the foxpro database. Does any one have a solution |
| | hello.. my problem is, im using the following code to insert the records..but whenevr i click on ok button it shows the error "Object reference not set to an instance of an object" im declaring the variables in the following form, [code] private OleDbConnection cn = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source= ..\\abc.mdb"); … |
| | I am trying to populate an MS Access table using VB.Net through a connection string everything else seems to work except when I try to add a new row. I get this error: OleDbException was unhandled Syntax error in INSERT INTO statement Here is the code [code=vbnet] [Dim MaxRows As … |
| | Hello, some help here.. I have a gridview, at my home page, binded to a dataset. On the first column is a hyperlink, on which, if click it will go to another, page, Viewer Page, and passes the data to display on the other page pls advise, preferably in c#.. … |
| | hi guys heres the problem i have a excell file which reads into a datagrid now everything works fine BUT yes theres alwas a but i want to password the excell file and have the password passed through to excell so far i have pulled out my hair teeth and …  |
| | please tell me the significance of using datasets. i have strted leaning its basics. i have been using data table without datasets but i wanted to know whether using datasets helps in any way |
| | I am working on vb.net Windows Application with an Access database. The program that i am trying to develop is for stock/inventory control. The update works when i update the first time, but then when I want to update another record it just wont update. I have to stop running … |
| | I want to update the data in database but As I add the code [ICODE]Dim cb As New OleDb.OleDbCommandBuilder(da)[/ICODE] and [ICODE]MsgBox("Data updated")[/ICODE] in the code it generate error where is wrong in the following code [ICODE]Imports System.Data Public Class Form1 Dim con As New OleDb.OleDbConnection Dim ds As New DataSet … |
| | Hello I'm working on a local mdb file. I can send to Oledbdataadapter constructor 2 string variables. I looked in MSDN and they say I still have to open connection with Oledbconnection to connect to my mdb file. but I can work regulary without opening the connection. [code=vb.net] Imports System.Data … |
| | After creating a datasource and generating a dataset, my database has changed. How can I "refresh" the dataset so it sees these changes. One Method I have been able to do is delete the .xsd file from soultion explorer. There go my modified queries & code. Another method tried was … |
| | so i have a program that is supposed to update a table called master by increasing the clicked field by 1 for every time the email shows up on a second list (tempop); it worked fine when i tested it on a small dataset - the tables were 5000 and …  |
| | Hi, I was assigned to study and understand some code and I was told the major problem with the program was poor performance. Here's the bottleneck: A global data set is maintained. This data set is updated regularly. Then there are threads that have to do some processing using a …  |
| | hi, there, i am trying to work out selecting rows in gridview using checkbox and button submit after rows are selected. Please guide me. i have time till 11am today. the errors: dsnews- unused local variable CheckBox1-String constants must end with double quote -Not declared IsChecked- not declared Dropdownlist code … |
| | Hey all, I have a listbox, textbox, and search button on my form. I am populating my listbox with data from a sql database. I need to be able to seach my listbox and filter it. Here is what I have so far: [code] Sub RefreshListBox() Dim DSDept As New … |
| | I am studying vb.net and am trying to develop a data access program I am getting the following error when I try to add a new record to the dataset. Any help would be great error " Input string was not in correct format. Could not store<LinenIndex> in LinenItemsID colomn … |
| | Hi, there, i am coming up with a dropdownlist that needs to get list from the sql database. the dropdownlist must get its data from the database. i am getting error in this codes: It says that it is not declared. at the same time i can not get the … |
| | hi, there, i need to know if the datagrid and dropdownlist will respond to the button click. At the same time, will this dropdownlist will get the data from database. Please help me. i need the solution in a day. [ICODE]<%@ Page Language="VB" MasterPageFile="~/Courier.master" Title="Untitled Page" %> <%@ Import Namespace="System.data.sqlclient" … |
| | I have to create a Gradebook program with a Mdb provided by our prof. it is suppose to compose a letter in a listbox to say as so Student Name address Dear student your grade for CMSC 100 are as follow finalexam: semester grade: Best wishes for a good summer, … |
| | Hi, I'm new to the forum and I was wondering if anyone would know how to display data from the tables of a MS Access database on labels on a form. The code underneath is my code for saving inputted data from textboxes. [CODE] Private Sub Button2_Click(ByVal sender As System.Object, … |
| | Please advice me what is the most suitable Design Pattern for C++ to create Data Access Layer. Objective is to have clear separate layer for Presentation Layer, Business Logic, and Data Access Layer. Sub Question: 1. In C#, there was Dataset class to get data tabular records from query. What …  |
| | Hi , I have a small requirement, which I am unable to complete. I am having a gridview on the form, and the data is bined to the grid using ObjectDatasource that is inturn binding from a TableAdapter in the dataset. I have all select,insert,update and delete commands specified. When … |
| | I am developing my final year rail reservation project.. I am having a little problem with the seat selection.. I can either get all the seats that are available or that are not available.. so what i want to do is if there is a seat in another table then … |
| | Hello, I am having a problem adding a node properly. It does add but it duplicates the Test node I know why it is doing it (I create the Test node in the root as well as in the dataset) but I don’t know how to prevent it. Any suggestions … |
| | Here is my code: Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load InitializeComponent() Dim str As New StreamReader("C:\projects\servers.txt") Dim server As String = str.ReadToEnd().ToString() str.Close() Dim thisconnection As New SqlConnection("server=" & server & ";integrated security=True;database=Deduping") Dim thisAdapter As New SqlDataAdapter() Dim cmdthisAdapter As New SqlCommand("SELECT ProjectNumber, … |
| | Hi I'm really new to C#, more familiar with .ne but haven't code much in a while. I am not sure how to populate a table with data after clicking a search button.. know how to do this in .net but eve after looking at examples I'm not sure how … |
| | plz tel me how to resolve that error my code is [code=asp.net]<asp:GridView ID="gridView" runat="server" Style="position: relative; left: 299px; top: 69px;" PageSize="5" OnRowCommand="gridView_OnRowCommand" AllowPaging="True" OnSelectedIndexChanged="gridView_SelectedIndexChan ged1" > <PagerTemplate> <% if (gridView.PageIndex > 0) { %> <asp:ImageButton ID="imgBtnPrevious" runat="server" Style="vertical-align: middle;" ImageUrl="pre.jpg" OnClick="click1" CommandArgument="Prev" CommandName="Page" /> <% } %> <%=(gridView.PageIndex * 5) … |
| | Ok i have this code to retreive data from a Table "Calendar" and the feild within the table are Id,Day ,Month and Year. When i press the button to run this code and i get the error message "The parameterized query '(@Day varchar(8000),@Month varchar(8000),@Year varchar(8000))Sel' expects the parameter '@Day', which …  |
 | I am working on a vb app and am getting this error when calling a form (frmCaseList) from another form(LoginForm). the frmCaseList wasat one time in a different solution where it worked fine (it was the startup form). frmCaseList is also inside a namespace. If I commentout the [icode].show()[/icode] line … |
| | Hi, In vb.net2008 if we want to disable/enable the groupbox as per condition.Then how its possible when we used save button.how its insert into database.following is the code: [code=vb.net] Imports System.Data.OleDb Public Class addcust Dim da As OleDbDataAdapter Dim ds As DataSet Dim cmd As OleDbCommand Dim cmd1 As OleDbCommand … |
 | hi, i'm using VS2008 and used the database wizard to make sure my database table and dataset datatable match. I used following code to transfer data from my windows form to my dataset then database. I keep getting an error saying "Invalid Object name 'Housing'" and I cant find the … |
The End.