473,396 Members | 2,050 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,396 software developers and data experts.

Help needed with a datatable

I am trying to add some code to below to include a datatable and fill the
datatable. The reason for doing this is so as I can check to see whether
there are any rows returned by the stored procedure. If there are no records
returned then this would give me an indicator and I can re-direct the page
somewhere more appropriate. Well this is the theory. I have never used
datatables before and am not sure how to implemenet what I want so I was
wondering if someone could help me please. I basically just need a datatable
and then fill the datatable with my record set. Thanks for any help anyone
can give me.

private static SqlDataReader dr;

private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
{
//Create a Connection
SqlConnection conSQL = new
SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);

//Create Parameter
SqlParameter @IPCURN = new SqlParameter
("@IPCURN", System.Data.SqlDbType.BigInt);
@IPCURN.Direction = ParameterDirection.Input;
@IPCURN.Value = IPC;

//Create Parameter
SqlParameter @SUSPECTURN = new SqlParameter
("@SUSPECTURN", System.Data.SqlDbType.BigInt);
@SUSPECTURN.Direction = ParameterDirection.Input;
@SUSPECTURN.Value = SUSPECT;

//Create a Command
SqlDataAdapter da = new SqlDataAdapter();
//DataTable dt = new DataTable();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conSQL;
da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(@IPCURN);
da.SelectCommand.Parameters.Add(@SUSPECTURN);

conSQL.Open();

//Create a datareader
dr = da.SelectCommand.ExecuteReader();
}
Jul 21 '05 #1
8 1572
guy
hi Stephen
dont use a datareader,

just use:-
da.Fill(dt)

providing the parameters, connection, CommandText etc are ok thats all you
need

hth
guy

"Stephen" wrote:
I am trying to add some code to below to include a datatable and fill the
datatable. The reason for doing this is so as I can check to see whether
there are any rows returned by the stored procedure. If there are no records
returned then this would give me an indicator and I can re-direct the page
somewhere more appropriate. Well this is the theory. I have never used
datatables before and am not sure how to implemenet what I want so I was
wondering if someone could help me please. I basically just need a datatable
and then fill the datatable with my record set. Thanks for any help anyone
can give me.

private static SqlDataReader dr;

private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
{
//Create a Connection
SqlConnection conSQL = new
SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);

//Create Parameter
SqlParameter @IPCURN = new SqlParameter
("@IPCURN", System.Data.SqlDbType.BigInt);
@IPCURN.Direction = ParameterDirection.Input;
@IPCURN.Value = IPC;

//Create Parameter
SqlParameter @SUSPECTURN = new SqlParameter
("@SUSPECTURN", System.Data.SqlDbType.BigInt);
@SUSPECTURN.Direction = ParameterDirection.Input;
@SUSPECTURN.Value = SUSPECT;

//Create a Command
SqlDataAdapter da = new SqlDataAdapter();
//DataTable dt = new DataTable();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conSQL;
da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(@IPCURN);
da.SelectCommand.Parameters.Add(@SUSPECTURN);

conSQL.Open();

//Create a datareader
dr = da.SelectCommand.ExecuteReader();
}

Jul 21 '05 #2
I need to use a datareader in order to read the populate the fields in my
report. Using active reports you see and I need to be able to have some way
for telling when no records are returned. At the moment if there are no
records a blank report comes back but I need to be able to count the rows in
a data table and then re-direct the page if no rows are present.

"guy" wrote:
hi Stephen
dont use a datareader,

just use:-
da.Fill(dt)

providing the parameters, connection, CommandText etc are ok thats all you
need

hth
guy

"Stephen" wrote:
I am trying to add some code to below to include a datatable and fill the
datatable. The reason for doing this is so as I can check to see whether
there are any rows returned by the stored procedure. If there are no records
returned then this would give me an indicator and I can re-direct the page
somewhere more appropriate. Well this is the theory. I have never used
datatables before and am not sure how to implemenet what I want so I was
wondering if someone could help me please. I basically just need a datatable
and then fill the datatable with my record set. Thanks for any help anyone
can give me.

