2,634 Topics
 | |
| | when i try to retrieve data from multiple tables and display the data in a datagrid it does nt display all the records i.e., it misses some of the record.what cud b d reason.below is my code:- dbcon.start_connection() ds = dbcon.getdataset("Select DISTINCT casemas.CaseID as ID, tblCourtType.CourtType as Court, casemas.CaseNo as …  |
| | Hi everyone, I nearly finished my project but have come across an error. I can't update the database, it's the only error that comes up. I tried a few things but couldn't get my head around it. Any Help will be greatly appreciated. Here is the main snippet of code … |
| | Im having problems with my ms acess sql command, well im trying to get the last value from the database here is my code, the error is ORDER BY clause syntax error.. [code] data.Open() record.SelectCommand = New OleDbCommand("SELECT PatientID FROM PatientRecord ORDER BY PatientID desc LIMIT 1", data) Dim ds … |
| | Hello! I have an SQL query designed to search a string field and return results based on input from the user. If I use VB.NET to interrogate the Access Db using the following SQL: "Select *FROM TRAINING WHERE ((Trainer Like '*Rob*'));" I get no results. If I perform this same … |
| | I've been working with a class module to make my connection codes abit shorter but when i removed my connection from the class and made it public it was not working anymore. The way I use the class lcon = New ADOcon lds = New DataSet Dim ltb As DataTable … |
| | I am trying to use a Listview1 instead of a datagrid1 by dropping a oledbDataadapter1 or a SQLDataAdapter1 on the Window form But having the hardest time. I can use this method: Private Sub btnLoad_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLoad.Click Dim MyConnection As New SqlClient.SqlConnection() 'Define … |
| | I have a form that is supposed to update tblMain in my database, and when I press btnSave it says in a messagebox, saved, but when I look at the table or try and recover the data from the dataset all I see is NULL values. Any help would be … |
| | Hi, I have two drop down lists boxes, upon page load first DDL gets populated and depending on user's selection on first DDL second DDL (child DDL) gets populated, works fine. My problem is when user goes back and makes another selection on first (parent) DDL (note that it's not … |
| | HAI! CAN ANYONE HELP ME TO RETREIVE DATA BETWEEN TWO DATES FROM MS-ACCESS USING VB.NET. I HAVE TAKEN DATETIMEPICKER CONTROLS. THIS IS THE CODE . ITS RETURS ERROR. PLEASE SOLVE THIS PROBLEM. Imports System.Data.OleDb Public Class Form7 Dim con As OleDbConnection Dim cmd As OleDbCommand Dim dr As OleDbDataReader Private … |
| | While Creating DataSet on Red Colored statement error occured which is Mentioned in Green Color....(A'm using Visual Studio 2005 and SQL Server 2005) Please Help...... 'Create New DataSet Dim ds As New DataSet("DataSetVendorInfo") 'Create a new Table and Columns Dim dTable As New DataTable("Vendors") dTable.Columns.Add("Ven_ID", System.Type.GetType("System.Int32")) dTable.Columns.Add("FName", System.Type.GetType("System.String")) dTable.Columns.Add("LName", System.Type.GetType("System.String")) … |
| | Is there some simple code to move first, previous, next and last in a dataset without using the wizard and creating your own buttons? Thanks in advance for any and all assistance, it it greatly appreciated. |
| | I'm back again for some more homework help. I just want to start off by saying thanks for assisting me in my last assignment. This one, I have to allow it to Enter a name, and enter grades for that name, and then it will display the average for that …  |
| | gud evening.. seems there are no replies regarding my project based on adpative detection of deisgn flaws , anyways i am persuading on,, i would like to have few datasets if possible. please try to post in,..the subject regarding my dataset are shapes eg:circle, square..etc.... incoporating machine learining technique with … |
| | I'm having some issues retrieving data from an OLEDB database. In a certain column it contains about 400 or so characters, but when I read it into my dataset or read it using a DataReader, all I get is the first 199 characters. I'm completely stumped as to why the …  |
 | I'm experiencing a little problem here with my code: DataSet _ds = new DataSet(); //convert xml to dataset _ds.ReadXml(textBox1.Text); try { //Create a relation between the Authors and the Titles tables. _ds.Relations.Add("Level", _ds.Tables["HEADER"].Columns["IDMAT"], _ds.Tables["ITEM"].Columns["IDNRK"]); } catch(DataException dt) { util.logThis("ERROR while Adding Dataset Relations between tables / UI / ProcessClick event … |
| | Here is what I am trying to achieve: I have an access database with a table [GroupTable] with 3 fields [RecNo, Group, SubGroup] (Group & SubGroup use integers) I want, under program control, to populate a table adapter with a subset of all records eg I want to be able …  |
| | Hi All, I m working on a vb.net application. Having a form with treeview & datagrid control. My requirement is that I'll populate the treeview control from a SQL server table. I made this one. The next task is to populate the datagrid control (another SQL Server Table) from a … |
| | Hi All, I m working on a vb.net application. Having a form with treeview & datagrid control. My requirement is that I'll populate the treeview control from a SQL server table. I made this one. The next task is to populate the datagrid control (another SQL Server Table) from a … |
| | Hi All, I m working on a vb.net application. Having a form with treeview & propertygrid control. My requirement is that I'll populate the treeview control from a SQL server table. I made this one. The next task is to populate the propertygrid from another sql server table by selecting … |
| | Please tell me how to store a user given input as one of the options in the combo box?? I have put up a combo box on my form with no collection,no options to choose from, in it.I want the user to enter some value in it and the next … |
| | Hello, I am writing a program that connects to a webservers db. I have a testing db on my local machine and i add a new dataset to this local db. I have tried to go into the app.config and change the connectionstring to a global variable i created useing … |
| | My question is to calculate the mean of a comma separated dataset stored in a file. The program will be run on a system with no floating point library. Obey the following rules: 1.Maximum 100 values in dataset 2.Each data entry in the dataset is a byte (0 - 255) …  |
| | i have a dataset [code] Dim query1 As SqlDataAdapter = New SqlDataAdapter("SELECT * FROM AnswerList WHERE SurveyID=83 AND QuestionNum='" & counter & "'", strConnection) Dim ds As New DataSet query1.Fill(ds)[/code] how can i refer to specific column for example if i want to search for column QuestionNum=1 in table AnswerList … |
| | OK, so I'm finally transitioning from VB6 to VS 2005 and it is excruciating. I do a lot of db programming in VB6 and Access 2003 and just trying to connect to a table in VS2005 has taken me several hours. I finally could read data from a table and … |
| | this is the questions i faced in an interview i am new in .net and sql so anyone knows this ans please inform me thanks *Can we have an updateable view in SQL? *What is the difference between stroed procedure and stored function in SQL? *What is connection pooling? how … |
| | Im having problems with my insertcommand using odbcadapter, it doesnt insert the information I needed.. But the selectcommand works fine, only the insertcommand that is having problems.. heres my code.. [code] Private Sub cmdLogin_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdLogin.Click a = Trim(txtStudNo.Text) If Trim(txtStudNo.Text) = "" …  |
| | Hi there I have connected visual basic express to my access database and designed a windows form with navigation functions as well as add delete, update functions. I have used textboxes to display the database fields on the form, but i am having trouble displaying an updated autonumber when a … |
| | I am using two textboxes and one checkbox to remmber my username in login page My requirement is for the first time if user logs in and he checks the check box when he login for next time based on his username the password should be filled i have written … |
| | Hello, I am having trouble with the memory size of an array I am using. At the moment I have an array to pointers of objects. These objects get read in from a file and sorted, then a new file is outputted after some filtering is done on the array. … |
| | I have a combo box on a binding control. It is bound to a name column in my dataset. It works like it should, but I need the autocomplet to be able to find names by either first name or last name. For example, if I have two names in …  |
| | Can someone tell me how to store the following information into a dataset. The information is already loaded into the treeview, but I need to figure out how to recurse the tree and set the values to the specification as laid out. I can't seem to figure that one out. … |
| | Hi :) I want to move the data in a cartein table to a DataGrid. What im doing right now is using the: dataGridView1.DataSource = dataset.Tables[0]; And its adding rows and columns automaticly according to the data base. (including the headers) I dont want to do it like that, i … |
| | hello , i want to add new record ino database ,but getting some problem pl help me front end :- VB.net2003 back end :- SQL Server 2000 my efforts : Imports System.Data.SqlClient Imports System.Data Dim conn As SqlConnection = _ New SqlConnection("server=;database=tempdb;uid=;pwd=") Dim ds As New DataSet Dim da As … |
| | hi im having a dataset in which i have to filter a column with unique values  |
| | Hi.....need hel from u guys...would like to ask on the error with the coding below...the total dura_hour did not shown in the textbox...can anyone point out the mistake or the missing coding? Me.OracleSelectCommand2.CommandText = "SELECT sum(DURA_HOUR) FROM DOWNTIME" Me.OracleSelectCommand2.Connection = Me.OracleConnection2 OracleConnection2.Open() OracleSelectCommand2.ExecuteNonQuery() OracleDataAdapter2.Fill(DataSet141) txtRelia.DataBind() OracleConnection2.Close() thx in advance |
| | Hi. I'm starting to use clientdatasets after years with Zeos DBO and I'm facing some difficulties. I created a TSQLConnection, a TSqlDataset as a ctTable, a TDatasetProvider and a TClientdataset. I populated the clientdataset and tried an ApplyUpdates(0) to insert the records. But I'm getting a "cannot modify a read-only … |
| | Please help me " System.Data.SqlClient.SqlException: Prepared statement '(@Name varchar(100),@Describes varchar(100),@Money char(10))Upda' expects parameter @Describes, which was not supplied. at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Assignment.rose.dtgFlower_UpdateCommand(Object source, DataGridCommandEventArgs e) in c:\inetpub\wwwroot\assignment1\rose.ascx.cs:line 111Error:Cannot update " This is the code "namespace Assignment { using System; using System.Data; using …  |
| | Dear friends: I've copy the asp.net code from Unleashed book. I want to use this part of the code to take stored procedure rather than select statment. The stored procedure I write for is this: ********************************************************* CREATE PROCEDURE authenticatedUser ( @userName Varchar ( 20 ) , @userStatus Varchar (20), @userPassword … |
| | Hi :) I have 3 DataGrids (and even more in the future) that supose to present data from a DataBase. When i press on the main DG all the rest are updated according to a cartein Code Index. The problem is that its very slow and i want to make … |
| | I need to use C# methods to set the values of some DataColumns in a table. DataColumn provides an Expression property, but that only allows a subset of SQL style calculations on the dataset. What I need to do is call a C# method to perform calculations too complex for … |
| | This is my second c# program and the database stuff is [U]quite [/U]different than vb 6.0, I am obviously missing a line or otherwise have malformed code -- Help! Program is supposed to read in FCC Amateur Radio DB (flat file) and insert data into an Access Database. DB has … |
 | Hello, all-- Our ASP.NET 2003 app's primary screen uses a datagrid with clickable headers for sorting by column. There is a "user control" with two list boxes from which the user filters the datagrid rows. I added a textbox in the user control -- changed nothing else* -- and now … |
