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
Jyoti Jodha
NA
1.7k
406.3k
How to get all the details of particular bill in another win
May 4 2017 5:12 AM
How to get all the details of particular bill in another window when I double click the row of grid view....
public void displayDataGridView()
{
SqlCommand cmd = new SqlCommand("Select ROW_NUMBER() over(ORDER BY Billno ASC) as ID, Billno, Customer_Details.CustName, Date,Amount, Tax_Amount, Total_Amount from MainBillForm join Customer_Details on MainBillForm.Name=Customer_Details.CustID where Sno=0 ", con);
try
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = cmd;
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();
}
catch (Exception ec)
{
MessageBox.Show(ec.Message);
}
Reply
Answers (
5
)
hide previous open forms in windows application
Visual Studio 2012 permium VS Visual studio 2015 Free ?