Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
6
Answers
How to retrieve data from database to Gridview when i Doubleclick a particular cell using C#?
roy himanshu
15y
7k
1
Reply
hi,
How to retrieve data from database to Gridview when i Doubleclick a particular cell using C#
.i past my code bellow,plz help me
private
void
Form3_Load(
object
sender,
EventArgs
e)
{
cn =
new
SqlConnection
(
"data source=server2;database=costing1;user id=sa;password=sa"
);
da =
new
SqlDataAdapter
(
"select *from CATABLE001 where 1=2"
, cn);
ds =
new
DataSet
();
da.MissingSchemaAction =
MissingSchemaAction
.AddWithKey;
da.Fill(ds,
"CATABLE001"
);
dataGridView1.DataSource = ds.Tables[0];
private
void
dataGridView1_DoubleClick(
object
sender,
EventArgs
e)
{
int
sno =
int
.Parse(
Interaction
.InputBox(
"Enter ItemCode"
,
"db operations"
,
""
, 50, 50));
DataRow
dr = ds.Tables[
"CATABLE001"
].Rows.Find(sno);
dataGridView1.DataSource = ds.Tables[
"CATABLE001"
];
}
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
All objects created in a class referance the same object?
deleting row in mysql from datagridview