MISSING ACCESS RECORDS

Similar Threads:

1.MISSING ACCESS RECORDS - CORRECTION

2.Missing first record

Using asp.net and .net framework 2 and SQL server 2000
I am using simple SELECT statement in SP to retrieve data and then bind to a 
datagrid but fail to pick up the first record in the dataset:

        invConn = New 
SqlConnection(ConfigurationManager.ConnectionStrings("Connectstring").ConnectionString)
        invConn.Open()
        invComm = New SqlCommand(zStrg, invConn)
        invComm.CommandType = Data.CommandType.StoredProcedure
        invComm.Parameters.AddWithValue("@ClCode", strClCode)
        iP = invComm.ExecuteReader
        iP.Read()
        dgPInv.DataSource = iP
        dgPInv.DataBind()
        iP.Close()
        invConn.Close()

The SP is pulling back the full dataset but code above misses first rec.
with thanks

3.Add missing records into datatable..

Mahesha,

I'd approach this via brute force. Load the two tables, search the child
table for the missing records and create them, then set the relation.

This is not a good idea to do client side if the two tables are large. In
that case, load a table into SQL with the dates, add the child records, then
extract what you need. These tables can be psuedo temp tables if needed.



"Mahesha" < XXXX@XXXXX.COM > wrote in message
news: XXXX@XXXXX.COM ...
> Hello,
>
> I want to add a data relation between two tables based on a date.
> I have a datearray table in a SQL server database
> which contains a Date column.
> I query sql server to get distinct dates from this table based on a
> daterange(say 5 years)  and populate a datatable.
> I then query a sybase data source which contains Date and datavalue
> fields to get the data for the same 5 years date range.
> Now I have two datatables in a data set one with Date data(master
> table) and another with date,datavalue data (detail table).
> I want to add datarelation between these two tables on the date
> field.This is going to fail because there are some date records in my
> master table which do not have child records in the detail table.
> I want to add these missing date records into my child datatable with
> null datavalues and then add the datarelation. I want to know which is
> the easiest way to accomplish this.?
>
> Thanks
> -Mahesha

4.text missing from sql record after return

I have a web form with a multiline textbox. The string value entered into
the textbox is inserted into a field in the sql server. If a return is
pressed in the web form textbox to start a new line, the text following the
return appears in the sql insert statement when printed before inserting,
but is missing from the sql stored text value. I
check the sql stored value by running a select statement after the insert.
If no return is pressed in the web form textbox then the entire value is
inserted into the sql cell. Any ideas? I am running MSDE 2000 and VB.NET.

Thanks for your help,
John

5.Reading an Excel file - missing first record....

Hi,

I am using the following code to read the data from an Excel spreadsheet. It 
runs basically OK but it skips the first row of the spreadsheet. Does anyone 
know how to either read the first line or (*hack warning*) insert a blank 
record in the first line of the worksheet....?

Dim cnExcel As New OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data 
Source = MyFile.xls;Extended Properties=Excel 8.0;")
cnExcel.Open()
lookup = cnExcel.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, Nothing)
Dim cmdExcel As New OleDbCommand("SELECT * FROM [" & 
lookup.Rows(0)("TABLE_NAME") & "]", cnExcel)
Dim dr As OleDbDataReader
dr = cmdExcel.ExecuteReader
If dr.Read Then
    response.write(dr(0))
end if
dr.Close()
cnExcel.Close()

Thanks in advance,

Stu

6. Missing Record in Crystal Report

7. Newbie Missing Something with Access DB Update Using VB .NET

8. MS Access provider missing