2,634 Topics
 | |
| | Hi. I have a couple of combo boxes. Any combination chosen from the combobox works. I am getting 2 errors in it. error1: When I chose RAM as 2.98 i get 4 results but when i chose RAM as 8 I get 2 records of 8 gb and the 4 … |
| | i tried putting in actual values and it works..this code gives results of RAM > 0.500 and less than and equal to 2.000 but how do i make it parametrized ??????????????????? [QUOTE] Private Sub Button6_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button6.Click Dim con As OleDbConnection = New … |
| | Hi, I am a beginner in VB.net. I have some problems here, that is how to transfer data between 2 different mySQL servers using VB.net? Myself have 2 solutions this problem but when i implement it, i face some difficulty. 1st solution is insert the data line by line means … |
| | Hi, I need help solving this problem. I have a dataset with four columns col1,col2,col3,col4 and the data could be col1 col2 col3 col4 ===================================== t1 abc a 1 t1 xyz a 2 t1 mnp b 3 t2 abc 1 t2 kkl 2 I want to create a datagrid which … |
| | hi frds, I want to fetch data from a table who contain approx 10 million data or above. I am able to fetch approx 1 million within 3 min. but this is so slow. and also problem to fetch more then 1 million. I used to data adapter and dataset … |
| | Folks: I am trying to get all NVIDIA users on the list and I am saying NVIDIA* in my SQL statement since there are different versions of NVIDIA.. if instead of NVIDIA* i said 'NVIDIA Quadro fx 4600' i get a list of queries.. but if I said 'NVIDIA*' i … |
| | Hello, I have an problem with updating a database after I have deleted or edited a database row in VB.NET. When I insert a new row it works well. When I delete I get the following error message: [I][COLOR="Red"]Update requires a valid DeleteCommand when passed DataRow collection with deleted rows[/COLOR][/I] … |
| | I create 2 datatables and add them to the dataset and add the relation. The problem is only the parent table seems to be bound to my gridview. Any idea of what I might be missing? [code] Dim connVT As New SqlConnection(ValuTrak.strConnVT) Dim strSqlAD As String = "SELECT * FROM … |
| | In relation to my previous post. I was able to delete the rows in the datagridview (thanks to ema005), but now I am having problems with the updating of it in the database. It's deleting in my datagridview alright. But not in my database. My codes are already going on … |
 | Greetings! I am developing a contact system using openlaszlo. So far I am able to view,remove and make updates except for adding. I am able to add successfully to the database though....The problem is that when I hit the add button the new entry is displayed on a separate window … |
