|
Thanx,but I want to know how vb.net to do it not with office toolkit?
|
|
|
|
|
OK, then the answer is you really can't, not unless you write a program that is fully able to read the XLS file format. Unless you work only with the new Office 2007 format, which is just a zip full of XML, I'm sure that's easy to add to.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i need a way to deal with a number that is 320 digits long. Whats more, it needs to be an integer, not a decimal. how would i go about working with such large numbers, dividing, adding subtracting, etc. I have tried Long, Decimal and Double but none of them are long enough.
Posted by The ANZAC
|
|
|
|
|
There is no type that handles numbers remotely that long. You'd have to write your own class, to handle a type like this, or look for one online. Do you need all 320 digits to be accurate ? If you only need accuracy to a certain number of digits, you can always assume the rest are 0s.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
|
Hi, Could ayone give me the simple sample code for datagrid.
I need to fill the datagrid dynamically, also thers syould also be able to have chekbox.
Be simple and Be sample.
|
|
|
|
|
Just add a checkbox in a column definition. There are heaps of samples here and elsewhere on the web.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
hi,
in my project i want to display report on a btn click.
i did it as
cryRpt1.connect=(connection string)
i am getting an error incorrect log on parameters.
please tell me the correct syntex for this connection. my server is sql server and database is sql server datebase and both r on same machine.
|
|
|
|
|
hi,
there are two tables
table name PROJECT_CATEGORY
fields PROJECT_CAT VARCHAR(3) PRIMARY KEY
CAT_ACTIVE VARCHAR(1)
table name PROJECT_DETAILS
PROJECT_CODE VARCHAR(6) PRIMARY KEY
PROJECT_CAT VARCHAR(3) REFERENCE PROJECT_CATEGORY(PROJECT_CAT)
In a form to fill project details i have used DATAGRID. to fill project category i want categories from table PROJECT_CATEGORY to be listed in datagrid cell with button (dropdown).
PLEASE HELP. thanks.
-- modified at 0:13 Saturday 10th February, 2007
|
|
|
|
|
Hello guys
I am reading values from a table from a DB
what i want is to color the BackColor of the row for specific values
exemple :
if row1 at column("columname") ="xxx" --- color row1 in blue
if row1 at column("columnname") ="yyy" --- color row1 in yellow
and dont change the color of the other row
Regards
Ramy
|
|
|
|
|
Hello,
Try the DataGridView_CellFormatting method.
You can specify some rowdetails like ForeColor, BackColor, etc. depending on the value of the cell.
Good luck!
Jan
|
|
|
|
|
Hello!
I am using VB.Net 2005 and I would like to know if there is way to define an array for a single label or picturebox object at design time.
Thanks!
Bedri
|
|
|
|
|
What do you want ? What sort of array do you mean ? An array of pixels ? Of letters ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
My aim is to store the letters in two dimensional array. The array must be a label object so I can easily place pictures behind of these labels also. I have 10 rows and 8 columns in each row. It is a simple matrix but must be made by label objects.
If I do this internally (nor at design time), How I could write AdHandlers for each specific label object to check if it is selected or clicked.
Thanks a lot!
|
|
|
|
|
Sounds like you need to write a custom control. Do you mean each label contains a letter, but the letters also map back to positions in an array, so if you change the array, the controls change ? If so, you need to write code to map an array of letters to an array of controls.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
i know this is a c# forum but couldn't find one vb. if i get a sample how to it in C# no prob i can convert it
Default using vb.net to post to a website
i want to post a string to a website can anyone show me or point me to example of how you would use vb.net to post a string to a website and accept the response sent back from post / request to the site?
|
|
|
|
|
Hello,
1°) I would like to know how to recognize a readonly directory in advance
only without having to await the code error of return in attempt at writing
on this one as one can let it to know if a file is system, file, reading, hidden.
2°) I would like to also know how to detect the authorizations (permissions,
accounts authorized) of writing on a directory without having to await the code error of return in attempt at writing on this one like one does it for
a file.
This question is independent of the first because the directory can be
in read/write but that only for certain people thus useless to go further if it is already in readonly mode.
I tested by the code according to various tests:
Dim FolderBrowserDialog1 as FolderBrowserDialog = New FolderBrowserDialog()
Dim MyAttr asFileAttribute
If FolderBrowserDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then
MyAttr = GetAttr(FolderBrowserDialog1.SelectedPath)
MsgBox(MyAttr.ToString) 'response : Directory
MsgBox(File.GetAttributes(FolderBrowserDialog1.SelectedPath).ToString)
'response : Directory
Dim information as System.IO.FileInfo
information =
My.Computer.FileSystem.GetFileInfo(FolderBrowserDialog1.SelectedPath)
MsgBox(information.IsReadOnly) 'response : always false even if the
directory is readonly mode
End If
in advance thank you with all
|
|
|
|
|
A ReadOnly folder is easy enough. All you need in the File class and it's GetAttributes[^] method.
You shouldn't be attempting to calculate your own access levels. There's simply so many levels of security and inheritance affecting file access from your code that the best way of reliably testing access is to try to create your file! You can calculate NTFS permissions all you want, but code access permissions can also affect your ability to write a file. What this means is that NTFS can say that it's perfectly OK for you to create a file, but code access permissions can deny you!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi.
can someone pls direct me in how i can go about working out how i can capture printpreview/printdocument data and save into a file for example
doc, txt ,pdf or anything you can assist with..
many thanks.
Robbo
|
|
|
|
|
Are you trying to capture the data that's going to the printer?? Or are you trying to capture an image of the Print Preview?? In your application or any application??
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Hi Dave. Thanks for replying. ive already got a print method working where i can see data in print preview but need to work out if i can capture everything in my print preview and save it to a file whether it'd be a pdf or doc or anything you can advise me with. and YES its for my APP and in my app that i need to do this.
Thanks Dave
Robbo
|
|
|
|
|
You'd use the same code you use to draw your print document to draw to a bitmap if you wanted.
A PDF is a bit of a different story. You'd have to use some kind of PDF library to create the file and you can probably get away with using, again, the same drawing code you're using to generate the print preview.
I don't have any example or knoweldge of any PDF libraries because I simply don't need them and don't use them for anything I do. There's a bunch of them though, just Google for ".net pdf library"[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
thanks dave. so what function or commands am i looking to use and to capture the bitmap.
|
|
|
|
|
There really isn't any. You create a bitmap object the size you need, then create a Graphics object from it, pass that to your drawing code and your code should draw everything using that Graphics object. Done. Everything just got drawn to your bitmap. You can do whatever you want with the image then.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I am having difficulty iterating through an array. I have found the following sample code and tried modifying it with my variables.
' Sample Array Read Code
'For i = 0 To arrList2.Count - 1
' Console.WriteLine(CStr(arrList2.Item(i)))
'Next
After modifying line 3 with x = CStr(arrList2.Item(i)) , I receive the following error: "Value of type 'String' cannot be converted to '1-dimensional array of String'." X is defined as: Dim x() As String
I need to get each element (which is a name read from a textbox) into a variable strName. This is to allow my SQL statement to create a record for each name in the array.
Any help would be greatly appreciated!
Thank you in advance.
LWhite
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
