Comments by sakshi111

sakshi111 9-Dec-13 13:19pm View

if one procedure can do m,multiple task then why will i create multiple procedure for different dml statement

sakshi111 9-Dec-13 13:17pm View

complete error

Major Error 0x80040E14, Minor Error 25501
> create proc dbo.proc_Emp
(
@MODE NVARCHAR(10),
@EMP_ID NVARCHAR(20),
@EMP_NM NVARCHAR(50),
@EMP_LNM NVARCHAR(50)=NULL,
@EMP_DOJ DATETIME,
@EMP_MNO NVARCHAR(30)=NULL
)
AS BEGIN
IF @MODE='SAVE'
BEGIN
INSERT INTO EMP_MST (EMP_ID,EMP_NM,EMP_LNM,EMP_DOJ,EMP_MNO)
VALUES (@EMP_ID,@EMP_NM,@EMP_LNM,@EMP_DOJ,@EMP_MNO)
END
ELSE IF @MODE='UPDATE'
BEGIN
UPDATE EMP_MST SET EMP_NM=@EMP_NM,EMP_LNM=@EMP_LNM,EMP_DOJ=@EMP_DOJ,
EMP_MNO=@EMP_MNO WHERE EMP_ID=@EMP_ID
END
ELSE IF @MODE='VIEW'
BEGIN
SELECT EMP_ID,EMP_NM,EMP_LNM,EMP_DOJ,
EMP_MNO FROM EMP_MST WHERE EMP_ID=@EMP_ID
END
END
There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = proc ]

sakshi111 9-Dec-13 13:17pm View

complete error

Major Error 0x80040E14, Minor Error 25501
> create proc dbo.proc_Emp
(
@MODE NVARCHAR(10),
@EMP_ID NVARCHAR(20),
@EMP_NM NVARCHAR(50),
@EMP_LNM NVARCHAR(50)=NULL,
@EMP_DOJ DATETIME,
@EMP_MNO NVARCHAR(30)=NULL
)
AS BEGIN
IF @MODE='SAVE'
BEGIN
INSERT INTO EMP_MST (EMP_ID,EMP_NM,EMP_LNM,EMP_DOJ,EMP_MNO)
VALUES (@EMP_ID,@EMP_NM,@EMP_LNM,@EMP_DOJ,@EMP_MNO)
END
ELSE IF @MODE='UPDATE'
BEGIN
UPDATE EMP_MST SET EMP_NM=@EMP_NM,EMP_LNM=@EMP_LNM,EMP_DOJ=@EMP_DOJ,
EMP_MNO=@EMP_MNO WHERE EMP_ID=@EMP_ID
END
ELSE IF @MODE='VIEW'
BEGIN
SELECT EMP_ID,EMP_NM,EMP_LNM,EMP_DOJ,
EMP_MNO FROM EMP_MST WHERE EMP_ID=@EMP_ID
END
END
There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = proc ]

sakshi111 9-Dec-13 13:10pm View

what type of details

sakshi111 9-Dec-13 13:09pm View

There was an error parsing the query. [ Token line number = 1,Token line offset = 8,Token in error = proc ] this error

sakshi111 9-Dec-13 13:09pm View

we can write any number of dml statement in procedure

sakshi111 8-Oct-13 7:39am View

thanks i will try...

sakshi111 26-Jun-13 6:25am View

i want to insert only charactor and symbol but not digits'

sakshi111 26-Jun-13 6:24am View

public bool ContainUnallowedData(string s, char[] UnallowedData)
{
for (int i = 0; i < UnallowedData.Length; i++)

if (s.Contains(UnallowedData[i]))
return true;

return false;

}

sakshi111 15-May-13 3:10am View

yes sir like window xp calculator copy and paste please tell me how can i do it.

sakshi111 13-May-13 7:09am View

no its not empty

sakshi111 13-May-13 6:31am View

sir this code is not working....when i clicking at backspace than nothing is cahanging

sakshi111 13-May-13 6:17am View

why???

sakshi111 13-May-13 5:34am View

thank u it was minor mistake

sakshi111 10-May-13 3:31am View

how to use debbuger in visual studio

sakshi111 9-May-13 1:08am View

thank u so much

sakshi111 9-May-13 1:03am View

yes exit a page

sakshi111 9-May-13 1:03am View

i mean exit a page if i click at cancel button than it should exit

sakshi111 25-Apr-13 1:25am View

but sir one more thing why this problem was occuring? and why it only removed by refreshing report??

sakshi111 25-Apr-13 1:21am View

thank u so much sir the problem has been removed

sakshi111 24-Apr-13 8:27am View

after commenting this code now the problem is not coming...so ofcourse the problem is due to this code...plz do the needful

sakshi111 24-Apr-13 6:43am View

