|
I have a fairly simple winform that has several textBoxes, one listbox and one combobox. I have the listBox bound to a field in a table (table1), when a user clicks on an item in the listBox the textBoxes are bound to that table so they display the other data columns for that record. The comboBox is bound to another table (table2) in the dataset that is merely a lookup table. The "Selected Value" of the combobox is bound to one of the colums in table1. This results in the appropriate value being selected in the combobox list. The comboBox has been changed to type "DropDownList" so the user cant type in the box, they can just select one of the pre-existing values in the comboBox. This all works great. The problem occurs when I try to change the selected value in the comboBox. The value does not update in the database when I call the update() method of the table adapter. If I change one of the textBoxes I call a function that ends the current edit ------this.BindingContext[ds_form_contacts, "table1"].EndCurrentEdit(); ------- then calls table1TableAdapter.Update() . This works fine, but if I change the comboBox, I call the same function and the value for the comboBox does not update. If I change the comboBox value then change one of the textBoxes the newly selected value for the comboBox will get updated in the database. I can post code if it helps. All of the binding was done in the designer in vs2005
thanks, -Kevin
|
|
|
|
|
Oh C# gurus, surely someone has the answer to my burning binding question....
anyone????
anyone????
Bueller????
Please....
-Kevin
|
|
|
|
|
I was able to get one step closer. I added a function to handle the SelectionChangeCommited event. In the function I added code to force the rowstate to be "Modified".
((DataRowView)this.tblgroupsBindingSource.Current).Row.BeginEdit();
Interestingly enough this works only if I select the same value in the comboBox twice in a row. The first time it does not change the rowstate.
Thoughts?
|
|
|
|
|
Sorry, Scratch that. The BeginEdit() has no effect on the situation. I removed it and it still does work when you select the value from the combobox twice in a row.
I put a MessageBox in just after the endcurrentedit() to check the state of the row. The first time through it is Unchanged, but when I select it again it is Modified.
thoughts?
|
|
|
|
|
I have a C# application that calls a MySQL procedure and writes data to the db. All of the fields get populated properly but for the ID field, which is my PK field. It populates the field with an empty string instead of the value. the ID field is a varchar field.
When I try a direct insert through the MySql Query Browser, it populates the field correctly, but when using the C# code/appl. the above issue occurs.
What could the issue be?
|
|
|
|
|
when you use the MySql QB what value does it use to populate the field? and I would have to see the code you are using to call the MySQL procedure.
-Kevin
|
|
|
|
|
Here is the c# code that calles the stored procedure:
public void createUserProcedure(string uId, string lname, string fname, string email, string pswd, DateTime expdate, int secId, char usrStat, DateTime lgn)
{
MySqlCommand cmd = new MySqlCommand();
try
{
DB_Connection conn = new DB_Connection();
cmd.Connection = (MySqlConnection)conn.DBConnect();
cmd.CommandText = "createUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("USERID", uId);
cmd.Parameters["USERID"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_LAST_NAME", lname);
cmd.Parameters["USER_LAST_NAME"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_FIRST_NAME", fname);
cmd.Parameters["USER_FIRST_NAME"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_EMAIL", email);
cmd.Parameters["USER_EMAIL"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_PSWRD", pswd);
cmd.Parameters["USER_PSWRD"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_PASSWORD_EXPIRE_DATE", expdate);
cmd.Parameters["USER_PASSWORD_EXPIRE_DATE"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_SECURITY_LEVEL_ID", secId);
cmd.Parameters["USER_SECURITY_LEVEL_ID"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_STS", usrStat);
cmd.Parameters["USER_STS"].Direction = ParameterDirection.Input;
cmd.Parameters.AddWithValue("USER_UNSUCCESSFULL_LOGIN", lgn);
cmd.Parameters["USER_UNSUCCESSFULL_LOGIN"].Direction = ParameterDirection.Input;
cmd.ExecuteNonQuery();
}
This is how I call the procedure:
DateTime dt = new DateTime();
dt = DateTime.Parse("02/01/2007");
UserDAO test = new UserDAO();
test.createUserProcedure("test","TEST", "tst", "tst@net", null, dt, 1, 'A', dt);
Here is the stored procedure in mysql:
DELIMITER $$
DROP PROCEDURE IF EXISTS `the_vault`.`createUser` $$
CREATE DEFINER=`VAULT_DEV`@`%` PROCEDURE `createUser`(IN USERID varchar(20), IN USER_LAST_NAME VARCHAR(40), IN USER_FIRST_NAME VARCHAR(20), IN USER_EMAIL VARCHAR(50),IN USER_PSWRD VARCHAR(20), IN USER_PASSWORD_EXPIRE_DATE DATETIME, IN USER_SECURITY_LEVEL_ID INT, IN USER_STS VARCHAR(1), IN USER_UNSUCCESSFULL_LOGIN DATETIME)
BEGIN
INSERT INTO USERS VALUES(USER_ID, USER_LAST_NAME, USER_FIRST_NAME, USER_EMAIL, USER_PASSWORD, USER_PASSWORD_EXPIRE_DATE,
USER_SECURITY_LEVEL_ID, USER_STATUS, USER_UNSUCCESSFULL_LOGIN);
END $$
DELIMITER ;
|
|
|
|
|
newbieAl wrote: DROP PROCEDURE IF EXISTS `the_vault`.`createUser` $$
CREATE DEFINER=`VAULT_DEV`@`%` PROCEDURE `createUser`(IN USERID varchar(20), IN USER_LAST_NAME VARCHAR(40), IN USER_FIRST_NAME VARCHAR(20), IN USER_EMAIL VARCHAR(50),IN USER_PSWRD VARCHAR(20), IN USER_PASSWORD_EXPIRE_DATE DATETIME, IN USER_SECURITY_LEVEL_ID INT, IN USER_STS VARCHAR(1), IN USER_UNSUCCESSFULL_LOGIN DATETIME)
BEGIN
INSERT INTO USERS VALUES(USER_ID, USER_LAST_NAME, USER_FIRST_NAME, USER_EMAIL, USER_PASSWORD, USER_PASSWORD_EXPIRE_DATE,
USER_SECURITY_LEVEL_ID, USER_STATUS, USER_UNSUCCESSFULL_LOGIN);
END $$
Check the "Bold" values. They are different. Is this an intended difference, or is it a mistake?
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it! 
|
|
|
|
|
I'd say that's it. Everything else looks pretty good.
-Kevin
|
|
|
|
|
Kevin, That was the issue,however why would MySQL still write this record to the table even though tere wasn't a valid USERID value?
|
|
|
|
|
Is the USER_ID field actually set as the PK in MySQL?
You say it is a varchar?
Is it set to Auto Increment?
Is set to not null?
in MySQL QB does the newly inserted value show up as empty or null?
-Kevin
|
|
|
|
|
Yes, PK
Yes, varchar
No it is not set to auto increment
Yes, it is set to not null
in mysql qb it shows up as the value that I passed to the stored procedure
|
|
|
|
|
yes, now that you've fixed it, it should show up as the value you passed. Your question was why did it allow this in the first place? Your original post stated "It populates the field with an empty string instead of the value". That was my question was the value showing up in the db as any empty string or null, before you fixed it? There is a difference. I think your application was posting an empty string and not a null value, thus passing the db's test to not allow nulls. and since you do not have the field set as auto-incrementing an empty string would be a valid unique string. You probably could not run it twice in a row since that would violate the "unique" requirements of a pk. I guess in any event it is working now, eh?
-Kevin
|
|
|
|
|
Yes, it is working. Your analysis is correct. It put an empty string it orig. and not the value.
Thanks for your help!
|
|
|
|
|
Elina, Thank you so much, that was the issue!!
|
|
|
|
|
I have a few questions over speed and threading of the .NET 2.0 web browser control...
1) Which of the following is the "faster" methodology for capturing events HTML events?
a) setting up custom scripting methods (window.external with an ObjectForScripting and ScriptMethods)
b) nabbing HTML elements and setting events to them (.GetElementById() and then adding an event to it)
To me it seems that the more diversity as it can be called from any object by evoking the window.external script object, but if nabbing HTML elements is "quicker" by only monitoring one element instead of waiting on a method call it might be best.?.
2) Also do you think it'll be safe to interact with the web browser control cross thread? or should I make some type of external method in the owner class to interact with the web browser control to be called from the 2nd thread?
(I think I should do the later, but it might not be safe at all.?.)
|
|
|
|
|
I want to move focus to next cell by click on Enter button. I am using DataGridView control ,how?
-- modified at 13:10 Monday 10th September, 2007
welcome in hims.
|
|
|
|
|
hi friend's
i have a method that do below code:
for(int i=0;i<=max;i++)
str+=i.ToString();
i want to create two thread that call this method at a same time.
but i have a problem:
max and str are variables that difference for each thread it means that each thrad must have max and str that contain a difference value from other threads.
what i have to do?
thank you for your guide.
nobody help you...
you have to help you yourself
and this is success way.
|
|
|
|
|
Then don't make them static.
|
|
|
|
|
Hi,
don't use statics for things that are not unique at all. Instead:
make a class that contains some data (str, max) and a method containing your for loop.
have its constructor create a thread calling that method. Now instantiate two objects.
BTW: you did not specify any output, so I will assume the method ends on
Console.WriteLine(str);.
Otherwise you may need some delegate to report results to the original class.
Luc Pattyn [Forum Guidelines] [My Articles]
this weeks tips:
- make Visual display line numbers: Tools/Options/TextEditor/...
- show exceptions with ToString() to see all information
- before you ask a question here, search CodeProject, then Google
|
|
|
|
|
Hi all,
Anyone know how to see the actual xml-document sent by HttpWebRequest when using webservices?
Thanks,
smsmfe
|
|
|
|
|
smsmfe wrote: Anyone know how to see the actual xml-document sent by HttpWebRequest when using webservices?
I have no idea how to do that but if I needed to I would start here[^]
|
|
|
|
|
Hi people
I have an idea for an algorithm, but am gonna need some help in actually implementing it.
What I need to do is read file paths from right to left, comparing all of them, finding the right-most unvarying element of the path.
An example of how I want this algorithm to work is below
C:\Root Dir\Const Sub Dir1\Sub Dir1
C:\Root Dir\Const Sub Dir1\Sub Dir2
C:\Root Dir\Const Sub Dir1
Path scanned was C:\Root Dir\Const Sub Dir1
Any ideas would be greatly appreciated
Cheers
Give me strength, give me caffeine
|
|
|
|
|
How about something like this: split the string into pieces separated by the \ character. You can do this using theString.Split('\\')
Once you've split the string up into an array, you can check the last elements of the array for the differences.
|
|
|
|
|
It will actually be faster to just go left to right, comparing each char as you go. When one of the chars varies, return the current string (as follows):
List<string> paths = new List<string>();
int shortestPathLength;
// Populate paths and shortestPathLength
if (paths.Count == 0) return string.Empty;
string result = string.Empty;
string tempResult = string.Empty;
for (int charIdx = 0; charIdx < shortestPathLength; ++charIdx) {
char c = paths[0][charIdx];
for (int pathIdx = 1; pathIdx < paths.Length; ++pathIdx) {
if (paths[pathIdx][charIdx] != c)
return result;
}
// Not sure if "DirectorySeparator" is the property, but you get the idea
if (c == Path.DirectorySeparator)
result = tempResult;
tempResult += c.ToString();
}
return tempResult;
Hope this helps!
Jeff
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
