Professional Web Applications Themes

How to delete all rows in a dataSet, Update problems - ASP Database

In ASP.net Is there a way of deleting all the rows in a table in the dataset. In regards to deleting all the rows is there a Delete/Remove function similar to the simple update function of an DataAdapter i.e objDataAdapter.Update(objDataSet, "TableName")? In relation to updating is there anyway to update into a column with spaces in its name using the simple update function - i.e objDataAdapter.Update (objDataSet, "TableName") Also is there a way finding out how many rows in a dataset? Thanks...

  1. #1

    Default How to delete all rows in a dataSet, Update problems

    In ASP.net

    Is there a way of deleting all the rows in a table in the dataset.

    In regards to deleting all the rows is there a Delete/Remove function
    similar to the simple update function of an DataAdapter
    i.e objDataAdapter.Update(objDataSet, "TableName")?


    In relation to updating is there anyway to update into a column with spaces
    in its name using the simple update function - i.e objDataAdapter.Update
    (objDataSet, "TableName")

    Also is there a way finding out how many rows in a dataset?

    Thanks
    ree Guest

  2. #2

    Default Re: How to delete all rows in a dataSet, Update problems

    This group only deals with "classic" ASP. The ASP.net groups have "aspnet"
    in their names. Try posting this question in one of those groups, or in
    m.p.dotnet.framework.adonet.

    Ray at work

    "ree" <coom> wrote in message
    news:29.133.50... 


    Ray Guest

  3. #3

    Default Re: How to delete all rows in a dataSet, Update problems

    "Ray at <%=sLocation%> [MVP]" <myfirstname at lane34 dot com> wrote in
    news:phx.gbl:
     


    I cant find any newsgroups with "aspnet" on my grouplist from my ISP.

    I will try adonet.
    ree Guest

  4. #4

    Default Re: How to delete all rows in a dataSet, Update problems

    Microsoft's news server is open to the public, and you'll find all the
    available newsgroups if you use their server. And posts will show up more
    quickly that way as well.

    Here's a walkthrough on connecting to MS's news server with most popular
    news clients: http://www.aspfaq.com/5007

    Ray at work

    "ree" <coom> wrote in message
    news:29.133.50... 
    >
    >
    > I cant find any newsgroups with "aspnet" on my grouplist from my ISP.
    >
    > I will try adonet.[/ref]


    Ray Guest

  5. #5

    Default Re: How to delete all rows in a dataSet, Update problems

    ree wrote: 
    >
    >
    > I cant find any newsgroups with "aspnet" on my grouplist from my ISP.
    >
    > I will try adonet.[/ref]

    Use msnews.microsoft.com instead of your ISP's news server.

    Bob

    --
    Microsoft MVP -- ASP/ASP.NET
    Please reply to the newsgroup. The email account listed in my From
    header is my spam trap, so I don't check it very often. You will get a
    quicker response by posting to the newsgroup.


    Bob Guest

Similar Threads

  1. How to delete duplicate rows?
    By Clodoaldo Pinto in forum PostgreSQL / PGSQL
    Replies: 4
    Last Post: February 4th, 11:11 AM
  2. Replies: 0
    Last Post: January 20th, 11:44 AM
  3. Cache DataGrid Datasource, Add/Delete rows and rebind problems
    By locitt in forum ASP.NET Data Grid Control
    Replies: 0
    Last Post: February 2nd, 07:00 AM
  4. need help figuring out how to delete rows?
    By Deadsam in forum PHP Development
    Replies: 3
    Last Post: August 25th, 06:03 AM
  5. count rows in dataset...
    By Chris Wilmot in forum ASP.NET General
    Replies: 3
    Last Post: July 24th, 11:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139