|
Well, again, your code really sucks. You need to abandon this project, and work on something more simple while you are just learning and cannot write commercial quality code. You seem to not know anything about ASP.NET and how it works yet.
haleemasher wrote: ddlCType.DataBind();
Every time you do this, the selected index is reset. I assume you call it in page load, and it therefore runs prior to your event, which is the problem.
haleemasher wrote: string query = "select CouponName,CouponTypeID from CouponType";
DAL Helper = new DAL();
Helper.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
ds = new DataSet();
ds = Helper.ExecuteDataSet(CommandType.Text, query, null);
This is an absolute joke.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
u mean i will write
ddlCType.DataBind(); in page load or i write all my code in pageload????
|
|
|
|
|
I assume this method is being called by pageload now ? What is calling it ?
I am saying if you do this in page load, or any time prior to trying to access the selection, it will reset the selection. In fact, you should use IsPostback blocks to only load the data the first time, after that, it is in viewstate
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I think DataSet and DataTable are the most misused classes in .NET framework. 
|
|
|
|
|
Well, for a class called DAL to require a connection string AND SQL, just beggars belief. The sad thing is, someone somewhere is paying for this code, and I am certain he will ignore what I said, and deliver a project that is poorly written, unmaintainable, and totally insecure.
You have to wonder who is basing their inventory systems, staff management and other vital functions to this sort of third rate beginner code, and, worse, if the bad job being done by these people, will end up reflecting on how dumb managers view you and I, people who have done the work to learn how to write professional code, before presuming to charge money for our efforts.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Christian Graus wrote: and deliver a project that is poorly written, unmaintainable, and totally insecure.
Whatever Christian is pointed out is right but If proper code review is there it won't happen. right?
|
|
|
|
|
i want to submit data in a database using a button (submit) while entering data i got an exceptionDB Exception Error converting data type varchar to numeric plz chk this code and help me that where i is the error.these are its data type
CouponTypeID tiny int
TransactionDate datetime
TransactionTypeID numeric(18,0)
description text
CafeMenu nvarchar(50)
SerialEnd Bigiint
SerialStart Bigint
Price int
TotalSale int
protected void btnSubmit_Click(object sender, EventArgs e)
{
try
{
ErrorMessage.Text = "";
string query = "insert into CouponTransaction(CouponTypeID,TransactionDate,TransactionTypeID,Description,CafeMenu,SerialStart,SerialEnd,Price,
TotalSale)values('" + ddlCType.SelectedValue.ToString() + "','"+ TxtbxDate.Text
+"','"+ddlTtype .SelectedValue .ToString ()+"','"+TxtDes .Text +"',
'"+ddlMenu .SelectedValue+"','"+txtSFrom .Text +"','"+TxtEnd .Text +"','"+Txtprice .Text +"','"+TxtSale .Text +"')";
DAL helper = new DAL();
helper.ConnectionString = ConfigurationManager.AppSettings["ConnectionString"].ToString();
int result = helper.ExecuteNonQuery(CommandType.Text, query, null);
if (result == 1)
ErrorMessage.Text = "Records inserted successfully";
else
ErrorMessage.Text = "Records could not be inserted";
cnx.Close();
}
catch (Exception ex)
{
ErrorMessage.Text = ex.Message;
}
}
|
|
|
|
|
This is horrible code. I hope you're just experimenting to teach yourself, because if someone is paying for this code, they are being robbed.
You should choose a more simple project to experiment with while you are just learning. There's too much going wrong here, too many things to address. Some basic points:
1 - I can erase the database on your website whenever I like, because you have NO security. You need to buy some books and read them, and you need to google injection attacks, there's at least one great article here on CP
2 - you also need to buy a book on ADO.NET and read it. Also, you need to read your error messages, which are in plain english, and either google them, or at least stop to think what they may mean. The issue here, is that you are placing your number in quotes, which means it becomes a string, hence the (very explicit and clear ) error message you are getting
3 - Given that you're accepting numbers in text boxes, are you doing anything to deal with the possibility of someone entering text ? I doubt it, I thnk your code will just blow up
4 - You should write simplified error messages to an end user, not give them an exception verbatim. Log the real error for your own use
5 - your data layer is crap. If it was a real data layer, you would not be writing SQL in the presentation layer, or looking up a connection string. In fact, I can't see what your so called data layer is doing at all.
There's nothign wrong with learning. As I said, if you are doing this for money, you are a liar and a cheat, you have no idea how to program yet. But, if you're learning, then experimenting AND buying books/reading articles is the way to go. Choose something simpler to learn from, get some decent resources, and you will be fine. You're at least a year from writing anything that anyone in their right mind would pay for, however.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Its now working. Thread end
|
|
|
|
|
What a weird response. So, do you mean that you fixed all the security holes and other bugs in your software, or just that you removed the quotes in your SQL ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thanx 4 ur kind suggestions. I will try my best to work on the issues u have mentioned in ur reply.
|
|
|
|
|
I had missed something in ASP.NET.
Looking for info on the below:
1. What's the purpose of tag <%#....%>, we mention in aspx file.
2. WHat's the purpose of template column?
3. Whats'the diff bewteen ItemTemplate and EditItemTemplate
4. What's the diff between <%#Eval("myColumn")%> and <%#Bind("myColumn")%>? Which to use and when?
|
|
|
|
|
Do they not make books where you live ? Does google not work where you live ?
1 - it's for embedding code
2 - to define a template for a databound control
3 - one is to show data and one is to edit data
4 - I'm not sure, but I am certain if I googled I could find out.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
I have a web app that uses cookies. Seems that IE8 doesn't handle having multiple sessions to my application - one session per tab. I think the cookies are part of the problem. Anybody else have this problem? Anyone have a work-around?
Rob
tagyurit.com
|
|
|
|
|
If you're using cookies, I can see how that would be an issue. You'd have to put the session id into the cookie name to have a cookie per session, I'd think.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Currently I have a web hosting solution with "Network Solutions" and I have various sub domains created there. The web sites are all straight HTML and work perfectly.
Now, I want to deploy an ASP.NET application on one of the sub domains and I'm getting a problem because the code-behind can't seem to find my custom class.
I know that the web-server is running IIS 6.0 and .NET 2.0, and I can verify that it will run a simple .aspx page which has a Page_Load code behind of:
Me.TextBox1.Text = Now.ToLongDateString
When I use the following code, Me.TextBox1.Text = HttpContext.Current.Request.PhysicalApplicationPath.ToString() it returns
"E:\0\0\112\153\275968\user\280245\htdocs\"
The twist is that my "hello.aspx" page is deployed in a sub domain in a folder called, "\htdocs\ppsm". This makes me believe that the \htdocs folder is considered the application root directory.
Question: How can I get an ASP.NET applicaiton deployed in \htdocs\ppsm to find the \htdocs\ppsm\bin folder ? Is there something I can do in the web.config ?
Thanks,
David
|
|
|
|
|
You configure IIS to see the subfolder as a seperate web application.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
Thank you for your input.
I've placed a support ticket with my hosting provider requesting that my sub domain folder be listed as an application on their IIS server. I'm finding that Network Solutions is not very supportive relative to ASP.NET application deployments.
I noticed that discountASP.NET is listed under the "ASP.NET Web Hosting" section here on CodeProject. Do you have any exeprience with them ? I'm considering moving hosting providers if I can't get the support I need from my existing provider.
David
|
|
|
|
|
Hello,
i am using the article "Sending SMS using .NET through Web service
By Manoj Kumar C" for sending sms through web ser. but when this application
will run the output show the sms will send successfuly but the msg will not deliver
in the mobile and also not getting an e-mail.
so anybody tell me what i have done to deliver the message sucessfuly.
|
|
|
|
|
This has NOTHING to do with ASP.NET. And yet, it gets asked every day. You need to find a service that will deliver SMS in your area. Most services are unstable, or they cost money.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
If use localhost to send email at first check the directory C(System Drive):\Inetpub\mailroot\Queue . do you get the email message? If not you should configure IIS correctly?
shahdat
|
|
|
|
|
What on EARTH does this have to do with the question that was asked ?
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
The web service that he provided for that article stopped working for almost 3 years from now.. (AFAIK)
You need to find another web service like this which can send sms. If you want it for India, you might use way2sms. 
|
|
|
|
|
But don't forget, if the client is NOT in india, that webservice may not work for them.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
yes... way2sms can send sms only to indian mobiles..
I dont know if there is any service available which can send sms around the globe. 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
