how to store repeater control value in database

design:

--SELECT SUBJECT CODE--

<%--

--%>

<%----%>

<%-- --%>

code:

public partial class repeateraspx : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

viewsubjectdropdown();

}

getData(this.User.Identity.Name);

}

public void viewsubjectdropdown()

{

SqlConnection con = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Feedback;User ID=sa;Password=admin28");

con.Open();

string com = "Select subject_code,subjectid from tbl_subject";

SqlDataAdapter adpt = new SqlDataAdapter(com, con);

DataTable dt = new DataTable();

adpt.Fill(dt);

ddlsubject1.DataSource = dt;

ddlsubject1.DataTextField = "subject_code";

ddlsubject1.DataValueField = "subjectid";

ddlsubject1.DataBind();

con.Close();

}

private void getData(string user)

{

SqlConnection con = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Feedback;User ID=sa;Password=admin28");

con.Open();

SqlCommand cmd = new SqlCommand("select question_id,question_name from tbl_question", con);

cmd.ExecuteNonQuery();

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

rptQues.DataSource = dt;

rptQues.DataBind();

}

protected void Repeater1_ItemDataBound(object sender, RepeaterItemEventArgs e)

{

if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)

{

SqlConnection con = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Feedback;User ID=sa;Password=admin28");

con.Open();

//HiddenField hdn = new HiddenField();hdn= (HiddenField)FindControl("HiddenField1");

// string carrierName = ((String)e.Item.DataItem)["carrierName"].ToString();

DataRowView dr = (DataRowView)e.Item.DataItem;

string strcarrierName = Convert.ToString(dr["question_id"]);

SqlCommand cmd = new SqlCommand("select tbl_option.option_name from tbl_option inner join tbl_question_option_mapping on tbl_question_option_mapping.option_id=tbl_option.option_id inner join tbl_question on tbl_question.question_id=tbl_question_option_mapping.question_id where tbl_question.question_id='" + strcarrierName + "'", con);

cmd.ExecuteNonQuery();

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

Repeater rptOrders = e.Item.FindControl("rptOption") as Repeater;

rptOrders.DataSource = dt;

rptOrders.DataBind();

//RadioButtonList rdoLst = new RadioButtonList();

//rdoLst.DataSource = dt;

//rdoLst.DataTextField = "Options";

//rdoLst.DataBind();

RadioButtonList rdot = e.Item.FindControl("rdoTest") as RadioButtonList;

rdot.DataSource = dt;

rdot.DataTextField = "option_name";

rdot.DataBind();

con.Close();

//PlaceHolder plc = e.Item.FindControl("plchldr") as PlaceHolder;

//plc.Controls.Add(rdoLst);

}

protected void rptQues_ItemCommand(object source, RepeaterCommandEventArgs e)

{

}

protected void ddlsubject1_SelectedIndexChanged(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Feedback;User ID=sa;Password=admin28");

con.Open();

string com = "select tbl_staff.staff_name from tbl_staff join tbl_subject_staff_mapping on tbl_staff.staff_id=tbl_subject_staff_mapping.staff_id where tbl_subject_staff_mapping.subjectid='" + ddlsubject1.SelectedValue + "'";

SqlDataAdapter adpt = new SqlDataAdapter(com, con);

DataTable dt = new DataTable();

adpt.Fill(dt);

if (dt.Rows.Count > 0)

{

Label2.Text = dt.Rows[0]["staff_name"].ToString();

}

// DropDownList1.DataSource = dt;

// DropDownList1.DataTextField = "staff_name";

// //DropDownList1.DataValueField = "substaffmap_id";

// DropDownList1.DataBind();

//// Label2.Text = Convert.ToString(dt.Rows[0][0]);

con.Close();

}

protected void Button1_Click(object sender, EventArgs e)

{

SqlConnection con = new SqlConnection("Data Source=.\\SQLExpress;Initial Catalog=Feedback;User ID=sa;Password=admin28");

con.Open();

string selectedItem = ddlsubject1.SelectedItem.Text;

for (int i = ddlsubject1.Items.Count - 1; i >= 0; i--)

{

if (ddlsubject1.Items[i].Text == selectedItem) ddlsubject1.Items.RemoveAt(i);

}

if (ddlsubject1.Items.Count == 1)

{

Response.Redirect("Webform3.aspx");

}

//viewsubjectdropdown();

Label2.Text = "";

con.Close();

}

Hi Anu,

Here is the below example to update the values of the repeater control to database.

protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING");
try
{
TextBox Amountbox = ((TextBox)e.Item.FindControl("txtAmount"));
Label EID = (Label)e.Item.FindControl("lblExpId");
string strUpdate = "UPDATE UserExpenses SET Amount = @txtAmount WHERE ExpId =@ExpId";
SqlCommand SqlCmd = new SqlCommand(strUpdate, conn);
SqlCmd.Parameters.Add(new SqlParameter("@txtAmount", Amountbox.Text));
SqlCmd.Parameters.Add(new SqlParameter("@ExpId", EID.Text));
if (conn.State == ConnectionState.Closed)
conn.Open();
SqlCmd.ExecuteNonQuery();
Repeater1.DataBind();
}
catch (Exception ex)
{
// Handle Exception
}
finally
{
if (conn.State == ConnectionState.Open)
conn.Close();
conn.Dispose();
}
}

source: https://forums.asp.net/t/1596028.aspx?Help+with+updating+database+with+values+from+Repeater+control+using+c+

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Madhanmohan Devarajan8y ago
Hi Anu,

Here is the below example to update the values of the repeater control to database.
protected void Repeater1_ItemCommand(object source, RepeaterCommandEventArgs e)
{
    SqlConnection conn = new SqlConnection("YOUR CONNECTION STRING");
    try
    {
        TextBox Amountbox = ((TextBox)e.Item.FindControl("txtAmount"));
        Label EID = (Label)e.Item.FindControl("lblExpId");
        string strUpdate = "UPDATE UserExpenses SET Amount = @txtAmount WHERE ExpId =@ExpId";
        SqlCommand SqlCmd = new SqlCommand(strUpdate, conn);
        SqlCmd.Parameters.Add(new SqlParameter("@txtAmount", Amountbox.Text));
        SqlCmd.Parameters.Add(new SqlParameter("@ExpId", EID.Text));
        if (conn.State == ConnectionState.Closed)
            conn.Open();
        SqlCmd.ExecuteNonQuery();
        Repeater1.DataBind();
    }
    catch (Exception ex)
    {
        // Handle Exception
    }
    finally
    {
        if (conn.State == ConnectionState.Open)
            conn.Close();
        conn.Dispose();
    }
}
source: https://forums.asp.net/t/1596028.aspx?Help+with+updating+database+with+values+from+Repeater+control+using+c+
0