Hi , I want to retrive the xml data into my database table. The xml file is from outside of application.so i want to retrive that xml data into database with in some temporary table Thanq

Hi , I want to retrive the xml data into my database table. The xml file is from outside of application.so i want to retrive that xml data into database with in some temporary table Thanq

Hi I want to know how to write storedprocedure when search creiteria is Present. Here the query to give the list of "select ID, Salesmennummer , Salesname Commision, Areacode from sales_master Areacode Salesmennummer Salesname Commision 1 1000 Rams 200 2 2000 Johny 1000 I Want to search above list by areacode or Salesmennummer or Salesname. so PlZ help me how to write storedprocedure for this. Thanq.

Can u explain that how the timer control works..If possible with example plz.

See if the following works for you: ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _ "Data Source=e:\My Documents\Orders.xls;Extended Properties=""Excel 8.0;HDR=NO""" Dim ExcelConnection As New System.Data.OleDb.OleDbConnection(ConnectionString ) ExcelConnection.Open() Dim ExcelCommand As System.Data.OleDb.OleDbCommand = ExcelConnection.CreateCommand() ExcelCommand.CommandText = "SELECT * INTO [Orders] FROM [Orders] IN '' [ODBC;Driver={SQL Server};Server=(local);Database=Northwind;Trusted_ Connection=yes];" ExcelCommand.CommandType = CommandType.Text ExcelCommand.ExecuteNonQuery() ExcelConnection.Close() :)