Hi,
You can go for a control array.
For ex.
Steps
1. Place one checkbox control on your form
2. Give appropriate name to your checkbox control - chkBox
To work with control array you need to set index property of control
3. Set index property to Zero (0)
4. Find total no. of rows retrieved from your table. For ex. RecCount = 10 rows
5. Use loop
...
shaileshb
Last Activity: Aug 8 '08, 08:31 AM
Joined: Jun 25 '07
Location:
-
Last edited by Killer42; Dec 24 '07, 10:49 PM. -
If you need to show your form vbModal state
by default the state is vbModeless with constant value 0
Form2.Show vbModal
or
Form2.Show 1Last edited by Killer42; Oct 17 '07, 10:09 PM.Leave a comment:
-
Alter table <tableName>
Alter Column <ColumnName> Decimal(8,3)
GoLeave a comment:
-
according to my know there r only tow ways
1) Count()
but if ur tables contains lacks of records then count will take considerable amount of time to execute ur query, the other way is
2) ShowStatastics : give u table information including no. of rowsLeave a comment:
-
dim rs as adodb.recordset
dim strSql as string
set rs = new adodb.recordset
strSql = "select Sum(FieldName) From TableName"
rs.Open strSql, ConnectionObjec t
lable1.caption = rs.fields(0).va lueLeave a comment:
-
Here what i am thinking u want to give caption to each column in the grid
so here r variou ways
1)
flexgrid1.forma tstring = "ColName1" & "|<ColName2"... .
2)
Flexgrid1.row =0 :
FlexGrid1.col = 0
FlexGrid1.Text = "ColName1"
FlexGrid1.col = 1
FlexGrid1.Text = "ColName2"
3)
FlexGrid1.TextM atrix(0,0)...Leave a comment:
-
use format function
Format(round(te xt1.text,2), "#00.00")Leave a comment:
-
You can use SendKeys statement.
SendKeys "{F6}"Last edited by Killer42; Oct 17 '07, 09:29 PM.Leave a comment:
-
ex. ur table name is TEMP10 with column "COL1" which contains following records
Select * From Temp10
Col1
-------------
2551001
2551002
2551003
now if u want to replace 255 just use update statement
Update TEMP10 Set COL1 = Replace(Col1, '255', '000')
[where condition]Leave a comment:
-
Select * From [TABLENAME] Where [DateFieldName] = #" & format(textbox. text, "MM/dd/yyyy") & "#"Leave a comment:
-
1) Creating a Stored Procedure
Create Procedure <Procedure Name>
(<Parameter1> DataType, <Parameter1> Datatype......)
As
Begin
--your t-sql statements
End
--------------------------------------------------------------------------------------
2) Executing the stored procedure
Exec <Procedure Name> Parameter1, parameter1,.... .....Leave a comment:
-
hi
i m not getting exeactly what u wanna to ask ?
pls mentn it clearly
In Sql Server we can use two types of Queries
1) SubQuery
2) Corelated Query
3) Multipal Queries
Ex. Select * From Employee; Select * From Dept
this query will give u two resultset
that u can use with recordset object in VB6.0
and get next resultset by using the...Leave a comment:
-
vb.Net Colletion Class
hi to all
can anyone tell me how to work with collections in vb.net
ex. given below
Class Product
{
ItemName
Quantity
Price
}
--Collection Class
System.Collecti ons.CollectionB ase
Class Products
{
Sub Add(ByRef NewProduct As Product)
{
List.Add(NewPro duct)
}
}
I am using... -
hi
i have gone through ur query, but if possible just send me 1 or two records of each table and tell me exactily what u wantLeave a comment:
-
according to your table design we can find out total quantity and total amount
for each product for each month
Select Month(PDate), ProductName, Sum(Quantity), Sum(Total) From
Stock Group By Month(PDate), ProductName
pls try thisLeave a comment:
-
hi
pls chk this
dim rs as new adodb.recordset
dim mRow as integer
rs.open "Select * From Categories", con, adOpenDynamic, adLockOptimisti c
'suppose u r using MSHFlexGrid1 Grid Control having 4 columns
With MSHFlexGrid1
For mRow = 1 To .Rows - 1
rs.AddNew
Rs.Fields(0).Va lue = .TextMatrix(mRo w,0)
Rs.Fields(1).Va lue = .TextMatrix(mRo w,1)...Leave a comment:
-
hi
thanks for ur given solution.
but i want to write a programme in such a way that end user will select the pdf document so internally we need to convert pdf to xml and no one can modify that converted xml file. From converted xml file we have to filter some data. for ex. data available in table format in pdf document that data i want to take from converted xml file, but how to identify fields and how to identify...Leave a comment:
-
you can find tables by using this query
Select name from sysobjects where xtype = 'u' and name like 'tblname%'
and for deleting the table
drop table tblNameLeave a comment:
-
u can use the query like
Select Sum(WorkDays) TotWorkDays From WorkTable
Where WorkDate Between '01/01/2007' AND '06/30/2007'Leave a comment:
-
try to use below syntax
databasename.ow nername.tablena me
ex.
Select * From NorthWind.dbo.P ubs
but remember u cannot use JOINs between table available in two sepearte databaseLeave a comment:
No activity results to display
Leave a comment: