Three Tier Structure (from code behind to data access)

Jes Sie

Hello everyone, I created an xml file from a gridview (thanks to Rakesh article). My application is done using a 3 tier structure. How will I transfer my code behind to data access and call only the xml from my code behind? Please see code below.

StringBuilder sbSubjects = new StringBuilder();
sbSubjects.AppendLine("");
foreach (GridViewRow row in GridView1.Rows)
{
Label SubjectID = (Label)row.FindControl("lblSubjectId");
string lblEnrollmentId = lblEnrollmentID.Text.Trim();
if (SubjectID == null || lblEnrollmentId == null)
{
return;
}
if (string.IsNullOrEmpty(SubjectID.Text.Trim()) || string.IsNullOrEmpty(lblEnrollmentId))
{
return;
}
else
{
sbSubjects.AppendLine("");
sbSubjects.AppendLine(" ");
sbSubjects.AppendLine(" " + SubjectID.Text.Trim() + "");
sbSubjects.AppendLine(" " + lblEnrollmentId + "");
sbSubjects.AppendLine(" ");
sbSubjects.AppendLine("");
}
}
SqlCommand cmdSubjects = new SqlCommand("[dbo].[spInsert_XML_BulkEnrollmentSubjects]", con, transaction);
cmdSubjects.CommandType = CommandType.StoredProcedure;
cmdSubjects.Parameters.AddWithValue("@SubjectsData", sbSubjects.ToString());

4 Replies

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

Jes Sie8y ago
As I have stated above, I need to transfer my dot net code to the data access layer as seen below:

Once it's located in the data access layer, I need to call the class from my code behind. Please see example pix below:

And since my values from charges and subjects are inside a gridview (xml), how will I add the xml of charges and subjects to my .cs file?

Thanks Nitin for the insight. Do you have any links to the split technique?
Nitin Sontakke8y ago
It is not quite clear why you are creating an xml, that too manually, and passing it on to the stored procedure as a parameter.

From what I see from the code is you are just passing two set of values, namely SubjectId and EnrollmentId. For such a simple data structure an XML would be a overkill.

Remember that processing xml is a quite a processor / cpu intensive process at SQL Server side because that is not something which sql server natively understand.

Much quicker and simpler would be a string with two distinct delimeters. For example,

1,2|3,4|5,6 etc.

And then use double split technique as shown below:
declare @dualSplit varchar(1000) = '1,2|3,4|5,6|7,8'

select
    max(case ds2.[id] when 1 then ds2.[splitdata] else '' end) as SubjectID,
    max(case ds2.[id] when 2 then ds2.[splitdata] else '' end) as EnrolmentID
from
    dbo.Split(@dualSplit,'|') ds1
    cross apply dbo.Split(ds1.[splitdata], ',') ds2
where
    ds1.[id] <> ''
group by
    ds1.[splitdata];
Which version of SQL Server are you using?
Sagar Pandurang Kap8y ago
Hi,
Refer below solution :-

http://www.aspdotnet-suresh.com/2010/05/introduction-to-3-tier-architecture-in_17.html

Hope it helps....
Mangesh G8y ago
Hey Hold On Can u explain what u want exactly ?