vivekanandaan

I am using VS2010 and created a database using SQL server residing in VS2010. the database is stored in the folder APP_DATA with an extension .mdf My PC name is rvivek and it resides in a domain. below is my connection string. myConnection = New SqlConnection("server=rvivek; uid=; pwd=; database=Database1.mdf;") when …

When i try to run my webpage with database connection i am getting this error. Unable to find the requested .Net Framework Data Provider. It may not be installed. Visual Studio 2010 and SQl Server .. Kindly advice..

I've developed a web page in Asp.net using visual studio 2010.how to make those pages work in my website.I have tried uploading all the folders in my httpdocs folder. But it's not working. Kindly help me out. Vivek

Dim conn As New OleDbConnection("PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = e:\wms\wms\wms.mdb") conn.Open() Dim userDetailsAdapter As New OleDbDataAdapter("select * from daily_trans", conn) Dim userDetailsTable As New DataTable userDetailsAdapter.Fill(userDetailsTable) Dim returnRows() As System.Data.DataRow = Nothing returnRows = userDetailsTable.Select("cons = " & TextLine) If returnRows Is Nothing Then MsgBox("Can be saved") Else MsgBox("Primary Key") End If …

Can somebody suggest one free barcode OCX which can be used for Vb.net projects . Regards Vivek

I have a domain registered. I've uploaded my pages in httpdocs of my webspace. Other html pages are working fine, but my asp.net pages are not working properly. when i try to load those pages i am getting error as below : Server Error in '/' Application. -------------------------------------------------------------------------------- Runtime Error …

Hi, I have a designed a page in asp.net. I want to setup in IIS that page so that if i enter localhost it will take me to that page. Kindly help me how to do it. Regards Vivek

Hi to all, I want to pass the below statement to a report... Kindly help me how to do it ... select a.po_number,a.mr_number,b.item_code,c.item_desc, b.qty,b.rate from po_head a,po_detail b,item_master c where a.mr_number=b.mr_number and b.item_code=c.item_code and po_number = ' & combopo.text & '; kindly help...

[CODE] Dim connectionString As String Dim cnn1 As OleDbConnection Dim cmd1 As OleDbCommand Dim sql1 As String connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = d:\sprrg\sprrg.mdb" sql1 = "update po_detail set po_number=" & txtPoNo.Text & " where po_number=0;" cnn1 = New OleDbConnection(connectionString) cnn1.Open() cmd1 = New OleDbCommand(sql1, cnn1) cmd1.ExecuteNonQuery() cmd1.Dispose() [/CODE] The table …

[CODE]insert into po_detail (item_code,qty,item_rate,item_tax) select a.item_code,qty,item_rate,item_tax from mr_detail a,mr_head b where a.mr_no = " & combo_mr_no.Text & " and a.mr_no=b.mr_no""[/CODE] what's the error in the above code ?

I need a code in vb.net for sending mail with attachment... Kindly help ... Vivek

[CODE]Dim connectionString As String Dim cnn As OleDbConnection Dim cmd As OleDbCommand Dim sql As String connectionString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;Data Source = d:\sprrg\scm\scm\sprrg.mdb" sql = "insert into mr_detail select job_Code,mr_no,item_code,qty,addl_description" cnn = New OleDbConnection(connectionString) cnn.Open() cmd = New OleDbCommand(sql, cnn) cmd.ExecuteNonQuery() cmd.Dispose() cnn.Close()[/CODE] I am getting eror as No value given …

hi, I am having two tables with a similar structure. I want a code to select data from one table and update the same in second table and then delete the records in the first table. Kindly help me out. Thanks & Regards Vivek

[CODE] Dim conn As New OleDb.OleDbConnection Dim dbprovider As String Dim dbsource As String Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter Dim sql As String Dim maxrows As Integer dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbsource = "Data Source = d:\sprrg\scm\scm\sprrg.mdb" conn.ConnectionString = dbprovider & dbsource conn.Open() sql = "select …

I am selecting the max value of a column from a table. If the table does not have any rows i need the result as zero. how can i achieve this Regards Vivek

[CODE] Dim connection As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""d:\sprrg\\scm\scm\sprrg.mdb"";") Dim adapter As New OleDbDataAdapter("SELECT * FROM mr_head", connection) Dim dbInsert As New OleDb.OleDbCommand Dim table As New DataTable adapter.Fill(table) 'job_code,mr_no,mr_date,item_code,qty,mr_status,mr_approved_date 'Dim row As DataRow = table.Rows(0) connection.Open() dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "job_code" dbInsert.Parameters.Item("job_code").Value = jobcode dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "mr_no" dbInsert.Parameters.Item("mr_no").Value = mr_no dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "mr_date" …

Please look into the code and help me ... [CODE] dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "mr_no" dbInsert.Parameters.Item("mr_no").Value = 1 dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "mr_date" dbInsert.Parameters.Item("mr_date").Value = DateTimePicker1.Value dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "item_code" dbInsert.Parameters.Item("item_code").Value = txtItemcode.Text dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "qty" dbInsert.Parameters.Item("qty").Value = txtQty.Text dbInsert.Parameters.Add(dbInsert.CreateParameter).ParameterName = "mr_status" dbInsert.Parameters.Item("mr_status").Value = "N" dbInsert.CommandText = "insert into mr_head values ('MBBK7490','2',DateTimePicker1.VALUE,txt_itemcode.text,txtQty.text,'N',NULL);" dbInsert.CommandType = CommandType.Text …

Hi, I am having the below situation ... In the form i will itemcode, quantity and rate controls.... If i click the add item button after putting values it should get saved in one temp table and should display in the side of the table. The fields should get automatically …

Hi, What's the problem in the below code... [CODE] Dim ds As New DataSet Dim da As New OleDb.OleDbDataAdapter Dim cb As New OleDb.OleDbCommandBuilder(da) Dim dsNewRow As DataRow dsNewRow = ds.Tables("mr_head").NewRow() [/CODE] I am getting the below error : Object reference not set to an instance of an object.

Hi, This is my situation. I am entering a value in textbox and click the find button. In the button click i've written the following code, but it does not yield any result. Kindly help. [CODE] dbprovider = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" dbsource = "Data Source = D:\sprrg.mdb" con.ConnectionString = dbprovider & dbsource …