Hello Friends,
I have code, to pick up the, values from database in Session, By Clicking on Dynamically Generated Linkbutton. I want to redirect those values to another page, my code is here..
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class Dynamic_link : System.Web.UI.Page
{
SqlConnection cnn = new SqlConnection();
protected void Page_Load(object sender, EventArgs e)
{
cnn.ConnectionString=ConfigurationManager.ConnectionStrings["jin"].ConnectionString;
if(cnn.State==ConnectionState.Closed)
{
cnn.Open();
}
SqlCommand cm = new SqlCommand("select itemname from menu", cnn);
cm.CommandType = CommandType.Text;
SqlDataAdapter da = new SqlDataAdapter(cm);
DataSet dt = new DataSet();
da.Fill(dt);
Repeater Repeater1 = new Repeater();
Repeater1.DataSource = dt;
Repeater1.DataBind();
if (cnn.State == ConnectionState.Open)
{
cnn.Close();
}
foreach (RepeaterItem repeatItem in Repeater1.Items)
{
if (repeatItem.ItemIndex == 0)
{
RepeaterItem headerItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Header);
HtmlGenericControl hTag = new HtmlGenericControl("h4");
hTag.InnerHtml = "Menu Collection";
repeatItem.Controls.Add(hTag);
}
RepeaterItem repeaterItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Item);
LinkButton lnk = new LinkButton();
lnk.ID = "lnk_itemname";
lnk.Text = String.Format("{0}",(dt.Tables[0].Rows[repeatItem.ItemIndex]["itemname"]));
lnk.Click += new System.EventHandler(link_Click);
repeatItem.Controls.Add(lnk);
repeaterItem = new RepeaterItem(repeatItem.ItemIndex, ListItemType.Separator);
LiteralControl ltrlHR = new LiteralControl();
ltrlHR.Text = "<hr />";
repeatItem.Controls.Add(ltrlHR);
}
Panel1.Controls.Add(Repeater1);
}
protected void link_Click(object sender, EventArgs e)
{
cnn.ConnectionString = ConfigurationManager.ConnectionStrings["jin"].ConnectionString;
SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand("str_get_subitemDetails", cnn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
DataSet ds = new DataSet();
DataTable dt = new DataTable("submenu");
da.Fill(dt);
Session["subitem_name"] = dt.Rows[0]["subitem_name"].ToString();
Session["item_descript"] = dt.Rows[0]["item_descript"].ToString();
Session["item_rate"] = dt.Rows[0]["item_rate"].ToString();
Response.Redirect("getsubitem.aspx");
}
}
My StoredProcedure Code is this:
USE [JIN]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER procedure [dbo].[str_get_subitemDetails]
@item_id nvarchar(50),
@itemname nvarchar(50),
@subitem_name nvarchar(50),
@item_descript nvarchar(100),
@item_rate decimal(18,2)
as
begin
select submenu.subitem_name,submenu.item_descript,submenu.item_rate from submenu join menu on menu.item_id=submenu.item_id where menu.itemname=@itemname
end
I m Facing this error...
No mapping exists from object type ASP.dynamic_link_aspx to a known managed provider native type.
Please Help me
Facing error:
Procedure or function 'str_get_subitemDetails' expects parameter '@item_id', which was not supplied.
please help: