4
Answers

Debugging Parmeters when calling a stored procedure

All, I built a parameter list when calling a stored procedure. However. the system errors as if the first parm is being overwritten. The syntax used is as follows: c.Parameters.Add(new SqlParameter("@p_Curr_Year",SqlDbType.Int,4)); c.Parameters.Add(new SqlParameter("@p_HID",SqlDbType.Char,8)); I wish to pass an int followed by a comma and user string. Thanks
Answers (4)
1
Upendra Pratap Shahi

Upendra Pratap Shahi

NA 13.3k 861.3k 9y
Where is your code dear?
0
Sreenish

Sreenish

NA 249 16.2k 9y
is anyone there to solve my problem??
0
Sreenish

Sreenish

NA 249 16.2k 9y
upendra any idea???
0
Sreenish

Sreenish

NA 249 16.2k 9y
no upendra not as a modalpopup  it should display beside that calendar control
0
Upendra Pratap Shahi

Upendra Pratap Shahi

NA 13.3k 861.3k 9y
0
Sreenish

Sreenish

NA 249 16.2k 9y
hi vijay,
 
 
i have one calendar in my webform ...once if i select one date one popup will open with some fields...after filling i have one add button once i add that it will display in grid.am done upto that...now if i want to click once then that popup should open...if i double click gridview should open... 
0
Sreenish

Sreenish

NA 249 16.2k 9y
and one more thing upendra ....now am adding events in one date cell if i want to add again in the same date cell it is nit accepting dont know whyy...
0
Sreenish

Sreenish

NA 249 16.2k 9y
in javascript i have tried something  to display gridview
0
Sreenish

Sreenish

NA 249 16.2k 9y
my problem is on double click of date cell gridview should open on single click modal popup should open....
0
Sreenish

Sreenish

