Problem with INSERT

I've made customcontrol with 3 textboxes, dropdownlist and button.

here is action for button:

protected void Button1_Click(object sender, EventArgs e) { SqlDataSource1.InsertCommand ="insert INTO P ( Numer, Opis, Koszt, id_kli) VALUES('" + nr.Text +"'" +"," +"'" + opisTB.Text +"'" +"," +"'" + kosztTB.Text +"'" +"," +"'" + DropDownList1.SelectedValue +"');"; SqlDataSource1.Insert(); Button1.Visible =false; }

the problem is it insert 5 row at once

what should i change.

my db looks like:  P(nr_id(PK), Numer, Opis, Koszt, id_kli);

K(id_kli(PK), Name); 

PS

sorry for my english... 

baran:

I've made customcontrol with 3 textboxes, dropdownlist and button.

here is action for button:

protected void Button1_Click(object sender, EventArgs e)
 {
 SqlDataSource1.InsertCommand ="insert INTO P ( Numer, Opis, Koszt, id_kli) VALUES('" + nr.Text +"'" +"," +"'" + opisTB.Text +"'" +"," +"'" + kosztTB.Text +"'" +"," +"'" + DropDownList1.SelectedValue +"');";
 SqlDataSource1.Insert();
 Button1.Visible =false;
 }

the problem is it insert 5 row at once

what should i change.

my db looks like:  P(nr_id(PK), Numer, Opis, Koszt, id_kli);

K(id_kli(PK), Name); 

First of all, you should be using parameterized SQL statements. The code you have there, with concatenating UI-supplied data to a SQL string to be executed, is quite insecure. It opens you up to a possibleSQL Injection attack.

If you need to insert 5 rows, wouldn't you create a loop in your code, executing the SQL statement 5 times, each time with different parameter values?

|||

i don't need to insert 5 rows it makes it and i don't know why and how...

i'm noob just getting started

|||

Hi baran,

In this case, I suspect that this event has been fired several times. Please set a breakpoint to see if it has been fired 5 times. Each time should insert 1 record.

Problem with Embedded Image

Hi,

I have a report with background embedded image. I have placed few textboxes on top of them to display data. Every time I set the location of the textbox, it is behaving strangely by rendering at one location one time and changing location next time when it is rendered. I am viewing it in PDF format.

How can I fix the location of textboxes that renders at one location all the time ?

Thanks,

Shyamkumar123

I am having this problem and others, too. I have a large background image, and I'm placing textboxes on top. I designed it with just dummy data in the textboxes, got it laid out just fine. But after putting actual data in and conditionally hiding some textboxes, the problem shows up in the Preview tab in SQL Studio and in an Adobe Acrobat export. Text boxes do not render in their correct locations.

Furthermore, I cannot get the text box to line up at all where I want it. In the Preview, a textbox will render higher up than I intend. If I move it downward in the Layout tab, the textbox renders much lower than I intend. I have my choice of rendering above or below where I want it, but I just can't render it at the correct location even using direct manipulation of the location attributes of the textbox properties. If I correct a rendering by 0.01 inches, it moves a half inch downward on the rendering and pdf.

Maybe it's a rounding error in the application with regard to the textbox locations... But I had no problems when I laid out the form with plain text in all textboxes and none of them hidden. All textboxes are set to CanGrow = False

Suggestions are welcome...

|||

Shyam,

I found a workaround to my problem. It fixes the problem of Layout not looking like Preview or Export to PDF. I had to set all textboxes to hidden = false. Then instead of making them conditionally hidden, I made them all visible but made the data conditionally empty.

Moral of the story: don't hide textboxes.

Problem with Embedded Image

Hi,

I have a report with background embedded image. I have placed few textboxes on top of them to display data. Every time I set the location of the textbox, it is behaving strangely by rendering at one location one time and changing location next time when it is rendered. I am viewing it in PDF format.

How can I fix the location of textboxes that renders at one location all the time ?

Thanks,

Shyamkumar123

I am having this problem and others, too. I have a large background image, and I'm placing textboxes on top. I designed it with just dummy data in the textboxes, got it laid out just fine. But after putting actual data in and conditionally hiding some textboxes, the problem shows up in the Preview tab in SQL Studio and in an Adobe Acrobat export. Text boxes do not render in their correct locations.

Furthermore, I cannot get the text box to line up at all where I want it. In the Preview, a textbox will render higher up than I intend. If I move it downward in the Layout tab, the textbox renders much lower than I intend. I have my choice of rendering above or below where I want it, but I just can't render it at the correct location even using direct manipulation of the location attributes of the textbox properties. If I correct a rendering by 0.01 inches, it moves a half inch downward on the rendering and pdf.

Maybe it's a rounding error in the application with regard to the textbox locations... But I had no problems when I laid out the form with plain text in all textboxes and none of them hidden. All textboxes are set to CanGrow = False

Suggestions are welcome...

|||

Shyam,

I found a workaround to my problem. It fixes the problem of Layout not looking like Preview or Export to PDF. I had to set all textboxes to hidden = false. Then instead of making them conditionally hidden, I made them all visible but made the data conditionally empty.

Moral of the story: don't hide textboxes.