convert sql query into procedure

vidhya

13y1.6k.NET

hi i need to use stored procedure instead of sql query. howcan i use here

My coding here

index.cshtml

var db = Database.Open("EduCon");

var selectQueryString = "select firstname,lastname,emailaddress from person2";

var data = db.Query(selectQueryString);

var grid1 = new WebGrid(source: data,

defaultSort: "firstname",

rowsPerPage: 5,

sortFieldName:"firstname"

);

@grid1.GetHtml(

tableStyle: "grid",

headerStyle: "head",

alternatingRowStyle: "alt",

columns: grid1.Columns(

grid1.Column("firstname", format: @@item.firstname),

grid1.Column("lastname", format: @@item.lastname),

grid1.Column("emailaddress", format: @[email protected])

)

10 Replies

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

Iftikar Hussain13y ago
try like this in your controler

public ActionResult Index()
{
List result = new StudentBusinessLayer().GetStudentInfo();

List cols = new List();
foreach (StudentGradeBookInfo student in result)
{
WebGridColumn webGridColumn;
webGridColumn = new WebGridColumn { Header = "student" };
webGridColumn.Format = (o) => { return new HtmlString(string.Format("{0} {1}", o.FirstName, o.LastName)); };
cols.Add(webGridColumn);

webGridColumn = new WebGridColumn {Header = student.AssignmentName};
webGridColumn.Format = (o) => { return new HtmlString(string.Format("{0}/{1}", o.PointsAwarded, o.PointsPossible)); };
cols.Add(webGridColumn);
}
ViewBag.Columns = cols;
return View(result);
}

in your cshtml

columns:ViewBag.Columns
Regards,
Iftikar
0
vidhya13y ago
how?
0
Iftikar Hussain13y ago
for dynamic column name you need to do it from controller.

Regards,
Iftikar
0
vidhya13y ago
If i use this from the above
grid1.Column("marks", format: @@item.marks)

I am getting the error:

'System.Web.Helpers.WebGridRow' does not contain a definition for 'marks'
0
vidhya13y ago
var db = Database.Open("EduCon");
var selectQueryString = " exec getgradebooks";
var data = db.Query(selectQueryString);
var grid1 = new WebGrid(source: data,
defaultSort: "studentname",
rowsPerPage: 5,
sortFieldName: "studentname"
);

@grid1.GetHtml(
tableStyle: "grid",
headerStyle: "head",
alternatingRowStyle: "alt",
columns: grid1.Columns(
grid1.Column("studentname", format: @@item.studentname),
grid1.Column("marks", format: @@item.marks)

)
)

This is my stored procedure output

StudentNameCreate cost analysiscreate new
GoMarkers 0/25 0/0 0/30 0/15 0/30

create,cost,analysis,create,new are assignmentname how do i assign in grid

0
Iftikar Hussain13y ago
try like this

var db = Database.Open("EduCon");
var data = db.Query("exec dbo.YourStoredProcedure");

Regards,
Iftikar
0
vidhya13y ago
no , u did not understand what i am expecting. whatever it may be i explain clearly

this is my index.cshtml file

@{
var db = Database.Open("EduCon");
var selectQueryString = "select firstname,lastname,emailaddress from person2";
var data = db.Query(selectQueryString);
var grid1 = new WebGrid(source: data,
defaultSort: "firstname",
rowsPerPage: 5,
sortFieldName:"firstname"
);

Here i used sql query (which i bolded).
Instead of the sql query i need to use my procedurename.

0
Iftikar Hussain13y ago
if you are using ADO.NET then try like this

public ActionResult Convert(int id)
{
var connection = new SqlConnection("YOUR CONNECTION STRING");

var command = new SqlCommand("ConvertLeadToCustomer1",connection)
command.CommandType = CommandType.StoredProcedure;
command.Parameters.AddWithValue("@CompanyID", id);

connection.Open();

command.ExcuteNonQuery();

connection.Close();
}

Regards,
Iftikar
0
vidhya13y ago
i no need to use entityframework and linq.

directly i need to use storedprocedure. from the above example i used directly sql statement like that i need to use stored procedure.
0
Iftikar Hussain13y ago
Hi,
Are using EntityFramework or LINQ to SQL?

Regards,
Iftikar
0

convert sql query into procedure

If i use this from the above grid1.Column("marks", format: @@item.marks)I am getting the error:'System.Web.Helpers.WebGridRow' does not contain a definition for 'marks'

If i use this from the above
grid1.Column("marks", format: @@item.marks)

I am getting the error:

'System.Web.Helpers.WebGridRow' does not contain a definition for 'marks'