Update table using bound text box

[gj]

Hi,

I'm trying to update a sql database from a web form using text boxes.
I'm trying to learn C# on my own so I am at a complete loss. I created
my sql connection, data adapter, dataset and data view in the visual
studio designer. I'm trying to keep a history of the record so instead
of editing the record I insert a new record with my changes. Instead
of the changes, it inserts the orginal record. Below is the part of
the code. Any help would be appreiated.

else if (txtTask.Text.T rim() == "1")
{
//assign values to variables
valName = txtName.Text.To String();
valStatus = txtStatus.Text. ToString();
valQuestionsPer Page = short.Parse(txt QuestionsPerPag e.Text);
valRetakeOption = int.Parse(drpRe takeOption.Sele ctedValue);
valPassGrade = short.Parse(txt PassGrade.Text) ;
valAuthor = txtAuthor.Text. ToString();
valUserID = "jongay";
valSortType = int.Parse(drpSo rtType.Selected Value);
valNotifyOption s = int.Parse(drpNo tifyOptions.Sel ectedValue);
valGradeScale = int.Parse(drpGr adeScale.Select edValue);
valNumber = int.Parse(txtAQ QuizID.Text);
valEffectiveDat e = DateTime.Parse( txtEffectiveDat e.Text);
valActivityDate = DateTime.Now;

dsMain.QuizRow drv = dsMain1.Quiz.Ne wQuizRow();

drv.Quiz_Name = valName;
drv.Quiz_Status = valStatus;
drv.Quiz_Questi ons_PerPage = valQuestionsPer Page;
drv.Quiz_PassGr ade = valPassGrade;
drv.Quiz_User_I D = valUserID;
drv.Quiz_Author = valAuthor;
drv.Quiz_Activi ty_Date = valActivityDate ;
drv.SortType_ID = valSortType;
drv.NotifyOptio ns_ID = valNotifyOption s;
drv.GradeScale_ ID = valGradeScale;
drv.RetakeOptio n_ID = valRetakeOption ;
drv.Quiz_Effect ive_Date = valEffectiveDat e;
drv.Quiz_Number = valNumber;

dsMain1.Quiz.Ad dQuizRow(drv);

daQuiz.Update(d sMain1, "Quiz");

} //end if

[Zürcher See]

I think you do a DataBind() of the Controls with the DB before updating it

Let me guess:

In the OnLoad method you fill the DataSet and bind the Controls with it
In the OnClick event you try to update the DB

I'm right?

"gj" <jo****@boystow n.org> schrieb im Newsbeitrag
news:4f******** *************** ***@posting.goo gle.com...

Hi,

I'm trying to update a sql database from a web form using text boxes.
I'm trying to learn C# on my own so I am at a complete loss. I created
my sql connection, data adapter, dataset and data view in the visual
studio designer. I'm trying to keep a history of the record so instead
of editing the record I insert a new record with my changes. Instead
of the changes, it inserts the orginal record. Below is the part of
the code. Any help would be appreiated.

else if (txtTask.Text.T rim() == "1")
{
//assign values to variables
valName = txtName.Text.To String();
valStatus = txtStatus.Text. ToString();
valQuestionsPer Page = short.Parse(txt QuestionsPerPag e.Text);
valRetakeOption = int.Parse(drpRe takeOption.Sele ctedValue);
valPassGrade = short.Parse(txt PassGrade.Text) ;
valAuthor = txtAuthor.Text. ToString();
valUserID = "jongay";
valSortType = int.Parse(drpSo rtType.Selected Value);
valNotifyOption s = int.Parse(drpNo tifyOptions.Sel ectedValue);
valGradeScale = int.Parse(drpGr adeScale.Select edValue);
valNumber = int.Parse(txtAQ QuizID.Text);
valEffectiveDat e = DateTime.Parse( txtEffectiveDat e.Text);
valActivityDate = DateTime.Now;

dsMain.QuizRow drv = dsMain1.Quiz.Ne wQuizRow();

drv.Quiz_Name = valName;
drv.Quiz_Status = valStatus;
drv.Quiz_Questi ons_PerPage = valQuestionsPer Page;
drv.Quiz_PassGr ade = valPassGrade;
drv.Quiz_User_I D = valUserID;
drv.Quiz_Author = valAuthor;
drv.Quiz_Activi ty_Date = valActivityDate ;
drv.SortType_ID = valSortType;
drv.NotifyOptio ns_ID = valNotifyOption s;
drv.GradeScale_ ID = valGradeScale;
drv.RetakeOptio n_ID = valRetakeOption ;
drv.Quiz_Effect ive_Date = valEffectiveDat e;
drv.Quiz_Number = valNumber;

dsMain1.Quiz.Ad dQuizRow(drv);

daQuiz.Update(d sMain1, "Quiz");

} //end if