| | when I hit click i get a blank table in my datagridview with no values in it! why is that ? [code] Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click Dim con As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") Dim cmd1 As New OleDbCommand con.Open() … |
| | I have 3 radio buttons and each connected to a SQL statement..the first one 'NVIDIA*' does not get executed whereas the other two do because they dont have wildcard character in them. Can you please help me with this ? I tried 'NVIDIA*' in Access query and they worked perfect … |
| | Folks: I am trying to establish a connection with an Access DB. To me the code looks right..but I get an error in the da.Fill(ds,"table1") and the error is "Fill select.command.connection property has not been initialized".. i know it means that the connection has not been established properly but i … |
| | when i check one or 2 or 3 or all 4 chechboxes..i want a corresponding SQL query to get executed. Please help me rectify my code.. thanks kavitha. Dim con As OleDbConnection = New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") Dim cmd1 As New OleDbCommand con.Open() If (CheckBox1.Checked = True) … |
| | hi frds, I want to fetch a table from database to my application. Table have a very large data. So I use threading. but problem is threads execute but not fetch full table from databse. What I do? Plz Give idea by which i complete my task of fetching database … |
| | I am writing a simple program to update a access database and keeping getting a syntax error and I don't know why. Please help I have been working on this for a while now and I am well and truly stuck! The datatable updates as expected but I cant make … |
| | I am new to VB 2008 Express and have built a few simple database applications, one with two tables, oth table have a primary key and one has a secondary key which I have added a relation to the other table using Dataset Designer. My question is: Is this relation … |
| | I am pretty sure that the VB.NET code is right but I am sure my SQL statements are completely wrong ..can anyone help me figure out my mistakes and as to how the SQL statements need to be framed to get the results correctly from the Access Database ? Thansk, … |
| | Hai All, I want to create crystal reports dynamically, I don't know the columns i will take it from database at runtime, im getting all data into one dataset and im convrting dataset into xml schama, then im using that xml schama in crystal reports,there i drag n drop all … |
| | hi.. i wanna know is there any way where i can automatically reload data into datasets without invoking the dataset.Fill(...) function. Since i work in an application where i take input and store it into database in one form and use the data for working in another form. So i … |
| | Friends: I have a question.. now..in my form I have 4 checkboxes and I have a click button..the idea is when any one or 2 or 3 or all 4 checkboxes are checked, a SQL statement should be executed and the results should be displayed in a datagridview. now..i have … |
| | my selection of one, or 2 or all 3 at a time should get connected to a SQL query and get executed but that does not happen here atall.can u all please take a look at this code and help me with this.. please..' thanks Private Sub Button4_Click(ByVal sender As … |
| | hi guys, im having problems connecting to my database using vb.net and sql server 2k5. below is the code im currently using and it is having problems. please help me solve this problem. Thanks adapter.connection = conn is the one having problems the problem is connection is not a member … |
| | Dear Friends DataView is pouplated from an oracle database table and when i tried to Filter records which has been created in between two dates gives me misguiding rows. I have tried with different date format, still getting wrong information. [code] Dim dt as New DataSet, dv as New DataView … |
| | Haris Hussain - Posted on Monday, June 30, 2008 23:15:15 I am facing a following exception. While am deleting a row from gridview. I am using VS 2005. Exception: Index was out of range.Parameter must be non negative and less than the index collection. Parameter Name : INDEX private void … |
| | Hello All: I have a program using VB.NET and Access. I have 5 comboboxes and any combination that I choose I get a result. I have 2 problems here: 1. I want to design 4 check boxes in such a way that any1 or combination when selected should give a … |
| | This code simpy does not work..it does not do anything..can anyone please help me figure out why this is happening? Thanks, Kavitha. Private Sub Button4_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button4.Click Dim con As New OleDbConnection("provider=microsoft.jet.oledb.4.0;data source=C:\Documents and Settings\bashkark\Desktop\Copy of USERS.mdb") con.Open() Dim cmd1 As New OleDbCommand … |
| | The bold section of the code below is supposed to loop in the dataset and return the values from the second code snippet into the database. The second snippet of code is for the data to be inserted into the database. [CODE]Imports System.Data Imports System.Data.SqlClient Imports System.Data.OleDb Imports System.Data.OleDb.OleDbType Public … |
| | I'm a beginner to VB.net 2005. I've started creating a small database project by refering to some VB.net books. I've know the use of dataadapter, datareader, commandbuilder etc which are required to connect to the database. I'm using Microsoft SQL Server Database File (SqlClient) for my project. I've used the …  |
| | I created the code below to import an Excel file into an existing M'soft Access database. The attributes present in the Access database are CWNO(Text), Name(Text), ICNO(Text), Nasion(Text), Company(Text), JoinDT(DateTime), ExpDT(DateTime), ResBT(Boolean), ResDT(DateTime), Note(Text), PBIT(boolean). The final four columns are not present in the Excel sheet. (ResBT, ResDT, Note, PBIT).But … |
| | Hi All I am working since 2 days to display images in a datalist and the code used is given below, but its not displaying the images. I am storing path of the image in database in imagepath cooumn. Kindly help me please. html code <asp:DataList ID="dlImage" runat="server" RepeatColumns="3" Width="311px" … |
| | Hi, I am wondering if anyone can help me with a small problem I am having. I am populating a gridview from an oracle DB. I only want some of these columns to be editable so I am using the code below to try and acheive this. As you can … |
| | i'm new to vb.net and i cant figure out how to solve this problem any help would be greatly appreciated how can i show data into list view if the data is located in different tables. here few of my code, Public strConn As String = "C:\*********.mdb" Public cn As … |
 | Hi, I was wondering (if possible) how to change the server address, port number, username and password of a dataset connection form within a form using textboxes. Thank you for your help |
