TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
bhanu prasannakumar
NA
132
146.6k
gridview concept
Jun 7 2011 2:28 AM
hi my problem is
my table contain these fields and each row contain one checkbox and this name is pros table
businessname status
------------ --------
electronic active
rise inactive
cooler active
if i check where status =inactive those rows will be moved to another table that is non live pros table and those checked rows will be deleted in first table and those rows will be placed in second table
please solve this one using gridviews(web application)
and i write one application but that application will give only inactive items
protected void Page_Load(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection("user id=bhanu;password=bhanu@123;database=EMS;server=server\\mit");
SqlDataAdapter da = new SqlDataAdapter("select * from pros", con);
DataSet ds = new DataSet();
da.Fill(ds, "pros");
GridView1.DataSource = ds.Tables["pros"];
GridView1.DataBind();
}
protected void Button1_Click(object sender, EventArgs e)
{
//SqlConnection con1 = new SqlConnection("user id=bhanu;password=bhanu@123;database=EMS;server=server\\mit");
//SqlDataAdapter da1=new SqlDataAdapter("select * from pros where status='inactive'",con1);
//DataSet ds1=new DataSet();
//da1.Fill(ds1,"pros");
//GridView2.DataSource=ds1.Tables["pros"];
//GridView2.DataBind();
so please check and give me the code for my requirement............but i am not writing checked ones...please give me that one also
Reply
Answers (
7
)
How to retrieve all the web services hosted in IIS using ASP.Net
multiple tables in a DataSet