TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Kavi suja
NA
298
171.6k
CheckboxList - Update - StoredProcedure
Aug 2 2013 7:12 AM
Hi,
I have table with 4 fields pkey,name,whosinfo_pkey,description.Here 'pkey' is autogenerated key. The sample values following here:
'75', 'Contact Dermatitis', '513', 'Contact Dermatitis'
'76', 'Anaphylaxis', '513', 'Anaphylaxis'
'77', 'Insect Venom', '513', 'Insect Venom'
'78', 'Atopic Dermatitis', '520', 'Atopic Dermatitis'
'79', 'Food Alergies', '520', 'Food Alergies'
'80', 'Insect Venom', '520', 'Insect Venom'
Here I want to
update this table using whosinfo_pkey
.I use following StoredProcedure for this
CREATE DEFINER=`root`@`%` PROCEDURE `SPUpdateMA`(in pkey varchar(45),
in DisName varchar(60)
)
BEGIN
UPDATE medicalhistory medhis
INNER JOIN whosinfo whos
ON whos.pkey=medhis.whosInfo_pkey
SET
medhis.name=DisName,
/*medhis.whosInfo_pkey=pkey,*/
medhis.description=DisName
WHERE medhis.whosInfo_pkey=pkey;
END
In update button click I use following code:
try
{
if (whospkey == "")
{
}
else
{
//string patid = Request.QueryString["Ptid"];
for (int i = 0; i < CheckBoxList2.Items.Count; i++)
{
if (CheckBoxList2.Items[i].Selected == true)
{
objReg.Name = CheckBoxList2.Items[i].Text;
objReg.WhosInfo = whospkey;
// objReg.WhosInfo = Convert.ToString(ViewState["WhosInfo"]);
objRegLogic.UpdatePMedHis(objReg);
}
}
}
}
catch (Exception ex)
{
}
In design page,I use checkboxlist as following:
<asp:CheckBoxList ID="CheckBoxList2" runat="server" BorderStyle="Ridge" RepeatColumns="3"
CssClass="CheckboxList" Width="100%" RepeatDirection="Horizontal" BorderColor="#3399FF">
</asp:CheckBoxList>
Here the problem is,when I update this it will update all data like following:
'75', 'Contact Dermatitis', '513', 'Contact Dermatitis'
'76', 'Anaphylaxis', '513', 'Anaphylaxis'
'77', 'Insect Venom', '513', 'Insect Venom'
'78', 'Anaphylaxis', '520', 'Anaphylaxis'
'79', 'Anaphylaxis', '520', 'Anaphylaxis'
'80', 'Anaphylaxis', '520', 'Anaphylaxis'
But actually I check 3 checkboxes.It takes last checkbox value only Hives,Food Allergies,Anaphylaxis.How I overcome this?How can I update values here correctly?Can anyone help me?
Reply
Answers (
5
)
how to fill public holiday in event calender in .net?
How to Reload value in combobox?