| | Please Check the code and reply what is wrong in the update code Try block is executed successfully........but it is not being updated. Public Class Form3 Dim cn As New Odbc.OdbcConnection("Driver={MySQL ODBC 3.51 Driver};Server=localhost;Database=attend_ap; User=root;Password=;") Dim cmd, cmd2 As Odbc.OdbcCommand Dim adp, adp2 As Odbc.OdbcDataAdapter Dim ds, ds2 As New … |
| | Greetings Daniweb! I am building a webapp business management system. The backend that supports the app is currently under design and I am wondering on the following: In reality, each business' records have nothing to do with another business' records. I would like to design my db to reflect this … |
| | Hello everyone, as will be seen from the following massage I am new to C#. I have dataGrid that reads data from mine database. Also, I can update database from dataGrid, but I want to update it in more ways. So, I have the following code just to see something, … |
 | Hey all! First off, yes i have read the tutorial and i'm still stuck (mainly cos i'm not using ADOOB). My main problem is that my code adds a new record to the end of the dataset, which is what i want, but then it also has the very annoying …  |
 | i have created one database in which there is one table **Supplier**, its **primary key is SCode**. i have one more table **Quotation**, in which i have created **SCode as Foreign Key**.nw i want to allow user **to select SCode from Combobox in Quotation table.** Format. hw 2 add databinding … |
| | Hi I have a prob with my code. This way I get to see all the fields in table1 in the grid view but they hold no values! :( if u can help me make changes in this code..it will great! Imports System.Data.oledb Public Class Form1 Dim con As OleDbConnection … |
| | This is my code to load data from a database(SQL Server 2000) into a combo box. I keep getting the error [B]Name 'connString' not declared.[/B](the highlighted section of the code). I've tried posing this error in Google search but there are no answers. I am working in a software development …  |
| | hi Im trying to rationalise my code as i feel i am doing the same thing a couple of times with different bits of code. What i am doing is query a db and putting the result into a dataset and then filling a datagrid with this dataset..Fine. now i … |
 | How do I handle more than one thread to run parallely ? one thread keeps on updating the dataset and binding the grid every 10 seconds whis the timer does. so it cannot be stopped.But I want other events to execute fastly without consuming time such as scrolling the grid … |
| | Hi I have the following code. I have 5 combo boxes and a check box. I want the application to respond for one combo box chosen and work even for several different values from the 5 combo boxes and same applies to the checkbox. I want to know if i …  |
| | Please correct me if there's something wrong with my codes...It already have SQL Database connection and I successfully display my record from the database.... Please help me...here's so far I have...I need codes for data manipulation adding/edit/delete records....im using C#Windows Application THANK YOU...you're a big help... using System; using System.Collections.Generic; … |
| | hi all, i'm having 13 datasets in my windows service.nw the task is to convert dataset into xml.i know to convert 1 dataset into xml.nw i ve to combine all the 13 datasets into 1.den convert the 1 dataset to xml. nw i'm in need to know how to combine … |
| | I'm trying to extract information (people's names and other info.) from a public database into a spreadsheet. Unfortunately, info about the people in the dataset (like their name and occupation) is not visible in the source code. Instead, there is this application by Caspio done, from what I can tell, … |
| | I have no problem getting it there in the first place - my problem lies in the fact that I cannot get it to update - I have this code: [CODE] Private Sub reloadFieldNames(ByVal tableName) Dim da As New OleDb.OleDbDataAdapter Dim oDS As New DataSet Dim sSQL As String = … |
| | hi i am just starting with vb.net and have set a connection to an existing access db that i have and am able to get the data displayed on a form. my problem lies where as i want to setup a basic search. i have added a query to a … |
| | now i am doing something that i thought would be real straight forward but for some reason is not. Im trying to lookup records in a DB based on todays date. ow i know the db contains records for these dates but nothing ever gets returned. My code is below … |
The End.