|
I am trying to insert data directly from datagridview control.
I have captured dataentry errors by handling datagridview dataerror event.
But when i insert duplicate value in the primary key; this event doesnot get fired.
My code is from MSDN and goes like this:
Private Sub dataGridView1_DataError(ByVal sender As Object,ByVal e As DataGridViewDataErrorEventArgs)Handles dataGridView1.DataError
' If the data source raises an exception when a cell value is ' commited, display an error message.
If e.Exception IsNot Nothing AndAlso e.Context = DataGridViewDataErrorContexts.Commit
Then MessageBox.Show("Value value must be unique.")
End If
End Sub
This code doesnot work.
How to capture this error?
X
|
|
|
|
|
There is probably a better way to code this. For example, if you are using a DataView as your DataSource. You can use the RowFilter property to figure out if the value already exists.
So if you have a DataSet and the first Table is what you are binding to.
dim dv as DataView = yourDataSet.Tables[0].DefaultView
dv.RowFilter = "yourcolumn = "+ yournewvalue
If dv.Count > 0 Then
'You have found a value that already exists...
End If
Otherwise you probably need to check for errors / exceptions on your insert into your dataset. I think that is where the errors would be happening.
The only other thing I can think of is that the primary key isn't set up right in your dataset. That is the column that is set up to be the primary key must have the AllowDBNull property set to false and the Unique property set to true.
Hope that helps.
Ben
|
|
|
|
|
I am now creating a vb.net windows form manually by creating textfiles and rename it to vb.net extension(eg. .vb, .Designer.vb and .resx).
Do there have a way to load this form from any path(location) without needing to add or include this form into the project solution?
Thanks.
123456
|
|
|
|
|
Where do you want to load it from ? I don't think you can create a form class without a solution, although you can create web apps that way.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
Let say I have a form Form1(include in solution), when I click a button 'Create' in Form1, it will create 3 textfile(Form2.vb, Form2.designer.vb, Form2.resx) on the fly which is Form2(not include in solution) located in the same location of Form1.
How do I dynamically load Form2, since Form2 is not included in solution?
-- modified at 2:42 Tuesday 27th March, 2007
-- modified at 2:43 Tuesday 27th March, 2007
123456
|
|
|
|
|
My window application calling a web service to process data. so, if i process little data only, it run perfectly, but if i run around more data, it pop up a message : The operation is timed out", how i solve this problem ? any coding can make solve this problem?
Regards,
Chee ken
|
|
|
|
|
When you create the web service in your windows or web app there is a Timeout property that you can set. It is in miliseconds, so 1 second = 1000. I think if you change this to a larger value you won't get a timeout.
Hope that helps.
Ben
|
|
|
|
|
i have two month records in my table........,
example:
table look like this:
id date remarks
1 02/28/2006 test1
2 02/24/2006 test2
3 03/31/2006 test3
4 03/12/2006 test4
5 03/12/2007 test5
if i tell month on "3" and year on "2006" then it want to display...,
id=3 & 4 only...............,
how to do that....
plz hlp me.....
Regards,
Magesh,
regards,
-- modified at 3:27 Monday 26th March, 2007
Magi
|
|
|
|
|
Hi,
Use the following SQL,
select * from tablename where datepart(yy, [date])=2006 and datepart(mm, [date])=3
it will select all the records having year 2006 nad month 3 depending upon clolumn DATE.
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
Thanks lot...........
Keep in touch...........
Magi
|
|
|
|
|
Can my vb.Net windows application be linked to outlook express or MS-Outlook if yes how can it be done?
|
|
|
|
|
yes. reference microsoft.office.tools.outlook
|
|
|
|
|
hi,
i have a readonly textbox and a FolderBrowserDialog box. I am selecting the file from the dialog box and filling the textbox. The problem is that i have to fill the textbox only for UNC format. How can i check the format?
Pankaj
|
|
|
|
|
Hi All,
Iam Using Datagrid with combobox...If i pressed the Enter key, Combobox values are displayed in Datagrid cell...So i need some Related coding format Pls.... advanced Thanks.........
Thanking you
Somasundaram g
|
|
|
|
|
Hello,
I have added one setup project to my already existing vb.net application.
in this i have included uninstallation routine to uninstall application from
program menu.
Added the following code:
Dim arguments As String() = Environment.GetCommandLineArgs()
Dim argument As String
For Each argument In arguments
If argument.Split("=")(0).ToLower = "/u" Then
Dim guid As String = argument.Split("=")(1)
Dim path As String = _
Environment.GetFolderPath(Environment.SpecialFolder.System)
Dim si As New ProcessStartInfo(path & _
"\msiexec.exe", "/x " & guid)
Process.Start(si)
Close()
Application.Exit()
End
End If
Next
If i mention the path as C:\Program files\MyFiles\MyApp while installing the setup, then how i could i retrieve the same path using above code.
which statement is that. Here i have to remove MyApp Folder with all files which consists of file created after running the exe.
I have added one custom action and beneath its uninstall folder, i added Primary output and sets its argument property to "u" "[TARGETDIR]\".
Please tell at the earliest how the path can be obtain from argument list.
Any help would be highlty appreciated.
Thanks.
|
|
|
|
|
hi there,
i want to write line in textbox through textwriter but vb giving some errors
the coding is:
Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click<br />
Dim a As TextWriter = New StreamWriter(lkj.Text)<br />
a.WriteLine("ssss")<br />
End Sub
can some one tell where is the mistake or problem
|
|
|
|
|
xmen_xwk wrote: lkj.Text
I'd guess that your variable names suck.
It's hard to say more, b/c you didn't tell us what the error is, or what line it occurs on.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
Why on earth would you post an image to a site that shows it to me resized so I can't read it, instead of pasting the text in here ?
It looks like an argument exception ( hard to read ), what is the value of the text going in ? Did you set a breakpoint ?
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
i post image because in text some important info. might be remain
no i dont use any breakpoint ever
|
|
|
|
|
xmen_xwk wrote: i post image because in text some important info.
Yeah, that makes sense
xmen_xwk wrote: no i dont use any breakpoint ever
Do you mean you don't know how ? F9 gives you a breakpoint, the code will stop when it reaches it, and you can examine the state of variables, etc.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
The error says "empty path name is not legal". The text property of lkj is returning an empty string. You need to supply a file to be written too. StreamWriter will not accept an empty string.
|
|
|
|
|
yeah you are right the textbox is empty but man i want to write "ssss" in the textbox
|
|
|
|
|
You don't need a textwriter for that. What you are attempting to do with your code is write the text "sssss" to a file on your harddrive. The file to be written to would be whatever the path is in the textbox. If you want to set the text of the textbox just use:
lkj.text = "ssss"
|
|
|
|
|
yeah buddy, i know this , i want to do this in another way,
my whole problem is that ,i create an application in which Richtextbox contains about 10 lines of numbers
eg.
10
121
153....
and i want to add the textbox`s number which will be enter by user in every line thats why i was asking for textwriter
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
