|
Great! Yes, it is clear! 
One question, on your approach it seems we got to have all possible "validation classes" defined before compilation if the method which calls these classes is in the same assembly.
So, how would you handle "future validation classes" that we don't know we need yet.
I guess from your explanation, we could separate the main program which calls these "validation classes" in one assembly, and the validation classes in another assembly.
So, future validation classes get added to the second assembly and recompiled for the first assembly to consume -we need to add this new validation class to the config file as well.
Am I interpreting this correctly or I missed something? 
Thanks for your great feedback!
...Alex
|
|
|
|
|
neualex wrote: Am I interpreting this correctly
Almost.
Usually when you develop and package the application, there will be some default validation classes which are known at compile time. That can be created with your project and have in the same assembly. For future validation classes, you can have it on a separate assembly and supply only that assembly and modify the configuration file to add this new class.
|
|
|
|
|
Gotcha! Thanks for your outstanding feedback!
...Alex
|
|
|
|
|
I am filling my datatable initially and databinding it to data gridview.code is written in button_click event.I am selecting an item from dropdownlist and when the button is clicked it is getting stored in the table.My problem is that the secondly selected item from dropdownlist is overwriting the first selected item instead of appending in the new row.I know some looping has to be done, but how and where?
OleDbCommand pay_cmd2 = new OleDbCommand("select group_details.Group,description_details.Description,description_details.Unit_price from group_details,description_details where description_details.Description='" + descrptndpdnlt .SelectedItem .Value + "' AND group_details.Group_id=(select Group_id from description_details where Description='" + descrptndpdnlt .SelectedItem .Value + "')", con2);
This is my code
da_pay.SelectCommand = pay_cmd2;
da_pay.Fill(ds_pay ,"details");
DataTable pay_dt=ds_pay .Tables ["details"];
con2.Close();
GridView2.DataSource = pay_dt;
GridView2.DataBind();
|
|
|
|
|
Hello
I have no experience with datagrid
But for DataGridView I'm sure about TWO think
1 : you must set the datasource to null before to reassign it
GridView2.DataSource = null;
GridView2.DataSource = pay_dt;
2 : this is not necessary :
GridView2.DataBind();
|
|
|
|
|
Server Error in '/WebSite1' Application.
--------------------------------------------------------------------------------
Syntax error (missing operator) in query expression 'DOCTOR NAME = 'ankit''.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.OleDb.OleDbException: Syntax error (missing operator) in query expression 'DOCTOR NAME = 'ankit''.
Source Error:
Line 175: OleDbCommand cmd4 = new OleDbCommand(query,con1);
Line 176: //cmd4.ExecuteNonQuery
Line 177: dr = cmd4.ExecuteReader();
Line 178: if (dr.Read())
Line 179: {
Source File: c:\Users\Ankit\Documents\Visual Studio 2005\WebSites\WebSite1\Default2.aspx.cs Line: 177
my code is
tring connection1 = ConfigurationManager.AppSettings["conn"];
OleDbConnection con1 = new OleDbConnection(connection1);
con1.Open();
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
OleDbDataReader dr;
string query="select COUNT(*) from appointment where DOCTOR NAME = '" + DropDownList1.SelectedItem + "' ";
OleDbCommand cmd4 = new OleDbCommand(query,con1);
//cmd4.ExecuteNonQuery
dr = cmd4.ExecuteReader();
if (dr.Read())
{
//if (Convert.ToInt16(dr[0]) != 4)
TextBox3.Text = "hello";
TextBox3.Text = dr[0].ToString();
}
|
|
|
|
|
Are you sure it should be 'DOCTOR NAME' with the space? As far as I know, SQL doesn't like having spaces in field names, or at least, not used in the way you have here.
Edit: Looking at your code below, this seems likely. Did you copy and paste this code snippet or copy it out by hand?
Also, try and avoid things like 'plz', it annoys people.
|
|
|
|
|
okk....i got it correct.the problem was with the field name itself.
|
|
|
|
|
You just asked this question, wait for a response or continue to post on that thread don't start a new one.
only two letters away from being an asset
|
|
|
|
|
Arguably, it is a different error. Same set of code though.
|
|
|
|
|
Hi i m developing windows application in C#.net,where i m using datagridview. i want to disply only some of column when the application get execute. right now im storing the column header text, width and displayindex in textfile.and at the time of execute i read the textfile and apply thos header text, width and displayindex to the datagridview
but not displaying in proper manner
plz help me..
thanks
|
|
|
|
|
Do you want to hide the columns, that you dont need ?
If yes :
Sample :
dataGridView1.Columns[1].Visible = false;
|
|
|
|
|
I am using MS VS 2008 and can find the ListView property ContextMenuStrip, but no property for ContextMenu.
How can I activate (show) a ContextMenu when I right-click my ListView please?
|
|
|
|
|
You must set it using code :
listView1.ContextMenu = ... // place your context menu here.
It doesn't show in property windows, because ContextMenu is replaced using ContextMenuStrip since VS2005.
|
|
|
|
|
Many thanks for the heads up. Much appreciated.
|
|
|
|
|
hi,
I was not sure whether to post this message in database forum or C#, plz guide.
I have developed a simple database application which reads records from table and displays them in grid, it runs fine on my system but when I try to run it on client's machine it either gives exception or just crashes. It seems that there is some issue in connection string but I have not been able to identify..
here's some information:
Connection String: Data Source=.\SQLEXPRESS;AttachDbFilename=D:\dev\POS\POS\bin\Release\POS_DB.mdf;Integrated Security=True;User Instance=True;Connect Timeout=200
Exception: "The timeout period elapsed prior to completion of the operation or the server is not responding."
I have tried many things but nothing worked, any kind of help will be appreciated. Thanks,
Regards,
Affan Ahmad Toor
..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!
|
|
|
|
|
Things that occur to me. I'm sure that you will have checked them anyway, but it does no harm to have a reminder.
1) is the SqlExpress on the clients machine running?
2) was it installed with the same settings as the one on your machine?
3) unlikely, but is the path correct? (you should get a different error, if so, but worth checking)
If I think of any others I'll post again.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
hi Henry,
thanks for reply. i dint knew that SQL Express should be installed on client machine. I havnt installed it on client machine, i will try it. Can you please elaborate how can I install SQL Express having same setting? Thanks,
Regards,
Affan Ahmad Toor
..................
QUAIDIAN FOR ONCE, QUAIDIAN FOR EVER!
|
|
|
|
|
For the application to run on the clients machine, it must have access to an Sql Server instance. If one is already there, either on the machine or on the network, then simply change the '.\SQLEXPRESS' part of your connection string to the name of that Sql Server. If not, then install SqlExpress. The biggest problem you will have is to remember the settings you used on your own machine.  Unless you can remember exactly how you did it, just go for the defaults and try it. Don't forget to copy the *.mdf and *.ldf files, unless your application creates them or the installer does it for you.
Good luck!
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
|
|
|
|
|
string connection1 = ConfigurationManager.AppSettings["conn"];
OleDbConnection con1 = new OleDbConnection(connection1);
con1.Open();
OleDbDataAdapter da = new OleDbDataAdapter();
DataSet ds = new DataSet();
OleDbDataReader dr;
OleDbCommand cmd4 = new OleDbCommand("select count(*) from appointment where DOCTOR_NAME = '" + DropDownList1.SelectedItem + "' ";", con1);
dr = cmd4.ExecuteReader();
if (Convert.ToInt32(dr[0]) != 4)
TextBox4.Text = "hello";
am tryin this code but its showing error in the run time.
the error is
Exception Details: System.Data.OleDb.OleDbException: No value given for one or more required parameters.
Source Error:
Line 173:
Line 174: OleDbCommand cmd4 = new OleDbCommand("select count(*) from appointment where DOCTOR_NAME = '" + DropDownList1.SelectedItem + "' ", con1);
Line 175: dr = cmd4.ExecuteReader();
Line 176: if (Convert.ToInt32(dr[0]) != 4)
Line 177: TextBox4.Text = "hello";
can u help me out
|
|
|
|
|
Hi,
is ExecuteReader() the right method to call, your query seems to produce only one number?
BTW: when a complex expression (such as the query string) is involved in a problem statement, I suggest you calculate the expression beforehand and print it out, e.g. using Console.WriteLine, to have a careful look at it (don't use Visual Studio's watch for this, it is confusing everyone with quotes and double quotes).
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
thank you sir....actually i only want the value of the count.how can i get it in some variable.
|
|
|
|
|
Have a look at ExecuteScalar and ExecuteNonQuery; one of those should fit your purpose.
Luc Pattyn [Forum Guidelines] [My Articles]
The quality and detail of your question reflects on the effectiveness of the help you are likely to get.
Show formatted code inside PRE tags, and give clear symptoms when describing a problem.
|
|
|
|
|
Replace
OleDbCommand cmd4 = new OleDbCommand("select count(*) from appointment where DOCTOR_NAME = '" + DropDownList1.SelectedItem + "' ";", con1);
with
<br />
OleDbCommand cmd4 = new OleDbCommand("select count(*) from appointment where DOCTOR_NAME = '" + DropDownList1.SelectedItem.Text + "'", con1);
I Love T-SQL
"Don't torture yourself,let the life to do it for you."
If my post helps you kindly save my time by voting my post.
www.aktualiteti.com
|
|
|
|
|
its still not workin sir...
the error is
Line 173:
Line 174: OleDbCommand cmd4 = new OleDbCommand("select count(*) from appointment where DOCTOR_NAME = '" + DropDownList1.SelectedItem.Text + "' ", con1);
Line 175: dr = cmd4.ExecuteReader();
Line 176: //if (Convert.ToInt16(dr[0]) != 4)
Line 177: TextBox4.Text=dr[0].ToString();
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
