problm solved dont no how...thnx ne ways...

also tried the following code

SqlConnection connect;
string con = "Data Source = localhost; Initial Catalog=master ;Integrated Security = True;";
connect...

m using visual studio 2005 and sql server 2005.
i want to create a backup of the sql server which m doin using the following code..

if (saveBackupDialog.ShowDialog() == DialogResult.OK)
...

some kind of sample code will be very helpful

first add a check box column to the datagridview.
to do this click on the datagridview control on ur form.
click on the right arrow on the top of ur datagrid.
click edit columns
add a column and...

in excel 07 the limit is 1048567. however even if this many rows are filled up cant we use another sheet.
and i was looking forward to export it in a single excel file with multiple workbooks....

ive also set double buffer to true but to no avail...
plz help

hie
m using visual studio 2005 and sql 2005
i want to export my sql database to excel..

hie lennie..
i have visual studio 2005 and the code works fine. not sure about visual 2003 but u can still giv it a try...

textbox1.text =...

hello every1,
my project is on the verge of completion and a large part of the credit goes to daniweb.
now m stuck with a very annoying problm. ive googled the whole day but to no avail.
m using...

which database are you using and which version of visual studio are you using.
this shud get u strted...
go to the properties of the label..,..
go to databindings...
advanced option...
in the...

how to assign the date and time to the status strip..
it shud automatically update the date and time.
also i want to display the name of the form in the status strip.
how can this be done.
m...

i think there are extra inverted commas at the end of the update statement

hello every1,
am unable to edit data in a data table and save it to the data base.
this is my code
this is to fill the data table

m_ContentsDataAdapter = New OleDb.OleDbDataAdapter("Select...

no it is not being automatically incremented. i am aware of tht option but cannot use it since at a later stage i have to manually assign tht value.
moreover the porblem seems to be only at the id...

hie m looking to edit certain data on the form.
data on the form is divided into two sections A and B.
when i right click on A and select edit i shud get the option to edit A and similarly for B....

didnt get you...

If Me.txtCompany.Text.Trim = "" Or Me.txtTelephone.Text.Trim = "" Or Me.txtEmail.Text.Trim = "" Or Me.txtAddress1.Text.Trim = "" Then
MessageBox.Show("Please enter all informaiton",...

hie,
m using visual studio 2005 and access 07.
this is my code. ive also attached an access 07 file and this is the exact data tht my actual database has..plz help

Dim DataAdapter As New...

yes my table has a primary key.

if u want the exact exception that is occuring this is it

System.Data.OleDb.OleDbException was unhandled
ErrorCode=-2147217900
Message="Syntax error in...

still the same error

subquery is not the only way.
u can simply create another query and fetch the data from the other table.
alternatively u can also use data tables...

i am aware of the insert query. but i wanted to add data using command builder.

i agree with tomw.
m sorry i forgot to add the parameter part mentioned by tomw.

u can make the connection object as module level variable.
moreover u dont need to create a string and then attach it to the connection object
for eg.

dim conn as new sqlconnection("Data...

this is the code

m_DataAdapter = New OleDb.OleDbDataAdapter("Select * from [Base Colours]", oledbcon)
m_DataAdapter.Fill(m_DataTable)
m_CommandBuilder = New...

the data adapter handles my update insert and delete query...

price is declared as text in the database.

select * from accesstable

m using access 2007 and vb 2005
this is my code

Dim drNewRow As DataRow = m_DataTable.NewRow()
drNewRow("Code") = txtColourCode.Text.Trim
drNewRow("Colour Name") =...

why dont u try and use data reader

wht is search. if its just a variable then it can store only one value.
try using data reader or array.

thnx a ton tht worked fine.....

what r u trying to do..?
do u want the user to enter only numeric values?

the error that i get is
"syntax error in update statement"
with the title..."oledb exception was unhandled"
i am using access 2007 and visual studio 2005
sorry for late reply...

this is my code

If Me.txtOldPassword.Text = pwd Then
Dim oledbcom1 As New OleDb.OleDbCommand
oledbcom1.CommandText = "Update login Set password = ?"

...

first u have to think of a way to determine whether data is saved or not.
thn this factor can be used as a condition to determine if u want to run the above code or not.

Private Sub...

hie
how can i restrict the user to enter only numbers in a textbox

my previous code is working fine. i had made a few mistakes.

dataGridView1.Rows.Add()
dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = cboColourCode.SelectedItem.ToString...

this is my code

dataGridView1.Rows.Add()
dataGridView1.Item(0, dataGridView1.Rows.Count - 1).Value = cboColourCode.SelectedText.ToString
dataGridView1.Item(0,...