473,748 Members | 2,161 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

DataRow Delete Method

The .NET 2.0 documentation states the following:

When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove
the row. The Delete method marks the row as Deleted in the DataSet or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The row can then be
permanently removed using the AcceptChanges method.

Now I have this code:

<script runat="server">
Sub Page_Load(..... )
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
Dim dSet As DataSet
Dim dTable As DataTable

sqlConn = New SqlConnection(" ..........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Marks", sqlConn)

dSet = New DataSet()
sqlDapter.Fill( dSet, "Marks")

dTable = dSet.Tables("Ma rks")

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges()

dgMarks.DataSou rce = dSet.Tables("Ma rks").DefaultVi ew
dgMarks.DataBin d()
End Sub
</script>

<form runat="server">
<asp:DataGrid ID="dgMarks" runat="server"/>
</form>

When I execute the above code, the 4th row gets deleted from the
DataTable & hence the DataGrid doesn't display that row. Now how do I
make the SqlDataAdapter encounter the 4th row which has been marked as
Deleted in the Page_Load sub? Do I have to add the OnDeleteCommand
event to the DataGrid like this?

<asp:DataGrid ID="dgMarks" OnDeleteCommand ="DeleteItem "
runat="server"/>

& then add the event handler named "DeleteItem " which will have the
same code snippet that exists in the Page_Load sub (of course, except
for the 2 lines that immediately precede the 'End Sub' line)?

Nov 26 '06 #1
5 3109
OHM

Your problem is that you are accepting changes, this has the effect of
removing the row, hence the DataAdapter does not see the row maked for
deletion and will not delete the row in the database itself.
'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges() '// REMOVE THIS LINE //
HTH

<rn**@rediffmai l.comwrote in message
news:11******** *************@j 44g2000cwa.goog legroups.com...
The .NET 2.0 documentation states the following:

When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove
the row. The Delete method marks the row as Deleted in the DataSet or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The row can then be
permanently removed using the AcceptChanges method.

Now I have this code:

<script runat="server">
Sub Page_Load(..... )
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
Dim dSet As DataSet
Dim dTable As DataTable

sqlConn = New SqlConnection(" ..........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Marks", sqlConn)

dSet = New DataSet()
sqlDapter.Fill( dSet, "Marks")

dTable = dSet.Tables("Ma rks")

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges()

dgMarks.DataSou rce = dSet.Tables("Ma rks").DefaultVi ew
dgMarks.DataBin d()
End Sub
</script>

<form runat="server">
<asp:DataGrid ID="dgMarks" runat="server"/>
</form>

When I execute the above code, the 4th row gets deleted from the
DataTable & hence the DataGrid doesn't display that row. Now how do I
make the SqlDataAdapter encounter the 4th row which has been marked as
Deleted in the Page_Load sub? Do I have to add the OnDeleteCommand
event to the DataGrid like this?

<asp:DataGrid ID="dgMarks" OnDeleteCommand ="DeleteItem "
runat="server"/>

& then add the event handler named "DeleteItem " which will have the
same code snippet that exists in the Page_Load sub (of course, except
for the 2 lines that immediately precede the 'End Sub' line)?

Nov 26 '06 #2
You are correct, Ohm but just removing the AcceptChanges line won't
delete the record from the data source. To delete the row from the data
source, the DataAdapter's Update method has to be invoked without which
the deletion won't take place. The code would look something like this
(it comes immediately after the dTable.Rows(3). Delete line shown in
post #1; of course, remove or comment out the AcceptChanges line as
well):

'instantiate the SqlCommand object with the SQL
'query to delete the row from the data source

sqlCmd = New SqlCommand("DEL ETE FROM Marks WHERE ID = 4", sqlConn)
sqlDapter.Delet eCommand = sqlCmd
sqlDapter.Updat e(dTable)

'the above Update line is equivalent to
sqlDapter.Updat e(dSet.Tables(" Marks"))

That's it! Now the 4th row will be deleted from the SQL Server 2005 DB
table data source permanently.
OHM wrote:
Your problem is that you are accepting changes, this has the effect of
removing the row, hence the DataAdapter does not see the row maked for
deletion and will not delete the row in the database itself.
'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges() '// REMOVE THIS LINE //

HTH

<rn**@rediffmai l.comwrote in message
news:11******** *************@j 44g2000cwa.goog legroups.com...
The .NET 2.0 documentation states the following:

When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove
the row. The Delete method marks the row as Deleted in the DataSet or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The row can then be
permanently removed using the AcceptChanges method.

Now I have this code:

<script runat="server">
Sub Page_Load(..... )
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
Dim dSet As DataSet
Dim dTable As DataTable

sqlConn = New SqlConnection(" ..........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Marks", sqlConn)

dSet = New DataSet()
sqlDapter.Fill( dSet, "Marks")

dTable = dSet.Tables("Ma rks")

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges()

dgMarks.DataSou rce = dSet.Tables("Ma rks").DefaultVi ew
dgMarks.DataBin d()
End Sub
</script>

<form runat="server">
<asp:DataGrid ID="dgMarks" runat="server"/>
</form>

When I execute the above code, the 4th row gets deleted from the
DataTable & hence the DataGrid doesn't display that row. Now how do I
make the SqlDataAdapter encounter the 4th row which has been marked as
Deleted in the Page_Load sub? Do I have to add the OnDeleteCommand
event to the DataGrid like this?

<asp:DataGrid ID="dgMarks" OnDeleteCommand ="DeleteItem "
runat="server"/>

& then add the event handler named "DeleteItem " which will have the
same code snippet that exists in the Page_Load sub (of course, except
for the 2 lines that immediately precede the 'End Sub' line)?
Nov 26 '06 #3
OHM
Yes well of course.

I assumed you were not getting the result you wanted and 'Were' invoking the
update method. Thats why I told you to remove the AcceptChanges line.

I find your response a little strange because it sounds like you are trying
to teach me ADO.NET basics, there is no need beleive me, I have been doing
this stuff for nearly four years now.

Good Luck.

<rn**@rediffmai l.comwrote in message
news:11******** **************@ j72g2000cwa.goo glegroups.com.. .
You are correct, Ohm but just removing the AcceptChanges line won't
delete the record from the data source. To delete the row from the data
source, the DataAdapter's Update method has to be invoked without which
the deletion won't take place. The code would look something like this
(it comes immediately after the dTable.Rows(3). Delete line shown in
post #1; of course, remove or comment out the AcceptChanges line as
well):

'instantiate the SqlCommand object with the SQL
'query to delete the row from the data source

sqlCmd = New SqlCommand("DEL ETE FROM Marks WHERE ID = 4", sqlConn)
sqlDapter.Delet eCommand = sqlCmd
sqlDapter.Updat e(dTable)

'the above Update line is equivalent to
sqlDapter.Updat e(dSet.Tables(" Marks"))

That's it! Now the 4th row will be deleted from the SQL Server 2005 DB
table data source permanently.
OHM wrote:
>Your problem is that you are accepting changes, this has the effect of
removing the row, hence the DataAdapter does not see the row maked for
deletion and will not delete the row in the database itself.
'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges() '// REMOVE THIS LINE //

HTH

<rn**@rediffma il.comwrote in message
news:11******* **************@ j44g2000cwa.goo glegroups.com.. .
The .NET 2.0 documentation states the following:

When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove
the row. The Delete method marks the row as Deleted in the DataSet or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The row can then be
permanently removed using the AcceptChanges method.

Now I have this code:

<script runat="server">
Sub Page_Load(..... )
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
Dim dSet As DataSet
Dim dTable As DataTable

sqlConn = New SqlConnection(" ..........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Marks", sqlConn)

dSet = New DataSet()
sqlDapter.Fill( dSet, "Marks")

dTable = dSet.Tables("Ma rks")

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges()

dgMarks.DataSou rce = dSet.Tables("Ma rks").DefaultVi ew
dgMarks.DataBin d()
End Sub
</script>

<form runat="server">
<asp:DataGrid ID="dgMarks" runat="server"/>
</form>

When I execute the above code, the 4th row gets deleted from the
DataTable & hence the DataGrid doesn't display that row. Now how do I
make the SqlDataAdapter encounter the 4th row which has been marked as
Deleted in the Page_Load sub? Do I have to add the OnDeleteCommand
event to the DataGrid like this?

<asp:DataGrid ID="dgMarks" OnDeleteCommand ="DeleteItem "
runat="server"/>

& then add the event handler named "DeleteItem " which will have the
same code snippet that exists in the Page_Load sub (of course, except
for the 2 lines that immediately precede the 'End Sub' line)?

Nov 26 '06 #4
Oh! no, Ohm, I am not trying to teach you ADO.NET. After all, how can
I, who has been working with ADO.NET since last 4 months, teach you
ADO.NET which you have been doing since last 4 years?

