i want to Fetch data from database based on Order Bill No

Question

hi i have two form sales order and sales invoice. and i want to fetch data from sales order to sales invoice based on Order Bill No . In Sales order also contains Text and gridview .i want to same as it is fetch on Sales Invoice also have textbox and gridview.

Karthi Keyan · Answer

@Rajnish By your Replay you got all rows from query but gridview show only one row. am i right. so your problem in showing the data in the gridview. can share your code and some examples.

Rajnish Kumar · Answer

@ Karthi Keyani i got all details through Order Bill No . but the problem is in datagridview i got only single row. how can i done multi row.

Karthi Keyan · Answer

@Rajnish Are you stored the Sales order details in DataBase???... if yes you can easily get the data's to the Sales invoice. use select query to get. Can you tell when you need to get the Data to the Sales invoice???