[gj]

You are right. I do fill the DataSet in the Page_Load method. Then I
do this.Databind() ;. When I fill out the web form and click Submit,
the value in the text box changes back to the orginal value before it
accesses my code in the OnClick event. I bound the textbox to the
DataView in Visual Studio designer using the textbox properties. Did I
do this wrong? Do I need to redo the DataBind() in the OnClick event?

Thanks

"Zürcher See" <aq****@cannabi smail.com> wrote in message news:<Ox******* *******@tk2msft ngp13.phx.gbl>. ..

I think you do a DataBind() of the Controls with the DB before updating it

Let me guess:

In the OnLoad method you fill the DataSet and bind the Controls with it
In the OnClick event you try to update the DB

I'm right?

"gj" <jo****@boystow n.org> schrieb im Newsbeitrag
news:4f******** *************** ***@posting.goo gle.com...

Hi,

I'm trying to update a sql database from a web form using text boxes.
I'm trying to learn C# on my own so I am at a complete loss. I created
my sql connection, data adapter, dataset and data view in the visual
studio designer. I'm trying to keep a history of the record so instead
of editing the record I insert a new record with my changes. Instead
of the changes, it inserts the orginal record. Below is the part of
the code. Any help would be appreiated.

else if (txtTask.Text.T rim() == "1")
{
//assign values to variables
valName = txtName.Text.To String();
valStatus = txtStatus.Text. ToString();
valQuestionsPer Page = short.Parse(txt QuestionsPerPag e.Text);
valRetakeOption = int.Parse(drpRe takeOption.Sele ctedValue);
valPassGrade = short.Parse(txt PassGrade.Text) ;
valAuthor = txtAuthor.Text. ToString();
valUserID = "jongay";
valSortType = int.Parse(drpSo rtType.Selected Value);
valNotifyOption s = int.Parse(drpNo tifyOptions.Sel ectedValue);
valGradeScale = int.Parse(drpGr adeScale.Select edValue);
valNumber = int.Parse(txtAQ QuizID.Text);
valEffectiveDat e = DateTime.Parse( txtEffectiveDat e.Text);
valActivityDate = DateTime.Now;

dsMain.QuizRow drv = dsMain1.Quiz.Ne wQuizRow();

drv.Quiz_Name = valName;
drv.Quiz_Status = valStatus;
drv.Quiz_Questi ons_PerPage = valQuestionsPer Page;
drv.Quiz_PassGr ade = valPassGrade;
drv.Quiz_User_I D = valUserID;
drv.Quiz_Author = valAuthor;
drv.Quiz_Activi ty_Date = valActivityDate ;
drv.SortType_ID = valSortType;
drv.NotifyOptio ns_ID = valNotifyOption s;
drv.GradeScale_ ID = valGradeScale;
drv.RetakeOptio n_ID = valRetakeOption ;
drv.Quiz_Effect ive_Date = valEffectiveDat e;
drv.Quiz_Number = valNumber;

dsMain1.Quiz.Ad dQuizRow(drv);

daQuiz.Update(d sMain1, "Quiz");

} //end if

[Zürcher See]

This is my way:
In the onload method:
-fill the dataset
-if page is postback get the value from the controls and add/update them in
the dataset
-if page is not postback bind controls with the dataset

In the onclick method (for example 'save')
-Use dataadapter to update DB
-Bind controls with the dataset

On_Load()
{
...
FillDataSetWith DataAdapter();
if (!Page.IsPostba ck) BindControls();
else GetValueFromCon trolsAndUpdateD ataSet();
...
}

OnClick_Save()
{
DataAdapterUpda teDataSet();
BindControls();
}

OnClick_New()
{
AddANewRowToThe DataSet();
BindControls();
}

BindControls()
{
... //here bind the controls with the dataset
}
"gj" <jo****@boystow n.org> schrieb im Newsbeitrag
news:4f******** *************** ***@posting.goo gle.com...

You are right. I do fill the DataSet in the Page_Load method. Then I
do this.Databind() ;. When I fill out the web form and click Submit,
the value in the text box changes back to the orginal value before it
accesses my code in the OnClick event. I bound the textbox to the
DataView in Visual Studio designer using the textbox properties. Did I
do this wrong? Do I need to redo the DataBind() in the OnClick event?

Thanks

"Zürcher See" <aq****@cannabi smail.com> wrote in message

news:<Ox******* *******@tk2msft ngp13.phx.gbl>. ..

I think you do a DataBind() of the Controls with the DB before updating it
Let me guess:

In the OnLoad method you fill the DataSet and bind the Controls with it
In the OnClick event you try to update the DB

I'm right?

"gj" <jo****@boystow n.org> schrieb im Newsbeitrag
news:4f******** *************** ***@posting.goo gle.com...

Hi,

I'm trying to update a sql database from a web form using text boxes.
I'm trying to learn C# on my own so I am at a complete loss. I created
my sql connection, data adapter, dataset and data view in the visual
studio designer. I'm trying to keep a history of the record so instead
of editing the record I insert a new record with my changes. Instead
of the changes, it inserts the orginal record. Below is the part of
the code. Any help would be appreiated.

else if (txtTask.Text.T rim() == "1")
{
//assign values to variables
valName = txtName.Text.To String();
valStatus = txtStatus.Text. ToString();
valQuestionsPer Page = short.Parse(txt QuestionsPerPag e.Text);
valRetakeOption = int.Parse(drpRe takeOption.Sele ctedValue);
valPassGrade = short.Parse(txt PassGrade.Text) ;
valAuthor = txtAuthor.Text. ToString();
valUserID = "jongay";
valSortType = int.Parse(drpSo rtType.Selected Value);
valNotifyOption s = int.Parse(drpNo tifyOptions.Sel ectedValue);
valGradeScale = int.Parse(drpGr adeScale.Select edValue);
valNumber = int.Parse(txtAQ QuizID.Text);
valEffectiveDat e = DateTime.Parse( txtEffectiveDat e.Text);
valActivityDate = DateTime.Now;

dsMain.QuizRow drv = dsMain1.Quiz.Ne wQuizRow();

drv.Quiz_Name = valName;
drv.Quiz_Status = valStatus;
drv.Quiz_Questi ons_PerPage = valQuestionsPer Page;
drv.Quiz_PassGr ade = valPassGrade;
drv.Quiz_User_I D = valUserID;
drv.Quiz_Author = valAuthor;
drv.Quiz_Activi ty_Date = valActivityDate ;
drv.SortType_ID = valSortType;
drv.NotifyOptio ns_ID = valNotifyOption s;
drv.GradeScale_ ID = valGradeScale;
drv.RetakeOptio n_ID = valRetakeOption ;
drv.Quiz_Effect ive_Date = valEffectiveDat e;
drv.Quiz_Number = valNumber;

dsMain1.Quiz.Ad dQuizRow(drv);

daQuiz.Update(d sMain1, "Quiz");

} //end if

[gj]

Thanks, I really appreciate your help.

Gayle

"Zürcher See" <aq****@cannabi smail.com> wrote in message news:<ux******* *******@TK2MSFT NGP15.phx.gbl>. ..

