ASP.NET

Re: how i can make text box second line is to hilighted

13-Jan-08 21:09

Abhijit Jana wrote:
Because in textbox , it contain same property for all chartacter as NotePad,

What do you mean ?

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Abhijit Jana13-Jan-08 21:26

Abhijit Jana

13-Jan-08 21:26

What ever font or color or font style you apply to a Notepad it will be same
for conatin of that file, you cant use multiple color to differ character in Notepad
and this is the concept of TextBox.

If you thing about wordpad , it has same features of RichTextBox, as you can apply multiple color
style for differt line etc...

Please Correct me if I am wrong !!!

Thanks

Best Regards
-----------------
Abhijit Jana
View My Latest Article :- SpyNet : Your Network Spy

"Success is Journey it's not a destination"

Re: how i can make text box second line is to hilighted

N a v a n e e t h13-Jan-08 21:56

How to Insert Multiple Values into a Single Column

13-Jan-08 21:56

Abhijit Jana wrote:
you cant use multiple color to differ character in Notepad
and this is the concept of TextBox.

Ohh you mean that. It was not giving clear idea, Yes you are correct, a normal textbox is used for showing/entering plain text.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Imranlogi13-Jan-08 19:52

Imranlogi

13-Jan-08 19:52

Could any one please tell me how to insert multiple values into a single column i want structure something like this

JobNumber SupplyParts

J001 Tyres
Mirrors
Bonnets
Rear Bumper

J002 Side Bumper
Bonnet
Seat Cover

Please tell me how to insert values into the column JobNumber and SupplyParts with a single insert statement where column SupplyParts will have multiple rows and at the same time JobNumber value will be only One.

Currently iam inesrting values like this

string InsertName = "insert into ComplaintSupply" +
"(JobNum, SupplyParts)"
+ "values('" + this.txtSupplyParts1.Text + "'),('" + this.txtSupplyParts2.Text + "'),('" + this.txtSupplyParts3.Text + "'), ('" + this.txtSupplyParts4.Text + "'),('" + this.txtSupplyParts5.Text + "')";
MySqlCommand command = new MySqlCommand(InsertName, ComplaintSupply.con);
ComplaintSupply.dComplaintSupplyAdapter.InsertCommand = command;
//Insert New Record.
ComplaintSupply.dComplaintSupplyAdapter.InsertCommand.ExecuteNonQuery();

In the above code i am inserting multiple rows for SupplyParts column from different 5 textboxes but iam not getting how to insert value for JobNum column taking value from some other text box say txtJobNum.

Any help will be greatly appreciated. I am new with database and could not able to solve this issue from last 1 week
Thanks in Advance

Imran

Re: How to Insert Multiple Values into a Single Column

Malcolm Smart13-Jan-08 20:57

Malcolm Smart

13-Jan-08 20:57

Hi
Your problem is more SQL related than ASP.NET related. I'd post this in the SQL forum. Also, don't build up SQL strings by concatonation. You are wide open to SQL Injection Attacks[^]

Small angry dogs

Storing Values to database from dynamic controls

Radha2713-Jan-08 19:49

Radha27

13-Jan-08 19:49

By default I have 10 rows of dynamically created controls on Page Load. After entering Data, When i click Submit button, only rows in which data entered should be inserted into the database.

I am inserting records based on the table rows count. So, it inserts 10 records even if values are not entered.