NA 249 16.2k 9y
Code Behind::
 
 
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Globalization;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using AjaxControlToolkit;
namespace Scheduler
{
public partial class ScedulerCal : System.Web.UI.Page
{
DataTable dt;
protected void Page_Load(object sender, EventArgs e)
{
GetData();
}
public void GetData()
{
if (!IsPostBack)
{
dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Event");
dt.Columns.Add("AddedOn");
DataRow dr = dt.NewRow();
ViewState["dt1"] = dt;
GridView1.DataSource = dt;
GridView1.DataBind();
}
}
protected void Link1_Click(object sender, EventArgs e)
{
LinkButton Link1 = (LinkButton)sender;
GridViewRow row = (GridViewRow)Link1.NamingContainer;
row.BackColor = Color.Red;
}
DataRow[] dr;
protected void Calendar1_SelectionChanged(object sender, System.EventArgs e)
{
if ((Calendar1.SelectedDate < DateTime.Now.AddMonths(3)) && (Calendar1.SelectedDate >= DateTime.Now.Date))
{
TextBox3.Text = Calendar1.SelectedDate.Date.ToLongDateString();
Btn1_Click(null, null);
dt = ((DataTable)ViewState["dt1"]).Copy();
dr = dt.Select("[AddedOn]='" + Calendar1.SelectedDate.Date.ToLongDateString() + "'");
DataTable dt1 = new DataTable();
dt1 = dt.Clone();
foreach (DataRow drw in dr)
{
dt1.ImportRow(drw);
}
GridView1.DataSource = dt1;
GridView1.DataBind();
}
}
protected void Calendar1_DayRender(object sender, DayRenderEventArgs e)
{
if (dt != null)
{
DataView dv = new DataView(dt);
dv.RowFilter = string.Format("AddedOn = #{0}#", e.Day.Date.ToShortDateString());
if (dv.Count > 0)
{
Literal l = new Literal();
l.Visible = true;
l.Text = "<br/>" + dv.Count.ToString() + "<br/>";
e.Cell.Controls.Add(l);
e.Cell.BackColor = Color.GreenYellow;
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
dt = (DataTable)ViewState["dt1"];
DataRow dr1 = dt.NewRow();
dr1[0] = TextBox1.Text;
dr1[1] = TextBox2.Text;
dr1[2] = Calendar1.SelectedDate.Date.ToLongDateString();
TextBox1.Text = TextBox2.Text = string.Empty;
dt.Rows.Add(dr1);
ViewState["dt1"] = dt;
Calendar1_SelectionChanged(null, null);
Panel1.Visible = false;
}
protected void Btn1_Click(object sender, EventArgs e)
{
Panel1.Visible = true;
Mdl1.Show();
}
protected void Calendar1_VisibleMonthChanged(object sender, MonthChangedEventArgs e)
{
if (e.NewDate.Month < e.PreviousDate.Month)
{
dt = ((DataTable)ViewState["dt1"]);
dr = dt.Select("[AddedOn]='" + Calendar1.SelectedDate.Date.ToLongDateString() + "'");
}
if (e.NewDate.Month > e.PreviousDate.Month)
{
dt = ((DataTable)ViewState["dt1"]);
dr = dt.Select("[AddedOn]='" + Calendar1.SelectedDate.Date.ToLongDateString() + "'");
}
}
}
}
 
0
Sreenish

Sreenish

NA 249 16.2k 9y
Source Code::
 
 
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="ScedulerCal.aspx.cs" Inherits="Scheduler.ScedulerCal" %>
<%@ Register Assembly="AjaxControlToolkit" Namespace="AjaxControlToolkit" TagPrefix="asp" %>
<%--<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
--%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
window.onload = function () {
var timer;
var el = document.getElementById('Calendar1');
el.onclick = function () {
if (timer) clearTimeout(timer);
timer = setTimeout(function () { alert('<%= Calendar1.SelectedDate.Date.ToLongDateString() %>'); }, 250);
var calendarDate = '<%= Calendar1.SelectedDate.Date.ToLongDateString() %>';
document.getElementById("GridView1").style.display = 'block';
}
el.ondblclick = function () {
clearTimeout(timer);
document.getElementById("Mdl1").style.display = 'block';
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<asp:ToolkitScriptManager ID="ToolkitScriptManager1" runat="server">
</asp:ToolkitScriptManager>
<div style="width: 100%; height: 100%" id="MainDiv">
<div style="width: 70%; float: left" id="caldiv">
<asp:Calendar ID="Calendar1" runat="server" Width="98%" Height="100%" OnSelectionChanged="Calendar1_SelectionChanged"
OnDayRender="Calendar1_DayRender" BackColor="White" BorderColor="Black"
DayNameFormat="Shortest"
Font-Names="Times New Roman" Font-Size="10pt" ForeColor="Black" NextPrevFormat="FullMonth"
TitleFormat="Month" OnVisibleMonthChanged="Calendar1_VisibleMonthChanged" >
<DayHeaderStyle BackColor="#CCCCCC" Font-Bold="True" Font-Size="7pt" ForeColor="#333333"
Height="10pt" />
<DayStyle Width="14%" />
<NextPrevStyle Font-Size="8pt" ForeColor="White" />
<OtherMonthDayStyle ForeColor="#999999" />
<SelectedDayStyle BackColor="#CC3333" ForeColor="White" />
<SelectorStyle BackColor="#CCCCCC" Font-Bold="True" Font-Names="Verdana" Font-Size="8pt"
ForeColor="#333333" Width="1%" />
<TitleStyle BackColor="Black" Font-Bold="True" Font-Size="13pt" ForeColor="White"
Height="14pt" />
<TodayDayStyle BackColor="#CCCC99" />
</asp:Calendar>
</div>
<div style="width: 27%; float: left" id="Gvdiv">
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" Width="100%"
Height="5%" >
<Columns>
<asp:BoundField DataField="Name" HeaderText="Name" />
<asp:BoundField DataField="Event" HeaderText="Event" />
<asp:BoundField DataField="AddedOn" HeaderText="AddedOn" />
<asp:TemplateField>
<ItemTemplate>
<asp:LinkButton ID="Link1" runat="server" Text="Delete" OnClick="Link1_Click"></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</div>
<asp:Panel ID="Panel1" Style="border: Solid 1px Blue; background-color: #CCFFFF;
width: 30%" runat="server" Visible="false" BackColor="#CCCCFF">
<div style="background-color: #CCFFFF; text-align: center">
<asp:Label ID="lblE" runat="server" Text="Events On" ForeColor="Red"></asp:Label>
<asp:TextBox ID="TextBox3" runat="server" Width="60%" Style="margin-left: 30px; background-color: Yellow"></asp:TextBox>
</div>
<div id="Name">
<asp:Label ID="Label" runat="server" Text="Name" Width="5%"></asp:Label>
<asp:TextBox ID="TextBox1" runat="server" Width="30%" Style="margin-left: 30px"></asp:TextBox>
</div>
<br />
<div id="Event">
<asp:Label ID="Label2" runat="server" Text="Event" Width="5%"></asp:Label>
<asp:TextBox ID="TextBox2" runat="server" Width="30%" Style="margin-left: 30px"></asp:TextBox>
</div>
<br />
<div id="Add">
<asp:Button ID="Button1" runat="server" Text="Add" Width="20%" Style="margin-left: 50px"
OnClick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="cancel" Width="20%" />
</div>
</asp:Panel>
<asp:Button ID="Btn1" runat="server" Style="display: none" OnClick="Btn1_Click" EnableViewState="true" />
<asp:ModalPopupExtender ID="Mdl1" runat="server" TargetControlID="Btn1" PopupControlID="Panel1"
CancelControlID="Button2">
</asp:ModalPopupExtender>
</form>
</body>
</html>