Doubt In Datagrid Fiedls: V.B 6.0

[hussainiyad]

Dear All,\
I,m doing one small project in v.b 6.0 and i,m totllay new for v.b , i,v one issue can anyone kindly give me the solution,

i,m doing a invoice project they asked me to show the sales invoice and purchase invoice

i created 3 tables
1.Purchase, 2.Sales,3.Products

and i insert the values so far but in invoice they need this kind of fornat


Invno Textbox Date =Textbox

CustomerName =TextBox CustomerName=TextBox(To avoid repeated value they asked me to do this format)


ItemNo Description Qty Rate Gross (in DataGrid)






in under the Grid they asked me to show the Total in a TextBox


can anyone tell me what i,v to do coz if i give the datasource to grid it retrive all the fields so how can i retrive the particular fields and how can show the total in text box

plzzzzzzzzzzzzzzzzzzzzz its very urgent

[muddasirmunir]

Dear Hussain
what i get from your query i get that you want to call only particular
fields on data grid.

you can select particular field by using this code
( i think you are using adodc for your connection to databae)

 
Adodc1.Recordset.Open "select item,qty,rate,amount from sales"
 

change the name of fields and table accordingly.
hope this help you.

if this does not work tell us the complete thing which database are
you using and how did you make connection to your database

Dear All,\
I,m doing one small project in v.b 6.0 and i,m totllay new for v.b , i,v one issue can anyone kindly give me the solution,

i,m doing a invoice project they asked me to show the sales invoice and purchase invoice

i created 3 tables
1.Purchase, 2.Sales,3.Products

and i insert the values so far but in invoice they need this kind of fornat


Invno Textbox Date =Textbox

CustomerName =TextBox CustomerName=TextBox(To avoid repeated value they asked me to do this format)


ItemNo Description Qty Rate Gross (in DataGrid)






in under the Grid they asked me to show the Total in a TextBox


can anyone tell me what i,v to do coz if i give the datasource to grid it retrive all the fields so how can i retrive the particular fields and how can show the total in text box

plzzzzzzzzzzzzzzzzzzzzz its very urgent