|
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.
जय हिंद
|
|
|
|
|
Hello
How i can get the date 6 month late from this date (Now)
thanks in advance
Assaf
|
|
|
|
|
You mean past right ??
DateTime.Now.AddMonths(-6); or future ??
DateTime.Now.AddMonths(6);
|
|
|
|
|
Hello everybody,
in order to group radio buttons (and other controls) I use a class "clsCheckGroup" which inherits GroupBox.
When it comes to using it on a form I face visual differences between other (normal) groupboxes and my "checkgroup" (i.e. font color). In the designer I found that the normal groupboxes implement "me.Groupname.UseVisualStyleBackColor = True" which my class can't implement (error msg: "...is not a member of...").
What would I have to do (i.e. add to my class) in order to use the visual styles?
Thank you
Michael
|
|
|
|
|
I want to create setup that is run for only limited users as microsoft do for limited user or to run cd for limited users in c#
|
|
|
|
|
What? I am not sure what you want. Do you want an installer that can be run a limited number of times or do you want to restrict the number of users that can use your software?
Steve Jowett
-------------------------
Real programmers don't comment their code. If it was hard to write, it should be hard to read.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
