|
Off the top of my head I'd say pull the data in as normal & perform editing on it using string methods.
Are you looking for a particular bit of string in the data you're pulling through? How do you know which 20 characters it is? The first 20? A bit more explanation please.
|
|
|
|
|
I am looking for the first 20 characters. from character 1 to 20.
Hope this is clear.
|
|
|
|
|
Assuming your reading the data as string, use the Substring method on your data e.g. txtResult.Text = strSQLData.Substring(0, 20).
|
|
|
|
|
thank you.
It works perfect.
|
|
|
|
|
hi,
how can i save a word file into database and import that file into word and do editing and again save into the database
|
|
|
|
|
Wouldn't it be easier to save the Word files as is and just reference their paths/build a schema of the file system where they are stored? Your ability to edit & save the files would be much easier as well.
|
|
|
|
|
How can i create a document in VB.Net.
i have used ritch textbox and text boxes.
how the memo field contained in the database is placed in the ritchtextbox in a special format
|
|
|
|
|
Word will not retrieve documents out of a database. You'll have to write some mechanism to retrieve the document, save it to a temp file, open it in Word, wait for the user to finish editing it, resave it back to the temp file, then your app can put the edited copy back in the database.
It's FAR more managable to just save the document in a file system somewhere and save the path to that file in the database.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
Amen to that, why does everyone want to create five extra steps to do something simple?
DB_Cooper1950
"Life is like a box of..."
|
|
|
|
|
No idea over here. I don't even like putting images in a database just because of the bandwidth it takes, but I do realize that there is a need for it. But for Word documents?? Good luck searching them! 
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
How can i make Demo(Trial) for Deployment program ?, i mean how can i determine a period so the program will not be accessible after the period expired?
|
|
|
|
|
All sorts of ways. They all have a few things in common - they need to store a time stamp, and that stamp needs to be hidden and left behind if the program is removed.
Oh, and because you're using .NET, they are all a waste of time, anyone can decompile your code and remove the section that enforces the demo.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Christian Graus wrote: Oh, and because you're using .NET, they are all a waste of time, anyone can decompile your code and remove the section that enforces the demo.
As a sidebar - your thoughts on obfuscation?
I've read a few articles on it but never bothered putting into practice.
|
|
|
|
|
My app supports a piece of hardware, so I've never bothered. But, I think it's a good idea, I really should be doing it, too.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Can I use the registry to solve this problem ?
If yes please tell me how?
I mean, if I save a value in a register and update it on time(ex. Hour,Minute),and when we reache to specific value the program will not be accessible.
|
|
|
|
|
You can, sure. You can store the date the program is first run, and every time you run the program, load that date, and check how many days ago it was.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Hello!
I'm using vb.net with net 2.0.
Is there a way to play a midi sound file with a predefined tempo? I would like to make it possible for the user to adjust the tempo of a midi song.
|
|
|
|
|
I have a project, where I print my invoice with code like this:
<br />
With Printer<br />
.PaperSize = Papier: .ScaleMode = 6: .Orientation = Ausricht<br />
.CurrentY = RandOben<br />
.FontSize = 10<br />
If UCase(frmAdressverwaltung.txtNName.Text) = "BARVERKAUF" Then<br />
Zeile = ""<br />
For i = 1 To 6<br />
Printer.Print Zeile<br />
Next i<br />
Else<br />
If frmAdressverwaltung.optAnredeF.Value = True Then<br />
Zeile = "Frau"<br />
ElseIf frmAdressverwaltung.optAnredeH.Value = True Then<br />
Zeile = "Herr"<br />
ElseIf frmAdressverwaltung.optAnredeK.Value = True Then<br />
Zeile = ""<br />
ElseIf frmAdressverwaltung.optAnredeC.Value = True Then<br />
Zeile = "Firma"<br />
End If<br />
Zeile = Zeile & " " & frmAdressverwaltung.txtTitel.Text<br />
.CurrentX = Randlinks<br />
Printer.Print Zeile<br />
.FontBold = True<br />
.CurrentX = Randlinks<br />
Zeile = frmAdressverwaltung.txtNName.Text & " " & frmAdressverwaltung.txtVName.Text<br />
Printer.Print Zeile<br />
.FontBold = False<br />
Zeile = frmAdressverwaltung.txtStrasse.Text<br />
.CurrentX = Randlinks<br />
Printer.Print Zeile<br />
Printer.Print ""<br />
Zeile = frmAdressverwaltung.txtPLZ & " " & frmAdressverwaltung.txtOrt.Text<br />
.CurrentX = Randlinks<br />
Printer.Print Zeile<br />
Printer.Print ""<br />
End If<br />
The code goes over 100 lines in this way. - So I don't want to change the code. - Now I want to print also the logo and some text on tho the invoice
It is a bmp File with the logo & text & the rest ist transparency - I tried to this with the following code:
<br />
If GetSetting("VOPTNeu", "Firmendaten", "ReLogo") = "True" Then<br />
.PaintPicture LoadPicture(App.Path & "\rechnungslogo.bmp"), 2, 3, 130, 35<br />
.CurrentY = 52<br />
.CurrentX = Randlinks<br />
End If<br />
But this wan't work.
Please help - Hope you understand what I mean.
Yours faithfully
|
|
|
|
|
Hi Guys,
Quick question.
How can i apply say Silver theme to my app while xp is using blue?
I've seen this done but don't remember where or how. 
Plz help
The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!
|
|
|
|
|
You'd have to owner draw stuff, I guess, then you can draw it any way you like.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Christian is right. You'd have to ownerdraw everything yourself. Applications cannot use one system theme and the system use another at the same time. You have to do all the drawing work yourself.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I was kinda hopping to avoid that...no time.
Thanks for your time guys
The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!
|
|
|
|
|
Hi Guys,
I hope everyone is well and filled with caffeine...I know i'm
I've read in one of the posts here recently that it's not a good idea to keep the code that does not run the ui inside the form and usercontrol classes as it will run on the same thread as the ui and slow down the app. Which does make a lot of sence 
Not that it makes much difference but I have all my code in dll's and for processing purposes the forms only call dll functions, anything ui related is kept inside the form modules and usercontrol classes.
So
What's the syntax to start a new thread and run specific code on it?
Also
Do I need to keep track of the threads, if so how?
Finally, as far as canceling of currently running code is concerned
How do I handle threads, and cancel code running on them?
The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!
|
|
|
|
|
Alex Feature wrote: it's not a good idea to keep the code that does not run the ui inside the form and usercontrol classes
Correct, your business logic should be seperate from presentation logic.
Alex Feature wrote: as it will run on the same thread as the ui and slow down the app.
No, you can put code in the UI layer that runs in another thread, and moving code out to a middle tier won't change it being in the same thread.
Alex Feature wrote: What's the syntax to start a new thread and run specific code on it?
ThreadStart and Thread are the two classes you need.
Sounds to me like you need to google threading in VB.NET and read some articles.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
|
|
|
|
|
Thanks Christian.
NOW! Where is that damn coffe pot...I got some catching up to do! 
The perfect code is always in your head...it just a matter of how hard you bang your head against the wall to get it out!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
