|
You can use ODBC connection for that. By using Transact SQL command like UPDATE or INSERT you will be able to print in Excel file. You can search web for an appropriate ODBC connection to a file code.
B.B.
|
|
|
|
|
|
I had one file template type "file_1.xls".
I need open file this and insert data in sheet of file. But at present because of me haven't been processed.
Can you hepl me and give a examples to me ?
|
|
|
|
|
Hi,
Is it possible to programmatically add menu items and sub menus at run time?
I want to read in the contents of a database when my form is loaded, and add two of the database columns to my menu strip.
At design time, I've added a "View" menu. One of the options beneath it is, "Filter 1", and another is "Filter 2".
I want the column 0 contents of my database to populate a sub menu off the "Filter 1" option, and my column 1 contents to populate a sub menu off "Filter 2".
I'm using VB.NET 2005 Express.
|
|
|
|
|
Yes,
You have to define a new MenuItem object and then add it to another MenuItems items collection. You then also have to enable the required event handlers.
|
|
|
|
|
I have this
Dim img As Image = Image.FromFile("c:\Pics\Frame.gif")
Now how do I place it on the form?
|
|
|
|
|
You would have to use a picture box, like so:
<br />
Dim PicBox As New PictureBox<br />
PicBox.ImageLocation = "c:\Pics\Frame.gif"<br />
Me.Controls.Add(PicBox)<br />
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
A picture box is second easiest, easiest is to set the background image property of the form to the image, but that is harder to control if you don't want it over the entire form. You get the most control by drawing it yourself in a paint message handler.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Thanks for that,
You get the most control by drawing it yourself in a paint message handler.
Just need to go and find out how.
|
|
|
|
|
I am trying to get the DataGridView to show a Column Selected. I want the user to be able to select a column and capture the index to that column??
|
|
|
|
|
You have to deal with DataGridTableStyle and DataGridColumnStyle. Useful hints here [^]
If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler.
-- Alfonso the Wise, 13th Century King of Castile.
|
|
|
|
|
i have two forms say form1 and form2...
on clicking button1 on form1 , form2 gets open...
form2 has 2 two buttons back and close
i have dne coding in this way:
form1 :
button1_click event
dim a as new form2
a.show()
me.hide()
form2:
for close button
me.close()
my problem is on clicking close buttton of form2, form2 gets close
but form1 which is already hidden doesnt close...
i want that wen i click close buttton all the hidden and active forms should close...
and debugging should stop..
thanks for any kind of help.
|
|
|
|
|
Change the Shutdown Mode in your project properties.
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
sorry i am not able to see any option in project property window...
can u explain a little bit more.....
|
|
|
|
|
manni_n wrote: sorry i am not able to see any option in project property window...
Are you using Visual Studio 2.0? If not, then just add Form1.close() to your close button on form2.
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
i am using VS 2003.
and about form1.close()
i have already used this one, its not working telling that refernce to non shares members need object refernce...
i am ussing me.close, but if i apply it on form2 then this works for form2 2 only , form1 still remains hidden..
|
|
|
|
|
manni_n wrote: i have already used this one, its not working telling that refernce to non shares members need object refernce...
It works fine for me. Could you post your full code for the Form2 close button?
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
there is no such great code involved in close button...
i have jst used like...
button2_click()
me.close()
end sub
thats it...
and if i also write form1.close
then its shows the error i told u in previous post....
you do one thing just tell me your way, i'll implement that method...
i just want to close all forms whenevr close button is clicked..
whether its on form2 or any other form say next form form3 or form4.
|
|
|
|
|
Alright, just to make sure, goto your project properties (Project Name Properties). Click Application, from there, you should have an option that says Shutdown Mode (or something similar). If there's no such option, then try the following:
<br />
Dim x As Integer<br />
For x = 0 To (Me.OwnedForms.Length) - 1<br />
Me.OwnedForms(x).Close()<br />
Next x<br />
Trinity: Neo... nobody has ever done this before.
Neo: That's why it's going to work.
|
|
|
|
|
Give this a try. What I've done is added a handler for the child forms formclosed event. This way we know when the child is closed and can close too.
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim a As New Form1
'Register our method (ChildClosed) with the new forms FormClosed event
AddHandler a.FormClosed, AddressOf ChildClosed
a.Show()
End Sub
'When the child closes this method will run which will close the current form
Private Sub ChildClosed(ByVal sender As System.Object, ByVal e As System.Windows.Forms.FormClosedEventArgs)
Me.Close()
End Sub
End Class
***EDIT***
Also what are you doing to go back?
**EDIT2***
Oh, ya. You can also just use 'End' or 'Application.exit' to shutdown everything. I forgot about the easy answer 
|
|
|
|
|
yeah this End and application.exit are working...
well to go back i am coding like this..
suppose i am on form 2 and button "back"
in back_click
dim a as new form1
me.close() ' to close the existing form
a.show()
here thing is a new form1 gets open by this method...
what if i want same form1 which is hidden...??
any idea.?
|
|
|
|
|
You could use the same code I posted earlier. However, instead of closing form1 when the child is closed you would just show it. Form2 doesn't need to worry about form1 at all in this case. When the back button is clicked just call me.close. Form1's method will then get called because you registered that method with form2's closed event.
|
|
|
|
|
The right way to do this, is to have the two forms defined as user controls and showing them both on the one form, your button changes which is visible.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Hi to all,
how can I build the base64_decode in VB.NET?
I have found this code but I don't know how can I use it. The decoded string is an image. How can I display it?
This is the code:
<br />
<br />
Private Const base64 = "abcdefghijklmnopqrstuvwxyzabcdefghijklmnopqrstuvwxyz0123456789+/"<br />
<br />
Private Function base64_decode(ByVal a As String) As String<br />
Dim w1 As Integer<br />
Dim w2 As Integer<br />
Dim w3 As Integer<br />
Dim w4 As Integer<br />
Dim n As Integer<br />
Dim retry As String<br />
<br />
For n = 1 To len(a) Step 4<br />
w1 = mimedecode(mid$(a, n, 1))<br />
w2 = mimedecode(mid$(a, n + 1, 1))<br />
w3 = mimedecode(mid$(a, n + 2, 1))<br />
w4 = mimedecode(mid$(a, n + 3, 1))<br />
If w2 >= 0 Then retry = retry + Chr(((w1 * 4 + Int(w2 / 16)) And 255))<br />
If w3 >= 0 Then retry = retry + Chr(((w2 * 16 + Int(w3 / 4)) And 255))<br />
If w4 >= 0 Then retry = retry + Chr(((w3 * 64 + w4) And 255))<br />
Next<br />
base64_decode = retry<br />
End Function<br />
<br />
Private Function mimedecode(ByVal a As String) As Integer<br />
If Len(a) = 0 Then mimedecode = -1 : Exit Function<br />
mimedecode = InStr(base64, a) - 1<br />
End Function<br />
<br />
This is the encoded image:
<br />
/9j/4AAQSkZJRgABAQAAAQABAAD
I would like to show it in a image control.
Thanks
|
|
|
|
|
You don't have to build it, it's already there. Convert.FromBase64String.
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
