I dont have the code .The combox contains the dept_names and i want the cprrosponding value that is the dept_no in the yextbox.iam able to save the values.

I have a sql table consisting of dept_name and dept_code.and on the form i have textbox for dept_code and combobox for dept_name.When i select a particular dept_name from the combobox i should get...

I have made a project in VB.net in which i have used sql server trial version 2000.I have made the exe but when i run the exe a error message is thrown :-An error has occured while establishing a...

I have two fields in a table(dept_code and DEPT_name) in SQL.In my form iam having two comboboxs. one for dept_name and the other for Dept_code.What i want is that when i select a particular ...

I have a button and on the click of that button i want to change a the name of few fielnames of Ms access table In Vb.net coding.

help me out plz

sir....not able to do aliasing..if any help it would be highly appreciated.

sir i have a confusion probably...we have used MappedSelect...for alising.that means i have to replace the vareiable strSQL with MappedSelect???
and remove the statement


strSQL1 = "SELECT...

did not undrestand these lines
Put the breakpoint in the lines oCmdOleDb.CommandText = strSQL and oCmd.CommandText = strSQL , dump the strSQL variables and compare the field lists.

Plz see my code(EXPORT)

Public Sub ExportTableData(ByVal ConnectionStr As String, ByVal TableName As String, _
ByRef oView As DataView, _
ByVal SelectSQL As String, ByVal WhereSQL...

sir not able to implement.....things ant working

may i write this code on load....without changing the existing code.or i make changes accordingly.


MappedSelect = "SrcFieldName1 AS NewName1, SrcFieldName2 AS NewName2, FieldName3, FieldName4"
...

do i need to write select fieldname as newfieldname ........in SQL part of the code only???coz i have tried and not able to import data

The thing is that i want the values in the combobx whatever i have saved at the backend in the table for a particular coloumn.every time i run my form ..i should be able to see the values in the...

I have a combobx on the form and i enter the value in the combobox and then click save button and the values get stored in the sql table.but i want to display all the values in the drop down of the...

no doubts i have accomplished the task.I have given the names of coloumns in MS access same as that in the SQl table and then the data is imported successfully but i want to change the names of...

Thanks a ton...I solved the problem

Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
Try
oCmdOleDb = New OleDbCommand("Delete from table1")
...

I tried this code and it is throwing an exception that connection property has not been initialized!!!
giving error in this statement

cmd.ExecuteNonQuery()

I have to delete the records in a ms access table using vb.net when i click on a button.

just want to thank you..for helping me out!!!!I don know if we can put messages like this but from my heart iam really thankful for your help.

I have got the records in MS access....For further...

I want to ask when we are importing the data into sql why we are using select command in SQL.....it should only be used in MS access and in sql we should write a insert statement.....

Where this code has to be written????

Dim oView As DataView
ExportTableData(SourceConnectionString, SourceTableName, oView, "", "")
ImportTableData(TargetConnectionString, TargetTableName,...

Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

connetionString = ("server=192.9.200.82;database=eKalyan;user...