|
hiii.....
i have a form named sale form.on each n every sale of a product i wanna to update the quantity n totalprice columns of the table named purchaseproduct.can u giv me the code.
wat shud i do.shud i use datareader.i hav tried a bit but dont
know wat to do further.this is the code...
protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection conn = new SqlConnection(GetConnectionString);
string sql = "Select * From PurchaseProduct";
SqlCommand cmd = new SqlCommand(sql, conn);
conn.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
}
}
}
thanks......
|
|
|
|
|
What do you want .Here in the above code,You are reading the values from PurchaseProduct table.
Do you want to update the the table columns?
If yes you can not Like this.Datareader is used just for reading the data.
For updating,
read this one
|
|
|
|
|
After all of the negative ratings on one of your previous threads you're lucky anyone is prepared to help you.
Can I just ask, have you ever undertaken any software development training? Are you a professional developer?
|
|
|
|
|
DoctorMick wrote: After all of the negative ratings on one of your previous threads you're lucky anyone is prepared to help you.
Dude ,Rating is not the only thing for that we are here.We are here to help someone if we can, vice versa because we love to share the knowledge.
|
|
|
|
|
I appreciate that but negative voting everyone when multiple people have gave the right answer is irritating and rude.
|
|
|
|
|
sorryy buddy......
i m new to code project n when anyone gives me totaly negative answer i get annoy...
anyway sorry.ur suggestions are welcome.plz try to solve my problems if u can....
thanks..
|
|
|
|
|
Hi pariofshona,
Your profile says that, you have joined CP today !! So Welcome to Code project
Now, Here code project every body will help you, but atleast you should come with a proper question. The question what ever you have either does not make any sense or you can try to resolve the by searching google.
So from next time when post, just do google before.
One more Important suggestion, If you are new in .NET Era, Please BUY some Basic .NET Books and start reading, practice your self. Then if you have problem come over here.
All the Best !!
|
|
|
|
|
Hi All,
In windows forms we have the datetimepicker control, what is the similar control in ASP.net?
Thanks.
|
|
|
|
|
|
There isn't one. You can use something like the suggestion above, you can roll your own using an asp:Calandar or the ms ajax toolkit has a nice one too.
|
|
|
|
|
|
hiii.....
use calender for this case....
|
|
|
|
|
Hi Team,
I have to do a functional that split a sigle file into multiple files based on pages via asp.net.
If the input file contains Three pages,then the output would be create three different pages with the corresponding contents.
Can anyone help me out from this scenario.
Thanks
Regards
Tarun Singh
Sr. Software Engineer.
mailto:tksingh@zenta.com
|
|
|
|
|
codeproject_Tarun wrote: mailto:tksingh@zenta.com
Marked as Spam.
Sathesh.
Blessed is the season which engages the whole world in a conspiracy of love.
|
|
|
|
|
codeproject_Tarun wrote: Sr. Software Engineer.
Senior software engineers never ask such a vague question. At first they will try to research for possible solutions. If they have any problem on a specific area while implementing, they will came here for help. So do what exactly like a senior software engineer.
|
|
|
|
|
Hai friends
I want to run word application from my aspx page. The scenario is given below.
When I click a command button from aspx page, It opens word application, I will type the contents and on clicking the save button, it gets saved in to predefined file, and word application should close.
Every thing works except closing of word application.
The event available is "DocumentBeforeSave" and I put all the code to save it to a predefined file in this event.
So my question is that, is there any event which works after save ( for closing word application )
Thanks
Shivanandan C V
|
|
|
|
|
I have two textoxes in my form as Password and Retype Password. There is a postback after this,.
The issue is whenever there is a postback, the two textboxes loses value. Is there anyway I can preserve the value and show the same after postback?
please help.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
Why are doing postback aftar Retype Password? because I think its not possible when your textbox mode is set to password.
|
|
|
|
|
It is possible. Probably it would be help somebody. You can use like this:
PasswordTextBox.Attributes.Add("value", PasswordTextBox.Text.Trim());
I got this when I googled for some time and got from forums.asp.net
This will preserve the value even after postback. But I am not sure whether this will invalidate any other action or causes any issue.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
Thanks for sharing it.Please also share any issue you find.
|
|
|
|
|
There is a good reason why the password doesn't get sent back in the postback so I would be wary of setting the value manually. Basically, sending the password back in the postback is a security right, if you right click on your page and view source you can see the password value in plain text, this is obviously not a good thing. If that doesn't bother you, or your organisation, fair enough but personally I wouldn't want my password being sent back in plain text.
|
|
|
|
|
I completely agree with you. This is because I didn't implement the functionality initially. But client requires the same and doesn't want to type again and again since the page have a couple of postbacks.
Success is the good fortune that comes from aspiration, desperation, perspiration and inspiration.
|
|
|
|
|
Can't u give something Like "remember me " option ???
and store pwd and username in a cookie ??
|
|
|
|
|
i use UpdatePanel. It work perfectly.
ma tju
Software Application Engineer
Petaling Jaya,Selangor, Malaysia
Ring Master SB MVP 2008
Petaling Jaya MOP (Otai)
|
|
|
|
|
I 'm trying to add some free web services to my asp.net website.I'm getting Error......System.Net.WebException: The request failed with HTTP status 407: Proxy Authentication Required ( The ISA Server requires authorization to fulfill the request. Access to the Web Proxy filter is denied. ).
What do i need to do access free webservices.....Can any one provide me some sample code .
|
|
|
|