How can i bind 2 datagrids that have checkboxes in the first columns??When i checked one row from first datagrid and then checked a row from second datagrid , i should insert selected rows into the database....Please help me and correct my code...
private void Page_Load(object sender, System.EventArgs e)
{
if (Page.IsPostBack)
return;
if (Request.QueryString["hemPatientId"]!=null)
bindMyHemogram(Int32.Parse(Request.QueryString["hemPatientId"].ToString()));
}
private void bindMyHemogram(int hemPatientId)
{
coreLpms.hemograms myHemogram = new coreLpms.hemograms();
DataSet myDataSet = myHemogram.getPatientsHemogram(hemPatientId);
if (myDataSet.Tables[0].Rows[0]["HEM_HEMOGRAMDATE"]==DBNull.Value)
textHemHemogramDate.Text = "";
else
textHemHemogramDate.Text = Convert.ToDateTime(myDataSet.Tables[0].Rows[0]["HEM_HEMOGRAMDATE"]).ToString("dd-MM-yyyy");
textHemLokosit.Text = myDataSet.Tables[0].Rows[0]["HEM_LOKOSIT"].ToString();
textHemNNS.Text = myDataSet.Tables[0].Rows[0]["HEM_NNS"].ToString();
textHemEOS.Text = myDataSet.Tables[0].Rows[0]["HEM_EOS"].ToString();
textHemBAS.Text = myDataSet.Tables[0].Rows[0]["HEM_BAS"].ToString();
textHemLIM.Text = myDataSet.Tables[0].Rows[0]["HEM_LIM"].ToString();
textHemMON.Text = myDataSet.Tables[0].Rows[0]["HEM_MON"].ToString();
textHemDoze.Text = myDataSet.Tables[0].Rows[0]["HEM_DOZE"].ToString();
textHemPack1.Text = myDataSet.Tables[0].Rows[0]["HEM_PACK1"].ToString();
textHemPack2.Text = myDataSet.Tables[0].Rows[0]["HEM_PACK2"].ToString();
bindMyPhysicianGrid(Request.QueryString["customerType"].ToString(), Int32.Parse(Request.QueryString["seperationId"].ToString()), Request.QueryString["fullname"].ToString());
bindMyPharmaCistGrid(Request.QueryString["customerType"].ToString(), Int32.Parse(Request.QueryString["seperationId"].ToString()), Request.QueryString["fullname"].ToString());
}
private void bindMyPhysicianGrid(string customerType, int seperationId, string fullname)
{
coreMarseg.Customers myCustomer = new coreMarseg.Customers();
myPhysicianGrid.DataSource = myCustomer.getCustomersBySeperation("Y", 0, physicianFullName.Text);
myPhysicianGrid.DataBind();
}
private void bindMyPharmaCistGrid(string customerType, int seperationId, string fullname)
{
coreMarseg.Customers myCustomer = new coreMarseg.Customers();
myPharmaCistGrid.DataSource = myCustomer.getCustomersBySeperation("Y", 0, pharmaCistFullName.Text);
myPharmaCistGrid.DataBind();
}
private void Button_Click(object sender, System.EventArgs e)
{
coreLpms.hemograms myHemogram = new coreLpms.hemograms();
coreMarseg.Customers myCustomer = new coreMarseg.Customers();
DataGridItem myItem;
for(int i=0;i < myPhysicianGrid.Items.Count; i++)
{
myItem = myPhysicianGrid.Items[i];
if ((myItem.ItemType != ListItemType.Header) &&
(myItem.ItemType != ListItemType.Footer) &&
(myItem.ItemType != ListItemType.Separator))
{
if (((CheckBox)myItem.FindControl("cbSelectRow1")).Checked==true)
{
if (myHemogram.addHemogram(textHemHemogramDate.Text, textHemLokosit.Text, textHemNNS.Text, textHemEOS.Text, textHemBAS.Text,
textHemLIM.Text, textHemMON.Text, textHemDoze.Text, textHemPack1.Text, textHemPack2.Text))
{
myError.Visible = false;
this.Response.Redirect("patient.aspx?patientNumber=" + Request.QueryString["patientNumber"].ToString());
bindMyHemogram(Int32.Parse(Request.QueryString["hemPatientId"].ToString()));
}
else
{
myError.Visible = true;
((Label)myError.FindControl("labelError")).Text = myHemogram.myError.getLastError();
}
}
}
}
for(int i=0;i < myPharmaCistGrid.Items.Count; i++)
{
myItem = myPharmaCistGrid.Items[i];
if ((myItem.ItemType != ListItemType.Header) &&
(myItem.ItemType != ListItemType.Footer) &&
(myItem.ItemType != ListItemType.Separator))
{
if (((CheckBox)myItem.FindControl("cbSelectRow2")).Checked==true)
{
if (myHemogram.addHemogram(textHemHemogramDate.Text, textHemLokosit.Text, textHemNNS.Text, textHemEOS.Text, textHemBAS.Text,
textHemLIM.Text, textHemMON.Text, textHemDoze.Text, textHemPack1.Text, textHemPack2.Text))
{
myError.Visible = false;
this.Response.Redirect("patient.aspx?patientNumber=" + Request.QueryString["patientNumber"].ToString());
bindMyHemogram(Int32.Parse(Request.QueryString["hemPatientId"].ToString()));
}
else
{
myError.Visible = true;
((Label)myError.FindControl("labelError")).Text = myHemogram.myError.getLastError();
}
}
}
}
}
private void myPhysicianGrid_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
CheckBox myCheckBox;
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
myCheckBox = (CheckBox)e.Item.FindControl("cbSelectRow1");
myCheckBox.Attributes.Add("OnClick", "CCA(this, 'selectRow', 'recipe');");
}
}
private void myPharmaCistGrid_ItemCreated(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
{
CheckBox myCheckBox;
if ((e.Item.ItemType == ListItemType.Item) || (e.Item.ItemType == ListItemType.AlternatingItem))
{
myCheckBox = (CheckBox)e.Item.FindControl("cbSelectRow2");
myCheckBox.Attributes.Add("OnClick", "CCA(this, 'selectRow', 'recipe');");
}
}
---------Datagrids:------------------------
-----------------
|
| |