|
Ash_VCPP wrote: I have Dataset having 10 table data. I want to Insert these data into respective tables in SQL Server.i
Good !
Ash_VCPP wrote: i tried with google but didnt get anything useful
See, I did THIS and check the result. 
|
|
|
|
|
oh great work...i can not even think of doing this.my friend if it was that much easy then i had not posted it on forum......my concern is that i have to insert data in multiple tables from a dataset which contains data for multple tables.this time i am expecting specific answer not any funny demo....so please if you can then provide me a solution.
Thanks A Ton
Ash_VCPP
walking over water is just knowing where the stones are.....
|
|
|
|
|
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 ??
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
