|
GroupBox or Panel from the containers tab in the toolbox.
|
|
|
|
|
Tried that out. But they don't seem to supply a changed-event for the controls within, do they?
One pretty smart solution I found:
Private m_GroupSelectedFileType As RadioButton
Private Sub gbFileTypes_CheckedChanged(ByVal sender As Object, _
ByVal e As EventArgs) Handles _
optAll.CheckedChanged, _
optPicOnly.CheckedChanged, _
optDpxOnly.CheckedChanged
Dim SourceControl As RadioButton = DirectCast(sender, RadioButton)
If SourceControl.Checked Then
m_GroupSelectedFileType = SourceControl
MsgBox("Another RadioButton checked!")
End If
End Sub
it works just fine with a little problem: It already fires when the form is loading.
How can I prevent from that?
modified on Tuesday, March 3, 2009 4:52 PM
|
|
|
|
|
This way it works - maybe it helps someone else:
Private m_gbFileTypesButton As RadioButton
Private Sub gbFileTypes_CheckedChanged(ByVal sender As Object, ByVal e As EventArgs) Handles _
RadioButton1.CheckedChanged, _
RadioButton2.CheckedChanged, _
RadioButton3.CheckedChanged
If Not Me.IsHandleCreated Then Exit Sub
Dim SourceControl As RadioButton = DirectCast(sender, RadioButton)
If SourceControl.Checked Then
m_gbFileTypesButton = SourceControl
MsgBox("Another radio button has been checked!")
Select Case SourceControl.Name
End Select
End If
End Sub
|
|
|
|
|
I use datagridview with last column type button. How I delete last button in datagridview?
|
|
|
|
|
simply use this statement
DataGridView1.Columns.Remove(DataGridView1.Columns(DataGridView1.Columns.Count - 1))
|
|
|
|
|
I want to remove only last Cell in this column not all column or disable this cell
|
|
|
|
|
AFAIK you can not remove a cell from any column.
However it is possible that when user click on this cell, then click event does not work for this cell.
try following
DataGridView1.Rows(DataGridView1.Rows.Count - 2).Cells(DataGridView1.Columns.Count - 1).ReadOnly = True
|
|
|
|
|
I am have an MDI application where I have several child forms that open under the parent MDI form.
When the child form is opened in the MDI parent form it flickers.
The child form has many controls on it which gets filled by querying from the database when the form loads.
Also the child form has a grid displaying all the records from database.
I am using dataset to fetch more than 2000 records from database and bind it to grid.
I am having problem during loading of this form.
I have tried using following to avoid form flickering:
> DoubleBuffering technique
> Using Datareader instead of Dataset for fetching records
> Fetching records from database after form is loaded using Form_Shown() event
and used BackgroundWorker to Asynchronously fetch records from database.
Can anyone please help me out to avoid the form flickering issue.
Thanks in advance !!!!!!!!
|
|
|
|
|
Double buffering, Suspend and Resume layouts are the option I can suggest. Clever fetching of data might help as well. "When" depends on the functionality of your application. Moreover, if you are using a grid, use Dataset. Using reader wont do any change.
After said all this, wait for other replies. I am not sure if my reply is 100% correct.
Time is the best teacher; unfortunately it kills all of its students.
जय हिंद
|
|
|
|
|
Hi!
On which Event of Form are you fetching the data, Can we know that?
Thanks!
Develop2Program & Program2Develop
|
|
|
|
|
Thanks for replying,
I am fetching data during form load event.
|
|
|
|
|
I have a table with 5 columns and one of this column is Autonumber. When I try to insert record give me error. This is my code
strQuery = "insert into rabotnici values(?,?,?,?)"
param1 = New OleDbParameter("@rabotnik_name", OleDbType.VarWChar, 100)
param1.Value = ComboBox1.Text
param2 = New OleDbParameter("@obekt_name", OleDbType.VarWChar, 100)
param2.Value = ComboBox2.Text
param3 = New OleDbParameter("@data_rabota", OleDbType.Date)
param3.Value = DateTimePicker1.Value.ToShortDateString()
param4 = New OleDbParameter("@nadnica", OleDbType.Currency)
param4.Value = FormatCurrency(0, 2)
aCmd = New OleDbCommand(strQuery, aCon)
aCmd.Parameters.Add(param1)
aCmd.Parameters.Add(param2)
aCmd.Parameters.Add(param3)
aCmd.Parameters.Add(param4)
'aCmd.Parameters.Add(param5)
aCmd.ExecuteNonQuery()
aCon.Close()
here i not insert data to autonumber field, because this field is autonumber
|
|
|
|
|
oooo here is the problem
strQuery = "insert into rabotnici (rabotnik_name,obekt_name,data_rabota,nadnica) values(?,?,?,?)"
it worked
|
|
|
|
|
I have used Autonumber field in SQL Server DB. In it I did not use to create parameter for the autonumber field.
The syntax is like this for SQL Server DB
Lets say I have 3 fields from which 1st one is autonumber field
strQuery = "insert into Student(FirstName,LastName) values(@fname,@lname)"
param1 = New SqlParameter("@fname_name", SqlDbType.VarChar, 100)
param1.Value = txtName1.Text
param2 = New SqlParameter("@lname_name", SqlDbType.VarChar, 100)
param2.Value = txtName2.Text
Conn.Open()
Cmd = New SqlCommand(strQuery, Conn)
Cmd.Parameters.Add(param1)
Cmd.Parameters.Add(param2)
Cmd.ExecuteNonQuery()
Conn.Close()
NOTE:
> I have mentioned the Database ColumnNames in which I want to insert the
parameter values.
You too try passing Column Names in the insert query I think so doing so will
solve your problem.
Tell me whether this solution worked or not.
|
|
|
|
|
yes I passing the autonumber column in query thanks
|
|
|
|
|
Ok, before the criticism starts, I need this app to be able to work in Win98. We are being forced to support legacy systems and O/Ss.
I need to call a report using the CR8 via interop. Any report that doesn't utilize a subreport works fine. On reports that contain subreports, I cannot successfully set the .SubReportToChange
with CrystalReport1
'This is where the error occurs. Source: "Exception from HRESULT: 0x800A4FB5"
'SourceTrace: " at Crystal.CrystalCtrl.GetNthSubreportName(Int16 n)\r\n at AxCrystal.AxCrystalReport.GetNthSubreportName(Int16 n)"
.SubreportToChange = .GetNthSubreportName(0S) 'If tried hardcoding the subrpt name which also doesn't work.
'All this code works fine from reports that don't have subreports
.set_LogonInfo(0, "blah blah")
.set_StoredProcParam(0, strTableTemp)
end with
Not sure what to do. .GetNthSubRptName requires a short value but always errs off. Can't set the .SubRportToChange to the actual name because it errs off as well w\ HRESULT: 0x800A4FB6.
Any suggestions, ideas, or 'constructive criticism' are always welcome.
"There's no such thing as a stupid question, only stupid people." - Mr. Garrison
|
|
|
|
|
I want to convert one of my VB6 Project to VB.NET 2005. If it possible how to do that.
|
|
|
|
|
|
Inthe Tools menu of Visual Studio you will find an option call "Upgrade Visual Basic 6 code...". Never used, but should be a good place to start.
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
|
Never tried the options others mentioned. But make one thing sure, any tool will not give you a 100% correct code. Not just syntactically but performancewise as well. Also the ways of doing things in VB6 and then in VB.Net has changed. So you will definitely need to inspect code manually.
Time is the best teacher; unfortunately it kills all of its students.
जय हिंद
|
|
|
|
|
Hello all,
I'm currently writing a Windows Form app, from scratch (VB & SQL2005). It's a client/server job and I want to add some reporting that will query information on my SQLServer 2005 database.
What I want is for users to be able to individually or batch print picking lists, despatch notes etc, but I don't want to have to shove a reportviewer onto the windows form to achieve it (which is what I am currently doing as a halfway house).
I want a user to both be able to click a button on a form to print an individual document for that job, or select a menu option to do a batch print off of all jobs that haven't been picked.
In VFP (my 'native' language you might say) I would simply author a set of reports then in my code select out my data for the report I wanted to run and then DO the report. This would send the report to preview or direct to the printer. The reports are compiled into the EXE, so no need to bother with paths etc.
Is it possible to build reports into your project so that I don't have to Load() them with a file path...I would rather DIM them and then send to print...
Again I'm not sure if what I ask is actually do-able...can anyone suggest the best method to use?
Thanks in advance,
LostMonkey
|
|
|
|
|
Hmm I no longer do much reporting but Iwould do the batch process on another thread from the main one. Not sure how the viewer form reachs to being hiddden when processing but it's something to try.
We use Reporting Services and manually launch subscriptions from the client, the server processes and logs the results. Same report can be launched by the UI for individual printing.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Cool! An answer from the more intelligent Holmes brother!! Cheers Mycroft.
I messed around with this and found that I could add a Crystal Report to my project.
Then in code, all I needed to do was: -
Dim oCrystalReport As NameofMyReport
Then I could issue a
NameofMyReport.PrintToPrinter(1, False, 0, 0)
To get the unpopulated report out. So all I'm getting is a blank report with no data but the layout (titles etc) are there.
Next step is to get the data in!
Boy, I never thought I'd see the day when I would miss good ol' VFP's Report Designer bless it!!
LostMonkey
|
|
|
|
|
You are going down the path of insanity, given a choice of using Crystal and eating a bowl of worms - most here would seriously consider the worms.
There was a discussion here, I'll look for it later, along the lines of which report engine to use for stand alone reports (no server installation etc) the winner was DevX and SSRS, the loser by unanimious vote was Crystal.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Try this thread
clickety[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|