|
The thing is, I need to do it through the application, because the person using it will only be able to use the app, and not the DB.
|
|
|
|
|
If you have VS 2005 Professional, then Crystal Reports is part of that development enviornment. You would build the report using Crystal and have your VB invoke the Crystal report. 
Or am I missing something? 
|
|
|
|
|
I am using VS2008 Express verision.
|
|
|
|
|
I believe that version of Visual Studio does not have Crystal bundled with it; so you can't use that option. Bummer. You may want to investigate XSLT as a reporting option. You could write your report data out as an XML file and use XSLT to make it pretty for the user.
Unfortunately, I have no experience with XSLT. At my previous company I saw one of the other developers use it in a prototype. Check out the technology.
Another option would be to create Excel documents from your VB App.
Instantiate EXCEL like this, Dim ExcelApp As New Excel.Application and manipulate the Cells with loops around your result set. Not easy, but it would work. 
|
|
|
|
|
Yeah, that was my next thought, but I want to avoid using excel for this one.
|
|
|
|
|
Hi,
I have a DataGridView control containing several columns one of which is a CheckBoxColumn. Clicking any of the CheckBoxes in this column fires the CellContentClick event which perfoms a task using the value of the clicked CheckBox. However, the value of the CheckBox doesn't seem to update until the cell loses focus, which is a problem for the task I am trying to achieve.
Anybody help me on this one? Thanks.
EDIT : Sorted it I think using the CommitEdit method of the grid.
modified on Wednesday, August 5, 2009 7:46 AM
|
|
|
|
|
Perhaps you can move the task from the CellContentClick event to the DataGrid's MouseUp event ?
Determine which cell has been clicked there, and because MouseUp happens after the rest, the CheckBox value should be resolved and ready for you to use.
My advice is free, and you may get what you paid for.
|
|
|
|
|
In the CellContentClick event, you will get the updated value in the EditedFormattedValue property of the cell and not in the Value property.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Great, just what I was looking for - thanks 
|
|
|
|
|
For my project, I have setup a small domain, and arranged a LAN connection.
From my domain, when I connect with my Sqlserver 2008 remotely It's connected, no problem.And the application is running good.
But when I run the program, out of domain not in LAN, it's not connecting with my sql server and showing the error,
"A network-related or instance-specific error occurred while establishing a connection to sql server......(provider; Named pipes provider, error: 40- could not open a connection to sql server).
Any ideas to fix this problem ?
Thanks...
|
|
|
|
|
What connection string do you use?
My first thought would be your trying to log in to the sql-server using windows-authentication, try providing a login / pass (usually sa / <set during="" installation=""> works)
|
|
|
|
|
Iam using the followings as connection string
Dim ConStr As String = "Data Source=1.1.1.1; initial Catalog=Employee_Master; User Id=Codeproject; Password=xxxxxxxx"
It's cnnecting under LAN, but not with remote machines.
Thanks
|
|
|
|
|
Sounds like an sql-server issue, from what I can remember you have to specifically allow remote connections to the sql-server.
Maybe better to ask this in the General database[^] forum
|
|
|
|
|
Hi,
I have a console application that gathers order data, and creates and sends email messages to sales people.
I run the application in a scheduled task, and the smtp credentials are simply hard coded:
Dim smtp As New System.Net.Mail.SmtpClient("MySMTPServer.MyDomain.com")
smtp.Credentials = New System.Net.NetworkCredential("MyAccount", "MyPassword", "MyDomain")
I run the job under my own account (with power-user rights), because I have no administrator rights to the domain.
What I am thinking about is, that hard coded credentials are ofcourse not ideal to say the least.
My question is, would it be possible to somehow pass the credentials with which the scheduled task is run, to the application?
Any insights appreciated,
Johan
My advice is free, and you may get what you paid for.
|
|
|
|
|
I don't have a problem with the idea of hard coded credentials, after all it is a service that is making the call. I have a problem with the being YOUR creds, you should have a service account set up to run these services with the permissions appropriate to the service.
What happens when your 30/90 days are up and you have to change you password (you do have a policy that requires password changes )
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The bad news is that we don't have such a policy, the good news is that I don't make the policy.
You have a good point there actually (about the credentials), and as a solution it is much simpler, than the line of thought I found myself stranded upon.
Thanks !
My advice is free, and you may get what you paid for.
|
|
|
|
|
We have a number of accounts set up specifically for different server jobs from SSIS to reporting and some WCF services, this is over and above the accounts that support the sa in each server.
We do have such a policy, even on the servers and their accounts, thakn God I don't have anything to do with it. The have scripts that change the passwords on all the 1000+ servers, including oracle, sql server, sybase and a couple of other breeds. You should see the chaos when they forget to include a new server in the script.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Mycroft Holmes wrote: thank God I don't have anything to do with it.
I am with you on that one.
Mycroft Holmes wrote: We have a number of accounts set up specifically for different server jobs
We are just a small subsidiary company, so I only need to take care of a relatively small amount of jobs that are specific to just us. Though I am sure that our HQ employs a setup similar to what you describe.
I'll be in contact with them about getting a service account like you suggested.
My advice is free, and you may get what you paid for.
|
|
|
|
|
Hi,
Im trying to make a robot player for a game im playing
so far i have been using a program called JoyTokey which transfers joystick strokes to mouse or keyboard events.
1) i tryed using sendkeys when the window is focused
But i get an error: "The specific module could not be found"
2) i tryed using Sendmessage and no affect,
3) when i right click the application on task manager and click "Go To Process"
i get nothing, and i cant find it in the processes in task manager manualy either.
4) when i try hwnd on it i get a number but dont know what to do with it.
any idea how can i solve the problem ?
if i knew how the program JoyToKey works...
thanks.
|
|
|
|
|
See this[^] C# article.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Thanks, ill try it as soon as i get home 
|
|
|
|
|
Hi,
I tryed the application,
it detected the window i want but when i tryed to send a key stroke
it crashed, I looked in the debugging information and guess what i found,
the same error i recieved :"The specific module could not be found"
so i guess he used Sendkeys too (i didnt look in the code, only runed the app)
and its not working with this specific game.
can anyone help ?
|
|
|
|
|
|
I have a VB.NET (VS 2008) main form that shows a second form. The second form has a listbox that has lines of data added for an amortization table based on global variables set in the main form.
The second form has an exit button as its only user control. If the user clicks the exit button while the data is still being calcualted and added to the listbox, the button executes me.close and frmMain.show.
The problem is that if a loan with many months (each month is a line in the listbox) is being displayed, then after the form closes and shows the main form, the second form's code is still running in the background. If I select a new set of loan parameters on the main form while the second form's code is still running, I get an error.
What I need to do is close the second form such that all code running in the form is also killed.
I have also tried this version and the "dispose" does not seem to make any difference.
Private Sub btnCloseAmort_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCloseAmort.Click
Me.Dispose()
frmMain.Show()
End Sub
I will apprechiate any help I can get.
William
|
|
|
|
|
1) how are you loading the 2nd form? as a dialog or?
2) how is it that you can say frmMain? you don't have a circular reference do you (gave form2 the pointer to form1)?
'Never argue with an idiot; they'll drag you down to their level and beat you with experience.' ~ anonymous
'Life's real failure is when you do not realize how close you were to success when you gave up.' ~ anonymous
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
