TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
selvi subramanian
NA
799
572.6k
It throw this error please clear this
May 5 2014 6:06 AM
my design is
<%@ Page Language="C#" MasterPageFile="~/MasterPage/cloth.master" AutoEventWireup="true" CodeFile="Login.aspx.cs" Inherits="Login" Title="Login" %>
<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
<style type="text/css">
.style2
{
height: 18px;
}
</style>
</asp:Content>
<asp:Content ID="Content3" runat="server"
contentplaceholderid="ContentPlaceHolder1">
</asp:Content>
<asp:Content ID="Content4" runat="server"
contentplaceholderid="FullContentArea">
</asp:Content>
<asp:Content ID="Content5" runat="server" contentplaceholderid="Header_Menu">
<ul id="nav">
<%-- <li ><a href="index.html">Home</a></li>--%>
<%--<li><a href="Login.aspx">Login</a></li> --%>
<li><a href="contactus.aspx" style="font-size:xx-large;font-style:normal;font-weight:lighter">Main</a></li>
</ul>
</asp:Content>
<asp:Content ID="Content6" runat="server" contentplaceholderid="ContentReport">
<form id="form1" runat="server">
<script type="text/javascript" language="javascript">
function ChangeBackground()
{
window.event.srcElement.style.background = " #1d599e";
}
function RestoreBackground()
{
window.event.srcElement.style.background = "#FFFFFF";
}
</script>
<script type="text/javascript" language="javascript">
function Account()
{
if(document.getElementById('ctl00_ContentReport_txtusername').value == "")
{
alert("Enter Username");
document.getElementById('ctl00_ContentReport_txtusername').focus();
return false;
}
if(document.getElementById('ctl00_ContentReport_txtpassword').value == "")
{
alert("Enter Password");
document.getElementById('ctl00_ContentReport_txtpassword').focus();
return false;
}
return true;
}
</script>
<table width="50%" align="center" style="border-color: #1d599e; border-style: outset;
border-width: thin;" >
<tr>
<td style="margin-left: 80px; background:#1d599e;" colspan="2" align="center">
<asp:Label ID="Label22" runat="server" Text="LOGIN" Style="color: #FFFFFF;
font-size: 12px; font-weight: 700; text-align: center;" class="style10"></asp:Label>
</td>
</tr>
<tr>
<td>
<asp:Label ID="Label1" runat="server" Text="Company Name" Height="15px" style="font-weight: 700; font-size: 11px; font-family: Arial, Helvetica, sans-serif"></asp:Label>
</td>
<td>
<asp:DropDownList ID="DropDownList1" runat="server" Height="16px" Width="134px"
AutoPostBack="True">
<asp:ListItem>Select</asp:ListItem>
<asp:ListItem>Birmandam</asp:ListItem>
<asp:ListItem>Riyas</asp:ListItem>
<asp:ListItem>Saravanas</asp:ListItem>
</asp:DropDownList>
</td>
</tr>
<tr>
<td >
<asp:Label ID="Label20" runat="server" Text="UserName" Height="15px" style="font-weight: 700; font-size: 11px; font-family: Arial, Helvetica, sans-serif"></asp:Label>
</td>
<td class="style2">
<asp:TextBox ID="txtusername" runat="server" Height="15px"
onmouseover="ChangeBackground();"
onmouseout="RestoreBackground();" ForeColor="#acacac" Width="130px"></asp:TextBox>
</td>
</tr>
<tr>
<td >
<asp:Label ID="Label21" runat="server" Text="Password" Height="15px"
style="font-weight: 700; font-size: 11px; font-family: Arial, Helvetica, sans-serif"></asp:Label>
</td>
<td>
<asp:TextBox ID="txtpassword" runat="server"
onmouseover="ChangeBackground();"
onmouseout="RestoreBackground();" ForeColor="#acacac"
Height="15px" TextMode="Password" Width="130px"></asp:TextBox>
</td>
</tr>
<tr align="center">
<td colspan="2">
<asp:LinkButton ID="LinkButton1" runat="server" onclick="LinkButton1_Click1">Forgot Password <asp:Image ID="Image1" runat="server" ImageUrl="~/Images/Forgotten-Password.jpg" /></asp:LinkButton>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<asp:ImageButton ID="img" ImageUrl="~/Images/login_button_01.jpg" runat="server" OnClientClick=" return RegainFocus()"
Width="90px" onclick="img_Click1" />
<br />
<asp:Label ID="label" runat="server" style="font-weight: 700; color: #666666"></asp:Label>
</td>
</tr>
<tr>
<td align="center" colspan="2">
<br />
</td>
</tr>
</table>
</form>
</asp:Content>
my code is
using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;
public partial class Login : System.Web.UI.Page
{
DataSet ds = new DataSet();
DataSet dss = new DataSet();
Marvel mar = new Marvel();
protected void Page_Load(object sender, EventArgs e)
{
}
protected void img_Click1(object sender, ImageClickEventArgs e)
{
string User = txtusername.Text;
string Pass = txtpassword.Text;
string qry = "select UserName,Password from Account where CompanyName='"+DropDownList1.SelectedItem.Text.ToString()+"'";
ds = mar.GETDS(qry);
if (ds.Tables[0].Rows != null)
{
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
if ((User == ds.Tables[0].Rows[i]["UserName"].ToString()) && (Pass == ds.Tables[0].Rows[i]["Password"].ToString()) && (ds.Tables[0].Rows[i]["CompanyName"].ToString() == "Birmandam"))
{
Response.Redirect("~/Admin/Report.aspx");
}
else if (ds.Tables[0].Rows[i]["CompanyName"].ToString() == "Riyas")
{
if ((User == ds.Tables[0].Rows[i]["UserName"].ToString()) && (Pass == ds.Tables[0].Rows[i]["Password"].ToString()))
Response.Redirect("ForgotPassword.aspx");
}
else if (ds.Tables[0].Rows[i]["CompanyName"].ToString() == "Saravanas")
{
if ((User == ds.Tables[0].Rows[i]["UserName"].ToString()) && (Pass == ds.Tables[0].Rows[i]["Password"].ToString()))
Response.Redirect("Stockentry.aspx");
}
else
{
label.Text = "UserName/Password is Incorrect";
}
}
}
}
protected void LinkButton1_Click1(object sender, EventArgs e)
{
Response.Redirect("ForgotPassword.aspx");
}
}
it throws this error
Server Error in '/Login' Application.
Column 'CompanyName' does not belong to table Table.
Description:
An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details:
System.ArgumentException: Column 'CompanyName' does not belong to table Table.
Source Error:
Line 40: } Line 41: Line 42: else if (ds.Tables[0].Rows[i]["CompanyName"].ToString() == "Riyas") Line 43: { Line 44: if ((User == ds.Tables[0].Rows[i]["UserName"].ToString()) && (Pass == ds.Tables[0].Rows[i]["Password"].ToString()))
Source File:
d:\selvi\Login\Login.aspx.cs
Line:
42
Reply
Answers (
2
)
json dateformat
Crop Image