ASP.NET

Re: Need to delete row in gridview but must not affect that row in the database.

11-Sep-09 2:17

Have you tried deleting the row from the datatable you bounded the grid and don't save the datatable to the database back. just after delting the data from thedatatable rebind the grid.

Thanks and Regards
Meetu Choudhary
My Web || My Blog || My Forums

Md. Marufuzzaman11-Sep-09 4:17

Md. Marufuzzaman

11-Sep-09 4:17

I think you can simply use datatable for your table manipulation in disconnected environment.

I will not say I have failed 1000 times; I will say that I have discovered 1000 ways that can cause failure – Thomas Edison.

Don't forget to click [Vote] / [Good Answer] on the post(s) that helped you.

Thanks
Md. Marufuzzaman

Remove items from generic list

yesu prakash11-Sep-09 1:52

yesu prakash

11-Sep-09 1:52

Hi,

I have a generic list with the following collection
Name
Age
ID
Count
Mark

How can i remove the items with age=10

Thankyou
YPKI

Re: Remove items from generic list

sashidhar11-Sep-09 1:57

sashidhar

11-Sep-09 1:57

Try The Below Link It May Help..!
http://msdn.microsoft.com/en-us/library/cd666k3e.aspx[^]

If It Helps Click It as Answer

Re: Remove items from generic list

N a v a n e e t h11-Sep-09 2:43

N a v a n e e t h

11-Sep-09 2:43

How about

list.RemoveAll(f => f.Age == 10);

Navaneeth

How to use google | Ask smart questions

error

ankitjain111011-Sep-09 1:26

ankitjain1110

11-Sep-09 1:26

string connection2 = ConfigurationManager.AppSettings["conn"];
OleDbConnection con2 = new OleDbConnection(connection2);
string connectionString = ConfigurationManager.AppSettings["conn"];

if(DropDownList1.SelectedItem.ToString()=="ALL")
{
string query = "select * from appointment where DATE > @StartDate and DATE < @EndDate ";
}
else
{
string query = "select * from appointment where DATE > @StartDate and DATE < @EndDate and DOCTOR_NAME='"+DropDownList1.SelectedItem.ToString()+"'";
}
// wrap the connection and command in using block to avoid resource leaks.
using (OleDbConnection connection = new OleDbConnection(connectionString))
using (OleDbCommand command = new OleDbCommand(query, connection))
{
command.Parameters.AddWithValue("@StartDate", sel.ToShortDateString());
command.Parameters.AddWithValue("@EndDate", tmp.ToShortDateString());

connection.Open();
// using a reader. You don't need a dataset as you are not persisting it in memory
using (OleDbDataReader reader = command.ExecuteReader())
{
GridView1.DataSource = reader;
GridView1.DataBind();
}
connection.Close();
}
}

its showing an error like
Error 1 The name 'query' does not exist in the current context C:\Users\Ankit\Documents\Visual Studio 2005\WebSites\WebSite1\Default.aspx.cs 53 56 C:\...\WebSite1\

can anyone help

Meetu Choudhary11-Sep-09 1:32

11-Sep-09 1:32

at which line?

Thanks and Regards
Meetu Choudhary
My Web || My Blog || My Forums

ankitjain111011-Sep-09 1:34

ankitjain1110

11-Sep-09 1:34

using (OleDbCommand command = new OleDbCommand(query, connection))

in dis line

Meetu Choudhary11-Sep-09 1:33

11-Sep-09 1:33

Try This:

//define string query ; outside the If block
<big>string query ;</big>
if(DropDownList1.SelectedItem.ToString()=="ALL")
{
string query = "select * from appointment where DATE > @StartDate and DATE < @EndDate ";
}
else
{
string query = "select * from appointment where DATE > @StartDate and DATE < @EndDate and DOCTOR_NAME='"+DropDownList1.SelectedItem.ToString()+"'";
}

Thanks and Regards
Meetu Choudhary
My Web || My Blog || My Forums

ankitjain111011-Sep-09 1:37

ankitjain1110

11-Sep-09 1:37

okk...i got it.thnx

Jay Royall11-Sep-09 1:34

Jay Royall

11-Sep-09 1:34

I think it's because you are declaring the string variable, query, inside the If statement, therefore it is out of scope. Declare the variable at the top with the other declarations.

visibility false of a column in gridview

J4amieC11-Sep-09 3:35

J4amieC

11-Sep-09 3:35

So how come you're smarty enough to use params for StartDate and EndDate but not for the doctor name?

shankbond11-Sep-09 1:02

shankbond

11-Sep-09 1:02

Hi,

I have a gridview with autogenerated fields, 2 template fields, 1 command field. Now, I want to hide one of the columns in a gridview .

I have a code written in rowdatabound

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

e.Row.Cells[2].Visible = false;

}

this code works well when I have not introduced allow paging=true. Thumbs Up | :thumbsup:

but when I have a page indexing property my code for pageindexingchanging is:

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)

{

gridview1.pageindex=e.newpageindex;

fillgrid();

}

where fillgrid is a function which is simply binding data coming from data base in gridview.

when I add page indexing to my gridview I get an error: Thumbs Down | :thumbsdown:

Specified argument was out of the range of valid values.
Parameter name: index

on this line: Sniff | :^)

e.Row.Cells[2].Visible = false;

any help shall be appreciated.

Meetu Choudhary11-Sep-09 1:29

11-Sep-09 1:29

Instead of

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

e.Row.Cells[2].Visible = false;

}

try

  protected void GridView1_DataBound(object sender, EventArgs e)
    {
e.Row.Cells[2].Visible = false;
    }

Thanks and Regards
Meetu Choudhary
My Web || My Blog || My Forums

shankbond11-Sep-09 1:58

shankbond

11-Sep-09 1:58

Hi Meetu,

Meetu Choudhary wrote:
protected void GridView1_DataBound(object sender, EventArgs e)
{
e.Row.Cells[2].Visible = false;
}

I tried but there is an error that it cannot access 'row' in the gridview1_databound event Confused | :confused:

Meetu Choudhary11-Sep-09 2:02

11-Sep-09 2:02

Oh Sorry I posted Wrong Code.

Try This

protected void GridView1_DataBound(object sender, EventArgs e)<br />
    {<br />
        GridView1.Columns[0].Visible = false;<br />
    }

Thanks and Regards
Meetu Choudhary
My Web || My Blog || My Forums

shankbond11-Sep-09 2:59

shankbond

11-Sep-09 2:59

Thanks for the code; it worked.

how can I add to your reputation from where? Laugh | :laugh:

Meetu Choudhary11-Sep-09 3:02