|
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
|
|
|
|
|
Thanks Mycroft
You have probably saved me a lot of time that I might have spent piddling into the wind!!
I shall crack on with some SSRS tutorials then.
|
|
|
|
|
I'm a newbie so apologies if I'm asking a dumb question.
A colleague showed me a web site VS2008 solution which had a mix of C# controls and other modules in VB code.
I've created a Windows Forms based application and I've found some cool classes in C# that I'd love to use.
Is there any way to do this in the same application.
I'm using VS2008 with .NET 3.5
Thanks in advance
1
|
|
|
|
|
Right click on the node called "References" in your solution-explorer to add a reference to the C#-assembly, and you're good to go 
I are troll
|
|
|
|
|
The C# project is in it's own project so not quite sure which file to add as a reference?
Thanks in advance.
1
|
|
|
|
|
You can either add;
- the generated assembly file, as found in the bin\debug folder,
- the complete .csproj file (by choosing the menu File, Add, Existing Project)
The first method is the easiest to perform, the second method compiles the C# code if you build your own code (updating everything that has changed in the C#-project)
Good luck
I are troll
|
|
|
|
|
ksportz wrote: I've found some cool classes in C#
AFAIK there should not be any difference in the classes available in C# and those in VB.Net unless you wrote it.
In case you have written it and its just a matter of using classes, then create a class library project, compile it to a dll and add as reference.
Time is the best teacher; unfortunately it kills all of its students.
जय हिंद
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
