DataTableAdapter Related Problem

hi guys
i have web application recently i want to add a new column in the database but i am having problem at front end of my application i have updated all the relevant procedures but it doesnt let me add a new column for updating and inserting i have attached the code below.
try
        {
            VideoItemsTableAdapter da = new VideoItemsTableAdapter();
            string _name = name.Text;
            int _gameid = Convert.ToInt32(((DropDownList)gameid.Controls[0]).SelectedValue);
 // adding this following new field
           int _gameidtwo = Convert.ToInt32(((DropDownList)gameidtwo.Controls[0]).SelectedValue);
            int _storyid = Convert.ToInt32(((DropDownList)storyid.Controls[0]).SelectedValue);
            DateTime _expirydate = Convert.ToDateTime(expirydate.Text);
            byte _rating = Convert.ToByte(((DropDownList)rating.Controls[0]).SelectedValue);
            DateTime _length = Helper.FormatVideoLength(length.Text);
            string _videofilename = videofilename.Text;
            byte _cretificate = Convert.ToByte(certificate.Checked ? 1 : 0);
           
           // _gameidtwo
               // [GameIDtwo] @GameIDtwo
            try // trying to update old data
            {
                int RowID = Convert.ToInt32(Request.QueryString["RowID"].ToString());
                da.Update(1, _name, _gameid, _gameidtwo,   _storyid, _expirydate, _rating, null, _length, _videofilename, _cretificate, null, null, null, null, Convert.ToInt32(Session["UserID"].ToString()), RowID, RowID);
                SavingRepeaterItems(keywordsTableControlRepeater, RowID);
            }
            catch (Exception exNewData) // saving new data
            {
                try
                {
                    da.Insert(1, _name, _gameid, _gameidtwo, _storyid, _expirydate, _rating, null, _length, _videofilename, _cretificate, null, null, null, null, Convert.ToInt32(Session["UserID"].ToString()));
                    SavingRepeaterItems(keywordsTableControlRepeater, 0);

Open in new window

LVL 11
mattibuttAsked:
Who is Participating?
 
Bob LearnedCommented:
Are you talking about adding a column in code, or through the DataSet designer?
0
 
mattibuttAuthor Commented:
ok

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.