kavithabhaskar

How can i link database from microsoft access 2003 with VB.NET? can i use anything from eg. Form1 and display them on Form2? thx u very much.

I am looking at a source code There is a class called A and it has a parameter in its _init_ function called. Class A self.id = id There is another class called B and has a parameter in its __init__ function called Class B self.ide = ide There's an …

hi, I have three comboboxes in my windows form. I want to relate them all with each other. the data is coming from database a table which has the following columns: id description ap code seg code now if user selects description then ap code and seg code should change …

Code for connecting to Microsoft Access databse, opening and closing connection

Hi ,I work with vb.net 2005 . I want to know if I want to connect to data base with Ms Access which data source i can use (ODBC or OLEDB) I write the following code in form load event (by OLEDB) : [COLOR=#0000ff]Dim[/COLOR] conn [COLOR=#0000ff]As[/COLOR] [COLOR=#0000ff]New[/COLOR] OleDb.OleDbConnection([COLOR=#800000]"Jet OLEDB:Global Partial …

Hello Folks: I had previously posted this problem and someone on this forum suggested that i used s[i] == 'a' || s[i] == 'A' .... but what I have here completely makes sense.. Can you please take a look at it ? [CODE] #include<iostream> #include<string> using namespace std; int main() …

here is a c++ code .. It compiles fine and looks fine but it messes up the output. [CODE=C++] #include<iostream> #include<string> using namespace std; int main() { string s; cin>>s; for(int i=0;i<s.length();i++) { if (isalpha (s[i])) if (s[i] == 'a'||'A'||'e'||'E'||'i'||'I'||'o'||'O'||'u'||'U') cout<<s[i]<<" is a vowel"<<endl; else cout<<s[i]<<" is a consonant"<<endl; if …

Hi I am trying to count the number of words in a file and this is what i have so far. I am not sure about the getchar().. could you please tell me what i should be doing ? [code] #include<iostream> #include<fstream> #include<string> #include<conio.h> using namespace std; int main() { …

This function does not work either.. error msg is as follows beep.cpp: In function ‘int main()’: beep.cpp:8: error: ‘Beep’ was not declared in this scope please assist! [CODE]#include <windows.h> #include <iostream.h> using namespace std; int main() { Beep (100,100); return 0; }[/CODE]

Hi I am learning C++ and i coded this program but it isnt working as it was supposed to.. [CODE] #include<iostream.h> using namespace std; class furniture { protected: int color,width, height; }; class bookshelf : public furniture { private: int no_of_shelves; public: int accept() { cout<<"enter color"<<endl; cin>>color; cout<<"enter width"<<endl; …

HI I am trying to work on a very simple recursive function but i get o/p as some negative values.. can u please help and tell me what mistake i am doing ? [CODE]#include<iostream.h> void countdown(int x) { using namespace std; cout<<x<<endl; countdown(x-1); } int main(void) { countdown(10); return 0; …

Hi: I have a problem.. I have 3 text boxes and 12 comboboxes. the idea of the form is that the data entry on form has to be stored in Access.. which happens.. but i to limit the user in choosing only the values available from the combo boxes and …

Hi: I need some assistance in this code. I am trying to get this format. 1 .2 ..3 ...4 and so on.. i dont get any errors in the code but i get no o/p eitehr [code] #include<iostream.h> int main() { int i; cout.fill('.'); for(i=i;i<10;++i) { cout.width(i); cout.fill('.'); cout<<i; }}[/code]

Hi folks I am new to C++ i tried to reverse the characters in an array [code=cplusplus] #include <iostream> using namespace std; int main() { char kavi[]={'s','w','o','r','d','\0'}; cout<<kavi<<endl; cout<<"now reversing the word"<<endl; int i; while(kavi[i] != '\0') { i++; } cout<<"Length is"<<i; int j; for(j=10;j>=0;j--) { cout<<kavi[i]; } } [/code] …

I have the code for transferring data from the datagridview to the excel spreadhseet.. my datagridview has colored data in it and I want the excel spreadsheet also to have the colored data. i get the error "property access must assign to the property or use its value vb.net error" …

I am trying to open an excel spreadsheet using vb.net. The data has to be fetched from a datagridview.. the datagridview has colored data in it and i want it to appear colored on excel spreadsheet too.. How do i get it colored ? [CODE] Private Sub Button4_Click(ByVal sender As …

Hi I have 4 comboboxes..and any value that I choose.. I get a whole set of fields displayed in my datagrid view.. I want to make a difference..the value that I choose in the combobox, has to appear green in color in my datagridview. How do I do this ? …

Hi: I am writing code in VB but SQL is the major role here.. I am checking if MFG="DELL" in table1 and if that is there I need a msg box saying "DELL is supported" [QUOTE] Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click Dim con …

i have 2 tables with same fields except that table2 has 1 additional field..but otherwise table1 and table2 have same fields and have different number of records in each and each row in each table could be the same or completely different.. i am trying to add the distinct values …

Folks: this is a very small part of my code.. i have 2 comboboxes filled with RAM values(integers). by using the "nothing" keyword i just want to make sure that both the combo boxes have some values filled in them.. say i choose 1 from combobox1 and 2 from combobox2.. …

I have a field as MFG. i want to use an if condition to see if MFG=DELL or HP. if it is, I want to change that cell's color in the datagridview to green..only those cells under MFG column should turn green but if i said if(mfg...) it considers MFG …

FOLKS: I fill my data grid view with data and i try to color a few cells based on a condition but nothing seems to work..no errors either..can u pls help me >? [CODE]Private Sub Button11_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Dim con As OleDbConnection = New OleDb.OleDbConnection("provider=microsoft.jet.oledb.4.0;data …

I want to try and store distinct values of table1 in an array and compare that with values in table2 in each field. But I am not sure where I need to pass the sql statement..can u please take a look at it ? for that matter..i will just have …

when i click "button1" on my form..i get field name as ' Expr1002' and the data in it are -1.. i believe it is soemthing to do with the da.fill() .. can u please asssist me with thsi ? [QUOTE] Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) …

Hi I have table2 and table1. I want to check if table2 values exist in table1. If they do, I want them to be displayed on datagridview in a form. The table1 and table2 have same fields except that the primary key in each table is the serial number. Even …

I want a button click event to do this: can i use "UNMATCHED" keyword in the same SQL Statment using a UNION ? pls help me with this!! table1 is my master Db and table2 is my work DB.. both have same columns expect that primary key in both tables …

the code worked perfect on Friday and when I come back today and try.. the RAM alone works fine in the T-SQL but the Mfg, Make, GraphicsCard and GraphicsVersion do not work atall.. they dont give me any queries atall in the data grid view o/p.. why am i stuck …

this is my code.. i got both my work database and my master database on the datagrid views in my form...but how do i go about comparing.. and generating the crystal report ? [QUOTE] imports System.Data.oledb Public Class Form1 Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles …

I have a work database and a master database. I have 4 fields in each of them. If I got A B C D values for a field in my work database. If I have A anywhere in my master database.. I want a report to be displayed in Access …

I need to choose a value from a combo box and check if that exists in a table and if it does..i need to make a button glow green.. I am not sure how I have to check if the chosen value exists in that table.. can you please help …