Actually I myself strugggled to get my code going & wasn't aware that
the DataAdapter's Update method needs to be invoked to reflect the
changes in the data source. Had I known that, you would have seen that
Update line in the code in post #1 (I don't know what made you assume
that I was invoking the Update method). So that's the reason why I
mentioned about the Update method in my follow-up post. & I swear I
wasn't aware of the fact the you have got 4 years of experience behind
you as far as ADO.NET is concerned.

There's another reason why I mentioned about the Update method in my
follow-up post. Often I find that a post has been answered in just
words like "You do this..& do that...delete that line" so on & so forth
(note that I am not referring to your first response to this post).
This often leaves the person who has put forth his question (especially
if he happens to be a newbie) perplexed as to what he should do & what
he shouldn't. A better way of answering would be a code snippet instead
of "you do this & then do that...". A small code snippet is equivalent
to those hundred words. Of course, all posts don't warrantee a code
snippet wherein a small explanation would suffice. For e.g. it was very
much kind of you to add that small code-snippet after your explanation
to my original post though your explanation was good enough to make me
realize where I was going wrong but it doesn't tell anything about the
DataAdapter's Update method. Had you added one line saying that the
DataAdapter's Update method needs to be invoked finally to change the
data source, then it would have saved me nearly an hour's time. So
that's the reason why I mentioned about the Update method & added the
small code snippet so that in future, if anyone struggles like I did &
if he happens to come across this post without wasting much time, then
he would get his problem resolved quickly.

My follow-up post mentioning about the Update method was meant more for
those who aren't aware about the Update method & who might encounter a
similar problem rather than those who already know about it.

Lastly, no offence intended.
OHM wrote:
Yes well of course.

I assumed you were not getting the result you wanted and 'Were' invoking the
update method. Thats why I told you to remove the AcceptChanges line.

I find your response a little strange because it sounds like you are trying
to teach me ADO.NET basics, there is no need beleive me, I have been doing
this stuff for nearly four years now.

Good Luck.

<rn**@rediffmai l.comwrote in message
news:11******** **************@ j72g2000cwa.goo glegroups.com.. .
You are correct, Ohm but just removing the AcceptChanges line won't
delete the record from the data source. To delete the row from the data
source, the DataAdapter's Update method has to be invoked without which
the deletion won't take place. The code would look something like this
(it comes immediately after the dTable.Rows(3). Delete line shown in
post #1; of course, remove or comment out the AcceptChanges line as
well):

'instantiate the SqlCommand object with the SQL
'query to delete the row from the data source

sqlCmd = New SqlCommand("DEL ETE FROM Marks WHERE ID = 4", sqlConn)
sqlDapter.Delet eCommand = sqlCmd
sqlDapter.Updat e(dTable)

'the above Update line is equivalent to
sqlDapter.Updat e(dSet.Tables(" Marks"))

That's it! Now the 4th row will be deleted from the SQL Server 2005 DB
table data source permanently.
OHM wrote:
Your problem is that you are accepting changes, this has the effect of
removing the row, hence the DataAdapter does not see the row maked for
deletion and will not delete the row in the database itself.

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges() '// REMOVE THIS LINE //

HTH

<rn**@rediffmai l.comwrote in message
news:11******** *************@j 44g2000cwa.goog legroups.com...
The .NET 2.0 documentation states the following:

When using a DataSet or DataTable in conjunction with a DataAdapter & a
relational data source, use the Delete method of the DataRow to remove
the row. The Delete method marks the row as Deleted in the DataSet or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The row can then be
permanently removed using the AcceptChanges method.

Now I have this code:

<script runat="server">
Sub Page_Load(..... )
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
Dim dSet As DataSet
Dim dTable As DataTable

sqlConn = New SqlConnection(" ..........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Marks", sqlConn)

dSet = New DataSet()
sqlDapter.Fill( dSet, "Marks")

dTable = dSet.Tables("Ma rks")

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges()

dgMarks.DataSou rce = dSet.Tables("Ma rks").DefaultVi ew
dgMarks.DataBin d()
End Sub
</script>

<form runat="server">
<asp:DataGrid ID="dgMarks" runat="server"/>
</form>

When I execute the above code, the 4th row gets deleted from the
DataTable & hence the DataGrid doesn't display that row. Now how do I
make the SqlDataAdapter encounter the 4th row which has been marked as
Deleted in the Page_Load sub? Do I have to add the OnDeleteCommand
event to the DataGrid like this?

<asp:DataGrid ID="dgMarks" OnDeleteCommand ="DeleteItem "
runat="server"/>

& then add the event handler named "DeleteItem " which will have the
same code snippet that exists in the Page_Load sub (of course, except
for the 2 lines that immediately precede the 'End Sub' line)?
Nov 28 '06 #5
OHM
No offence taken. Glad you sorted it out. Had I known, you had not completed
the code, I would have posted a snippet. I will be more careful next time.