i created a data set of four coloumn customer_name,order_id,product_name and product_qty
and also i create customer1 table of customer_id,customer_name,order_id,product_name and product_qty.and than i add crystal report and 1 .aspx page and in that page i include crystalreport viewer and code it

sakshi111 8-Apr-13 7:38am View

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default7.aspx.cs" Inherits="Default7" %>

<!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>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" BackColor="LightGoldenrodYellow"
BorderColor="Tan" BorderWidth="1px" CellPadding="2"
DataSourceID="SqlDataSource1" GridLines="None" Height="16px"
onselectedindexchanged="GridView1_SelectedIndexChanged" PageSize="5"
style="margin-right: 0px" Width="425px" ForeColor="Black">
<alternatingrowstyle backcolor="PaleGoldenrod">
<columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="student_id" HeaderText="student_id"
SortExpression="student_id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
<asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
<asp:BoundField DataField="dob" HeaderText="dob" SortExpression="dob" />

<footerstyle backcolor="Tan">
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"
HorizontalAlign="Center" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<sortedascendingcellstyle backcolor="#FAFAE7">
<sortedascendingheaderstyle backcolor="#DAC09E">
<sorteddescendingcellstyle backcolor="#E1DB9C">
<sorteddescendingheaderstyle backcolor="#C2A47B">

<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True"
CausesValidation="True" DataSourceID="SqlDataSource1" DataTextField="name"
DataValueField="student_id" AutoPostBack="True">

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:learnConnectionString %>"
SelectCommand="SELECT * FROM [student]">
<br />

</div>
</form>
</body>
</html>

sakshi111 8-Apr-13 7:37am View

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default7.aspx.cs" Inherits="Default7" %>

<!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>
</head>
<body>
<form id="form1" runat="server">
<div>

<asp:GridView ID="GridView1" runat="server" AllowPaging="True"
AllowSorting="True" AutoGenerateColumns="False" BackColor="LightGoldenrodYellow"
BorderColor="Tan" BorderWidth="1px" CellPadding="2"
DataSourceID="SqlDataSource1" GridLines="None" Height="16px"
onselectedindexchanged="GridView1_SelectedIndexChanged" PageSize="5"
style="margin-right: 0px" Width="425px" ForeColor="Black">
<alternatingrowstyle backcolor="PaleGoldenrod">
<columns>
<asp:CommandField ShowSelectButton="True" />
<asp:BoundField DataField="student_id" HeaderText="student_id"
SortExpression="student_id" />
<asp:BoundField DataField="name" HeaderText="name" SortExpression="name" />
<asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />
<asp:BoundField DataField="Class" HeaderText="Class" SortExpression="Class" />
<asp:BoundField DataField="dob" HeaderText="dob" SortExpression="dob" />

<footerstyle backcolor="Tan">
<HeaderStyle BackColor="Tan" Font-Bold="True" />
<PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue"
HorizontalAlign="Center" />
<SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />
<sortedascendingcellstyle backcolor="#FAFAE7">
<sortedascendingheaderstyle backcolor="#DAC09E">
<sorteddescendingcellstyle backcolor="#E1DB9C">
<sorteddescendingheaderstyle backcolor="#C2A47B">

<asp:DropDownList ID="DropDownList1" runat="server" AppendDataBoundItems="True"
CausesValidation="True" DataSourceID="SqlDataSource1" DataTextField="name"
DataValueField="student_id" AutoPostBack="True">

<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:learnConnectionString %>"
SelectCommand="SELECT * FROM [student]">
<br />

</div>
</form>
</body>
</html>

sakshi111 8-Apr-13 7:26am View

in if condition without GridView1.PageIndex = i; it does not goes to next page and by using your code same condition is happened.

sakshi111 8-Apr-13 6:24am View

i already enable select index and page index

sakshi111 8-Apr-13 6:10am View

i bind both dropdownlist and gridview with same sqldatasource

sakshi111 6-Apr-13 6:41am View

i was asking for confidental data
and now please tell me for all type(which you mention)what i have to use

sakshi111 4-Apr-13 21:58pm View

if session is not secure than what we have to use??? and why session is not secure??/

sakshi111 4-Apr-13 8:13am View

thank you so much...i planned most of the thing to intiate it but the problem is that i dont know the attendence procedure of college and can you help me? actually i want to know attendence procedure how the attendence enter(means who enter intime outime and leaves and about the leaves) in system so that i can make tables and forms in this project...

sakshi111 4-Apr-13 8:01am View

Que1 specific question is what is attendence procedure have to add in this project...
Que2 i prepared almost database for payrollmanagement system for college but i dont know how to implement it because its my first project

sakshi111 4-Apr-13 4:52am View

thank you very much
the problem is resolved but now a new problem arised
eror is:Invalid object name 'Customer'

Comments by sakshi111 (Top 32 by date)