Click here to Skip to main content
15,891,529 members
Home / Discussions / ASP.NET
   

ASP.NET

 
Questionusing membership controls Pin
ABBASI_RA3-Mar-07 9:54
ABBASI_RA3-Mar-07 9:54 
AnswerRe: using membership controls Pin
Haissam3-Mar-07 14:32
Haissam3-Mar-07 14:32 
Questionstoring encryption key Pin
Meysam Mahfouzi3-Mar-07 9:45
Meysam Mahfouzi3-Mar-07 9:45 
AnswerRe: storing encryption key Pin
badgrs3-Mar-07 10:33
badgrs3-Mar-07 10:33 
AnswerRe: storing encryption key Pin
Vasudevan Deepak Kumar4-Mar-07 2:04
Vasudevan Deepak Kumar4-Mar-07 2:04 
Question.net Remoting events in asp.net Pin
koleraba3-Mar-07 4:39
koleraba3-Mar-07 4:39 
AnswerRe: .net Remoting events in asp.net Pin
Parwej Ahamad3-Mar-07 8:13
professionalParwej Ahamad3-Mar-07 8:13 
QuestionCOMMAND not working Pin
govindkedia3-Mar-07 4:19
govindkedia3-Mar-07 4:19 
Hello group,

I am trying this command but i dont know its not working..
its not giving any error...but data is not getting inserted..i have tried to insert breakpoint..but program doesnt stop here..D'Oh! | :doh:
about the databse structure..I am using SQL Server express edition
Site_ID is auto incremental in nature

Code is :

SqlDataSource siteDataSource = new SqlDataSource();
siteDataSource.ConnectionString = ConfigurationManager.ConnectionStrings["ProjectConnectionString"].ToString();

siteDataSource.InsertCommandType = SqlDataSourceCommandType.Text;
siteDataSource.InsertCommand = "INSERT INTO site(Site_Id,Site,Address,City,State,Zip,Country,Date,Institution_Id,Project_id) VALUES (@Site, @Address, @City, @State, @Zip, @Country, @Date, @Institution_Id, @Project_id)";

siteDataSource.InsertParameters.Add("Site_Id", siteidTextBox.ToString());
siteDataSource.InsertParameters.Add("Site", sitenameTextBox.Text);
siteDataSource.InsertParameters.Add("Address", addressTextBox.Text);
siteDataSource.InsertParameters.Add("City", cityTextBox.Text);
siteDataSource.InsertParameters.Add("State", stateTextBox.Text);
siteDataSource.InsertParameters.Add("Zip", zipTextBox.Text);
siteDataSource.InsertParameters.Add("Country", countryTextBox.Text);
siteDataSource.InsertParameters.Add("Date", dateTextBox.ToString());
siteDataSource.InsertParameters.Add("Institution_Id", irbDropDownList.SelectedValue.ToString());
siteDataSource.InsertParameters.Add("Project_id", projectTextBox.ToString());



Kindly Please Tell me where I could Make changes....Smile | :)




Govind
AnswerRe: COMMAND not working Pin
Guffa3-Mar-07 10:48
Guffa3-Mar-07 10:48 
Questionplz help...urgent..? Pin
sathyan_82943-Mar-07 3:08
sathyan_82943-Mar-07 3:08 
AnswerRe: Useless subject [modified] Pin
Guffa3-Mar-07 4:59
Guffa3-Mar-07 4:59 
QuestionClass for looping every Character of string Pin
chitra4sat3-Mar-07 1:03
chitra4sat3-Mar-07 1:03 
AnswerRe: Class for looping every Character of string Pin
Abisodun3-Mar-07 2:30
Abisodun3-Mar-07 2:30 
AnswerRe: Class for looping every Character of string Pin
Guffa3-Mar-07 8:40
Guffa3-Mar-07 8:40 
Questionhow pictures are automatically changed in background by we typing date using javascript? [modified] Pin
sathyan_82942-Mar-07 23:21
sathyan_82942-Mar-07 23:21 
AnswerRe: how pictures are automatically changed in background by we typing date using javascript? Pin
Vasudevan Deepak Kumar4-Mar-07 2:06
Vasudevan Deepak Kumar4-Mar-07 2:06 
Questionupdating the updatepanel when clikcing the menu Pin
Member 38838322-Mar-07 22:42
Member 38838322-Mar-07 22:42 
AnswerRe: updating the updatepanel when clikcing the menu Pin
badgrs3-Mar-07 10:36
badgrs3-Mar-07 10:36 
QuestionWho's the expert in ASP.NET Pin
Kusal2-Mar-07 21:32
Kusal2-Mar-07 21:32 
AnswerRe: Who's the expert in ASP.NET Pin
minhpc_bk4-Mar-07 8:32
minhpc_bk4-Mar-07 8:32 
AnswerRe: Who's the expert in ASP.NET Pin
Vasudevan Deepak Kumar6-Mar-07 9:43
Vasudevan Deepak Kumar6-Mar-07 9:43 
QuestionCreating Word Documents with Passwords using ASP.NET Pin
Jijesh.V.R2-Mar-07 21:22
Jijesh.V.R2-Mar-07 21:22 
AnswerRe: Creating Word Documents with Passwords using ASP.NET Pin
Vasudevan Deepak Kumar4-Mar-07 2:07
Vasudevan Deepak Kumar4-Mar-07 2:07 
QuestionRe: Creating Word Documents with Passwords using ASP.NET Pin
Jijesh.V.R4-Mar-07 22:41
Jijesh.V.R4-Mar-07 22:41 
AnswerRe: Creating Word Documents with Passwords using ASP.NET Pin
Vasudevan Deepak Kumar6-Mar-07 9:44
Vasudevan Deepak Kumar6-Mar-07 9:44 

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.