This is my way:
In the onload method:
-fill the dataset
-if page is postback get the value from the controls and add/update them in
the dataset
-if page is not postback bind controls with the dataset

In the onclick method (for example 'save')
-Use dataadapter to update DB
-Bind controls with the dataset

On_Load()
{
...
FillDataSetWith DataAdapter();
if (!Page.IsPostba ck) BindControls();
else GetValueFromCon trolsAndUpdateD ataSet();
...
}

OnClick_Save()
{
DataAdapterUpda teDataSet();
BindControls();
}

OnClick_New()
{
AddANewRowToThe DataSet();
BindControls();
}

BindControls()
{
... //here bind the controls with the dataset
}
"gj" <jo****@boystow n.org> schrieb im Newsbeitrag
news:4f******** *************** ***@posting.goo gle.com...

You are right. I do fill the DataSet in the Page_Load method. Then I
do this.Databind() ;. When I fill out the web form and click Submit,
the value in the text box changes back to the orginal value before it
accesses my code in the OnClick event. I bound the textbox to the
DataView in Visual Studio designer using the textbox properties. Did I
do this wrong? Do I need to redo the DataBind() in the OnClick event?

Thanks

"Zürcher See" <aq****@cannabi smail.com> wrote in message

news:<Ox******* *******@tk2msft ngp13.phx.gbl>. ..

I think you do a DataBind() of the Controls with the DB before updating it
Let me guess:

In the OnLoad method you fill the DataSet and bind the Controls with it
In the OnClick event you try to update the DB

I'm right?

"gj" <jo****@boystow n.org> schrieb im Newsbeitrag
news:4f******** *************** ***@posting.goo gle.com...
> Hi,
>
> I'm trying to update a sql database from a web form using text boxes.
> I'm trying to learn C# on my own so I am at a complete loss. I created
> my sql connection, data adapter, dataset and data view in the visual
> studio designer. I'm trying to keep a history of the record so instead
> of editing the record I insert a new record with my changes. Instead
> of the changes, it inserts the orginal record. Below is the part of
> the code. Any help would be appreiated.
>
> else if (txtTask.Text.T rim() == "1")
> {
> //assign values to variables
> valName = txtName.Text.To String();
> valStatus = txtStatus.Text. ToString();
> valQuestionsPer Page = short.Parse(txt QuestionsPerPag e.Text);
> valRetakeOption = int.Parse(drpRe takeOption.Sele ctedValue);
> valPassGrade = short.Parse(txt PassGrade.Text) ;
> valAuthor = txtAuthor.Text. ToString();
> valUserID = "jongay";
> valSortType = int.Parse(drpSo rtType.Selected Value);
> valNotifyOption s = int.Parse(drpNo tifyOptions.Sel ectedValue);
> valGradeScale = int.Parse(drpGr adeScale.Select edValue);
> valNumber = int.Parse(txtAQ QuizID.Text);
> valEffectiveDat e = DateTime.Parse( txtEffectiveDat e.Text);
> valActivityDate = DateTime.Now;
>
> dsMain.QuizRow drv = dsMain1.Quiz.Ne wQuizRow();
>
> drv.Quiz_Name = valName;
> drv.Quiz_Status = valStatus;
> drv.Quiz_Questi ons_PerPage = valQuestionsPer Page;
> drv.Quiz_PassGr ade = valPassGrade;
> drv.Quiz_User_I D = valUserID;
> drv.Quiz_Author = valAuthor;
> drv.Quiz_Activi ty_Date = valActivityDate ;
> drv.SortType_ID = valSortType;
> drv.NotifyOptio ns_ID = valNotifyOption s;
> drv.GradeScale_ ID = valGradeScale;
> drv.RetakeOptio n_ID = valRetakeOption ;
> drv.Quiz_Effect ive_Date = valEffectiveDat e;
> drv.Quiz_Number = valNumber;
>
> dsMain1.Quiz.Ad dQuizRow(drv);
>
> daQuiz.Update(d sMain1, "Quiz");
>
> } //end if