Re: datareader - ASP.NET Discussion Boards

Re: help me , user -defined control

Abhijit Jana10-Jul-09 10:45

Abhijit Jana

10-Jul-09 10:45

you forgot to mention the time Laugh | :laugh:

Results 1 - 10 of about 46,000,000 for asp.net user control. (0.18 seconds)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Insert data from Dataset to Multipule tables in SQLServer

Ash_VCPP10-Jul-09 5:00

Ash_VCPP

10-Jul-09 5:00

Hi All,
I have Dataset having 10 table data. I want to Insert these data into respective tables in SQL Server.i tried with google but didnt get anything useful. so Please suggest me for the same.

Thanks A Ton
Ash_VCPP
walking over water is just knowing where the stones are.....

Re: Insert data from Dataset to Multipule tables in SQLServer

Manas Bhardwaj10-Jul-09 5:16

Manas Bhardwaj

10-Jul-09 5:16

Ash_VCPP wrote:
so Please suggest me for the same.

First you tell me how this is related to ASP.Net? D'Oh! | :doh:

Manas Bhardwaj
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.

Re: Insert data from Dataset to Multipule tables in SQLServer

Ash_VCPP12-Jul-09 21:37

Ash_VCPP

12-Jul-09 21:37

thanx man for your support, i would like to appiciate this answer.....now can you please tell me where i should have posted it?????

Thanks A Ton
Ash_VCPP
walking over water is just knowing where the stones are.....

Re: Insert data from Dataset to Multipule tables in SQLServer

Abhijit Jana10-Jul-09 5:28

Abhijit Jana

10-Jul-09 5:28

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. Wink | ;)

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Re: Insert data from Dataset to Multipule tables in SQLServer

Ash_VCPP12-Jul-09 21:47

Ash_VCPP

12-Jul-09 21:47

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.....

datareader

mylogics10-Jul-09 2:35

mylogics

10-Jul-09 2:35

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......

Re: datareader

Brij10-Jul-09 3:22

Brij

10-Jul-09 3:22

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

Cheers!!
Brij

Check My Latest Article

Re: datareader

DoctorMick10-Jul-09 4:25

DoctorMick

10-Jul-09 4:25

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?

Re: datareader

Brij10-Jul-09 5:21

Brij

10-Jul-09 5:21

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. Smile | :)

Cheers!!
Brij

Check My Latest Article

Re: datareader

DoctorMick10-Jul-09 5:41

DoctorMick

10-Jul-09 5:41

I appreciate that but negative voting everyone when multiple people have gave the right answer is irritating and rude.

Re: datareader

mylogics10-Jul-09 19:22

mylogics

10-Jul-09 19:22

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..

Re: datareader

Abhijit Jana10-Jul-09 5:25

Abhijit Jana

10-Jul-09 5:25

Hi pariofshona,
Your profile says that, you have joined CP today !! So Welcome to Code project Smile | :)

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. Smile | :)

All the Best !!

cheers,
Abhijit
CodeProject MVP
Web Site:abhijitjana.net
View My Recent Article

Datetimepicker

Priya Prk10-Jul-09 1:26

Priya Prk

10-Jul-09 1:26

Hi All,

In windows forms we have the datetimepicker control, what is the similar control in ASP.net?

Thanks.

Re: Datetimepicker

Brij10-Jul-09 1:44

Brij

10-Jul-09 1:44

You can This one

Cheers!!
Brij

Check My Latest Article

Re: Datetimepicker

J4amieC10-Jul-09 2:06

J4amieC

10-Jul-09 2:06

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.

Re: Datetimepicker

Vasudevan Deepak Kumar10-Jul-09 2:34

Vasudevan Deepak Kumar

10-Jul-09 2:34

http://www.dynarch.com/projects/calendar/[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

The woods are lovely, dark and deep,
But I have promises to keep,
And miles to go before I sleep,
And miles to go before I sleep!

Re: Datetimepicker

mylogics10-Jul-09 2:39

mylogics

10-Jul-09 2:39

hiii.....
use calender for this case....

Create Multiple word files based on Pagebreak in SigleFile.

codeproject_Tarun10-Jul-09 1:24

codeproject_Tarun

10-Jul-09 1:24

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

Re: Create Multiple word files based on Pagebreak in SigleFile.

Sathesh Sakthivel10-Jul-09 11:51

Sathesh Sakthivel

10-Jul-09 11:51

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.

Re: Create Multiple word files based on Pagebreak in SigleFile.

Kannan Ar10-Jul-09 16:44

Kannan Ar

10-Jul-09 16:44

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.

Word Automation Error

Shivan Nandan10-Jul-09 1:23

Shivan Nandan

10-Jul-09 1:23

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

Preserver password textbox value even after postback

meeram39510-Jul-09 1:04

meeram395

10-Jul-09 1:04

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.

Re: Preserver password textbox value even after postback

Brij10-Jul-09 2:09

Brij

10-Jul-09 2:09

Why are doing postback aftar Retype Password? because I think its not possible when your textbox mode is set to password.

Cheers!!
Brij

Check My Latest Article

Re: Preserver password textbox value even after postback

meeram39510-Jul-09 2:35

meeram395

10-Jul-09 2:35

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.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.