|
hi i get his Error
""An unhandled exception of type 'System.Data.SQlClient.SQlException'
occurred in System.data.dll""
when am trying to update the adapter, and it point in this code
<br />
SqlDataAdapter1.Update(DataSet1, "Property")<br />
What is the Problem,i googled the problem, i saw threads with different Scinerio. Please Help
Vuyiswa
|
|
|
|
|
Vuyiswamb wrote: What is the Problem,i googled the problem, i saw threads with different Scinerio
If you couldn't figure out your scenario yourself from a list of choices, how else do you expect anyone else to do it from you?
Add to this, a woefully inadequate question , which does not tell us how you're updating using the adapter. Do you use the Select command or a separate update command. Is it inline SQL or a SP? Do your modifications break any referential integrity? Do you see any inner exception?
Please look at it from a third person's perspective. Atleast give us enough information to understand and respond to your question.
SG
|
|
|
|
|
Help me to add DataGridView DateTime Picker Column using VB.net 2005
Kalika
|
|
|
|
|
hi kalika,
Perhaps you dont add DatetimePicker Column to Datagrid.however you can take a DateTimePicker control & whenever column(related to date) got focus,then u can set DateTimePicker control location to this cell and on lost focus event pick the value of DateTimePicker & assign it to cell.
Hope this helps
Rupesh Kumar Swami
Software Engineer,
Integrated Solution,
Bikaner (India)
|
|
|
|
|
Basically, you'd be creating your own Column class for the DataGridView. This is NOT for the faint of heart and it would take an entire article to explain it all. But, you need to create 3 classes.
The first, is the Column class for the DataGridView, which will inherit from DataGridViewColumn.
Public Class MyDatePickerColumn
Inherits DataGridViewColumn
The second is a class that will show the cell contents in the datagridview. You really don't want to show an entire calendar month graphic in there, it simply takes up too much screen realestate to show a date. So, you create a class that your column will use to show the data in a presentable form. This class will use the DataGridViewTextBoxCell as a base to build on.
Public Class MyDateCell
Inherits DataGridViewTextBoxCell
The final class is the hard one, the edit control. This one has to handle putting up the datetime picker control and letting the user pick a date. Since this class is expected to supply certain methods that your column control will call, it has to implement a specific interface, call IDataGridViewEditingControl. Since your just going to show a datetime picker control, it's be a good place to start with the class.
Public Class MyDateColumnEditControl
Inherits DateTimePicker
Implements IDataGridViewEditingControl
Want an example? Here it is[^].
|
|
|
|
|
Hi great one's and guru,
Please guys,i need you to explain some few things for me on Microsoft.Net,and they are
1.Client Application
2.Server Application
3.Web Services
4.Developer Tools
5.Integration with existing technologies
thanks guys
|
|
|
|
|
What do you need explained? Your post is vague and the 5 things you want explained, whole books have been written on them. Please elaborate what you need to know about them...
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
Thanks,well please can give direct me to a book,i can get them from or a link to where i can get the answer.Thanks Man
|
|
|
|
|
Take a look around on http://www.amazon.com[^] and start from there
"That's no moon, it's a space station." - Obi-wan Kenobi
|
|
|
|
|
|
Let me explain google.com. It's a great website where you can type general questions and get thousands of answers. Another way to answer your questions is to BUY A BOOK.
__________________
Bob is my homeboy.
|
|
|
|
|
You're starting from less than zero here. If you can't define these things with the help of google, I'm not sure how anyone can help you.
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 )
|
|
|
|
|
hello man,
do you know you are trying to say that, explain me
"whole book of .net" is it so easy???
My good advice is that "JUST READ THE BOOK FIRST" lot of books are avaliable on NET, get them and read,
and then if there is diffculties then "THE CODE PROJECT" welcomes you always ....!
Best of luck
---koolprasad2003
If the answer is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
Alright Thanks man,
But please can you tell me a book i can get answer's from or a link,cause have search google,and i get what am looking for.
Thanks for the help
|
|
|
|
|
Sounds like you have an interview scheduled!!;)
SG
|
|
|
|
|
So, what questions did you actually answer on the rest of your homework/test?
|
|
|
|
|
Hey r u preparing for the Interview?
Please get the Books for .NET there are lot of book savailable in the Market.
Some of the Publications are Wrox, Apress etc.,
Pls hereafterwards don't put the questions like this here?
If we want to explain abt the five topic you have asked it refers to the whole book.
So please be specific in your doubt and ask it here in forum.
Regards,
Satips.
|
|
|
|
|
gday,
i realise its VB 101 again, but was hoping someone could direct me to where I could find out how to use the datepicker . The circumstance is that on my form I have two date pickers and I want to be able to calculate how many nights between the two dates chosen
|
|
|
|
|
The date picker is not the issue. Each date picker will return a DateTime. Subtracting one date time from another results in a TimeSpan, which will give you the value you need.
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 )
|
|
|
|
|
Im not sure exactly what the problem is, but when i fill my dataset using a background worker, the data never shows in my grid...this is not an issue when not using a background worker...any sugestions?
below is the only code in the background worker:
DsCustomersGrid1.Clear()<br />
DsCustomersGrid1.Merge((New DSCustomersGridTableAdapters.SelectAllCustomersForGridTableAdapter).GetData(ZipsCommon.SetupInfo.StoreID, True))
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
|
|
|
|
|
This is because you can't update a control (even it's data) from a seperate thread. You have to Invoke a method on the UI thread to update the control for you.
Create a method on your form that takes the data as a parameter and adds the data to the control. Invoke this method from your background thread and it'll marshal the call to the UI thread to do the work.
|
|
|
|
|
Doesn't this defeat the purpose of a background worker? Invoke would cause the method to run back on the main thread, which would bog down the thread since they have over 50,000 customers that are being loaded into the dataset...Is there a way to do this on a separate thread? I guess I could run it on the background worker and then send each individual row to the main thread one at a time with invoke, that would keep it from bogging down, but it would take so long to load that they would end up having to wait for the grid to load before they could really do anything anyways...any suggestions?
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
|
|
|
|
|
You can load the dataset entirely in the background thread, then Invoke the binding through the UI thread. Personally, I find havin 50,000 records in a DataSet a waste of time if all you're going to do is show a small block of records out of that set or doing some processing on only a small block of that data.
A paging solution would be in order for this...
|
|
|
|
|
I agree with that 100%, unfortunately my boss wants it to show all of the records, with a scroll bar down the right side...I'll try loading the dataset on the background worker and then passing it back through the e.result and merging on the worker complete event. Thanks for the help
Apparently it's not OK to start a bonfire of Microsoft products in the aisles of CompUSA even though the Linuxrulz web site says so
|
|
|
|
|
I am thinking about writing a program for the PPC platform that will populate 4 combo boxes from columns in an excel spreadsheet, and then display a few fields based upon a selection from one of the combo boxes. Does anyone have any good code examples for this?
David Wilkes
|
|
|
|