|
I am likely overlooking something obvious and simple, but need help with this nonetheless. I am able to retrieve data from the database; however, when inserting, I get the following compile error:
Error 1 Cannot implicitly convert type 'int' to 'MTA_pre_test.MTATest.StudentsDataTable' E:\Documents\Visual Studio 2008\Projects\MTA_pre_test\MTA_pre_test\Form1.cs 100 25 MTA_pre_test
Here is the code:
private void btnAddData_Click(object sender, EventArgs e)
{
string fname = txtFname.Text;
string lname = txtLname.Text;
StudentsTableAdapter studentTA = new StudentsTableAdapter();
MTATest.StudentsDataTable studentDT = new MTATest.StudentsDataTable();
studentDT = studentTA.Insert(fname, lname);
txtFname.Text = "";
txtLname.Text = "";
}
Thank you in advance.
modified on Monday, October 6, 2008 1:19 PM
|
|
|
|
|
It seems that studentTA.Insert(fname, lname) returns an int so you have error because your studentDT is a MTATest.StudentsDataTable
While (true) { Human.isLearnable = true; }
|
|
|
|
|
After reading from a page on the msdn site, | have modified my code - this is actually an insert to a different table in the same database. I no longer receive errors; however, the code does not insert the record. I googled and found other people experiencing the same problem, where the code is apparently correct, but the insert (or update, as some found) never happens...
private void btnAddAttend_Click(object sender, EventArgs e)
{
string status = txtStatus.Text;
string desc = txtDesc.Text;
bool charge = chkCharge.Checked;
MTATestTableAdapters.AttendanceTableAdapter attendTA = new AttendanceTableAdapter();
attendTA.Insert(status, desc, charge);
txtStatus.Text = "";
txtDesc.Text = "";
chkCharge.Checked = false;
}
What is odd is that when I do a query to find the row count, it increments as if the data has been added. But, if I search for a particular entry, only those entries I manually added to Access appear...
|
|
|
|
|
I think you should use something like attendTA.Update(); or attendTA.Save(); or attendTA.EnythingLikeThat(); (I don't know clearly  ) but you have to do something like that to save your changes, take a look on MSDN[^] it surely helps.
While (true) { Human.isLearnable = true; }
|
|
|
|
|
With persistence comes success... the original database file was set to always copy to the debug folder, effectively overwriting changes each time the application shut down. By changing the properties of the database file in my project to "Do Not Copy" the problem was solved. Hope this may be of use to someone in the same position some day.
|
|
|
|
|
Congratulations! =D>
Edward Hoad wrote: Hope this may be of use to someone in the same position some day.
Surely it is 
While (true) { Human.isLearnable = true; }
|
|
|
|
|
Hi all!
I am currently trying to get all the installed applications on a Windows XP machine and their associated version numbers. I am using the following class;
mc = new ManagementClass("Win32_Product");
The ManagementClass class returns the majority of installed components on the system. There is however other components that appear when one runs 'Add/Remove Programs' in the control panel that do not appear in the object returned by the constructor above.
As an example;
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\
There are entries in here that are not returned in the ManagementClass presumably because they are two seperate things entirely.
What classes do I need to return 'EVERYTHING' as seen by the 'Add/Remove Programs' dialog under the control panel. Obviously some applications install in different ways which cause the descrepancies I have been seeing.
Any ideas?
|
|
|
|
|
I have a Form that allows the user to view four different DataGridViews that reside in UserControls. I am having a problem when adding a new row and navigating to another DataGridView. The dgv adds the new row to the datasource when exiting the Form but it does not do so when dumping the current UserControl and loading a new one. How can force the dgv to update the new row to the datasource?
Thanks,
Richard
I've used up all my sick days, so today I'm calling in dead.
|
|
|
|
|
why not just 1 dgv? trigger different procedures inside!!!
i really dont understand what you want to achieve?! your data source is a database? why wont you trigger a refresh procedure after edit like "select * from mytable"?
it does work you know!! 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Thank you for your sarcastic reply but my question was not answered. I choose different dgvs because each one has different formats and behavior that would simply make the code too cluttered to jam into one class. As far as the SELECT statement is concerned, it is simply a waste of time and cpu resources to rebind the entire dgv when adding a new row. I hate to think that your standards for efficiency are this lax.
Thanks again for the reply but please try to hold the sarcasm.
I've used up all my sick days, so today I'm calling in dead.
|
|
|
|
|
take it easy  be happy 
i didn´t answer, i placed a question message type like you see in my previous post. I don´t really know if i can help you here.
About the code, i don´t understand what you are trying to achieve.
The new row stuff; you trigger a sql procedure that adds a new record? after that you refresh the dgv and the new record appears, right?
You have 4 dgv in the same "page"? what kind of information you show there?
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
Hey,
In answering your last question, the 4 dgvs are not displayed at the same time. They are loaded as the user navigates through the dataset. For example, if the user is viewing an "Orders" table and wants to navigate to the "Customers" table, they would click on the dgvlink that says: "Customer Info". That action would cause the "Orders" control to close and the "Customers" control to load.
The reason for different dgvs stored in user controls is because they are all formmatted differently.
For example, when I load the "Customers" control, all column header names, column widths, column order, visibility etc. will be set. Storing this logic for multiple dgvs into one is simple too cluttered.
My only question is how do I make the dgv's underlying datasource recognize data that's entered in a new row when the dgv is disposed. As I have stated earlier, exiting the form automatically saves it but removing the control within the form doesn't. If I only knew what events are occurring when the form closes... 
Later,
Richard Blythe
I've used up all my sick days, so today I'm calling in dead.
|
|
|
|
|
ok,
i use more than one dgv but they are in different "pages", so for exemple i add a new record in country_page, exit page, and when i enter customer_page i have a new option (country) in combobox_customercountry.
It seems you need to have all the dgv in the same "page", i never used that before, but i think it doesn´t really matter here to solve problem.
I think it codes the same way!!!
When you say dispose you mean that you disable or set visible=false in dgv, not really dispose it, right?
hey, i dont have a clue, dont get me wrong but, my wild guess is that you are putting more code that you need. 
place another post, maybe you will be your answer
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
I am currently developing an API, which should be public to a number of vendors.
I have an amount of classes, which I share with one of my coworkers, but in order to minimise the objects/methods e.c.t exposed to our vendors we whould like to devide the common code and specific code into two diffrent namespaces, but I would like to be able to subclass classes from one name space to another even though the classes in the commen namespace is declared internal - does anybody have any ides. If I try I get an compiler error saying that I have Inconsistent accessibility
Thanks in advance
Jakob
|
|
|
|
|
You are probably trying to return an internal class from a public method (or similar).
|
|
|
|
|
Actually no! I really want to subclass my classes in the common namespace, but without having to expose them to my vendors or users of the API.
|
|
|
|
|
The short answer is that you can't. You can't derive from a class that has a more restrictive scope than the child class.
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
You could try making the classes public and the methods that you want to be exposed to subclasses protected internal.
|
|
|
|
|
You really can't do it this way. If you want a public class, then the class that it derives from must also be public.
Scott Dorman Microsoft® MVP - Visual C# | MCPD
President - Tampa Bay IASA
[ Blog][ Articles][ Forum Guidelines]
Hey, hey, hey. Don't be mean. We don't have to be mean because, remember, no matter where you go, there you are. - Buckaroo Banzai
|
|
|
|
|
Hi,
I have a small C# code snippet which i want to Unit test in VSTS 2008 .The problem is i am unable to find teh Unit Testing option in VSTS 2008.
I have searched and didnt get a answer for that.
In VS2008 and 2005 we can access Unit Test from Test Menu,but i cant seem to find teh similar in VSTS 2008.Can anybody provide any links.
Thanks in advance.
modified on Monday, October 6, 2008 10:42 AM
|
|
|
|
|
how to run external applications in c#
|
|
|
|
|
|
abiniyam wrote: how to run external applications in c#
System.Diagnostics.Process
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns
|
|
|
|
|
how to run exterrnal applications in c#
|
|
|
|
|
Do you want to do this twice?
xacc.ide - now with TabsToSpaces support IronScheme - 1.0 alpha 4a out now (29 May 2008) ((lambda (x) `((lambda (x) ,x) ',x)) '`((lambda (x) ,x) ',x))
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
