Novice Requires Help - Web Reference - Classes

Question

Hi,

I'm new to C# and need to make a Web Reference, this I've done and I can see the Class.

How do I make a reference to it in my code, do I use 'using .....'?

In the example of code for using it I have the following line: -

cpLatestBrief.authValue

there is now reference to 'cpLatestBrief', what should I do to correct this?

Hope this makes sense?

Regards

Answer 1

Hi,

You can use Acceptchange() method after deleting code. Just check this.
Change the table name as per ur TableName.
Insted of session You can use direct table from DataAdapter. Just assign table name. Check this code...

Write this code in GridView1 RowDelete Command event.

protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
    {      
        int i;       
        DataSet objds = (DataSet)Session["ObjDataSet"];     //Assign table from database here.
        DataTable dtNewAct = (DataTable)objds.Tables[0];
        i = GridView1.SelectedIndex;
        for (int iRow = 0; iRow < objds.Tables[0].Rows.Count - 1; iRow++)
        {
            if (i == iRow)
            {
                if (objds.Tables[0].Rows[i].RowState != DataRowState.Deleted)
                {
                    objds.Tables[0].Rows[i].Delete();
                    objds.Tables[0].AcceptChanges();
                    Session["ObjDataSet"] = objds;
                }
            }
        }

    }

Answer 2

Database Table Update in a DataGridView without Writing Code

Answer 3

hai,
Thanks for kind response, i tried ur code but it fails to get table name.
Here is the code below

Note: adduser is my table name

  private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (dataGridView1.SelectedRows.Count > 0)
            {
                dataGridView1.Rows.RemoveAt(this.dataGridView1.SelectedRows[0].Index);
            }

            addUserTableAdapter.Update(checkOutDataSet.Tables[adduser]);           
           
        }


error message:

Error    1    The name 'adduser' does not exist in the current context  

Answer 4

Add following line after your delete logic :
sqllAdap.Update(ds.Tables[TBL_NAME]);