protected void btnSubmit_Click(object sender, EventArgs e)
{
int j = tblRunTime.Rows.Count;

for (int c = 0; c < j; c++)
{
string query = " INSERT INTO Time VALUES( ";
query = query + " '" + Request.Form["_dr1" + c.ToString()] + "', ";
query = query + " '" + Request.Form["_dr2" + c.ToString()] + "', ";
query = query + " '" + Request.Form["text1" + c.ToString()] + "', ";
...
query = query + " '" + Request.Form["text8" + c.ToString()] + "', ";
query = query + " '" + f_date_b.Value + "'";
query = query + " )";

}
So, how i can solve this?
Can anyone please help me?

Thanks & Regards,
Radha

Re: Storing Values to database from dynamic controls

N a v a n e e t h13-Jan-08 19:55

Re: Storing Values to database from dynamic controls

13-Jan-08 19:55

In this, you are not checking the value is entered or not. And your controls are dynamically created on page_load, which don't have a viewstate maintained. So you won't get values for those controls. Consider creating it in some other event like (Init). Also read about SQL Injection attacks.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Radha2713-Jan-08 20:23

Radha27

13-Jan-08 20:23

But, I can get values for those controls. If i enter Data for 2 rows and click Submit button, 2 rows will be inserted with the entered values and the remaining 8 rows will be inserted with null values. I dont want that 8 rows to be inserted.

Thanks & Regards,
Radha

Re: Storing Values to database from dynamic controls

N a v a n e e t h13-Jan-08 21:10

Re: Storing Values to database from dynamic controls

13-Jan-08 21:10

Before insertion, check the controls has a value. If not sip it,

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

Radha2713-Jan-08 20:23

Radha27

13-Jan-08 20:23

Thanks & Regards,
Radha

DropDownList in GridView

AS@1313-Jan-08 19:15

13-Jan-08 19:15

hi,

Can anyone tell me how to bind a DataTable Column field to a DropDownList Items which is present in a GridView.
DataTable and GridView is generated at runtime.

A key to every Solution

N a v a n e e t h13-Jan-08 19:27

13-Jan-08 19:27

You need to find DropDown from GridView in GridView's RowDataBound event and bind it.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

AS@1313-Jan-08 19:36

13-Jan-08 19:36

Thanks,

Can I add it like Eval on Bind method as we do for label..

<asp:templatefield headertext="CUST_ID">
<headertemplate>CUST_ID
<itemtemplate>
<asp:label id="lblCustID" text="">]]>' runat="server">

I have the DropDownList instead of Label and CUST_ID is the Column anme present in the DataTable

A key to every Solution

AS@1313-Jan-08 19:36

13-Jan-08 19:36

Thanks,

Can I add it like Eval on Bind method as we do for label..

<asp:templatefield headertext="CUST_ID">
<headertemplate>CUST_ID
<itemtemplate>
<asp:label id="lblCustID" text="">]]>' runat="server">

I have the DropDownList instead of Label and "CUST_ID" is the Column name present in the DataTable

A key to every Solution

Michael Sync13-Jan-08 19:31

Michael Sync

13-Jan-08 19:31

You can add the dropdownlist to the template column at runtime. then, In rowcreated event of Gridview, you can find the dropdownlist that you have added and bind the data.

Thanks and Regards,
Michael Sync ( Blog: http://michaelsync.net)

AS@1313-Jan-08 22:12

Paging Button in Datagrid

13-Jan-08 22:12

hi,
thanks friend..
can u give a sample of code how to it...

A key to every Solution

danasegaranea13-Jan-08 18:55

13-Jan-08 18:55

Hi all,
Can I add Change the PageStyle Button like HTML Buttons in Datagrid using ASP.Net 1.0

Thanks
Dana

N a v a n e e t h13-Jan-08 19:25

13-Jan-08 19:25

You can't add a HTML button there. Use CSS to style current pager links to look like a HTML button.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

danasegaranea13-Jan-08 19:43

13-Jan-08 19:43

Thanks for the reply Navan,
Can I add the sylesheets in the desing view itself ?

Dana

N a v a n e e t h13-Jan-08 19:46

13-Jan-08 19:46

Yes. Datagrid allows you to add a pager style tag.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

My Website | Ask smart questions

danasegaranea13-Jan-08 20:05

13-Jan-08 20:05

Thanks.. I wll have a try

Dana

danasegaranea13-Jan-08 20:26