private static SqlDataReader dr;

private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
{
//Create a Connection
SqlConnection conSQL = new
SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);

//Create Parameter
SqlParameter @IPCURN = new SqlParameter
("@IPCURN", System.Data.SqlDbType.BigInt);
@IPCURN.Direction = ParameterDirection.Input;
@IPCURN.Value = IPC;

//Create Parameter
SqlParameter @SUSPECTURN = new SqlParameter
("@SUSPECTURN", System.Data.SqlDbType.BigInt);
@SUSPECTURN.Direction = ParameterDirection.Input;
@SUSPECTURN.Value = SUSPECT;

//Create a Command
SqlDataAdapter da = new SqlDataAdapter();
//DataTable dt = new DataTable();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conSQL;
da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(@IPCURN);
da.SelectCommand.Parameters.Add(@SUSPECTURN);

conSQL.Open();

//Create a datareader
dr = da.SelectCommand.ExecuteReader();
}

Jul 21 '05 #3
Stephen,

A datatable has a count
dt.rows.count

What do you want easier?

Cor

"Stephen" <St*****@discussions.microsoft.com>
I need to use a datareader in order to read the populate the fields in my
report. Using active reports you see and I need to be able to have some
way
for telling when no records are returned. At the moment if there are no
records a blank report comes back but I need to be able to count the rows
in
a data table and then re-direct the page if no rows are present.

"guy" wrote:
hi Stephen
dont use a datareader,

just use:-
da.Fill(dt)

providing the parameters, connection, CommandText etc are ok thats all
you
need

hth
guy

"Stephen" wrote:
> I am trying to add some code to below to include a datatable and fill
> the
> datatable. The reason for doing this is so as I can check to see
> whether
> there are any rows returned by the stored procedure. If there are no
> records
> returned then this would give me an indicator and I can re-direct the
> page
> somewhere more appropriate. Well this is the theory. I have never used
> datatables before and am not sure how to implemenet what I want so I
> was
> wondering if someone could help me please. I basically just need a
> datatable
> and then fill the datatable with my record set. Thanks for any help
> anyone
> can give me.
>
> private static SqlDataReader dr;
>
> private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
> {
> //Create a Connection
> SqlConnection conSQL = new
> SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);
>
> //Create Parameter
> SqlParameter @IPCURN = new SqlParameter
> ("@IPCURN", System.Data.SqlDbType.BigInt);
> @IPCURN.Direction = ParameterDirection.Input;
> @IPCURN.Value = IPC;
>
> //Create Parameter
> SqlParameter @SUSPECTURN = new SqlParameter
> ("@SUSPECTURN", System.Data.SqlDbType.BigInt);
> @SUSPECTURN.Direction = ParameterDirection.Input;
> @SUSPECTURN.Value = SUSPECT;
>
> //Create a Command
> SqlDataAdapter da = new SqlDataAdapter();
> //DataTable dt = new DataTable();
> da.SelectCommand = new SqlCommand();
> da.SelectCommand.Connection = conSQL;
> da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
> da.SelectCommand.CommandType = CommandType.StoredProcedure;
> da.SelectCommand.Parameters.Add(@IPCURN);
> da.SelectCommand.Parameters.Add(@SUSPECTURN);
>
> conSQL.Open();
>
> //Create a datareader
> dr = da.SelectCommand.ExecuteReader();
> }

Jul 21 '05 #4
I don;t want anything easier just need to be able to write some code which
counts the rows and if they are no rows then I need the code to re-direct the
page. Do you know the exact code which would help me do this. Sorry im very
knew to coding and am still learning so some things which may seem easy I
find quite hard, but im getting better.

"Cor Ligthert" wrote:
Stephen,

A datatable has a count
dt.rows.count

What do you want easier?

Cor

"Stephen" <St*****@discussions.microsoft.com>
I need to use a datareader in order to read the populate the fields in my
report. Using active reports you see and I need to be able to have some
way
for telling when no records are returned. At the moment if there are no
records a blank report comes back but I need to be able to count the rows
in
a data table and then re-direct the page if no rows are present.

"guy" wrote:
hi Stephen
dont use a datareader,

just use:-
da.Fill(dt)

providing the parameters, connection, CommandText etc are ok thats all
you
need

hth
guy

"Stephen" wrote:

> I am trying to add some code to below to include a datatable and fill
> the
> datatable. The reason for doing this is so as I can check to see
> whether
> there are any rows returned by the stored procedure. If there are no
> records
> returned then this would give me an indicator and I can re-direct the
> page
> somewhere more appropriate. Well this is the theory. I have never used
> datatables before and am not sure how to implemenet what I want so I
> was
> wondering if someone could help me please. I basically just need a
> datatable
> and then fill the datatable with my record set. Thanks for any help
> anyone
> can give me.
>
> private static SqlDataReader dr;
>
> private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
> {
> //Create a Connection
> SqlConnection conSQL = new
> SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);
>
> //Create Parameter
> SqlParameter @IPCURN = new SqlParameter
> ("@IPCURN", System.Data.SqlDbType.BigInt);
> @IPCURN.Direction = ParameterDirection.Input;
> @IPCURN.Value = IPC;
>
> //Create Parameter
> SqlParameter @SUSPECTURN = new SqlParameter
> ("@SUSPECTURN", System.Data.SqlDbType.BigInt);
> @SUSPECTURN.Direction = ParameterDirection.Input;
> @SUSPECTURN.Value = SUSPECT;
>
> //Create a Command
> SqlDataAdapter da = new SqlDataAdapter();
> //DataTable dt = new DataTable();
> da.SelectCommand = new SqlCommand();
> da.SelectCommand.Connection = conSQL;
> da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
> da.SelectCommand.CommandType = CommandType.StoredProcedure;
> da.SelectCommand.Parameters.Add(@IPCURN);
> da.SelectCommand.Parameters.Add(@SUSPECTURN);
>
> conSQL.Open();
>
> //Create a datareader
> dr = da.SelectCommand.ExecuteReader();
> }


Jul 21 '05 #5
guy
Stephen,
If dt.Rows.Count > 0 then
'DoStuff
Else
'DontDoStuff
End If

hth guy

"Stephen" wrote:
I don;t want anything easier just need to be able to write some code which
counts the rows and if they are no rows then I need the code to re-direct the
page. Do you know the exact code which would help me do this. Sorry im very
knew to coding and am still learning so some things which may seem easy I
find quite hard, but im getting better.

"Cor Ligthert" wrote:
Stephen,

A datatable has a count
dt.rows.count

What do you want easier?

Cor

"Stephen" <St*****@discussions.microsoft.com>
I need to use a datareader in order to read the populate the fields in my
report. Using active reports you see and I need to be able to have some
way
for telling when no records are returned. At the moment if there are no
records a blank report comes back but I need to be able to count the rows
in
a data table and then re-direct the page if no rows are present.

"guy" wrote:

> hi Stephen
> dont use a datareader,
>
> just use:-
> da.Fill(dt)
>
> providing the parameters, connection, CommandText etc are ok thats all
> you
> need
>
> hth
> guy
>
> "Stephen" wrote:
>
> > I am trying to add some code to below to include a datatable and fill
> > the
> > datatable. The reason for doing this is so as I can check to see
> > whether
> > there are any rows returned by the stored procedure. If there are no
> > records
> > returned then this would give me an indicator and I can re-direct the
> > page
> > somewhere more appropriate. Well this is the theory. I have never used
> > datatables before and am not sure how to implemenet what I want so I
> > was
> > wondering if someone could help me please. I basically just need a
> > datatable
> > and then fill the datatable with my record set. Thanks for any help
> > anyone
> > can give me.
> >
> > private static SqlDataReader dr;
> >
> > private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
> > {
> > //Create a Connection
> > SqlConnection conSQL = new
> > SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);
> >
> > //Create Parameter
> > SqlParameter @IPCURN = new SqlParameter
> > ("@IPCURN", System.Data.SqlDbType.BigInt);
> > @IPCURN.Direction = ParameterDirection.Input;
> > @IPCURN.Value = IPC;
> >
> > //Create Parameter
> > SqlParameter @SUSPECTURN = new SqlParameter
> > ("@SUSPECTURN", System.Data.SqlDbType.BigInt);
> > @SUSPECTURN.Direction = ParameterDirection.Input;
> > @SUSPECTURN.Value = SUSPECT;
> >
> > //Create a Command
> > SqlDataAdapter da = new SqlDataAdapter();
> > //DataTable dt = new DataTable();
> > da.SelectCommand = new SqlCommand();
> > da.SelectCommand.Connection = conSQL;
> > da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
> > da.SelectCommand.CommandType = CommandType.StoredProcedure;
> > da.SelectCommand.Parameters.Add(@IPCURN);
> > da.SelectCommand.Parameters.Add(@SUSPECTURN);
> >
> > conSQL.Open();
> >
> > //Create a datareader
> > dr = da.SelectCommand.ExecuteReader();
> > }


Jul 21 '05 #6
Stephen,

I see now it is almost the complete because you had already everything in it
for the datatable. therefore I only needed to changed the first and the
last lines.

\\\\

///private static SqlDataReader dr;
private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
{
//Create a Connection
SqlConnection conSQL = new
SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);

//Create Parameter
SqlParameter @IPCURN = new SqlParameter
("@IPCURN", System.Data.SqlDbType.BigInt);
@IPCURN.Direction = ParameterDirection.Input;
@IPCURN.Value = IPC;

//Create Parameter
SqlParameter @SUSPECTURN = new SqlParameter
("@SUSPECTURN", System.Data.SqlDbType.BigInt);
@SUSPECTURN.Direction = ParameterDirection.Input;
@SUSPECTURN.Value = SUSPECT;

//Create a Command
SqlDataAdapter da = new SqlDataAdapter();
//DataTable dt = new DataTable();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conSQL;
da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.Add(@IPCURN);
da.SelectCommand.Parameters.Add(@SUSPECTURN);

//conSQL.Open(); is not needed

//Create a datareader
///da.SelectCommand.ExecuteReader(); not needed
da.Fill(dt)
If (dt.Rows.Count!=0) {Response.Redirect("Whatever");}
}

I hope this goes, do not watch typos or whatever..

Cor
Jul 21 '05 #7
guy
oops didnt spot it was C#
sorry lads!

"guy" wrote:
Stephen,
If dt.Rows.Count > 0 then
'DoStuff
Else
'DontDoStuff
End If

hth guy

"Stephen" wrote:
I don;t want anything easier just need to be able to write some code which
counts the rows and if they are no rows then I need the code to re-direct the
page. Do you know the exact code which would help me do this. Sorry im very
knew to coding and am still learning so some things which may seem easy I
find quite hard, but im getting better.

"Cor Ligthert" wrote:
Stephen,

A datatable has a count
dt.rows.count

What do you want easier?

Cor

"Stephen" <St*****@discussions.microsoft.com>

>I need to use a datareader in order to read the populate the fields in my
> report. Using active reports you see and I need to be able to have some
> way
> for telling when no records are returned. At the moment if there are no
> records a blank report comes back but I need to be able to count the rows
> in
> a data table and then re-direct the page if no rows are present.
>
> "guy" wrote:
>
>> hi Stephen
>> dont use a datareader,
>>
>> just use:-
>> da.Fill(dt)
>>
>> providing the parameters, connection, CommandText etc are ok thats all
>> you
>> need
>>
>> hth
>> guy
>>
>> "Stephen" wrote:
>>
>> > I am trying to add some code to below to include a datatable and fill
>> > the
>> > datatable. The reason for doing this is so as I can check to see
>> > whether
>> > there are any rows returned by the stored procedure. If there are no
>> > records
>> > returned then this would give me an indicator and I can re-direct the
>> > page
>> > somewhere more appropriate. Well this is the theory. I have never used
>> > datatables before and am not sure how to implemenet what I want so I
>> > was
>> > wondering if someone could help me please. I basically just need a
>> > datatable
>> > and then fill the datatable with my record set. Thanks for any help
>> > anyone
>> > can give me.
>> >
>> > private static SqlDataReader dr;
>> >
>> > private void PPS4_ReportStart(object sender, System.EventArgs eArgs)
>> > {
>> > //Create a Connection
>> > SqlConnection conSQL = new
>> > SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);
>> >
>> > //Create Parameter
>> > SqlParameter @IPCURN = new SqlParameter
>> > ("@IPCURN", System.Data.SqlDbType.BigInt);
>> > @IPCURN.Direction = ParameterDirection.Input;
>> > @IPCURN.Value = IPC;
>> >
>> > //Create Parameter
>> > SqlParameter @SUSPECTURN = new SqlParameter
>> > ("@SUSPECTURN", System.Data.SqlDbType.BigInt);
>> > @SUSPECTURN.Direction = ParameterDirection.Input;
>> > @SUSPECTURN.Value = SUSPECT;
>> >
>> > //Create a Command
>> > SqlDataAdapter da = new SqlDataAdapter();
>> > //DataTable dt = new DataTable();
>> > da.SelectCommand = new SqlCommand();
>> > da.SelectCommand.Connection = conSQL;
>> > da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4 ";
>> > da.SelectCommand.CommandType = CommandType.StoredProcedure;
>> > da.SelectCommand.Parameters.Add(@IPCURN);
>> > da.SelectCommand.Parameters.Add(@SUSPECTURN);
>> >
>> > conSQL.Open();
>> >
>> > //Create a datareader
>> > dr = da.SelectCommand.ExecuteReader();
>> > }

Jul 21 '05 #8
Guy,

Why sorry, this is a general group, not the Csharp newsgroup, that one is

microsoft.public.dotnet.languages.csharp

Here you can give samples in every Net program code.

Cor
oops didnt spot it was C#
sorry lads!

"guy" wrote:
Stephen,
If dt.Rows.Count > 0 then
'DoStuff
Else
'DontDoStuff
End If

hth guy

