Databases :: While (dr.Read()) Not Picking Up All Rows?
May 18, 2010
The 'while (dr.Read()) statement in this code set is not process all the rows picked up by the sql statement in the access file. It will only process the first row found and ignore the rest. I can't seem to figure out why.
[Code]....
Here is the code in my access file: Product_Series_PendingAccess.sqlSelectAllRows
i want to tranfer a xml string variable to DB2 store procedure. And then, i will open xml to get data to insert into tables . If in sqlserver i user OPENXML,.. But in DB2 i am a newmember. How can i do it in DB2 store procedure.
If I use Microsoft.Jet.OLEDB.4.0 to retreive for example named range or sheet from Excel and use it as data source for some server control on the ASP page, everything works fine. But when I try to get table from Excel like this: "select * from [Table1]", debugger complains that database engine could not find object Table1. So how should I reference Table1 in Excel file so that the database engine could find it?
string strFileName = FileUpload1.PostedFile.FileName; string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection objConn = new OleDbConnection(connectionString); objConn.Open(); String strConString = "SELECT * FROM [Product Classification 5$]"; //where date = CDate('" + DateTime.Today.ToShortDateString() + "')"; OleDbCommand objCmdSelect = new OleDbCommand(strConString, objConn); // Create new OleDbDataAdapter that is used to build a DataSet // based on the preceding SQL SELECT statement. OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); // Pass the Select command to the adapter. objAdapter1.SelectCommand = objCmdSelect; // Create new DataSet to hold information from the worksheet. DataSet objDataset1 = new DataSet(); objAdapter1.Fill(objDataset1, "ExcelData");
but in it doesnt read the Description data of 20 & 30 because somebody said if the first cell value is string type then all the column should be string but in mycase its coming as mixed(alpha & numeric), so that it cant read the data, i tried to convert the column as Text then also the same problem continues,
Im reading some data from the excel file, using below code
objBusy = new BusinessLogic(); string strFileName = FileUpload1.PostedFile.FileName; string connectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + strFileName + ";" + "Extended Properties=Excel 8.0;"; OleDbConnection objConn = new OleDbConnection(connectionString); objConn.Open(); String strConString = "SELECT * FROM [Product1$]"; //where date = CDate('" + DateTime.Today.ToShortDateString() + "')"; OleDbCommand objCmdSelect = new OleDbCommand(strConString, objConn); // Create new OleDbDataAdapter that is used to build a DataSet // based on the preceding SQL SELECT statement. OleDbDataAdapter objAdapter1 = new OleDbDataAdapter(); // Pass the Select command to the adapter. objAdapter1.SelectCommand = objCmdSelect; // Create new DataSet to hold information from the worksheet. DataSet objDataset1 = new DataSet(); objAdapter1.Fill(objDataset1, "ExcelData");
after this if i looks on the DataSet i see some of the cell value not read from the Excel file, what was the problem and how to resolve this?
I have read the excel in asp.net. I am using OledbDatareader for read the column name.
[Code]....
Now my problem is the "date" field. If Excel sheet having column name "Date" then i got the error. i could not use the Column index because its also not fix. How can i ignore the upper case charactors in column name ?
i have been searching a lot but i didn't find my specefic result, my question is: how can i read excel sheet from asp.net using vb and how can i insert values into a worksheet from my web page
i want to ask whether we can read and write excel in website by using asp.net i don't want user to download the excel file and after edit upload again to website. what i want is user can read the excel file in website, after they edit, save the excel
I have 3 excel files having uniqe column Name JobNo. i want to develop a web page containing serach option based on Jobno.
User just type the jobno and press on search button corresponding record should be display on grid view.record may present any of the excel sheet.how can i acheive this.
I have a web app where user uploads a file.ile is saved in server locally and I want to read some data from it.Currently my development server has office 2003.So do I need office 2007 in order to be able to read an excel from office 2007 ?
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application(); Microsoft.Office.Interop.Excel.Workbook wrkBook; // = new Microsoft.Office.Interop.Excel.Workbook();
I have a problem that I can't figure out. I shall read an images from a column in a MySQL database. I use a simple aspx page and the codebehind file with the code below.
It is ok to read the image if I don't use any parameter value in the where clause, but if I use it, nothing is returned. I don't know if I have done anything wrong in the code. I have also tried to set a proper value on the parameter.value without success. So my conclusion is that the parameter sertup is wrong in my code.
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load Dim PictureID As Integer = Convert.ToInt32(Request.QueryString("id")) 'Connect to the database and bring back the image contents & MIME type for the specified picture
i'm trying to read an excel file and get data on a row by row basis. Since after converting the pdf file into an excel file, the formatting went a bit haywire but if read row by row, i'm still able to retrieve the original data.
As I am unable to generate the excel file using a single worksheet, i have multiple sheets in the excel file. I also need help on reading multiple sheets.
Currently i am onli able to get data via columns but due to the formatting going haywire, i gave up on it.
i have one task. i store the table records in tab delimiter then i want read that txt file data's line by line via asp.net application codebehind file after that i want insert into another table
am in deep trouble with retriving the data from oracle database. Please HELP ! In one line: "When i retrive the data from oracle database, it's truncate the data if it is more than 4 kb"I have oracle proc param as below:
PROCEDURE p_GetData ( ivar_id IN id_n%TYPE, oclb_owners OUT CLOB, onum_sqlcode OUT NUMBER, [code]...
Iām trying to read images from an excel file using OleDbDataReader. My excel file has 6 columns of data, the first 5 are all text but the last is image. While Iām reading the record, It's doing fine on the first 5 columns but return me with a for the sixth column.