|
I did that But I will do it again thanks for now
|
|
|
|
|
Hello !
I have a query and i reqiure very urgent reply.
I want to read image from sql server 2000, which is in image datatype.
And i want to display it on my windows form's picture box..
Can U help me for this
i am egrly waiting for ur response..
Poll Adams
|
|
|
|
|
I'v never tryd this before (I always use a ftp fileserver and a path in the database) but I think you can just get the image the same way as you would request a string from the sql server.
If not you might want to consider using a file server and only a path in the database for it will most likly be faster and you're database size will be much smaller
|
|
|
|
|
There are almost as many examples of this on the web as there are chat applications. All you have to do is Google for "sql server 2000 vb.net store retrieve image[^]".
Do NOT use the term "urgent" aywhere in your posts. This tends to get you ignored. If it were that urgent, you'd be Googling this question yourself, until your fingers bled.
|
|
|
|
|
hi
look at this sample code. i use it for reading image from sql server database and showing in picturebox at my form.
<br />
<br />
Dim arrPicture() As Byte = CType(dsPictures.Tables(0).Rows(rowindex)("Picture"), Byte())<br />
<br />
Dim ms As New MemoryStream(arrPicture)<br />
PictureBox1.Image = Image.FromStream(ms)
|
|
|
|
|
hi
do you have vb.net code to find harddisk serial number and mainboard
thanks
|
|
|
|
|
So, how many timers are you going to post this question, then ignore the replys you get?
You're making a huge assumption. Most motherboard don't expose any kind of serial number.
You can get the serial number of most harddrives using the links you got 2 days ago.
CPU serial numbers (CPUID) are turnedoff by defulat in just about all systems. Relying on either CPU or motherboard serial numbers is a very bad idea if you're looking to use them for securing your application. There is NOTHING that says a hardware manufacturer has to incorporate them into the hardware and even less that says it should be readable by any code.
|
|
|
|
|
i have fnished my VB.net Application. i want to install the Application to a System that has not .net Framework installed. and some other system have .Net installed. my application is a database application that connects to a SQL server that is in another Building. when i run my applicatin in another system, even if .Net framework is installed it gives me the Following Error
<br />
Request for the Permission of Type System.Data.SQlClient.SQlClientPermission, System.data, Version= 1.0.5000.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089 failed.<br />
Thank you
Vuyiswa
|
|
|
|
|
This looks like a permissions issue from the error message.
The user you are running the application under will need to be registered both on the server and the SQL database.
Have you checked this?
You always pass failure on the way to success.
|
|
|
|
|
so does it mean i have to create a User for every peson who has to use the application?
if i create my application in my connection strng i pass the user iD of an Admnistrator and the password, Doesnt it uses that credentials to run on any machine?
thanks
Vuyiswa
|
|
|
|
|
Yes you are correct SQL server will pick up the connection settings you send. So it looks like you should get a connection to SQL server.
What I wonder is this - can you see the server i.e computer over the network from the client machine? It may be that although SQL server side you are ok - on the windows server side you may not be.
Having said all of that I am not a windows server expert - it is more something I would look at.
Have a look at this link as well.
-- modified at 7:35 Monday 9th July, 2007
You always pass failure on the way to success.
|
|
|
|
|
i can connect to the Server remotely in the Client Machine
Vuyiswa
|
|
|
|
|
Have you looked at this?:
http://support.microsoft.com/kb/842419
You always pass failure on the way to success.
|
|
|
|
|
Vuyiswamb wrote: i want to install the Application to a System that has not .net Framework installed.
You have no choice but to install the .NET Framework on the workstation you want this app to run on. If you used VB.NET 2005, you MUST install the .NET Framework 2.0.
Vuyiswamb wrote: Request for the Permission of Type System.Data.SQlClient.SQlClientPermission, System.data, Version= 1.0.5000.0, Culture=Neutral, PublicKeyToken=b77a5c561934e089 failed.
Is your application installed on the workstation or is the code running from a network source, like a file share on a server? If the code is running from ANY source other than the hard drive in the local workstation, you can get this error message. This is because of Code Access Security (look it up on MSDN). Code running from any non-local source is run in a heavily restricted sandbox by default.
|
|
|
|
|
In my Organisation the Users dont have Access to their Local harddisk, now for me to see the Exe to Execute them, i had to install it to the Network drive so i can Access the Exe. the reason is that ma new to VB.NEt, when i Deploy my Application. it creates shortcuts that are not executables, and when i click them they just taking me to the Explorer.
Thank you Dave
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: In my Organisation the Users dont have Access to their Local harddisk
Lousy policy. It doesn't serve any real purpose other than to infuriate admins and developers...
Vuyiswamb wrote: i had to install it to the Network drive so i can Access the Exe. the reason is that ma new to VB.NEt, when i Deploy my Application. it creates shortcuts that are not executables, and when i click them they just taking me to the Explorer.
You have no choice but to read up on Code Access Security[^]. It affects every single corner of your application if you have to run the code from an non-local source.
|
|
|
|
|
Thank you it working localy, you are a star
Vuyiswa
|
|
|
|
|
How do I update my app.config file?
The following code works, but it doesn't save the xml file changes to the disk, when the app is started up again all old values are once again loaded.
My.Settings.Item("NewConnectionString1") = TryConnectionString
My.Settings.Save()
(PS. This is all done in runtime)
_______________________________________________________________________
http://www.readytogiveup.com/[ ^]
"you can't forget something you never knew..." M. Du Toit
|
|
|
|
|
You have to set the scope of variable to 'User' not 'Application'. Once that is done, you can save your value.
To slightly modify the above, I would perform the following:
My.Settings.NewConnectionString = TryConnectionString
|
|
|
|
|
Thank you!
One problemthough , my TYPE is (Connection string) which can only be in the Application scope.
_______________________________________________________________________
http://www.readytogiveup.com/[ ^]
"you can't forget something you never knew..." M. Du Toit
|
|
|
|
|
I have a number of rich text boxes that I want to disable the cursor for.
I make the boxes readonly but if I disable them they turn grey .
The background to this is that I need scrollable text boxes in which error messages will appear. So the user cannot update the data, however it just looks messy having a flashing cursor in a text box if the user clicks on the text when the text cannot be edited.
Any help appreciated
Guy
You always pass failure on the way to success.
|
|
|
|
|
You can change the cursor in the appearance section in the property grid to type 'cursor'. I only have VS2005 so I dont know for sure if this is exposed in 2003.
Hope that helps.
|
|
|
|
|
Thanks,
In the end I have decided to allow the blinking cursor to remain as users may want to cut text from the error boxes.
I solved it by setting the TabStop property to false so that a cursor does not blink in the box until the user clicks on the box.
Cheers
Guy
You always pass failure on the way to success.
|
|
|
|
|
Hi, for showing a list of line-oriented text messages, I prefer a ListBox,
since that one is really line-oriented, and much more efficient in handling
lots of lines. It does not show a cursor, and you can choose whether and how it
supports line selection.
If you need any fancy feature (available in RichTextBox but not in TextBox/ListBox)
you may choose to set the DrawMode to OwnerDraw.
|
|
|
|
|
Thanks Luc,
I may just give that a go - it sounds like a neater solution than the one I have used.
Guy
You always pass failure on the way to success.
|
|
|
|