|
I'm no stranger to programming, but I am brand new to programming with databases. I use MS Visual C# 2005. I have tried making forms with datasets and table adapters and it looks just fine... that is, until I try to make a change.
I have a simple form with a single datagridview. I edit the records, click the Save button on the binding navigator, the tableadapter.Update() method returns the correct number of updated rows, but when I close the program and re-open it, the changes aren't there.
Am I leaving out something? Is there extra code needed? etc.?
Thanks.
|
|
|
|
|
danielhasdibs wrote: Am I leaving out something?
Yes.
danielhasdibs wrote: Is there extra code needed?
Yes.
danielhasdibs wrote: etc.?
Yes.
Seriously though, there are any number of things that could be wrong. Is your query for fetching the data to initialize your grid view somehow filtering out the new rows? Are your updates part of a transaction that is never committed? If you are running SQL Server and have all the client tools, see if you can run "SQL Profiler" to see what queries are being run when you save your data.
--
gleat
http://blogorama.nerdworks.in[ ^]
-- Number Two's eyes narrowed and became what are known in the Shouting and Killing People trade as cold slits, the idea presumably being to give your opponent the impression that you have lost your glasses or are having difficulty keeping awake. Why this is frightening is an, as yet, unresolved problem. -- HHGTG
|
|
|
|
|
Well, can you provide a sample of the code so folks can see what is going on?
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Here is what I do:
I open a new project,
I create a database,
I enter one table into the database,
I add three or four records to the table,
I add the database as a data source,
I drag the table from the data source to the form to create a datagridview,
I run the program,
I edit/add records on the form and click the Save button from the binding navigator,
I close the program,
I re-open the program,
and the changes are not there.
What am I missing?
Here's the code for the save button click event:
private void customerBindingNavigatorSaveItem_Click(object sender, EventArgs e)
{
this.Validate();
this.customerBindingSource.EndEdit();
this.customerTableAdapter.Update(this.myCompanyDataSet.Customer);
}
|
|
|
|
|
Here is what I do:
I open a new project,
I create a database,
I enter one table into the database,
I add three or four records to the table,
I add the database as a data source,
I drag the table from the data source to the form to create a datagridview,
I run the program,
I edit/add records on the form and click the Save button from the binding navigator,
I close the program,
I re-open the program,
and the changes are not there.
What am I missing?
|
|
|
|
|
I found the answer:
SOLUTION:
1. Right Click Properties on tablename.mdf in Solution Explorer
2. Set the "Copy to Output Directory" property to "Copy if newer"
3. Run the program, and it should work in the IDE.
|
|
|
|
|
Hi Daniel,
In C# i add/edit/delete database data by triggering store_procedures with help of a partcular event(most times a buttom_click).
I really don´t edit the way you said because it accepts everthing, so i don´t do that stuff. I always create conditions!!! so that method doesn´t apply to me.
So, i dont know if you have already your anwser, but remember that you are editing a database not the datagrdview!!! 
nelsonpaixao@yahoo.com.br
trying to help & get help
|
|
|
|
|
In my c# 2005 windows form application I have a timer that pulls data from a mssql 2005 database. The query and code works fine most of the time. Occationally the sql connection will time out when connecting to the database or I'll get deadlocked by someone elses program.
What I need to change in my code so if the SQL connections has a exception it will continue to run as if nothing happened or change a label to say timeout. Since the SQL commands run on a timmer it will run again to update it shortly.
private void SQL_Timer_Tick(object sender, EventArgs e)
{
SqlConnection connection = new SqlConnection(connectionString);
connection.Open();
SqlCommand command = new SqlCommand("SELECT site from table);
SqlDataReader reader = command.ExecuteReader();
while (reader.Read())
{
presite.Add(reader.GetString(0));
point.Add(reader.GetString(1));
}
connection.Close();
}
|
|
|
|
|
Catch the Exception.
Oh, I forgot, you'll want to know what the problem was; deep inside the System.Data.SqlClient.SqlException is an error code you can translate.
Among the code included with my database accessor article[^] is the file SqlServerErrorInfo.cs which should be of help.
modified on Tuesday, October 28, 2008 2:19 PM
|
|
|
|
|
I have this activex control in my C# application. It has a method that will allocate a block of memory and return a variant. The variant contains HGLOBAL to the memory. In C++ it is simple to GlobalLock the memory pointer and access the data. How does one do this in C#?
system.object va;
va = object.GetMethod();
|
|
|
|
|
Here is c++ code, want to do same in c#:
COleVariant va;
BYTE *pSrc;
va = m_object.GetMethod();
HGLOBAL h = (HGLOBAL)va.lVal;
pSrc = (BYTE*)GlobalLock(h);
|
|
|
|
|
Hello World !
I want to call(run) my default dial_up connection with C#...
how can this ...
TanX world ...
if(Human.live)
{
Human.peaceful = false;
while(true)
{
Human.love(Human girl, Human Boy);
}
}
|
|
|
|
|
Hello everyone,
My application runs under low privilege account like NetWork Service, but in some specific method I need to have high privilege (e.g. to write to registry or access some local file).
So, I want to change the user privilege of some specific method of a class. Does anyone have any good ideas how to do this in .Net?
thanks in advance,
George
|
|
|
|
|
George_George wrote: Does anyone have any good ideas how to do this in .Net?
Yes.
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://codeproject.freetls.fastly.net/script/Forums/Images/coffee.gif)
|
|
|
|
|
Hi Mark,
Do you mean impersonate?
I have investigated impersonate technologies and it looks good. But two more issues with
impersonate technogies.
http://www.codeproject.com/KB/cs/zetaimpersonator.aspx
- How to manage the password expire issue? (for example, in the current domain, the
policy is for every 6 months, password must be changed);
- Is it possible to impersonate from a high privilege to a low privilege user without
providing password? My concern is to hardcode password in source code.
regards,
George
|
|
|
|
|
George_George wrote: How to manage the password expire issue?
How are you dealing with it on the account the process starts under?
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Sorry Mark!
I do not know what do you mean "dealing with it on the account the process starts under" -- could you say some other words please?
regards,
George
|
|
|
|
|
I have investigated impersonate technologies and it looks good. But two more issues with
impersonate technogies.
http://www.codeproject.com/KB/cs/zetaimpersonator.aspx
- How to manage the password expire issue? (for example, in the current domain, the
policy is for every 6 months, password must be changed);
- Is it possible to impersonate from a high privilege to a low privilege user without
providing password? My concern is to hardcode password in source code.
regards,
George
|
|
|
|
|
I may be wrong, but I don't think a running application can (nor should) elevate its privileges beyond that of the currently logged in user.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
|
I don't care if you *can* or not, I'm saying you shouldn't. User privileges are established for a reason.
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001
|
|
|
|
|
Thanks John,
Are there any technologies which I could use to impersonate? Thanks again! 
regards,
George
|
|
|
|
|
|
Thanks Le Centriste,
I like this comprehensive document. But it does not answer my question. My question is about how to change user privilege in a special method, i.e. impersonate. Do you have any good ideas for solution?
This document you recommended does not answer my question.
regards,
George
|
|
|
|
|
I know this may sound like a stupid question, but my head is completely empty today. 
I have three group boxes whose contents all differ greatly but only one of the three is displayed at any point in time. This leads to my question, does disabling and making not visible free up the memory from a group boxes contents or is there another method which should be used?
Cheers
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
