Click here to Skip to main content
15,924,935 members
Home / Discussions / ASP.NET
   

ASP.NET

 
GeneralRe: how can i get a row of the grid view Pin
Declan Bright13-Jan-08 22:50
Declan Bright13-Jan-08 22:50 
GeneralRemotely debugging a website on VS2008 Pin
SanderSaares13-Jan-08 21:01
SanderSaares13-Jan-08 21:01 
Questionhow i can make text box second line is to hilighted Pin
jagan12313-Jan-08 20:43
jagan12313-Jan-08 20:43 
AnswerRe: how i can make text box second line is to hilighted Pin
Abhijit Jana13-Jan-08 21:00
professionalAbhijit Jana13-Jan-08 21:00 
GeneralRe: how i can make text box second line is to hilighted Pin
N a v a n e e t h13-Jan-08 21:09
N a v a n e e t h13-Jan-08 21:09 
GeneralRe: how i can make text box second line is to hilighted Pin
Abhijit Jana13-Jan-08 21:26
professionalAbhijit Jana13-Jan-08 21:26 
GeneralRe: how i can make text box second line is to hilighted Pin
N a v a n e e t h13-Jan-08 21:56
N a v a n e e t h13-Jan-08 21:56 
QuestionHow to Insert Multiple Values into a Single Column Pin
Imranlogi13-Jan-08 19:52
Imranlogi13-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

AnswerRe: How to Insert Multiple Values into a Single Column Pin
Malcolm Smart13-Jan-08 20:57
Malcolm Smart13-Jan-08 20:57 
GeneralStoring Values to database from dynamic controls Pin
Radha2713-Jan-08 19:49
Radha2713-Jan-08 19:49 
GeneralRe: Storing Values to database from dynamic controls Pin
N a v a n e e t h13-Jan-08 19:55
N a v a n e e t h13-Jan-08 19:55 
GeneralRe: Storing Values to database from dynamic controls Pin
Radha2713-Jan-08 20:23
Radha2713-Jan-08 20:23 
GeneralRe: Storing Values to database from dynamic controls Pin
N a v a n e e t h13-Jan-08 21:10
N a v a n e e t h13-Jan-08 21:10 
GeneralRe: Storing Values to database from dynamic controls Pin
Radha2713-Jan-08 20:23
Radha2713-Jan-08 20:23 
QuestionDropDownList in GridView Pin
AS@1313-Jan-08 19:15
AS@1313-Jan-08 19:15 
GeneralRe: DropDownList in GridView Pin
N a v a n e e t h13-Jan-08 19:27
N a v a n e e t h13-Jan-08 19:27 
QuestionRe: DropDownList in GridView Pin
AS@1313-Jan-08 19:36
AS@1313-Jan-08 19:36 
QuestionRe: DropDownList in GridView Pin
AS@1313-Jan-08 19:36
AS@1313-Jan-08 19:36 
GeneralRe: DropDownList in GridView Pin
Michael Sync13-Jan-08 19:31
Michael Sync13-Jan-08 19:31 
GeneralRe: DropDownList in GridView Pin
AS@1313-Jan-08 22:12
AS@1313-Jan-08 22:12 
GeneralPaging Button in Datagrid Pin
danasegaranea13-Jan-08 18:55
danasegaranea13-Jan-08 18:55 
GeneralRe: Paging Button in Datagrid Pin
N a v a n e e t h13-Jan-08 19:25
N a v a n e e t h13-Jan-08 19:25 
GeneralRe: Paging Button in Datagrid Pin
danasegaranea13-Jan-08 19:43
danasegaranea13-Jan-08 19:43 
GeneralRe: Paging Button in Datagrid Pin
N a v a n e e t h13-Jan-08 19:46
N a v a n e e t h13-Jan-08 19:46 
GeneralRe: Paging Button in Datagrid Pin
danasegaranea13-Jan-08 20:05
danasegaranea13-Jan-08 20:05 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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