How to write two or more select statements in a single query
here my requirement is
SELECT dbo.SYS_PARAMS. PARAMETER_NAME, dbo.SYS_PARAMS. PARAMETER_UNITS , SYSTEM2.dbo.CAL IBRATION.CAL_TY PE,
SYSTEM2.dbo.CAL IBRATION.CAL_TI MESTAMP, SYSTEM2.dbo.CAL IBRATION.MEASUR ED_VAL, SYSTEM2.dbo.CAL IBRATION.EXPECT ED_VAL
FROM SYSTEM2.dbo.CAL IBRATION INNER JOIN
dbo.SYS_PARAMS ON SYSTEM2.dbo.CAL IBRATION.PARAME TER_INDEX...
bharathi228
Last Activity: Mar 11 '09, 05:21 AM
Joined: Jul 22 '08
Location:
-
Two or more select statements in a single query
-
days in a month
hello i want to get number of days in a month.
here my requirement is if iam selecting month name in a combobox then iam displaying days
in another combobox.
example :
if iam iam selecting JAN in one combobox then 1 to 31 numberd bind to another combobox.
if iam seleing FEB in a ombobox 1 to 28 numbers added to the combobox.
i want to do this in vb.net(windows... -
Get images row wise in datagridview
i want display images row wise using datagridview in windowsapplicat ion.
in asp datalist control is used but windows any control is there .
pls any one response to me urgently -
update method in datagridview
Hi,
iam working with windows application.her e my requirement is binding data to database from a datagridview.
next i want to update some rows in datagridview and update it to the database.for this purpose i need for each row loop in datagridview.i dont know how to update
the selected row in the datagridview.he re my code in asp.net is like this.its working fine.but i want to do this in datagridview in windows application.... -
datagridview selected row update in vb.net
hello sir,
iam new to windows application.iam working with datagridview in vb.net .how to update the selected row in datagridview.an y one help me with this. -
Problem in crystal reports
hi,
iam working with crystal reports.in my database table i have a
columns like dtmtime,paramet er_index
dtmtime parameter_index status
1/2/2006 11 SVC
4/2/2006 12 COS
6/2/2006 11 SVC
7/2/2006 11 UNK
12/2/2006 12 ... -
no.only i want to check database exists or not through asp.net code
so i need a query for this -
how to set dynamically datasource to crystal report
hello in my application we hav monthly databases
every month we create new database through code in asp.net
database name like 200901AVG
200902AVG
now my problem is iam working with crystal reports
here i want to create a AVG report from November 2008 to Jan 2009
so i need 200811AVG,20081 2AVG,200901AVG Databases
like this whatever dates i selected it will goes to the particular database... -
database exist or not
how to check if database exist or not in sqlserver through asp.net code.
if not exists i will give msgbox to user
otherwise i will allow the user to create reports
pls any one give me solution.its urgent -
how to find each cell value of column in gridview
hi,
iam doing one asp.net application
in gridview i have 3 columns.
the first two column values are coming from database.
the third column is template field.here i have one radiobuttonlist control.i have two
options in radiobuttonlist .
for example
Employee dept ...Leave a comment:
-
how to find each cell value of a column in a gridview
hi,
iam doing one asp.net application
in gridview i have 3 columns.
the first two column values are coming from database.
the third column is template field.here i have one radiobuttonlist control.i have two
options in radiobuttonlist .
for example
Employee dept attandance
bharathi finance a p (here iam... -
Object variable or With block variable not set
hi,
iam doning one vb.net application.it is windows application.her e iam having 6 class libraries and all dlls are added as reference to another module.the main module is CEMDAS. The referenced class library is RPT_LIB.
here my code is
in general declarations iam declared like this
Public m_uiREPORT_CONF IG As RPT_LIB.REPORT_ CONFIG
---------------calling-----------------------
[code=vbnet]... -
Global connection string in vb.net
Hi, iam doing a windows application
i have 4 modules.
3 are class libraries
in the 4th module iam adding these 3 dlls and execute this
but i want to put connection string property for this globally.
so how to write code in app.config
and how to use this in my class libraries
i want to know that app.config for storing connectionstrin g can be used... -
how to assign array values to datagridview
hi,
how to assign a array as datasource to datagridview in vb.net.
my problem is
iam having an array with 60 values
For intVALUE_INDEX = 0 To (muiiobufCEMCON (intCEMCON).DIG ITAL_INPUTS - 1
Dim intarray(mblnDI GITAL_INPUTS.Le ngth) As Integer
Array.Copy(mbln DIGITAL_INPUTS, intarray, mblnDIGITAL_INP UTS.Length)
here in intarray iam having values
... -
array as datasource to datagridview in vb.net.
hi,
how to assign a array as datasource to datagridview in vb.net.
my code is
Dim intarray(mblndi gital_inputs) As Integer
mblndigital_inp uts.Copyto(inta rray, 0)
Array.Reverse(i ntarray)
i want to assign intarray to datagridview control.
and another one is suppose is there 40 values in that array
then 16 values are displayed... -
VB.net control arrays
hi,
iam doing a windows application.iam displaying values in the form at runtime.
my requirement is from PLC iam retrieving 40 values like 0 and 1 s
then iam displaying 1st 16 values into one textbox
next 16 values into one textbox
next 8 values into one textbox
for example 010000000000000 1 ------ first textbox
and one more thing is values are displaying... -
Dynamic values for dynamic tables
hi,
iam doing a windows application.i have a requirement like to create labels and textboxes dynamically at runtime.
and data is coming from database. based on the columns controls should be created and data is to be loaded in them.
if the table is having 6 columns then 6 labels and textboxes should be created and corresponding data to be loaded.
...Leave a comment:
-
dynamic values for dynamic controls
my code for retrieving values from database
Dim da As New SqlDataAdapter( "select parameter_name, parameter_units from sys_params", con)
If con.State = ConnectionState .Closed Then
con.Open()
End If
Dim ds As New DataSet
Dim name, unit ,namunt As String
da.Fill(ds, "sys_params ")
For Each r In ds.Tables(0).Ro ws
name = r.Item("paramet er_name")... -
Dynamically Creating Controls in windows applications
hi,
iam doing a windows application.i have a requirement like to create labels and textboxes dynamically at runtime.iam giving input as number of labels,and textboxes then it will created dynamically.but here i put this controls in a panel.here my problem is all controls are placed in the same position.
but my requirement is all textboxes are arranged one by one.iam trying with this using tablelayoutpane l.but i dont know how... -
array data storage problem
Hi,
this is my code.
...Code:strQUERY = "SELECT PARAMETER_INDEX,SITE FROM SYS_PARAMS ORDER BY PARAMETER_INDEX" If CON.State = ConnectionState.Closed Then CON.Open() End If da = New SqlDataAdapter(strQUERY, CON) Dim ds1 As New DataSet da.Fill(ds1) reccount = ds1.Tables(0).Rows.CountLast edited by Curtis Rutland; Aug 30 '08, 06:46 AM. Reason: Added code tags -- Please use the # buttonLeave a comment:
No activity results to display
Leave a comment: