2,634 Topics
 | |
| | i need exam for dataset clone . if you find the result. reply me.. |
| | I am doing a project in college and I am not binding the database. I am connecting to it manually. i got the database to load and display, but can't create a new row or edit the database or delete a row. the code is here and could someone tell …  |
 | Hi Everyone, I would like to know how to make a DataView global to a particular form. The DataView is currently created and returned from a function within a public class residing in another .vb module. All help will be appreciated. Thanks. Truly, Emad Here's what the code in the … |
| | Hi experts I m creating a project in vb .net I have dataset xsd and a crystal report file when in xsd file I add any one table , in crystal report “database Field/ Project data/ADO .NET dataset/” show table & fields but when I add any more table or … |
| | Hi all plz help i need to search my database using data from the combo box which works fine the problem that I an experiencing is that FIND function gives me a runtime error, saying the string is not in the correct format plz help. here is the code that … |
| | Hi Everyone, Can you tell me how do I set up create Insert, Update and Delete commands for your a DataAdapter? I'm using a DataGridView to allow the user to view, change and delete data rows and would like to be able to save any changes made in the grid … |
| | I have an Access database with a contacts table and a location table that is linked to contacts. When i click the add button I want to add a new contact and add that contacts ID to a the location table. The ID is an Autonumber, so when i add … |
| | Hi All I have created a dataset and from this I want to retrieve values of a column into a variable. How can I do this? This is the code: [size=2][/size][size=2][color=#0000ff]Dim[/color][/size][size=2] sQuery [/size][size=2][color=#0000ff]As[/color][/size][size=2] [/size][size=2][color=#0000ff]String[/color][/size][size=2] = "Select PERMISSION_BUTTON_ID from ALC_SECURITY_PERMISSION where ROLE_ID = 1" Response.Write(sQuery) [/size][size=2][color=#0000ff]Dim[/color][/size][size=2] myAdapter [/size][size=2][color=#0000ff]As[/color][/size][size=2] OleDbDataAdapter = [/size][size=2][color=#0000ff]New[/color][/size][size=2] … |
| | hi, In my Dataset I have 3 columns "EducationLevel","Skill" and "PreferenceType".In the report I have a field called marks.I give marks adding above 3 column values.i.e If "EducationLevel" is (High,15 marks),(Medium,10marks),(Low,5 marks). If "PreferenceType" is ("First" 15 marks),("Second" 10 marks),("Third"5 marks) If "Skill" is (High,15 marks),(Medium,10marks),(Low,5 marks). The Marks field … |
| | I can insert into my table by the bindingnavigator and dragging textboxes straight from the DataSet entering them and saving. But I want to insert into the DataBase via code and in order to do this I have used the below code to connect. I use this code to test …  |
| | I have figured out how to populate the comboboxes for an app I'm making from a database this is not the actual code but is basically the way I'm populating them [code] for i = 0 to maxrows - 1 cbobox.items.add(dataset.tables("datatablename").Rows(i).Item(x)) next i [/code] I need either to be able … |
| | i use this method to fill data grid [code] public void fill() public void fill() { SqlConnection con = new SqlConnection(connStr); con.Open(); SqlDataAdapter da = new SqlDataAdapter("Select * from Dept_Master", con); DataSet ds = new DataSet(); da.Fill(table); } public void BindDG() { GridView1.DataSource = table; GridView1.DataBind(); } public void Nrow() … |
| | I'm developing a mobile website using vb.net but having set my tools right as I read somewhere, I've having an object reference...null error from the sqladapter line. I'm trying to authenticate by checking the db for username and password and granting or denying access asthe case maybe, here's my code, … |
| | Hi all, I am reading data from an excel spreadsheet. The column data which i am reading from my spreadsheet reads as follows: integer integer integer var char integer integer integer var char var char null integer etc..... As you can see it contains no specific data types, but just … |
| | i have to show data in datagrid view in windows forms for that write code in class library as [code] public DataSet fillgrid() { string selectall = "select * from employee"; con.Open(); da = new SqlDataAdapter(selectall,con); da.Fill(ds,"employee"); //con.Close(); return ds; } [/code] and iload add reference and write code on … |
| | hi i tried to search from a dataset but when i try to add from a dataset to a datagridview it is not adding to the datagridview. here is my code. moreover if i try a messagebox the result found is being displayed. [CODE]con.Open(); cmd = new SqlCommand("sp_getUsersDetails", con); cmd.CommandType … |
| | I am having two dropdownlists that are interrelated, in which one is vertical ddl and the other department ddl in a grid view if we select the vertical ddl then corresponding departments have to appear in department ddl. I've written the code like this In footer of gridview i successful …  |
| | Hi, I am having the same problem [I]<<mod edit: [URL="http://www.daniweb.com/forums/post228229.html#post228229"]as this[/URL] >>[/I] when i update my record in Access Database. It is successfully updated the record in the database. but the dataset in my project is still not updated. I am using vb 2005 to develop the application. Any one … |
 | Hi, I am writing a program that has a listbox which is bound to a dataset. When I click a button (e.g. delete) the item is deleted from the database ok using an SQL query but is still shown in the listbox. How do I get the listbox to refresh/update … |
| | I am using vs.net 2008 vb and mysql I am using datasets alot in this application, however I am having a few small snags I am running into. I created a login system that works quite well, but I need using the db or settings or a variable keep the …  |
| | Hello, I am developing a mobile application (school project) using a Windows Mobile 6 Professional emulator. This application has a login function that prompts for a password and uses a Data Access Object(DAO) to connect to a SQLServerCE database. This database has a table called User which stores the password. … |
| | Hi All Can anyone help me with this problem please. I am writing a program in C# and have an access db07. The user should be able to enter a date into a text box then that date is addedd to my sql query and then return all record with … |
| | Hi Good Guys, I encounter another interesting problem due to my lack of C# knowledge. Please Help me. I am trying to use DATAREADER to fill TEXTBOX controls on the FORM and it's not working because this coding generate error message: [COLOR="Red"] sqlDR = sqlCmd.ExecuteReader(); <---- Error [/COLOR] Error message: … |
| | Hi Good Guys, [B][I]I am learning how to use C#Net2008 to develop Window Application. I was a VB.NET2008 developer. I need your help, Please Help me. [/I][/B]I am encountering 2 problem trying to fill LISTBOX with [COLOR="Red"]DATASET[/COLOR] and [COLOR="red"]CATCH [/COLOR]to display error message. In the LISTBOX dropdown list instead of … |
| | am developing software using sql database. i want an sql statement that can enable me retrieve data which for example has same surname,save them in an array or dataset and navigate through them. |
| | Sir, I am using front end as a VB.net 2005 and I am a beginner in this language. I am creating Desktop application and using controls TAB controls 1st tab control is Contact in contact I am using one text box, two button and one datagrid while I am using … |
| | can somebody give me code that retrieve data from from same column which have same name e.g surname,store it in dataset and then navigate through it on form using odbc. |
 | [CODE]using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.IO; using System.Data.OleDb; using System.Web; //using System.Web.UI; //using System.Web.UI.WebControls; using System.Configuration; namespace QuanLiDSSV { public partial class Frm2 : Form { public Frm2() { InitializeComponent(); } private void btnBrowse_Click(object sender, EventArgs e) { } private … |
 | I'm retrieving immediate next record from database table using empcd(employeecode) [for which code is given below]. I wanna retrieve "next record" details from SQL SERVER 2005 with a Button Click Event but not using "EMPLOYEE ID". (SqlClient.SqlConnection) i want to access database table nextrecord directly using either query or Logic. … |
| | I am trying to add a new record to a database using VB.net. I have used code for one table in the database which worked and then copied and pasted it and changed the column names to the ones in the other table and then I got an error saying … |
| | I have a program that will load a datagridview with data from a database via a dataset at form load. On this same form, I have a button named "count", that when pressed, I want it to show a message box indicating how many entries were loaded into the dataset. … |
| | Hi everyone, I'm at my witts end and need some advice. I need to create a new table in MS Access from a datatable and I just can't get it to work. I have tried SQL with no luck, but I've been spinning my wheels in the mud. Any advice … |
| | hey, I've just joined daniweb - usually just search around on the net till i find solutions to coding problems but this time i'm stuck.... probably a simple problem but nonetheless... Anyway, I'm making a program that connects to an access database, retrieves data and the data is taken into … |
| | Probably a basic question but... I have an windows application comprising several forms with a SQL Server database in the background. From several of the forms, I keep needing to run the same method, so instead of repeating code in each form, I want to put this (repeated) method in …  |
| | Friends I m workin on vb.net ado.net oledb, I have also added datagrid Control to my form for retriving database from .Mdb file i used following code [code] 'decleared Name Space Imports System.Data.OleDb 'Dicleared Variabls in Class Form1 Dim con As New OleDb.OleDbConnection Dim ds As New DataSet Dim da … |
| | Hi! Does anyone knows how to add a radiobutton to a dynamic gridview that will be mutually exclusive? "In the GridView, the radio buttons cannot be grouped and therefore are not mutually exclusive. That is, an end user is able to select multiple radio buttons simultaneously from the GridView." One … |
| | Hey, I currently have a dataGridView which displays information from my SQL database. I have a button that I use to update/add into the SQL database - for example a user ammends a field in the dataGridView this automatically updates the database. I now want to implement a button that … |
| | Hi everyone, I've got an interesting problem that has me stumped and I just cannot seem to find the right answer in the help files. Background: My project requires that I establish more than a few relationships amongst datatables in a dataset so I decided to create a generic routine … |
| | I have 2 problems: First one is I want to put an user name password in a form...I have designed the table and database and I'm fetching the user names from a table and putting them in a combo box, from the combobox i select the required user name to … |
| | ok so i'm trying to set up my program to insert a new record to my database i keep getting a insert syntax error [CODE] Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click '************************************************ '* ** '* will first verify that all necessary information needed ** … |
| | I have set up a datagrid on my vb.net form for a MS access database. I have a listbox where i want to show only 1 column of data from the datagrid, which should be updated when the contents of the database changes. Please help ASAP. Dataset = Minicab_DatabaseDataSet Datagrid … |
| | Guyz I have a table named fec in which i hv column named EndDt having Date/Time Data type.Now i want to display those records in my report which have EndDt less than Date i pick from DateTimePicker and month is current month. [code] Private Sub DtpDefault_ValueChanged(ByVal sender As System.Object, ByVal … |
| | [CODE]//SELECT ID van ingelogde gebruiker MySqlConnection cn = cn = new MySqlConnection("server=localhost; user id=bla; password=bla; database=project; Allow User Variables=True;"); cn.Open(); string selID = "SELECT LidID FROM gebruikers WHERE Gebruikersnaam=?Gebruikersnaam;"; MySqlCommand cmd = new MySqlCommand(selID, cn); MySqlDataReader dr = default(MySqlDataReader); //Add parameters to get the username and password cmd.Parameters.Add("?Gebruikersnaam", MySqlDbType.VarChar); cmd.Parameters["?Gebruikersnaam"].Value … |
| | i have problem with my database.i using combobox to select elements. i have store the data using ms excess.the problem is when i select one of the element in the combobox.For example when i choose Perlis from the combobox, i hit summary button, there is no output on the label … |
| | I have two datasets called ds and ds1 that I want to merge into a grid. I get data from the first dataset to display in the grid but the second dataset where I want to display a count I don't get any data from it. I am trying a … |
| | Hi. I am new to this forum, but i have been playing with Visual Basic since 4.0. Anyway here is my problem. I am getting error and can't figure out why. [CODE] Dim connectionString As String Dim cnn As OleDbConnection connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\Database\tmprcStavka.mdb;" cnn = New OleDbConnection(connectionString) Try cnn.Open() … |
| | How can i can interesecting dataset column ? I mean common columns from two datasets |
| | hi there, need some help here, i am adding data to my access database, my add button is fine but what i wanted to do is to type directly in my DataGridView, not in textbox, as what is happening in my program, hope you could help me... thank you in … |
| | i have make the simple code log in program with connect database.The below code have something problem.Can someone pro solve the problem.:( [code] Private Sub btnSignIn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSignIn.Click Dim conn As New OleDb.OleDbConnection Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter … |
| | id been working on this for days now, maybe someone could help me figure this one, i have this items in listbox2, my database has a field for project, data directory, etc... if my first item in listbox2 equals to the field PROJECT in my database, i want to get … |
The End.