Cheers

<rn**@rediffmai l.comwrote in message
news:11******** **************@ 14g2000cws.goog legroups.com...
Oh! no, Ohm, I am not trying to teach you ADO.NET. After all, how can
I, who has been working with ADO.NET since last 4 months, teach you
ADO.NET which you have been doing since last 4 years?

Actually I myself strugggled to get my code going & wasn't aware that
the DataAdapter's Update method needs to be invoked to reflect the
changes in the data source. Had I known that, you would have seen that
Update line in the code in post #1 (I don't know what made you assume
that I was invoking the Update method). So that's the reason why I
mentioned about the Update method in my follow-up post. & I swear I
wasn't aware of the fact the you have got 4 years of experience behind
you as far as ADO.NET is concerned.

There's another reason why I mentioned about the Update method in my
follow-up post. Often I find that a post has been answered in just
words like "You do this..& do that...delete that line" so on & so forth
(note that I am not referring to your first response to this post).
This often leaves the person who has put forth his question (especially
if he happens to be a newbie) perplexed as to what he should do & what
he shouldn't. A better way of answering would be a code snippet instead
of "you do this & then do that...". A small code snippet is equivalent
to those hundred words. Of course, all posts don't warrantee a code
snippet wherein a small explanation would suffice. For e.g. it was very
much kind of you to add that small code-snippet after your explanation
to my original post though your explanation was good enough to make me
realize where I was going wrong but it doesn't tell anything about the
DataAdapter's Update method. Had you added one line saying that the
DataAdapter's Update method needs to be invoked finally to change the
data source, then it would have saved me nearly an hour's time. So
that's the reason why I mentioned about the Update method & added the
small code snippet so that in future, if anyone struggles like I did &
if he happens to come across this post without wasting much time, then
he would get his problem resolved quickly.

My follow-up post mentioning about the Update method was meant more for
those who aren't aware about the Update method & who might encounter a
similar problem rather than those who already know about it.

Lastly, no offence intended.
OHM wrote:
>Yes well of course.

I assumed you were not getting the result you wanted and 'Were' invoking
the
update method. Thats why I told you to remove the AcceptChanges line.

I find your response a little strange because it sounds like you are
trying
to teach me ADO.NET basics, there is no need beleive me, I have been
doing
this stuff for nearly four years now.

Good Luck.

<rn**@rediffma il.comwrote in message
news:11******* *************** @j72g2000cwa.go oglegroups.com. ..
You are correct, Ohm but just removing the AcceptChanges line won't
delete the record from the data source. To delete the row from the data
source, the DataAdapter's Update method has to be invoked without which
the deletion won't take place. The code would look something like this
(it comes immediately after the dTable.Rows(3). Delete line shown in
post #1; of course, remove or comment out the AcceptChanges line as
well):

'instantiate the SqlCommand object with the SQL
'query to delete the row from the data source

sqlCmd = New SqlCommand("DEL ETE FROM Marks WHERE ID = 4", sqlConn)
sqlDapter.Delet eCommand = sqlCmd
sqlDapter.Updat e(dTable)

'the above Update line is equivalent to
sqlDapter.Updat e(dSet.Tables(" Marks"))

That's it! Now the 4th row will be deleted from the SQL Server 2005 DB
table data source permanently.
OHM wrote:
Your problem is that you are accepting changes, this has the effect of
removing the row, hence the DataAdapter does not see the row maked for
deletion and will not delete the row in the database itself.

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges() '// REMOVE THIS LINE //

HTH

<rn**@rediffma il.comwrote in message
news:11******* **************@ j44g2000cwa.goo glegroups.com.. .
The .NET 2.0 documentation states the following:

When using a DataSet or DataTable in conjunction with a DataAdapter
& a
relational data source, use the Delete method of the DataRow to
remove
the row. The Delete method marks the row as Deleted in the DataSet
or
DataTable but does not remove it. Instead when the DataAdapter
encounters a row marked as Deleted, it executes its DeleteCommand
method to delete the row at the data source. The row can then be
permanently removed using the AcceptChanges method.

Now I have this code:

<script runat="server">
Sub Page_Load(..... )
Dim sqlConn As SqlConnection
Dim sqlDapter As SqlDataAdapter
Dim dSet As DataSet
Dim dTable As DataTable

sqlConn = New SqlConnection(" ..........")
sqlDapter = New SqlDataAdapter( "SELECT * FROM Marks",
sqlConn)

