Click here to Skip to main content
15,886,795 members
Home / Discussions / C#
   

C#

 
GeneralC# forms[design] Pin
davidj0x116-Apr-03 11:37
davidj0x116-Apr-03 11:37 
GeneralRe: C# forms[design] Pin
Andres Manggini16-Apr-03 13:25
Andres Manggini16-Apr-03 13:25 
GeneralRe: C# forms[design] Pin
davidj0x117-Apr-03 5:36
davidj0x117-Apr-03 5:36 
GeneralListview item click events Pin
vlusardi16-Apr-03 10:46
vlusardi16-Apr-03 10:46 
GeneralRe: Listview item click events Pin
James T. Johnson16-Apr-03 14:12
James T. Johnson16-Apr-03 14:12 
GeneralRe: Listview item click events Pin
chito16-Apr-03 16:24
chito16-Apr-03 16:24 
GeneralRe: Listview item click events Pin
vlusardi17-Apr-03 11:00
vlusardi17-Apr-03 11:00 
QuestionSqlDataAdapter .Fill() using DataTable instead of DataSet? Pin
zoltan_ie16-Apr-03 7:15
zoltan_ie16-Apr-03 7:15 

string m_sSelect = "SELECT Firstname, Secondname, [House Name], [House No], Street, Area, Postcode FROM VOTERSREGISTER WHERE [Postcode] = 'DUBLIN 6W'";

int m_nCurrentRow = 0;
...
...
...

public bool Read(ref DataSet ds)
{
SqlDataAdapter m_sda = new SqlDataAdapter(m_sSelect, m_sqlcConn);

ds.Clear();
try
{
m_sda.Fill(ds, m_nCurrentRow, 100, "VotingRegister");
}
catch(ERROR BLA DI BLA....)
{
return false;
}

if(0 == ds.Tables["VotingRegister"].Rows.Count)
return false;

m_nCurrentRow += 100;

return true;
}


This is the my code.

Now my problem is that I am using a DataSet to hold the return data and I place that data in a Table called VotingRegister. I feel thats a bit of a waste. Is there anyway that just insert the data into a DataTable? Also see the way I pull in 100 rows at a time. Is it possible to do the same with .Fill() if you use a DataTable? As I'm expect over 5000 records to be returned if I didn't do it in steps.

help please!
AnswerRe: SqlDataAdapter .Fill() using DataTable instead of DataSet? Pin
James T. Johnson16-Apr-03 7:30
James T. Johnson16-Apr-03 7:30 
GeneralRe: SqlDataAdapter .Fill() using DataTable instead of DataSet? Pin
zoltan_ie16-Apr-03 22:45
zoltan_ie16-Apr-03 22:45 
GeneralGet proc only for current user Pin
Alex Korchemniy16-Apr-03 5:50
Alex Korchemniy16-Apr-03 5:50 
GeneralRe: Get proc only for current user Pin
Mazdak16-Apr-03 8:30
Mazdak16-Apr-03 8:30 
GeneralOwnerdrawn StatusBarPanel Pin
monrobot1316-Apr-03 5:48
monrobot1316-Apr-03 5:48 
GeneralRe: Ownerdrawn StatusBarPanel Pin
Alex Korchemniy16-Apr-03 5:55
Alex Korchemniy16-Apr-03 5:55 
GeneralArgument-substitution vs Concatenation Pin
Alvaro Mendez16-Apr-03 4:37
Alvaro Mendez16-Apr-03 4:37 
GeneralRe: Argument-substitution vs Concatenation Pin
Alex Korchemniy16-Apr-03 5:54
Alex Korchemniy16-Apr-03 5:54 
GeneralRe: Argument-substitution vs Concatenation Pin
James T. Johnson16-Apr-03 7:00
James T. Johnson16-Apr-03 7:00 
GeneralRe: Argument-substitution vs Concatenation Pin
Paul Ingles16-Apr-03 7:56
Paul Ingles16-Apr-03 7:56 
GeneralRe: Argument-substitution vs Concatenation Pin
Adam Turner16-Apr-03 12:42
Adam Turner16-Apr-03 12:42 
GeneralRe: Argument-substitution vs Concatenation Pin
leppie16-Apr-03 12:54
leppie16-Apr-03 12:54 
GeneralDateTime Operation Pin
Mazdak16-Apr-03 3:52
Mazdak16-Apr-03 3:52 
GeneralRe: DateTime Operation Pin
Jim Stewart16-Apr-03 4:21
Jim Stewart16-Apr-03 4:21 
GeneralRe: DateTime Operation Pin
Mazdak16-Apr-03 4:42
Mazdak16-Apr-03 4:42 
GeneralLoad File Pin
Mazdak16-Apr-03 2:48
Mazdak16-Apr-03 2:48 
GeneralRe: Load File Pin
Chris Austin16-Apr-03 5:19
Chris Austin16-Apr-03 5:19 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.