473,700 Members | 2,350 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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 2942
On 11 Oct, 03:11, insiraw...@gmai l.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...@jazztheca t.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmai l.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...@gma il.comwrote:
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazztheca t.co.ukwrote:


On 11 Oct, 03:11, insiraw...@gmai l.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 Referencestable 1(id1),
* * * * * * id2 int not null
* * * * * * Constraint fk_table3_2 Foreign Key Referencestable 2(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...@jazztheca t.co.ukwrote:
On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gma il.comwrote:


On Oct 11, 1:04*pm, "JTC^..^" <d...@jazztheca t.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmai l.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.C olumns.Add(curr ow["ID"].ToString(),cur row["ID"].ToString());
}
foreach (DataRow currow in table2.Rows)
{
datagridview1.R ows.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...@gma il.comwrote:
On Oct 12, 11:48*pm, "JTC^..^" <d...@jazztheca t.co.ukwrote:


On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gma il.comwrote:
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazztheca t.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmai l.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.C olumns.Add(curr ow["ID"].ToString(),cur row["ID"].ToString());

}

foreach (DataRow currow in table2.Rows)
{
* * * datagridview1.R ows.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...@jazztheca t.co.ukwrote:
On 13 Oct, 15:09, "I~N~S~I" <insiraw...@gma il.comwrote:


On Oct 12, 11:48*pm, "JTC^..^" <d...@jazztheca t.co.ukwrote:
On 12 Oct, 01:55, "I~N~S~I" <insiraw...@gma il.comwrote:
On Oct 11, 1:04*pm, "JTC^..^" <d...@jazztheca t.co.ukwrote:
On 11 Oct, 03:11, insiraw...@gmai l.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.C olumns.Add(curr ow["ID"].ToString(),cur row["ID"].ToString());
}
foreach (DataRow currow in table2.Rows)
{
* * * datagridview1.R ows.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
6647
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 "Microsoft OLD DB Provider for ODBC Drivers" option to make the connection. This works fine... even though the Paradox table is password protected. I have dragged a the table from the Server Explorer to my form to make a connection object and a data...
10
9354
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 record in the second table and call the update method of the data adapter the command builders update command text is for the first table. Can the command builder handle two tables? Code example: Dim oCOnn As New SqlConnection("Data Source=.;" &...
1
4473
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 help in advance.
0
1236
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 database. The data adapter configuration wizard generates both insert, and select statements, but on the final page of the wizard it says that update, and delete statements could not be generated. The reason that Im given for this happeneing is "could...
9
2062
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. Assign to a datarow (dr1) the first record of the MASTER table 2. Assign to another datarow (dr2) the second record of the MASTER table 3. If dr1.field1 = dr2.field1, then proceed, otherwise do stop 4. Assign to a third datarow (dr3) the first record...
2
5207
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 other table, I get an error message, like that the parameter already exists. The SqlParameter with ParameterName '@datumZ' is already contained by another SqlParameterCollection
0
4536
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 and dataset. A add new row to dataset: <C#>
53
4685
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, and .Net2005 code. I'm developing in vb.net 2005. This test sub just reads an input text file, writing out records to another text file, eliminating records that have a '99' in them (it is similar to a CSV file). Some of my concerns are:
12
4155
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 there's a memory leak that seems to be to do with calling the data adapters update method. It's making the memory usage go through the roof and ultimately the service crashes after running out of memory.
1
8970
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8924
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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7807
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6560
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5902
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
4403
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
3088
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2392
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2027
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.