Hi all,
Can anyone tell me how to get a record for particular user or Number
In my sql i,v Pinvoice table following fields
InvNo int
1001
ItemNo
001
002
003
Descrption varchar(20)
Fan
Chair
Table
Price float
90
100
20
Qty
2
5
10
Gross
180
...
hussainiyad
Last Activity: Apr 20 '08, 06:15 AM
Joined: Feb 15 '07
Location:
-
hussainiyad started a topic How to retrive the records for parricular User in v.b 6.0in Visual BasicHow to retrive the records for parricular User in v.b 6.0
Hi all,
Can anyone tell me how to get a record for particular user or Number
In my sql i,v Pinvoice table following fields
InvNo int
1001
ItemNo
001
002
003
Descrption varchar(20)
Fan
Chair
Table
Price float
90
100
20
Qty
2
5
10
Gross
180
... -
Dear Debasis
Actually i need the total for particular InvNo so i tried many ways, in sql we can simply use this query "select sum(Gross)as Total from Pinvoice where InvNo=1001" but in my form when i retrive the datas from sql how i make the total thats my question is ? , shall i use the same query in button event
string sql
sqlstring"selec t sum(Gross)as Total from Pinvoice where InvNo="&"'"&txt InvNo.Text&"'"... -
Thanx Debidas i used that query which u sent but still i,m facing the same error , is there any solution plzzzzzzzzzzzzz zzzzzzzzzzz
and also tell me how to set the total in datareport and datagrid for examples i,v some regards in datagrid and i need the grand total in a textbox in my form
i created a view create view[Total ]as select sum(Gross)as total from Pinvoice
but it showed me the all Gross sum,...Leave a comment:
-
Hi Debi Thank your kind reply and tell me the solution for the below issue
tell me how to get a record for particular field, in my sql i,v Pinvoice table following fields
InvNo int ItemNo int Descrption varchar(20) Price float Qty Gross float
1001 090 Fan 30 5 150
1001 080 Table ...Leave a comment:
-
Datareport not showing in v.b 6.0
Dear all ,
I,m working with small invoice project and i need the report for 1.Purchase Order
2.SalesInvoice 3.Total stock, so created 3 dataenvironment and 3 DataReports and i created the connection for dataenvironment and declared the DataReport's Datasource as Dataenvironment and Datamember as Command1 when i run this report it showed me error msg "Report width is Larger than the paper width" but when i created a sepereted... -
Coding not working in adodc control : v.b 6.0
Hi all,
Can anyone tell me how to get a record for particular field, in my sql i,v Pinvoice table following fields
InvNo int ItemNo int Descrption varchar(20) Price float Qty Gross float
1001 090 Fan 30 5 150
1001 080 Table 45 2 90
1002 ... -
How to get records in two table with one same datafield: v.b 6.0
Dear all,
I,m doing a application in v.b 6.0 and can anyone solve my issue plz tell me how to retrive the two tables in a same time with one commonfield
Pinvoice1(Table 1) Pinvoice2(Table 2)
............... ............... ..
InvNo Primary key InvNo foreign key refrence Pinvoice(InvNo)
SupId int ItemNo int
Supname varchar(20) ... -
Doubt in vb 6.0
Dear All,
I,m doing a invoice project and in it i want to create both salesInvoice & purchase order
my Purchaseinvoice table contains following fields
1.InvoiceNo int primary key
2.Pdate datetime
3.Supplier Id varchar(10)(Thi s sup id should come from supplier table)
4.SupName(20)
5.ItemNo varchar(10)(Thi s following fields should from Product table)
6.Descrption varchar(20)... -
Datalist with datagrid in vb .6.6
Dear All,
I,m doing a invoice project and in it i want to create both salesInvoice & purchase order
my Purchaseinvoice table contains following fields
1.InvoiceNo int primary key
2.Pdate datetime
3.Supplier Id varchar(10)(Thi s sup id should come from supplier table)
4.SupName(20)
5.ItemNo varchar(10)(Thi s following fields should from Product table)
6.Descrption varchar(20)... -
Run time error 2147217842(80040e4e) in vb 6.0 form
Dear All
i,m totlally new for vb 6.0 and i,m doing a invoice project and i,m facing a issue , can you plz tell me solution
i,m trying to retrive some datas from sql (Product table)
it contains following fields
ItemNo varchar(10)
1.N1001
2.C909
3.F600 ... -
Thank U debi for ur kind reply i used the same coding for other two txtbox click event and this is my real problem
i,m totlally new for vb 6.0 and i,m doing a invoice project and i,m facing a issue , can you plz tell me solution
i,m trying to retrive some datas from sql (Product table)
it contains following fields
ItemNo varchar(10)
1.N1001 ...Leave a comment:
-
Run time error 2147217842(80040e4e)
Dear ADezii
i,m totlally new for vb 6.0 and i,m doing a invoice project and i,m facing a issue , can you plz tell me solution
i,m trying to retrive some datas from sql Product table
it contains following fields
ItemNo int,Descrption varchar(20),Sup id int,SupName varchar(20),Pur price float,SalPrice float,QtyIn int,QtySold int
i,m trying to retrive some datas from sql Product table... -
Doubt in datacombo in vb 6.0
Dear All,
In my form i,v many tables for examples
1.(Table)suppli er = SupId varchar(10) primary key,SupName(20)
2.(Table)Produc t = ItemNo varchar(10)Prim ary key,Descrp varchar(20),Pri ce float,Qty int
3.(Table)Pinvoi ce=InvoiceNo int primary key, Pdate datetime,SupId varchar(10),Sup Name varchar(10),Ite mNo varchar(10),Des crp varchar(20),Pri ce int,Qty int
i created 2 form lke... -
Need guidence in invoice project in vb 6.0 with sql
Dear all,
i,m doing a Invoice project in vb 6.0 and i,v no idea about it , can anyone tell me the solution
how to start the project
i created few forms like supplier,custom er,product, and i created the add,update,dele te, for the all forms , but i need to complete the sales invoice,purchas e order,and Reports of 1.sales,2.purch ase,3.Total to all and particular customer (or)supplier(or ) itemno
... -
Doubt In Datagrid Fiedls: V.B 6.0
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.Produ cts
and i insert the values so far but in invoice they need this kind of fornat
Invno Textbox ... -
Thank you veena for spending on me some timeLeave a comment:
-
Thank you veena , i,v done the all above things what u mentioned but i need a clarity about the insert,update.d elete commands while we r using adodc dontrol
Thanks in advanceLeave a comment:
-
yeah i,m trying with adodc control but there is no connection in datagrid if i right click the adodc control and specify the following details
1datasource
2databasename
3tablename
then the records fetch in the table but if i,m trying trough coding it was not working and also tell me about the insert,update,d elete codings
plzzzzzzzzzzzzz zzzzzzzzzzzzLeave a comment:
-
v.b 6.0 connection with adodc through sqlserver not working
Hi all,
I,m new to vb.6.0 and i don,t know how to connect to sql server through v.b 6.0 with the help of adodc control, and anyone plz tell me how connect and insert ,update,delete and other functions, coz i tried in m.s access not in sqlserver,
This is the coding which i used in ms.access
[code=vb]
'for insert
rs.Fields(0) = Text1.Text
rs.Fields(1) = Text2.Text
rs.AddNew
rs.Update...
No activity results to display
Leave a comment: