|
Hi,
You can use the HashSet as:
Hashset(Key(Type1), Value (List(Type2)))
Dictionary<string, List<object>> dicElements;
|
|
|
|
|
In datagridview filterpoup tool, combobox for dropdown shows distinct values of the table not gridview. So the combobox some times shows the value not in filtered gridview. For example .
I already removed all the records from datagridview the catagory column 'C' . So no more record in datagridview but when I popup combobox filter , that catagory 'C' still is there . So anybody can advice me how I refresh the combox item after filtering the datagridview.
With thanks
Pol
public void RefreshValues() {
if (!(this.DataGridViewColumn is DataGridViewComboBoxColumn)) {
DataTable DistinctDataTable = this.BoundDataView.ToTable(true, new string[] { this.DataGridViewColumn.DataPropertyName });
DistinctDataTable.DefaultView.Sort = this.DataGridViewColumn.DataPropertyName;
comboBoxValue.DataSource = DistinctDataTable;
}
|
|
|
|
|
Hi everybody,
How can i execute multiple dos commands on a c# function?
Here are my 3 commands to be executed:
"cmd.exe"
"cd c:\"
"TF get $Project_Path"
Last commands is for Team Foundation Server(TFS) to get latest operation for a project.
I've tried to do this operation with the below code but it did not work. Where is the error and how can i do it, run the 2 commands at the same time??
strCmdText1 = @" cd C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE";
strCmdText2 = @"TF get $/Project_Path /recursive";
System.Diagnostics.Process.Start("CMD.exe", strCmdText1);
System.Diagnostics.Process.Start("CMD.exe", strCmdText2);
|
|
|
|
|
Create a batch file containing all the commands and execute that file. What you have done above is to try and execute two totally independent commands, so it probably fails.
Unrequited desire is character building. OriginalGriff
I'm sitting here giving you a standing ovation - Len Goodman
|
|
|
|
|
You should just be able to run "TF" (TF.exe?) with parameters "get $/Project_Path /recursive" in the working directory you want to run it in.
|
|
|
|
|
Hi i want to insert the new XML tag in the existing file.
How can we insert the tag after a particular node using C#4.0
thanks
Harish
|
|
|
|
|
You can use the XmlNode.InsertAfter[^] method to insert new nodes into an xml document.
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
HI THIS IS MY C# PROGRAM I WANT TO GET A BOOLEAN RESULT TRUE OF FALSE I DIDNT FIND ANY ERROR....BUT THE PROB IS ONLY THE EXECPTION PART IS GETTING EXECUTED...ITS A LOGIN PAGE,....
public bool validateuser(User u)
{
bool result = true;
try
{
string validateq = "select count(*) from register where user.username = @username and user.password = @passwd ";
cmd = new SqlCommand(validateq, con);
cmd.Parameters.AddWithValue("@username", u.username);
cmd.Parameters.AddWithValue("@passwd", u.password);
con.Open();
reader = cmd.ExecuteReader();
reader.Read();
int r = Convert.ToInt32(reader[0]);
if (r > 0)
{
result = true;
}
else
{
result = false;
}
return result;
}
catch (Exception ex)
{
result = false;
return result;
}
}
|
|
|
|
|
User is a reserved word, it must be escaped:
...where [user].username = @username and [user].password = @passwd
Do not forget to close your reader, a good place for that is in a finally clause:
try
{
}
catch(Exception ex)
{
}
finally
{
if (reader!=null)
reader.Close()
}
|
|
|
|
|
i tried it but the prob is the if part is not getting executed insted its going to catch part!
|
|
|
|
|
And what's the error message?
|
|
|
|
|
no error message thats making it more bad 
|
|
|
|
|
There must be. If you are going into an exception handler, there has to be an exception.
|
|
|
|
|
s but instead of exception message i have given to return false result ;
|
|
|
|
|
We get that. We still need to know what exception you are currently getting to help diagnose the problem.
|
|
|
|
|
Come on!
What's that catch(Exception ex) thing? There it is. Use the debugger, or show it in a MessageBox, or write it to a log file...
|
|
|
|
|
Can you give an example of your table structure, because the query string doesn't seem right. Is the table you are querying register or user. Personally I think you should be looking to do something like this :- (assumes table where users info is kept is called users, substitute register if that is the correct table)
try
{
string validateq = "SELECT COUNT(userid) FROM users WHERE username = @username AND password = @passwd ";
SqlCommand cmd = new SqlCommand(validateq, con);
cmd.Parameters.AddWithValue("@username", u.UserName);
cmd.Parameters.AddWithValue("@passwd", u.Password);
con.Open();
return Convert.ToInt32(cmd.ExecuteScalar()) > 0;
}
catch (SqlException ex)
{
throw new Exception(ex.Message,ex) ;
}
I hope this helps.
When I was a coder, we worked on algorithms. Today, we memorize APIs for countless libraries — those libraries have the algorithms - Eric Allman
|
|
|
|
|
Reason for my vote of one:
DON'T SHOUT. Using all capitals is considered shouting on the internet, and rude (using all lower case is considered childish). Use proper capitalisation if you want to be taken seriously.
Ideological Purity is no substitute for being able to stick your thumb down a pipe to stop the water
|
|
|
|
|
Another reason for a one-vote: one should NOT swallow exceptions, i.e. have a catch block that does not use the information contained in the exception. At least, log it and look at it, that should allow you to solve your problems yourself.
|
|
|
|
|
Luc Pattyn wrote: Another reason for a one-vote: one should NOT swallow exceptions,
Can't disagree more with that.
This forum is "C#", not "Advanced C# Only".
So the fact someone doesn't know how to write exception handling correctly is a reason for correction not down voting.
|
|
|
|
|
if he doesn't know how to deal with an exception, he should not use a try-catch block. The code shown very much resembles an ON ERROR RESUME NEXT statement.
|
|
|
|
|
If I'm not wrong, your query is wrong and your database provider is throwing an exception that your code is swallowing.
select count(*) from register where user.username = @username and user.password = @passwd
must be rewritten as
select count(*) from register where username = @username and password = @passwd
And don't swallow exceptions, log it and/or display it.
|
|
|
|
|
Along with what the others say, I would use ExecuteScalar and simply cast the result.
return ( (int) cmd.ExecuteScalar() > 0 ) ;
And were I to catch the Exception I'd wrap it another Exception with more information. Something along the lines of:
catch (Exception ex)
{
throw ( new System.Data.DataException ( "validateuser unable to find user " + u.username , ex ) ) ;
}
|
|
|
|
|
You need to display the exception in your catch block.
Something like....
System.Console.WriteLine("Exception=" + e);
That will tell you what the error is and what line it shows up on.
|
|
|
|
|
Hi,
I need to display images from a particular path, in which the images are not stored in the data base.
Can anybody help with some sort of code will be very much helpfull for me.
Thanks in advance
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