dSet = New DataSet()
sqlDapter.Fill( dSet, "Marks")

dTable = dSet.Tables("Ma rks")

'delete the 4th row from the DataTable
dTable.Rows(3). Delete()
dTable.Rows(3). AcceptChanges()

dgMarks.DataSou rce = dSet.Tables("Ma rks").DefaultVi ew
dgMarks.DataBin d()
End Sub
</script>

<form runat="server">
<asp:DataGrid ID="dgMarks" runat="server"/>
</form>

When I execute the above code, the 4th row gets deleted from the
DataTable & hence the DataGrid doesn't display that row. Now how do
I
make the SqlDataAdapter encounter the 4th row which has been marked
as
Deleted in the Page_Load sub? Do I have to add the OnDeleteCommand
event to the DataGrid like this?

<asp:DataGrid ID="dgMarks" OnDeleteCommand ="DeleteItem "
runat="server"/>

& then add the event handler named "DeleteItem " which will have the
same code snippet that exists in the Page_Load sub (of course,
except
for the 2 lines that immediately precede the 'End Sub' line)?


Nov 28 '06 #6

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

Similar topics

3
1770
by: Phil | last post by:
Hi, I have a client/server app. that uses a windows service for the server and asp.net web pages for the client side. My server class has 3 methods that Fill, Add a new record and Update a record. The Fill and Add routines work as expected but unfortunately the update request falls at the 1st hurdle. I pass two params to the remote(server) method for the update, one is the unique ID and the other is a string that is the name of the table...
6
6218
by: André Fereau | last post by:
Hi, I wish to use a class derivated from DataRow. The rows within a table are created with the NewRow method of the DataTable class. So I writed a method NewSTMTTRNRow() in my class STMTTRNDataTable, but I have an Invalid Cast Exception in the code "return ((STMTTRNRow)(this.NewRow()));". Where is the bug? What is the smart way to achieve my goal? Code :
4
2010
by: CaptRR | last post by:
I think this is the right group to post to, so here goes. My problem is this, I cannot update the datarow to save my life. Been on this for 2 days now, and still am no closer to figuring it out than I was before. I'm basicly taking date from some text boxes, trying to put them into a datarow and using that datarow to update the database, but its not working. The btn_update is where I am sending the information back to the addclient...
3
11601
by: Agnes | last post by:
Dim drTemp As DataRow For Each drTemp In dtInvCharges.Select("invno ='" & Me.txtInvNo.Text.Trim & "' ") dtInvCharges.Rows.Remove(drTemp) Next I got a "Delete button" to delete all rows in that Table. and the process "SAVE", In the screen , i can see the datagrid got nothing, however, as i check back my table in SQL, The data still here ?? Please help bmInvInfo.EndCurrentEdit()
1
3231
by: Ryan Liu | last post by:
Hi, When my code run to DataRow.Delete() It throws: System.ArgumentOutOfRangeException: Non-negative number required. Parameter name: length at System.Array.Copy(Array sourceArray, Int32 sourceIndex, Array
10
24181
by: mcbobin | last post by:
Hi, Here's hoping someone can help... I'm using a stored procedure to return a single row of data ie a DataRow e.g. public static DataRow GetManualDailySplits(string prmLocationID, string
2
4833
by: =?Utf-8?B?TWFyYw==?= | last post by:
In Visual Studio 2005, I am developing a Windows Mobile application, using Mobile SQL 2005. I need Data from a Database to be shown in a DataGrid, this works. But now I want to be able to get the Data of the selected DataRow, for instance, I want to display the value of the "Klant" column of the selected Row using: DataRow currentRow = table.Rows; MessageBox.Show(currentRow.ToString());
0
893
by: anacrisan | last post by:
I have a dataset that hold rows with RowState Added, Modified or Deleted. This dataset is sent to a webservice that will do the changes to the database. The thing is, in each row I have a column that holds a byte array and whenever I call the Delete() method for a row that must be deleted, that column becomes empty, even though right before the method call it has the right contents. Is this a normal thing? How can I avoid this? Thanks in...
1
2435
by: Andy B | last post by:
I have the following code: //delete the row in the table that has ID of 1. This line works fine. DataSet.Table.Rows.Find(1).Delete(); //Accept the delete changes to the table. This row returns 'object set to a null reference' exception. Why? DataSet.Tables.Rows.Find(1).AcceptChanges(); Why does this happen if the DataRow.Delete method page on msdn says that you
0
8983
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, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9528
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, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
9359
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
9310
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
8235
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
6792
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
4592
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
3298
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
2774
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.