|
I am working with three datagrids in VS 2003, visual basic. I am importing numerical data from an excel spreadsheet I select
using a show dialog and connect using an OleDb data adapter to import the selected data into datagrid1 and datagrid2.
The data is displayed on these two datagrids. Then I have a routine to add the first field in datagrid1 with the first field in datagrid2
and show the results in datagrid3. I notice that if I manually insert the values I get the proper results when I push the button but when
the data was imported and displayed to the datagrids, I only get zeros when I press the button. I even tried showing the results to
a textbox but I still get zeros. Basically, I want to perform some math operation from data imported from excel into two datagrids
and show the results in a third datagrid.
Any help is much appreciated.
|
|
|
|
|
I am using a Barcode ActiveX control downloaded from fathsoft but i have a trial version it expires after 30 days i have made a simple way to crack it but thats not the proper way can any one tell me of another control that can display barcode usin Code39 format. i have designed the whole IMS with that Need help please somone.
Everthing is Not what it seems!
|
|
|
|
|
hi to all ..
i am reposting my question agine , but this time in a better format ,
i wanna know how can get or count the rows in a datagrid when i have multi selection in it ..
thxx
|
|
|
|
|
Dim dgCount As Integer
dgCount = DataSet1.Tables[0].Rows.Count
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
|
hi everyone
I'm writing an applciation in wich I use a toggle button. On the button is a picture:
me.ToggleButton.picture = new bitmap(application.startuppath & "\afbeeldingen\min.png"
Now the button has to be set disabled on startup. So i write the following code:
me.Togglebutton.enabled=false
It works, but the picture on my button becomes a gray rectangle??? (so I don't see my picture anymore when disabled)
Anyone any ideas
thx in advance
|
|
|
|
|
Sure when u set enabled to false picture get grayed but try to set visiblity insetad enabled
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Hi all,
am passing a varaible STD in an sql statement... its returning me type mismatch... DIM STD As Integer
ictRecordset.Open "select * from ICTConcepts where stdID = '$[STD]' ", myConnection, adOpenStatic, adLockOptimistic
help me plz
Arshaad
|
|
|
|
|
You can't use a VB variable in an SQL query, the database can't access the variables that you have declared in your program. You have to put the value of the variable into the string.
---
b { font-weight: normal; }
|
|
|
|
|
You can pass them with no problem. You just ned to format them correctly for example, if the value is an integer you pass it like this:
"select * from table where colID = " & IntVar & ""
if it is a string
"select * from table where Colval = '" & StringVar & "'"
There are more but i cant remember them all. If you google you should be able to find more.
Jon
|
|
|
|
|
Hi Arshaad,
Plz specify the database ur querying.
I think u'll need to check the datatype of the variable STD and the field stdID in the table ICTConcepts, and also ur connection that it is pointing to the correct database.
Thanx & Regards.
Success is not a Destination,
... But a Journey !!
|
|
|
|
|
I m using csMovieLabraryPro class in VB.NET
i want to capture the frame or to store the particular frame as a bmp image.what class or library is used for capture the frame from existing video.plz help me it is urgent.thanks
Please help me
|
|
|
|
|
I'd like some advice on how to print reports in vb.net - I'm using the printdocument's e.graphics.drawstring method with tabs as shown in the Quickstarts, but need some help to keep the strings within the tab stops
eg.
dim line as string
line = item1 & vbtab
line &= item2 & vbtab
line &=item3 & vbtab
e.graphics.drawstring(line, etc...
this works great until one of the items exceeds the width of the tabstop and throws the rest of the line out of alignment. Any ideas please?
I would also appreciate any info on how to use the vsflexgrid in Visual Studio 2003, links to documentation or helpful sites. I am developing an add-on for an accounting package and need to simulate invoice item lines with ellipsis buttons to look up codes etc - what is the best/easiest control or approach to use in this case
Thanks
Dave Curtiss
|
|
|
|
|
Hi Frns,
I am working on a project where i am supposed to make a replica of yahoo messenger, not all the features but messaging like we have in yahoo messenger and list of online users. Any ideas or any startup point will be a great help and also if i an get some references to articles, i will be greatfull.
Thanks in Advance
Amit Trehan
|
|
|
|
|
Hi there,
I want to create checkbox during runtime.
User will give the number of boxes that has to be created..
Thanks in advance.
bharath.s
|
|
|
|
|
if ur control should contain more than one checkbox that is checkboxlist and code should me like this
Dim CheckedListBox ch As CheckedListBox
Dim i As Integer
For i = 0 To 10 'instead number 10 u give items how u want to add
ch.items.add(i.Tostring())
Next ch
me.controls.add(ch)
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
private void Button1_Click(object sender, System.EventArgs e)
{
int n= Convert.ToInt32(DropDownList1.SelectedItem.Text);
for(int i=0;i
|
|
|
|
|
good job but you posted in vb.net forum
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Thank U
As I 'm a C# developer I just tried it in C# and got the solution ,just posted it
Any way language is not a constraint, logic is important!
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
Yes, you have right "logic is important" but most important is to give exact solution by exact languge.
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
Ok Thanks for the Update
Good job and good observation by U
---Proud to be an Indian
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|
|
Never Mind and you are Welcome
_____________________
Proud to be Albanian
_____________________
|
|
|
|
|
I am using Crystal Report in a VB.NET application. The report size that I have used is A4. The report is getting printed properly on a A4 size paper. But some users they want to print the same report on paper size smaller than A4 size (because the printer is a small printer). The problem is that when they want to print it in a small size paper, a part of the report is getting printed. I want the report/printing area to be adjusted based on Printer Selected.
Is there any way to do so. Please help.
|
|
|
|
|
Dear Friends,
I am using in my VB6 Project so many times SQL Query 'Like' Operator. But really I am confused about the use of % and *. some time when I uses like '%Str%' it works fine and sometime it doesn't. It means I have to check every like operator query twice. once with % and once with *.
My database is Access and front end is VB6.
Your quick response will be highly appreciated.
Thanks
Murtuza Patel
|
|
|
|
|
These are called wild card characters in Sqlserver
When u use * it fetches all the attributes from the table
when u use % it selects the fields that contains the data inside %'test'%
But don't use * in ur select statements even u are retrieving all the columns from the table
"Aim to go where U have never been B4 and Strive to achieve it"
http://groups.yahoo.com/subscribe/dotnetforfreshres
http://himabinduvejella.blogspot.com
|
|
|
|