"Stephen" wrote:
> I don;t want anything easier just need to be able to write some code
> which
> counts the rows and if they are no rows then I need the code to
> re-direct the
> page. Do you know the exact code which would help me do this. Sorry im
> very
> knew to coding and am still learning so some things which may seem easy
> I
> find quite hard, but im getting better.
>
> "Cor Ligthert" wrote:
>
> > Stephen,
> >
> > A datatable has a count
> > dt.rows.count
> >
> > What do you want easier?
> >
> > Cor
> >
> > "Stephen" <St*****@discussions.microsoft.com>
> >
> > >I need to use a datareader in order to read the populate the fields
> > >in my
> > > report. Using active reports you see and I need to be able to have
> > > some
> > > way
> > > for telling when no records are returned. At the moment if there
> > > are no
> > > records a blank report comes back but I need to be able to count
> > > the rows
> > > in
> > > a data table and then re-direct the page if no rows are present.
> > >
> > > "guy" wrote:
> > >
> > >> hi Stephen
> > >> dont use a datareader,
> > >>
> > >> just use:-
> > >> da.Fill(dt)
> > >>
> > >> providing the parameters, connection, CommandText etc are ok thats
> > >> all
> > >> you
> > >> need
> > >>
> > >> hth
> > >> guy
> > >>
> > >> "Stephen" wrote:
> > >>
> > >> > I am trying to add some code to below to include a datatable and
> > >> > fill
> > >> > the
> > >> > datatable. The reason for doing this is so as I can check to see
> > >> > whether
> > >> > there are any rows returned by the stored procedure. If there
> > >> > are no
> > >> > records
> > >> > returned then this would give me an indicator and I can
> > >> > re-direct the
> > >> > page
> > >> > somewhere more appropriate. Well this is the theory. I have
> > >> > never used
> > >> > datatables before and am not sure how to implemenet what I want
> > >> > so I
> > >> > was
> > >> > wondering if someone could help me please. I basically just need
> > >> > a
> > >> > datatable
> > >> > and then fill the datatable with my record set. Thanks for any
> > >> > help
> > >> > anyone
> > >> > can give me.
> > >> >
> > >> > private static SqlDataReader dr;
> > >> >
> > >> > private void PPS4_ReportStart(object sender, System.EventArgs
> > >> > eArgs)
> > >> > {
> > >> > //Create a Connection
> > >> > SqlConnection conSQL = new
> > >> > SqlConnection(ConfigurationSettings.AppSettings["DBConnectionString"]);
> > >> >
> > >> > //Create Parameter
> > >> > SqlParameter @IPCURN = new SqlParameter
> > >> > ("@IPCURN", System.Data.SqlDbType.BigInt);
> > >> > @IPCURN.Direction = ParameterDirection.Input;
> > >> > @IPCURN.Value = IPC;
> > >> >
> > >> > //Create Parameter
> > >> > SqlParameter @SUSPECTURN = new SqlParameter
> > >> > ("@SUSPECTURN", System.Data.SqlDbType.BigInt);
> > >> > @SUSPECTURN.Direction = ParameterDirection.Input;
> > >> > @SUSPECTURN.Value = SUSPECT;
> > >> >
> > >> > //Create a Command
> > >> > SqlDataAdapter da = new SqlDataAdapter();
> > >> > //DataTable dt = new DataTable();
> > >> > da.SelectCommand = new SqlCommand();
> > >> > da.SelectCommand.Connection = conSQL;
> > >> > da.SelectCommand.CommandText = "rep_PersonChargedInCustody_PPS4
> > >> > ";
> > >> > da.SelectCommand.CommandType = CommandType.StoredProcedure;
> > >> > da.SelectCommand.Parameters.Add(@IPCURN);
> > >> > da.SelectCommand.Parameters.Add(@SUSPECTURN);
> > >> >
> > >> > conSQL.Open();
> > >> >
> > >> > //Create a datareader
> > >> > dr = da.SelectCommand.ExecuteReader();
> > >> > }
> >
> >
> >

Jul 21 '05 #9

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: MikeY | last post by:
Hi everyone, I have posted earlier this week, but I'm still scratching my head trying to figure out how to change/modify my data back to my db. Using C# Windows forms. I am trying to learn how...
10
by: Bharat | last post by:
Hi Folks, Suppose I have two link button on a page (say lnkBtn1 and lnkBtn2). On the click event of the lnkbtn1 I have to add a dynamically created control. And On the click event of the lnkBtn2 I...
6
by: Jean Christophe Avard | last post by:
Hi! I'm designing an application that produces invoices. I have a combobox that is populated with the Name of every client in the database. What I would like to do is to have the combobox to...
8
by: Stephen | last post by:
I am trying to add some code to below to include a datatable and fill the datatable. The reason for doing this is so as I can check to see whether there are any rows returned by the stored...
4
by: Jeff | last post by:
I am stuck on trying to generate two columns headers for a datagrid on form load. I can use a datatable as the datasource and get the results I want, but I want to set different column widths and...
2
by: kewl | last post by:
Hi All, We have an ASP.NET 2.0 (C#) intranet application that needs to spawn multiple browsers using RegisterClientScriptBlock. Here's what we got so far: // Go thru each datarow in the...
1
by: sapkal.manish | last post by:
Question : How can I find actual row position of DataTable in DataGridView when DataTable is sorted / My source code like this Private WithEvent dgvInwDet as new DataGridView Private...
1
by: Shum | last post by:
Hi all!!! I found this piece of code from one of the threads here, I too want to get the list of tables and data types of columns, but when i tried to use this code in my program it gives me error:...
6
by: Frank Rizzo | last post by:
I am trying to create a parametrized generic object, but the compiler won't let me. Is this just the way it is? The class has a constraint that says all classes must inherit from BusinessBase,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.