| | This may be a NET bug, but maybe I'm missing something. I've been trying to trap a certain kind of error when using a DataGridView. The following describes the steps to generate the error. I used a typed dataset to make the example quick, but the same thing happens if … |
 | I try load a xml file (have DTD) into dataset, and bind it into datagrid (because i want to edit). when i call writeXML function, the scehema of my xml is different from the DTD.. how can i write based on my DTD? {sorry for my bad english} |
| | Hi All, First off, thanks in advance for your time! I'm a VB newbie, and I'm struggling with my first app. The scenario: I'm trying to manipulate a tab-delimited text file based on the contents of a MS Access table. My Approach: I'm at the point where I've imported the … |
| | So we're supposed to modify this class, which implements Comparable, so that it accepts any type of object. The Comparable interface contains the method signature for compareTo, which I need to implement. What I'm uncertain of is how to implement this method. I know that compareTo is supposed to return … |
 | hello all, i have been setting up reports to work with our intranet web application but after attempting to make the reports dynamic in the data they retrieve i have tried using a dataset and an xml file both return this error when i attempt to load the report document. … |
| | Hi everyone! Please help me, I am beginner of the vb.net , I want know how to create dataset coding and binding a textboxes,combobox and masked textbox pelase help me |
| | Hi Guys, Im learning about ADO and Im learning it from a website. I followed all the directions and copy pasted the example. For button next, previous and last command button, it tells me there is an error. the error say that an Identifier is expected in Me.BindingContext(DataSet21, _ "table1"). … |
 | We've got a database with a table that is growing fast. The database is a SQL db that exists at another location connected via the Internet. Originally, we had code to edit records, one at a time by flipping record by record (one record displayed on the form). Unfortunately, this …  |
The End.