473,386 Members | 1,721 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,386 software developers and data experts.

Can this be done using a Data adapter??

Hi all,

I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.

i have 3 tables as below

create table table1{
id1 int identity(1,1)
Constraint pk_table1 Primary Key,
title varchar(20) not null,
}

create table table2{
id2 int identity(1,1)
Constraint pk_table1 Primary Key,
title varchar(20) not null,
}

create table table3{
id1 int not null
Constraint fk_table3_1 Foreign Key References table1(id1),
id2 int not null
Constraint fk_table3_2 Foreign Key References table2(id2),
value int default 0,
Constraint pk_table3 Primary Key (id1,id2),
}

In my application i have a Datagrid view, which has all the records of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.

I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.

I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.

The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But that will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(

Can anyone giv me any leads.....

Thank you,
Insira.


Oct 11 '08 #1
6 2918
On 11 Oct, 03:11, insiraw...@gmail.com wrote:
Hi all,

I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.

i have 3 tables as below

create table table1{
* * * * * * id1 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,

}

create table table2{
* * * * * * id2 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,

}

create table table3{
* * * * * * id1 int not null
* * * * * * Constraint fk_table3_1 Foreign Key References table1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key References table2(id2),
* * * * * * value int default 0,
* * * * * * Constraint pk_table3 Primary Key (id1,id2),

}

In my application i have a Datagrid view, which has all the records of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.

I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.

I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.

The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But that will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(

Can anyone giv me any leads.....

Thank you,
Insira.
I suggest you need to let SQL process the data. Use the SQL Select
statement to pivot the data then select it as you need into a
datatable. The datatable passes only the modified/new/deleted rows to
the respective commands. Those respective SQL statements takes care of
only processing the changed data.

I hope that helps! If not please post more exact details about the
data you are working with.
Oct 11 '08 #2
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmail.com wrote:
Hi all,
I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.
i have 3 tables as below
create table table1{
* * * * * * id1 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table2{
* * * * * * id2 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table3{
* * * * * * id1 int not null
* * * * * * Constraint fk_table3_1 Foreign Key References table1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key References table2(id2),
* * * * * * value int default 0,
* * * * * * Constraint pk_table3 Primary Key (id1,id2),
}
In my application i have a Datagrid view, which has all the records of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.
I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.
I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.
The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But that will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(
Can anyone giv me any leads.....
Thank you,
Insira.

I suggest you need to let SQL process the data. Use the SQL Select
statement to pivot the data then select it as you need into a
datatable. The datatable passes only the modified/new/deleted rows to
the respective commands. Those respective SQL statements takes care of
only processing the changed data.

I hope that helps! If not please post more exact details about the
data you are working with.
Thanks for ur reply,
but i'm confused on how to use sql to pivot the data. can you give me
an example on how to do it. (my SQL knowledge is not that good)
Oct 12 '08 #3
On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gmail.comwrote:
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:


On 11 Oct, 03:11, insiraw...@gmail.com wrote:
Hi all,
I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.
i have 3 tables as below
create table table1{
* * * * * * id1 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table2{
* * * * * * id2 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table3{
* * * * * * id1 int not null
* * * * * * Constraint fk_table3_1 Foreign Key Referencestable1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key Referencestable2(id2),
* * * * * * value int default 0,
* * * * * * Constraint pk_table3 Primary Key (id1,id2),
}
In my application i have a Datagrid view, which has all the records of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.
I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.
I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.
The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But that will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(
Can anyone giv me any leads.....
Thank you,
Insira.
I suggest you need to let SQL process the data. Use the SQL Select
statement to pivot the data then select it as you need into a
datatable. The datatable passes only the modified/new/deleted rows to
the respective commands. Those respective SQL statements takes care of
only processing the changed data.
I hope that helps! If not please post more exact details about the
data you are working with.

Thanks for ur reply,
but i'm confused on how to use sql to pivot the data. can you give me
an example on how to do it. (my SQL knowledge is not that good)- Hide quoted text -

- Show quoted text -
Do you have more info about the solution and data you are working
with?

The SQL statements, will just process the changed data, where ever or
however that might be stored in the database.
Oct 12 '08 #4
On Oct 12, 11:48*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gmail.comwrote:


On Oct 11, 1:04*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmail.com wrote:
Hi all,
I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.
i have 3 tables as below
create table table1{
* * * * * * id1 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table2{
* * * * * * id2 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table3{
* * * * * * id1 int not null
* * * * * * Constraint fk_table3_1 Foreign Key References table1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key References table2(id2),
* * * * * * value int default 0,
* * * * * * Constraint pk_table3 Primary Key (id1,id2),
}
In my application i have a Datagrid view, which has all the recordsof
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.
I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.
I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.
The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But that will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(
Can anyone giv me any leads.....
Thank you,
Insira.
I suggest you need to let SQL process the data. Use the SQL Select
statement to pivot the data then select it as you need into a
datatable. The datatable passes only the modified/new/deleted rows to
the respective commands. Those respective SQL statements takes care of
only processing the changed data.
I hope that helps! If not please post more exact details about the
data you are working with.
Thanks for ur reply,
but i'm confused on how to use sql to pivot the data. can you give me
an example on how to do it. (my SQL knowledge is not that good)- Hide quoted text -
- Show quoted text -

Do you have more info about the solution and data you are working
with?

The SQL statements, will just process the changed data, where ever or
however that might be stored in the database.- Hide quoted text -

- Show quoted text -
the data im workin with also belongs to the same schema.
what i need to give is an excel like interface to the user with ID
values of table2 as columns and ID values of table1 as rows (i can
have the 1st column read only and put the table1 values there). what i
have done up to now is i bring the data of table1 and table2 from the
server and loop through the each table and add rows and columns to the
data grid view
as below

foreach (DataRow currow in table1.Rows)
{

datagridview1.Columns.Add(currow["ID"].ToString(),currow["ID"].ToString());
}
foreach (DataRow currow in table2.Rows)
{
datagridview1.Rows.Add(currow["ID"].ToString());
}

the trouble I’m having is how can i put the data in table3 into my
datagridview. i can't just give the data source of the grid view as
table3. then i lose all the row and column data.

is there a method i can assign the values of table3 into the
datagridview. the method i can think of is loop through the rows in
table3 and put the values into the datagridview but that makes my
application slow. (imagin when there are about 100 records in table1
and table2.....)

as you said above is there a way where i can create a view in
SQLserver itself for the above scenario and then feach the data of
that view. then it will be very easy...

Oct 13 '08 #5
On 13 Oct, 15:09, "I~N~S~I" <insiraw...@gmail.comwrote:
On Oct 12, 11:48*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:


On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gmail.comwrote:
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmail.com wrote:
Hi all,
I have this problem, i need to know is there a way i cn use the data
adapter's update method in this scenario.
i have 3 tables as below
create table table1{
* * * * * * id1 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table2{
* * * * * * id2 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table3{
* * * * * * id1 int not null
* * * * * * Constraint fk_table3_1 Foreign Key References table1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key References table2(id2),
* * * * * * value int default 0,
* * * * * * Constraint pk_table3 Primary Key (id1,id2),
}
In my application i have a Datagrid view, which has all the records of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the valuesi
enter in Datagrid view.
I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.
I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.
The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But thatwill
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(
Can anyone giv me any leads.....
Thank you,
Insira.
I suggest you need to let SQL process the data. Use the SQL Select
statement to pivot the data then select it as you need into a
datatable. The datatable passes only the modified/new/deleted rows to
the respective commands. Those respective SQL statements takes careof
only processing the changed data.
I hope that helps! If not please post more exact details about the
data you are working with.
Thanks for ur reply,
but i'm confused on how to use sql to pivot the data. can you give me
an example on how to do it. (my SQL knowledge is not that good)- Hidequoted text -
- Show quoted text -
Do you have more info about the solution and data you are working
with?
The SQL statements, will just process the changed data, where ever or
however that might be stored in the database.- Hide quoted text -
- Show quoted text -

the data im workin with also belongs to the same schema.
what i need to give is an excel like interface to the user with ID
values of table2 as columns and ID values of table1 as rows (i can
have the 1st column read only and put the table1 values there). what i
have done up to now is i bring the data of table1 and table2 from the
server and loop through the each table and add rows and columns to the
data grid view
as below

foreach (DataRow currow in table1.Rows)
{

datagridview1.Columns.Add(currow["ID"].ToString(),currow["ID"].ToString());

}

foreach (DataRow currow in table2.Rows)
{
* * * datagridview1.Rows.Add(currow["ID"].ToString());

}

the trouble I’m having is how can i put the data in table3 into my
datagridview. i can't just give the data source of the grid view as
table3. then i lose all the row and column data.

is there a method i can assign the values of table3 into the
datagridview. the method i can think of is loop through the rows in
table3 and put the values into the datagridview but that makes my
application slow. (imagin when there are about 100 records in table1
and table2.....)

as you said above is there a way where i can create a view in
SQLserver itself for the above scenario and then feach the data of
that view. then it will be very easy...- Hide quoted text -

- Show quoted text -
OK It may not be quite as easy as is sounds. Depending on how good
your SQL is there is a bit of understanding involved. It would be
easier to under them before trying to implement this. Of the top of my
head, you'll need to look at how to create Dynamic SQL, SQL triggers,
SQL temporary tables and SQL Cursor. I assume you are ok with Stored
Procedures and using Insert, update and delete statements in SQL
Stored Procedures.

In a nutshell alter the insert, update and delete stored procedures,
if rows are added to table1 or table2. You can use a SQL Trigger to do
this.

Create a stored procedure which uses a SQL Cursor to build up a SQL
Temporary table based on the values in table1 and table2. Insert from
table3 into the temporary table. This stored procedure will be the
SelectCommand of your adapter.

The only performance hit you should really see is when using the SQL
Cursor to fetch the data, after that it will be out of the way. The
insert, update and delete shouldn't be too heavy then.

The point is you are processing the data server side instead of client
side which should improve your performance.
Oct 13 '08 #6
On 13 Oct, 20:26, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 13 Oct, 15:09, "I~N~S~I" <insiraw...@gmail.comwrote:


On Oct 12, 11:48*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gmail.comwrote:
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazzthecat.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmail.com wrote:
Hi all,
I have this problem, i need to know is there a way i cn use thedata
adapter's update method in this scenario.
i have 3 tables as below
create table table1{
* * * * * * id1 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table2{
* * * * * * id2 int identity(1,1)
* * * * * * Constraint pk_table1 Primary Key,
* * * * * * title varchar(20) not null,
}
create table table3{
* * * * * * id1 int not null
* * * * * * Constraint fk_table3_1 Foreign Key References table1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key References table2(id2),
* * * * * * value int default 0,
* * * * * * Constraint pk_table3 Primary Key (id1,id2),
}
In my application i have a Datagrid view, which has all the records of
table1 as the columns of the datagrid view and records of table2 as
the rows of the data grid. and i have table 3 to store the values i
enter in Datagrid view.
I was wondering can i use the data adapter to fetch data of table3
using Fill method and use da update method of data adapter to add
values to table3.
I have no leads on how to start, thats why my 1st have the concern
whether i can do it using the Data adapter.
The only method i cn think of is loop through each cell im my datagrid
view and manually run the insert or update SQL commands. But that will
make my application very slow. specially when there is abt 40 records
in table1 and 100 records in table2... :-(
Can anyone giv me any leads.....
Thank you,
Insira.
I suggest you need to let SQL process the data. Use the SQL Select
statement to pivot the data then select it as you need into a
datatable. The datatable passes only the modified/new/deleted rows to
the respective commands. Those respective SQL statements takes care of
only processing the changed data.
I hope that helps! If not please post more exact details about the
data you are working with.
Thanks for ur reply,
but i'm confused on how to use sql to pivot the data. can you give me
an example on how to do it. (my SQL knowledge is not that good)- Hide quoted text -
- Show quoted text -
Do you have more info about the solution and data you are working
with?
The SQL statements, will just process the changed data, where ever or
however that might be stored in the database.- Hide quoted text -
- Show quoted text -
the data im workin with also belongs to the same schema.
what i need to give is an excel like interface to the user with ID
values of table2 as columns and ID values of table1 as rows (i can
have the 1st column read only and put the table1 values there). what i
have done up to now is i bring the data of table1 and table2 from the
server and loop through the each table and add rows and columns to the
data grid view
as below
foreach (DataRow currow in table1.Rows)
{
datagridview1.Columns.Add(currow["ID"].ToString(),currow["ID"].ToString());
}
foreach (DataRow currow in table2.Rows)
{
* * * datagridview1.Rows.Add(currow["ID"].ToString());
}
the trouble I’m having is how can i put the data in table3 into my
datagridview. i can't just give the data source of the grid view as
table3. then i lose all the row and column data.
is there a method i can assign the values of table3 into the
datagridview. the method i can think of is loop through the rows in
table3 and put the values into the datagridview but that makes my
application slow. (imagin when there are about 100 records in table1
and table2.....)
as you said above is there a way where i can create a view in
SQLserver itself for the above scenario and then feach the data of
that view. then it will be very easy...- Hide quoted text -
- Show quoted text -

OK It may not be quite as easy as is sounds. Depending on how good
your SQL is there is a bit of understanding involved. It would be
easier to under them before trying to implement this. Of the top of my
head, you'll need to look at how to create Dynamic SQL, SQL triggers,
SQL temporary tables and SQL Cursor. I assume you are ok with Stored
Procedures and using Insert, update and delete statements in SQL
Stored Procedures.

In a nutshell alter the insert, update and delete stored procedures,
if rows are added to table1 or table2. You can use a SQL Trigger to do
this.

Create a stored procedure which uses a SQL Cursor to build up a SQL
Temporary table based on the values in table1 and table2. Insert from
table3 into the temporary table. This stored procedure will be the
SelectCommand of your adapter.

The only performance hit you should really see is when using the SQL
Cursor to fetch the data, after that it will be out of the way. The
insert, update and delete shouldn't be too heavy then.

The point is you are processing the data server side instead of client
side which should improve your performance.- Hide quoted text -

- Show quoted text -
Sorry I posted early.... here's another solution..

I'm not sure what kind of performance improvement you'll see on this
one, but if your SQL is not so good, then it's definately easier to
implement.

Create the grid dynamically from table1 (columns) set the column title
as necessary from the title value, and set the id1 as the column name.
You'll also need a hidden column to store the row id - used to pass
id2.

Select table 3 directly into a datatable, but do not use it as the
datasource.

Use the Grid's RowUpdated event to get the updated row of the grid,
loop through each column of that row get the cell value (value column
in table3), and use the column name for the cell (id1 column in
table3) and the value in the hidden column (id2 column in table3).
Call the update method of the datatable. This will be better than
doing every cell in the grid. Call the DataAdapter Update to update
the source.
INSERT INTO table1 (title) VALUES ('Column1')
INSERT INTO table1 (title) VALUES ('Column2')
INSERT INTO table1 (title) VALUES ('Column3')
INSERT INTO table1 (title) VALUES ('Column4')
INSERT INTO table1 (title) VALUES ('Column5')
INSERT INTO table2 (title) VALUES ('Row1')
INSERT INTO table2 (title) VALUES ('Row2')
INSERT INTO table2 (title) VALUES ('Row3')

CREATE PROC GetColumns
AS
BEGIN
SELECT id1, title
FROM table1
END
GO
CREATE PROC GetRows
AS
BEGIN
SELECT id2, title
FROM table2
END
GO
CREATE PROC GetData
AS
BEGIN
SELECT id1, id2, value FROM table3
END
GO
CREATE PROC InsertValue
@Id1 int, @Id2 int, @Value int
AS
BEGIN
INSERT INTO table3 (id1, id2, value)
VALUES (@Id1, @Id2, @Value)
END
GO
CREATE PROC UpdateValue
@Id1 int, @Id2 int, @Value int
AS
BEGIN
UPDATE table3
SET value = @Value
WHERE Id1 = @Id1 and Id2 = @Id2
END
GO
Oct 13 '08 #7

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

Similar topics

0
by: Steve Barker | last post by:
I am trying to access Paradox through a .NET Windows application I am writing. I have added a Data Connection to the Paradox table in the Server Explorer of Visual Studio .NET. I have used the...
10
by: Hank1234 | last post by:
Can I use one Data Adapter and one Command Builder to update amny tables? Currently in my data adapter I query two tables and fill them into two tables in a data set. When I make a change to a...
1
by: JH | last post by:
I have a comma delimited file and I want to export it to an MS access table already designed with appropriate field names. How do I do this programmatically using VB.NET or C#? Thanks for any...
0
by: Vince Campanile | last post by:
Ive got what must bea very basic question, but its got ne thouroughly stumped. Im writing a very simple application in Visual Basic.Ne 2003, thats using a data adapter hooked up to an Access...
9
by: Brad | last post by:
I have written some code to manipulate data/records in a MASTER (order header) and DETAIL (order details) tables. What I have written is too extensive to post but essentially trying to: 1....
2
by: simon | last post by:
I use my functions to create adapter and fill dataSet: funkcije.createAdapter("c_CPOSkupaj", False, myParams).Fill(ds, "brezReklam") If I use this function another time to fill dataSet with...
0
by: Mateusz [PEYN] Adamus | last post by:
Hi I have a Typed DataSet. I've databinded it to some text controls on my form, controls show data when I show record. But now I would like to create a new record with this form, controls...
53
by: Hexman | last post by:
Hello All, I'd like your comments on the code below. The sub does exactly what I want it to do but I don't feel that it is solid as all. It seems like I'm using some VB6 code, .Net2003 code,...
12
by: Simon | last post by:
Hi all, I'm having a baffling problem with a windows service that I'm working on. Basically, I am using a typed dataset to insert a large number of rows into an SQL Server 2005 database. But...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
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
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
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: 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
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
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...

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.