|
Hello,
i am trying to export data from a vb.net application to an excel spreadsheet. It works but somehow some of the variables are right aligned in their field.
Is there any way to algin a whole column to the left.
I am using Microsoft.Office.Interop
|
|
|
|
|
Worksheet.Columns.HorizontalAlignment property should do that.
Or
((Range)WorkSheet.ColumnsObj[Type.Missing, "A"]).HorizontalAlignment
Not tested though.
|
|
|
|
|
Thanks!
Worksheet.Columns.HorizontalAlignment = = Microsoft.Office.Interop.Excel.XlHAlign.xlHAlignLeft
Worked perfect.
|
|
|
|
|
I have an exe application which is on vb6. I want to remotely push it into different machines and run it as a service there.This service should start as soon as the user logs into his machine.
Please tell me if it can be achieved and how to do it? Thanks.
|
|
|
|
|
As VB6 was always a useless language, and has not been supported for 7 years now, you should put VB6 in your subject, to attract the help of the 3-4 people still using it.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
IMO VB6 was only a useless language for people who can not program. In addition, Microsoft's support for VB6 did not end until March or April of 2008, which is significantly less than 7 years ago. And, FWIW, the name of this message board is 'Visual Basic', not 'VB.NET', so there is no real requirement that individuals specify what flavor of VB they are working with when posting their questions. You don't complain when people who are working with .NET do not specify that in the subject of their questions, so maybe you should consider showing the same respect for those who still work with VB6.
|
|
|
|
|
Member comments reflect the fact that VB6 is not what current day development "should be" done with. If you asked any Microsoft developer what they use in-house, its highly improbable that anyone would state VB6. Sure, some companies and people may not have the resources to convert everything to .Net still and you may be forced to remain on VB6, but the vast majority of developers here use .Net.
paas wrote: so there is no real requirement that individuals specify what flavor of VB they are working with when posting their questions.
The vast majority of members here use .Net and it is assumed if not specified, that's what the orig. poster is using. If not and the poster did not state it as such, you will not get correct answers to your question(s) and yes, probably "encouraged" to move up to .Net as well.
Sorry, such is the way of life with evolution. Adapt to your surroundings or become extinct.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
paas wrote: IMO VB6 was only a useless language for people who can not program.
True. Programmers could use C++ to make COM objects that took up the slack of what VB6 could not do. VB6 itself was DESIGNED for people who cannot program.
paas wrote: And, FWIW, the name of this message board is 'Visual Basic', not 'VB.NET'
Yes, but 99% of the questions are VB.NET. I didn't say 'wrong forum', I said 'you need to tell people on the subject that it's VB6 because people will assume VB.NET until told otherwise'.
paas wrote: In addition, Microsoft's support for VB6 did not end until March or April of 2008, which is significantly less than 7 years ago.
Really ? Well, I know they were eager to bury it right away, I guess enough people complained to drag out it's death.
paas wrote: You don't complain when people who are working with .NET do not specify that in the subject of their questions
No, because VB.NET is a modern, supported language that was designed rather than thrown together. It's what most people use, it's implicit when you say VB today, just like if you said you speak Greek, you'd assume modern, not ancient Greek.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Properly written, you don't. If you want to run an .eXE when a user logs in, this is not done as a service, but as a normal executable running out of the Registry's Run key.
|
|
|
|
|
use the sc.exe in the system32 folder. This will allow you to create, name, and assign an exe to a service. This can be easily done in a small batch script shelled out by the vb or in vbscript. A seperate script is not bad, but this does require to either sleep the thread, run another thread during execution of the script
|
|
|
|
|
I want select my form name from combo box and then
list my selected form controlsname in list box
but selecteditem in combobox is a string and control property for string is not valied
please help me
|
|
|
|
|
I can think of two ways. Either use System.Activator.CreateInstanceFrom or have the value member of the combo as the instance of the form.
|
|
|
|
|
please send me a example for this session
|
|
|
|
|
I assume this means you tried using what I told you yesterday, but don't really know much of anything about C# or winforms. Your forms have a Text property which is the title of the window. You can also use GetType().ToString() to get the name of the class. Either way, you really need to read a basic winforms book, so you can understand the answers you're given
you should also consider reading the posting guide - help me is obviously useless as a title, everyone posting here wants help.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Christian Graus wrote: You can also use GetType().ToString() to get the name of the class.
Could not get this. How can you get the instance of form by the a string variable having its text (I guess this is what he asked) using GetType(). Can you show some example?
|
|
|
|
|
d@nish wrote: How can you get the instance of form by the a string variable having its text (I guess this is what he asked) using GetType().
You don't, that's not what he asked. He asked how to get the open forms, and I said Application.Current.OpenForms ( or something like that ). He's then tried to assign THAT to his combo, instead of getting the strings he wants from there.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
Hi, I've looked in a few places but haven't had much luck in finding what I'm after.
So I have a picturebox on my windows form and it has an image set to it, I also have a bunch of reference files that reference to a bunch of images.
Me.PictureBox1.Image = My.Resources.imgs.image1
That piece of code works.
Now, I tried to databind the picture box to a database so the images would load on the change of a combo box but that got confusing really fast so what I did was created a database and it holds all the image references such as "My.Resources.imgs.image1" but its stored as type varchar(50).
Connecting to the database and retreiving the strings is no problem, that works all fine.
The problem is converting the string to the image reference, it doesn't work. I've tried type casting, I tried using imagelocation rather than image but I want to reference to the resources that is attached to the project.
Can anyone help me with this issue? - Thanks
Here is the full code, incase it helps
Imports System.Data.SqlClient 'before class constructor
Dim SQLStr As String
Private ConnString As String
'after class constructor
'the following is within a sub
ConnString = "Data Source=.\SQLEXPRESS;AttachDbFilename=C:\statsdata.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True"
SQLStr = "SELECT imgreference FROM tblImages WHERE (number = " + Me.ComboBox1.SelectedIndex + ")"
Dim SQLConn As New SqlConnection() 'The SQL Connection
Dim SQLCmd As New SqlCommand() 'The SQL Command
Dim SQLdr As SqlDataReader 'The Local Data Store
Dim text As String
Dim img As Image = Nothing
SQLConn.ConnectionString = ConnString 'Set the Connection String
Try
SQLConn.Open() 'Open the connection
SQLCmd.Connection = SQLConn 'Sets the Connection to use with the SQL Command
SQLCmd.CommandText = SQLStr 'Sets the SQL String
SQLdr = SQLCmd.ExecuteReader() 'Executes SQL Commands Non-Querys only
SQLdr.Read()
text = SQLdr.GetString(0)
SQLdr.Close() 'Close the SQLDataReader
SQLConn.Close() 'Close the connection
'This is where I would change the reference of the image
'E.g. Me.PictureBox1.Image = text - except I have to cast text from type String to type Image
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Information, "Somethings wrong!!")
End Try
|
|
|
|
|
So yea, I posted the same query on another forums and they answered the question 
The answer is the following ::::
If you look at the designer code of the resource file, you will find the following code
Public Shared ReadOnly Property image1() As System.Drawing.Bitmap
Get
Dim obj As Object = ResourceManager.GetObject("image1", resourceCulture)
Return CType(obj,System.Drawing.Bitmap)
End Get
End Property
However, the coding behind our windows form isn't a namespace, so instead of going straight to resource manager, My.Resources.imgs.ResourceManager
so in the code I had above, you can just go
Me.PictureBox1.Image = My.Resources.imgs.ResourceManager.GetObject(text)
|
|
|
|
|
Hello friends
I have two radio buttons view and insert the view radio button display dropdown box, the dropdown box display the records retrieved from the database and displayed.
(i) The first index is empty and the rest of the index is filled with the retrieved data i need the data to be displayed starting the first index.
(ii) When i switch between the view and insert radio button and back to view radio button the data in the dropdown box is doubled for each of the above mentioned cycle
Code:
-----
Public Class Form1
Dim Conn As SqlConnection
Dim Cmd As SqlCommand
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Conn = New SqlConnection
Cmd = New SqlCommand
Conn.ConnectionString = "Data Source=PERSONAL-A0CC22\SQLEXPRESS;Initial Catalog=personal;Integrated Security=True"
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
If (StudentId.Text = "" Or Fname.Text = "" Or Lname.Text = "" Or Address.Text = "" Or Mobile.Text = "" Or EmailId.Text = "") Then
Label1.Text = "Fill In All The Fields"
Label1.Visible = True
Else
Conn.Open()
Cmd = Conn.CreateCommand()
Cmd.CommandText = "Insert into student values('" + StudentId.Text + "', '" + Fname.Text + "', '" + Lname.Text + "', '" + Address.Text + "', '" + Mobile.Text + "', '" + EmailId.Text + "')"
Cmd.ExecuteNonQuery()
StudentId.Text = ""
Fname.Text = ""
Lname.Text = ""
Address.Text = ""
Mobile.Text = ""
EmailId.Text = ""
Label1.Visible = True
Label1.Text = "Data Have Been Stored Sucessfully"
Conn.Close()
End If
End Sub
Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged
TStudentId.Visible = True
StudentId.Visible = False
Button1.Visible = False
Button2.Visible = True
Button3.Visible = True
Dim i As Integer
Dim da As New SqlDataAdapter
Dim ds As New DataSet
Dim dt As New DataTable
Conn.Open()
Cmd = Conn.CreateCommand
Cmd.CommandText = "Select StudentId from Student"
da.SelectCommand = Cmd
da.Fill(ds, "Student")
dt = ds.Tables("Student")
For i = 0 To dt.Rows.Count - 1
TStudentId.Items.Add(dt.Rows(i).Item(0))
Next
Fname.Text = ""
Lname.Text = ""
Address.Text = ""
Mobile.Text = ""
EmailId.Text = ""
Conn.Close()
End Sub
|
|
|
|
|
I think the solution to your problem is quite simple, but I cannot be sure because your code snippet is so badly formatted that it is difficult to read.
Next time you post some code please use the 'code block' widget (below the Text: box). Put the cursor on a new line, click the 'code block' and then paste your code between the opening and closing tags. That way all of your formatting etc. will be retained, making it easier for people to read and therefore more likely that you will get a response.
OK, lecture over. To solve your problem, whilst using your existing code, modify your RadioButton2_CheckedChanged method like this:
Private Sub RadioButton2_CheckedChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles RadioButton2.CheckedChanged
TStudentId.Visible = True
StudentId.Visible = False
Button1.Visible = False
Button2.Visible = True
Button3.Visible = True
Dim i As Integer
Dim da As New SqlDataAdapter
Dim ds As New DataSet
Dim dt As New DataTable
TStudentId.Items.Clear() '<========================= HERE'S the change, get rid of the old stuff before adding the new
Conn.Open()
Cmd = Conn.CreateCommand
Cmd.CommandText = "Select StudentId from Student"
da.SelectCommand = Cmd
da.Fill(ds, "Student")
dt = ds.Tables("Student")
For i = 0 To dt.Rows.Count - 1
TStudentId.Items.Add(dt.Rows(i).Item(0))
Next
Fname.Text = ""
Lname.Text = ""
Address.Text = ""
Mobile.Text = ""
EmailId.Text = ""
Conn.Close()
End Sub
But I have to ask. Why not just set TStudentId.DataSource to dt, rather than use the For..Next loop as you do?
Another lecture coming up, sorry! 
For your own peace of mind, do try to stop using silly member names (da for a DataAdapter, dt for a DataTable), sure you remember what they do now, but in six months you won't. And what are you going to do when you need more than one DataAdapter, use da2? Instead of dt, how about StudentIdTable, or tblStudentID, and so on.
Also RadioButton2, what does it do? Again you know now, but in six months?? And more importantly in this case It took me a lot more reading to work out what was going on than it should have done. Give all members and controls (with the possible exception of Labels) sensible descriptive names. How about rbtnShowId for example 'rbtn' tells me it is a RadioButton 'ShowId' tells me that it shows/hides the Id Dropdown, devise your own naming scheme and stick to it.
It will make your life so much easier in future.
Rant over. Sorry again.
Anyway, good luck!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
Greetings,
I am writing a VB.NET console application that does nothing but read from a SQLServer database and spit out an Excel file. My development box has Windows XP and Office 2003 installed. The target box is running Windows Server 2008 and Office 2007. Everything runs fine on my dev box (of course) but I'm getting this error whenever I run it on the target box: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005.
I felt like I've searched the entire Internet looking for a solution but to no avail. Some solutions that specifically mention that CLSID involve ASP.NET configurations and DCOM properties. Since mine is an executable and not a web page, those solutions don't seem to apply. I went ahead and tried anyway, granting the application's User ID specific permissions to the Excel DCOM object, but that didn't fix my problem. I read somewhere that error 80070005 was a permissions error but the application's User ID is a member of the Admins group so I'd think that user has all the permissions it needs.
Here's part of my current code and a note on which line is causing the failure:
Imports Microsoft.Office.Interop.Excel
Public Function fExportToExcel() As Boolean
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet
Dim missingValue As Object = System.Reflection.Missing.Value
Try
xlApp = New Microsoft.Office.Interop.Excel.Application <code><<== FAILS HERE</code>
xlBook = xlApp.Workbooks.Add(missingValue)
xlSheet = CType(xlBook.Sheets("Sheet1"), Microsoft.Office.Interop.Excel.Worksheet)
xlSheet.Name = My.Application.Info.AssemblyName.ToString
<snip>I've set a reference to the Microsoft Excel 11.0 Object Library in my app. Here are two of it's properties:
Identity {00020813-0000-0000-C000-000000000046}\1.5\0\primary<br />
Path C:\WINDOWS\assembly\GAC\Microsoft.Office.Interop.Excel\11.0.0.0__71e9bce111e9429c\Microsoft.Office.Interop.Excel.dll
I don't quite understand what a CLSID is or how it works. Does it mean anything that my Identity CLSID ({00020813-0000-0000-C000-000000000046}) is different than that in my error message ({00024500-0000-0000-C000-000000000046})?
So is it possible to develop an app using one version of the OS and Office but target a different OS and Office? If so, do I account for those differences in my app or do I have to make some kind of change(s) to the target box? What property or code changes do I need to make? Any help will certainly be appreciated!
Thanks!
Dan
|
|
|
|
|
A CLSID is the id of your COM object. I'd guess the issue is the different versions of Office.
Christian Graus
Driven to the arms of OSX by Vista.
"! i don't exactly like or do programming and it only gives me a headache." - spotted in VB forums.
I can do things with my brain that I can't even google. I can flex the front part of my brain instantly anytime I want. It can be exhausting and it even causes me vision problems for some reason. - CaptainSeeSharp
|
|
|
|
|
You're referencing Excel 11 (2003) where your target is Excel 12 (2007). I would have thought backwards compatability would allow you to still reuse the same code for Excel 2007...
|
|
|
|
|
I'd have thought so too. Any idea how the CLSID factors into that?
|
|
|
|
|
Nope, but I did do some poking around, it might have something to do with permissions.
Try granting your application permission to access the office binaries?
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
