不使用gridview从数据库更新数据的代码

使用项目的列表框和文本框进行更新的C#代码(存储过程，DAL，BAL和UI)进行更新

存储过程

C# code for updating(stored procedure,DAL,BAL and UI)using listbox for items and textbox to update

Stored procedure

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[p_UpdateMainQ]

@MainQuestionId VARCHAR (50)

AS

UPDATE MAINQUESTION
SET SurveyId=@MainQuestionId
WHERE MainQuestion =MainQuestion

DAL代码

DAL code

public int UpdateMainQuestion(string MainQuestion)
        {
            //using (SqlConnection connection = new SqlConnection(connectionInfo))
            //{
            //    connection.Open();
            //    SqlDataReader myReader = null;
            //    SqlCommand myCommand = new SqlCommand("p_UpdateMainQ", connection);
            //    myCommand.CommandType = CommandType.StoredProcedure;
            //    myCommand.Parameters.Add(new SqlParameter("@MainQuestion", MainQuestion));
            //    myReader = myCommand.ExecuteReader();

            //    if (myReader.Read())
            //    {

            //        //txtMQ.Text = myReader[1].ToString();


            //    }
            //}

            SqlConnection conn = new SqlConnection(connectionInfo);
            conn.Open();
            SqlCommand dCmd = new SqlCommand("p_UpdateMainQ", conn);
            dCmd.CommandType = CommandType.StoredProcedure;
            try
            {
                //dCmd.Parameters.AddWithValue("@MainQuestionId", MainQuestionId);
               // dCmd.Parameters.AddWithValue("@SurveyId", 1);
                dCmd.Parameters.AddWithValue("@MainQuestion", MainQuestion);

                return dCmd.ExecuteNonQuery();
            }
            catch
            {
                throw;
            }
            finally
            {
                dCmd.Dispose();
                conn.Close();
                conn.Dispose();
            }
        }

BAL代码

BAL code

public int UpdateMainQuestion(string MainQuestion)
      {
         return  MQDAL.UpdateMainQuestion(MainQuestion);
      }

用户界面代码

UI code

try
               {
                   string Ques = lstMainQ.SelectedItem.ToString();
                   txtMain.Text = Ques;
                   txtMain.Focus();
                   int Index = lstMainQ.SelectedIndex;
                   lstMainQ.Items.RemoveAt(lstMainQ.SelectedIndex);
                   String MainQuestion = txtMain.Text;
                   MainQuestionBAL MQBAL = new MainQuestionBAL();
                 int MQ=  MQBAL.UpdateMainQuestion(MainQuestion);
                 if (MQ.Equals(1))
                 {
                 }