Comments by harshavardhan12345678 (Top 200 by date)

how to create a new sqlite database in server explorer

sorry sir ,that is previous code ... now tell me sir how to add sqlite database connection in server explorer

no , issue not solved sir

onclick event event


private void insertconnect_Click(object sender, EventArgs e)
{
// [snip] - As C# is purely object-oriented the following lines must be put into a class:

// We use these three SQLite objects:
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;



sqlite_conn = new SQLiteConnection(); // Create an instance of the object
sqlite_conn.ConnectionString = @"Data Source=C:\Users\Srikanth\Downloads\eminosoft.db;";// Set the ConnectionString
sqlite_conn.Open(); // Open the connection. Now you can fire SQL-Queries

// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();

}

okay issue solved

dont mind iam a fresher thats y iam asking ...

error is
Error 4 Expected class, delegate, enum, interface, or struct C:\Users\Srikanth\Documents\Visual Studio 2012\Projects\sqlitesample\sqlitesample\Form1.cs 55 17 sqlitesample

Error is Unable to open the Database file

error in this

private void insertconnect_Click(object sender, EventArgs e)
{
// [snip] - As C# is purely object-oriented the following lines must be put into a class:

// We use these three SQLite objects:
SQLiteConnection sqlite_conn;
SQLiteCommand sqlite_cmd;
SQLiteDataReader sqlite_datareader;



sqlite_conn = new SQLiteConnection(); // Create an instance of the object
sqlite_conn.ConnectionString = "Data Source=c:\\eminosoft.db;Version=3;New=True;Compress=True;"; // Set the ConnectionString
sqlite_conn.Open(); // Open the connection. Now you can fire SQL-Queries

// create a new SQL command:
sqlite_cmd = sqlite_conn.CreateCommand();

}

Now iam getting error like this Unable to Open the Database

Now iam getting error like this Unable to Open the Database

now iam getting error like this = Unable to Open the Database

Now the Error is Unable to Open the Database

now the error is Unable to open the database

now i did another sqlite sample same but getting error is


by clicking button it get like this Could not load file or assembly 'System.Data.SQLite, Version=1.0.94.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

now iam getting error like this
Error 2 Expected class, delegate, enum, interface, or struct c:\users\srikanth\documents\visual studio 2012\Projects\usesqlitecsharp\usesqlitecsharp\Form1.cs 35 17 usesqlitecsharp

now iam getting error like this
Error 2 Expected class, delegate, enum, interface, or struct c:\users\srikanth\documents\visual studio 2012\Projects\usesqlitecsharp\usesqlitecsharp\Form1.cs 35 17 usesqlitecsharp

hello sir ans my question

error is

Could not load file or assembly 'System.Data.SQLite, Version=1.0.94.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

now error is

Could not load file or assembly 'System.Data.SQLite, Version=1.0.94.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139' or one of its dependencies. An attempt was made to load a program with an incorrect format.

yeah i got it just now ... but didint connect to sqlite

Error 2 The name 'grid' does not exist in the current context c:\users\srikanth\documents\visual studio 2012\Projects\WindowsFormsApplication3\WindowsFormsApplication3\Form1.cs 36 17 Sqlite

Error 2 The name 'grid' does not exist in the current context c:\users\srikanth\documents\visual studio 2012\Projects\WindowsFormsApplication3\WindowsFormsApplication3\Form1.cs 36 17 Sqlite

Error 2 The name 'grid' does not exist in the current context c:\users\srikanth\documents\visual studio 2012\Projects\WindowsFormsApplication3\WindowsFormsApplication3\Form1.cs 36 17 Sqlite

have u got the solution

i send example..

send me ur code

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.Data.SqlClient;

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.Data.SqlClient;

Again getting same error

Again Getting same error

okay

what

issue solved ... thankq for remember the back end code

you can use this extension method and call it like this.

public static DataTable ToDataTable<t>(List<t> items)
{
DataTable dataTable = new DataTable(typeof(T).Name);

//Get all the properties
PropertyInfo[] Props = typeof(T).GetProperties(BindingFlags.Public | BindingFlags.Instance);
foreach (PropertyInfo prop in Props)
{
//Setting column names as Property names
dataTable.Columns.Add(prop.Name);
}
foreach (T item in items)
{
var values = new object[Props.Length];
for (int i = 0; i < Props.Length; i++)
{
//inserting property values to datatable rows
values[i] = Props[i].GetValue(item, null);
}
dataTable.Rows.Add(values);
}
//put a breakpoint here and check datatable
return dataTable;
}

click on postback property and select index.aspx k k

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
SqlCommand cmd;
//int upid;
string UserName;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
retrieve();
}
}
public void retrieve()
{
con.Open();
cmd = new SqlCommand("select * from tblRegistration where Email=@UserName");
cmd.Connection = con;
cmd.Parameters.AddWithValue("@UserName", Request.QueryString["UserName"]);
SqlDataAdapter da = new SqlDataAdapter(cmd);

//SqlDataReader dr=cmd.ExecuteReader();
DataTable dt = new DataTable();
da.Fill(dt);
txtFirstname.Text = dt.Rows[0].ItemArray[1].ToString();
txtLastname.Text = dt.Rows[0].ItemArray[2].ToString();
txtPwd.Text = dt.Rows[0].ItemArray[3].ToString();
string ddl = dt.Rows[0].ItemArray[4].ToString();
ddlNationality.Items.FindByText(ddl).Selected = true;
string cc = dt.Rows[0].ItemArray[5].ToString();
ddlCurrentLoc.Items.FindByText(cc).Selected = true;
txtMNum.Text = dt.Rows[0].ItemArray[6].ToString();
string gen = dt.Rows[0].ItemArray[7].ToString();
ddlGender.Items.FindByText(gen).Selected = true;
txtKeyskills.Text = dt.Rows[0].ItemArray[8].ToString();
txtResumeTitle.Text = dt.Rows[0].ItemArray[9].ToString();
//= dt.Rows[0].ItemArray[10].ToString();

string url1 = dt.Rows[0].ItemArray[11].ToString();
img.ImageUrl = "images/" + url1;
txtEmail.Text = dt.Rows[0].ItemArray[13].ToString();
cmd.ExecuteNonQuery();
con.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{

}
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;

public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
SqlCommand cmd;
//int upid;
string UserName;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
retrieve();
}
}
public void retrieve()
{
con.Open();
cmd = new SqlCommand("select * from tblRegistration where Email=@UserName");
cmd.Connection = con;
cmd.Parameters.AddWithValue("@UserName", Request.QueryString["UserName"]);
SqlDataAdapter da = new SqlDataAdapter(cmd);

//SqlDataReader dr=cmd.ExecuteReader();
DataTable dt = new DataTable();
da.Fill(dt);
txtFirstname.Text = dt.Rows[0].ItemArray[1].ToString();
txtLastname.Text = dt.Rows[0].ItemArray[2].ToString();
txtPwd.Text = dt.Rows[0].ItemArray[3].ToString();
string ddl = dt.Rows[0].ItemArray[4].ToString();
ddlNationality.Items.FindByText(ddl).Selected = true;
string cc = dt.Rows[0].ItemArray[5].ToString();
ddlCurrentLoc.Items.FindByText(cc).Selected = true;
txtMNum.Text = dt.Rows[0].ItemArray[6].ToString();
string gen = dt.Rows[0].ItemArray[7].ToString();
ddlGender.Items.FindByText(gen).Selected = true;
txtKeyskills.Text = dt.Rows[0].ItemArray[8].ToString();
txtResumeTitle.Text = dt.Rows[0].ItemArray[9].ToString();
//= dt.Rows[0].ItemArray[10].ToString();

string url1 = dt.Rows[0].ItemArray[11].ToString();
img.ImageUrl = "images/" + url1;
txtEmail.Text = dt.Rows[0].ItemArray[13].ToString();
cmd.ExecuteNonQuery();
con.Close();
}
protected void btnSubmit_Click(object sender, EventArgs e)
{

}
}

iam creating register page so i dont know code , pls help me

try in ur pc n reply

[WebMethod]
[ScriptMethod(UseHttpGet = true, ResponseFormat = ResponseFormat.Json)]
public string Inserttblval(string UserName, int CountryId, int IsActive)

{
int rowsInserted;
SqlConnection conn = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([CountryId],[UserName],[IsActive]) VALUES ({0},'{1}',{2})", CountryId,UserName, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
return string.Format("1 Row inserted");
}


error is

Error 3 The type or namespace name 'ScriptMethodAttribute' could not be found (are you missing a using directive or an assembly reference?) E:\mine\webserviceasp.net1\App_Code\WebService.cs 39 5 webserviceasp.net1

Error 3 The type or namespace name 'ScriptMethodAttribute' could not be found (are you missing a using directive or an assembly reference?) E:\mine\webserviceasp.net1\App_Code\WebService.cs 39 5 webserviceasp.net1

so wt , try it once

where

hellooo

hello sir give ur mailid ... my id nandyala.bhagyaraj@gmail.com

no sir , iam tired to know that, still trying but no use

hi sir

i need json code like this

xml example
<employees>
<employee>
<firstname>John <lastname>Doe

<employee>
<firstname>Anna <lastname>Smith

<employee>
<firstname>Peter <lastname>Jones

json example {"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}

json format means just like text

okay thankq so much....

I Can Understand your Problem... Ok Im Sorry for disturbing you . k dont mind Iam a fresher in small company , in my office iam only dotnet employee... once again sorrrrrryyyyy sir

hello sir busy aah

Do U got it Wt Iam Saying

my question is if i give values in (username , countryid , isActive ) and i want to display the values in json format

my question is if i give values in (username , countryid , isActive ) and i want to display the values in json format

i want display the Username , countryid, isactive in json format ....not 1row submitted like this

<string xmlns="http://tempuri.org/">Thank you, 1 number of rows inserted!

my mailid= nandyala.bhagyaraj@gmail.com ... cantact me sir i can learn each n eveything from u

always open in xml format only

did not get json format

ok ok no problem

oh k k ... in default.aspx page iam getting error like that, and in webservice again same xml code is running ....

USERNAME ACCEPTING INTEGER VALUES ONLY . HOW CAN I CHANGE THAT

hello sir .. every thing is okay , but did not get out put in json

hello sir . i want button code (cs)

helllloooooooooooo sir

sir pls send button code

sorry for late reply. here power issue...
where is button code

blank page

after click button didn't show anything

error in cs page.
return ws.<pre>Inserttblval(eno, ename, salary);

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data.SqlClient;
using System.Collections;
using System.Data;
///

/// Summary description for WebService
///

[WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line.
// [System.Web.Script.Services.ScriptService]
public class WebService : System.Web.Services.WebService
{
private string conStr;

public WebService()
{

//Uncomment the following line if using designed components
//InitializeComponent();
}

[WebMethod]
public string HelloWorld()
{
return "Hello World";
}
[WebMethod]
public int Add(int num1, int num2)
{
return (num1 + num2);
}

[WebMethod]
public string Inserttblval(int CountryId, String UserName, int IsActive)
{
int rowsInserted;
SqlConnection conn = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
string sql = string.Format(@"INSERT INTO [TestDB].[dbo].[Table_1] ([UserName],[CountryId],[IsActive]) VALUES ({0},'{1}',{2})", UserName, CountryId, IsActive);
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = sql;
cmd.CommandType = CommandType.Text;
conn.Open();
rowsInserted = cmd.ExecuteNonQuery();
conn.Close();
cmd = null;
return string.Format("row inserted!", rowsInserted);
}
}

getting error like this....
Input string was not in a correct format.

again getting same error

again getting error

sry dont mind pls..im tired to get result...

again getting same error

Error 6 'WebService' does not contain a definition for 'inserttblval' and no extension method 'inserttblval' accepting a first argument of type 'WebService' could be found (are you missing a using directive or an assembly reference?) E:\mine\webserviceasp.net1\App_Code\WebService.cs 30 19 webserviceasp.net1

oh k k
then what i do next

and the values are displaying in json format

i want this html value in json

sir how can we display values after click button [username , countryid,isactive]

please tell sir . i want to know that ..

hello Sir you Tell I can Learn From uu

hello sir .. i want UserName,CountryId,IsActive in Json Format

JSON Format



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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{
width: 100%;
}
.auto-style2
{
height: 26px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<script>
var text = '{"UserName":"John Johnson","CountryId":"16","IsActive":"7"}'

var obj = JSON.parse(text);

document.getElementById("demo").innerHTML =
obj.name + "<br>" +
obj.street + "<br>" +
obj.phone;
</script>
</form>
</body>
</html>

protected void Button1_Click(object sender, EventArgs e)
{
WebService ws = new WebService();
Label1.Text = ws.Inserttblval("UserName,CountryId,IsActive").ToString();
}

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

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<style type="text/css">
.auto-style1
{
width: 100%;
}
.auto-style2
{
height: 26px;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div>

<table align="center" class="auto-style1">
<tr>
<td>UserName</td>
<td>
<asp:TextBox ID="TextBox1" runat="server">
</td>
<td> </td>
</tr>
<tr>
<td>CountryId </td>
<td>
<asp:TextBox ID="TextBox2" runat="server">
</td>
<td> </td>
</tr>
<tr>
<td class="auto-style2">IsActive</td>
<td class="auto-style2">
<asp:TextBox ID="TextBox3" runat="server">
</td>
<td class="auto-style2"></td>
</tr>
<tr>
<td> </td>
<td>
<asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" />
</td>
<td> </td>
</tr>
<tr>
<td>Result:</td>
<td>
<asp:Label ID="Label1" runat="server" Text="">
</td>
<td> </td>
</tr>
</table>

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

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}

sorry for late reply ... here no power for 2hours .. error is Error 1 The name 'UserName' does not exist in the current context E:\mine\webserviceasp.net1\Default.aspx.cs 17 39 webserviceasp.net1

tell me process from start to end ...

please tell step by step ...process plsssssss

yes

getting error
System.InvalidOperationException: The ConnectionString property has not been initialized.
at System.Data.SqlClient.SqlConnection.PermissionDemand()
at System.Data.SqlClient.SqlConnectionFactory.PermissionDemand(DbConnection outerConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at WebService.InsertWebservice(Int32 CountryId, String UserName, String IsActive) in e:\mine\webserviceasp.net1\App_Code\WebService.cs:line 47

i dont know about webservice thats y iam asking each n everything

now iam getting page like this



Directory Listing -- /WebSite8/

Monday, August 18, 2014 06:39 PM App_Code
Thursday, August 21, 2014 10:13 AM App_WebReferences
Thursday, July 31, 2014 02:23 PM Style
Wednesday, July 30, 2014 04:14 PM 35,980 14 - 1.jpg
Wednesday, July 30, 2014 04:14 PM 56,617 2014-07-30 - 1 (2).jpg
Wednesday, July 30, 2014 04:17 PM 35,561 2014-07-30 - 1.jpg
Friday, August 01, 2014 07:17 AM 803 aboutus.aspx
Thursday, July 31, 2014 04:20 PM 279 aboutus.aspx.cs
Wednesday, July 30, 2014 04:43 PM 2,371 calculator.aspx
Thursday, July 24, 2014 12:35 PM 1,098 calculator.aspx.cs
Friday, August 01, 2014 07:16 AM 508 category.aspx
Thursday, July 31, 2014 04:12 PM 280 category.aspx.cs
Friday, August 01, 2014 07:19 AM 546 contactus.aspx
Thursday, July 31, 2014 04:16 PM 281 contactus.aspx.cs
Thursday, July 31, 2014 10:49 AM 2,289 Datalistaspx.aspx
Thursday, July 31, 2014 10:47 AM 804 Datalistaspx.aspx.cs
Wednesday, July 30, 2014 04:40 PM 3,309 EmployeDetails.aspx
Thursday, July 31, 2014 09:36 AM 1,676 EmployeDetails.aspx.cs
Friday, August 01, 2014 02:55 AM 4,213 Gridview.aspx
Thursday, July 31, 2014 09:54 AM 774 Gridview.aspx.cs
Wednesday, July 30, 2014 04:15 PM 123,451 IMG_2770.JPG
Monday, August 18, 2014 05:31 PM 3,202 loginpage.aspx
Monday, August 18, 2014 05:27 PM 466 loginpage.aspx.cs
Friday, August 01, 2014 06:57 AM 1,347 MasterPage.master
Thursday, July 31, 2014 02:05 PM 290 MasterPage.master.cs
Friday, August 01, 2014 07:22 AM 877 MMasterpage.aspx
Thursday, July 31, 2014 02:09 PM 280 MMasterpage.aspx.cs
Friday, August 01, 2014 06:52 AM 1,488 placeholder.aspx
Wednesday, July 30, 2014 04:32 PM 436 placeholder.aspx.cs
Friday, August 01, 2014 02:41 AM 893 QueryStringParams.aspx
Friday, August 01, 2014 02:39 AM 565 QueryStringParams.aspx.cs
Thursday, August 14, 2014 10:33 AM 3,048 Registrationpage.aspx
Thursday, July 24, 2014 02:30 PM 1,308 Registrationpage.aspx.cs
Thursday, August 21, 2014 10:13 AM 9,009 Web.config
Monday, July 21, 2014 09:28 PM 1,360 Web.Debug.config
Monday, August 18, 2014 06:39 PM 93 WebService.asmx
Friday, August 01, 2014 07:37 AM 2,534 website.publishproj
Version Information: ASP.NET Development Server 11.0.0.0

countryId Int IsActive int

Error 2 'WebService.db_insert(string, int, string)': not all code paths return a value E:\mine\rajservice2\App_Code\WebService.cs 31 19 rajservice2

i dont know about webservices , thats y am asking everything, so dont mind tell step by step

hello Vashishtha i dont get output (xml or Json).

yeah issue solved

hmm programme successfully , after click button it doesn't goes to db

do u got it wt iam saying

hmm then how can we use that page

after that its display blank page

after That it display blank page

Issued solved ... Thankq bro

Issue solved Thanks alot to Hard_Rockz ,ClimerChinna

issue solved .... thanks alot

issue solved thanks alot

<advertisement>
<ad>
<Image Url="imagess111.png"> </Image>
<navigate url="http://www.Google.com">
<alternate text="India">
<impressions>25

<ad>
<Image Url=""> </Image>
<navigate url="http://www.Google.com">
<alternate text="India">
<impressions>25

The AdRotator AdRotator1 could not find the AdvertisementFile or the file is invalid.

The AdRotator AdRotator1 could not find the AdvertisementFile or the file is invalid.

No No Issue is nOt Solved

Error 1 'ASP.default_aspx' does not contain a definition for 'AdRotator1_AdCreated' and no extension method 'AdRotator1_AdCreated' accepting a first argument of type 'ASP.default_aspx' could be found (are you missing a using directive or an assembly reference?) E:\mine\Advertisement\Default.aspx 15

<!--?xml version="1.0" encoding="utf-8" ?-->
<advertisement>
<ad>
<Image Url="14 - 1.jpg"> </Image>
<navigate url="http://www.Google.com">
<alternate text="India">
<impressions>25

<ad>
<Image Url="2014-07-30 - 1 (2).jpg"> </Image>
<navigate url="http://www.Google.com">
<alternate text="India">
<impressions>25

And 2nd error is


The AdRotator AdRotator1 could not find the AdvertisementFile or the file is invalid.

Error 1 The type or namespace name 'AdRotator' does not exist in the namespace 'System.Web.UI' (are you missing an assembly reference?) E:\mine\Advertisement\Default.aspx.cs 11 21 Advertisement

<applicationsettings>
<webapplication1.properties.settings>
<setting name="WebApplication1_Raj_changerate" serializeas="String">
<value>http://localhost:51569/changerate.asmx

<applicationsettings>
<webapplication1.properties.settings>
<setting name="WebApplication1_Raj_changerate" serializeas="String">
<value>http://localhost:51569/changerate.asmx

and also 2nd error is


Detailed Error Information:
Module DirectoryListingModule
Notification ExecuteRequestHandler
Handler StaticFile
Error Code 0x00000000
Requested URL http://localhost:51569/
Physical Path E:\mine\ChangerateWS
Logon Method Anonymous
Logon User Anonymous
Request Tracing Directory C:\Users\Srikanth\Documents\IISExpress\TraceLogFiles\CHANGERATEWS

Line 109: [System.Web.Services.Protocols.SoapDocumentMethodAttribute("http://tempuri.org/getrated", RequestNamespace="http://tempuri.org/", ResponseNamespace="http://tempuri.org/", Use=System.Web.Services.Description.SoapBindingUse.Literal, ParameterStyle=System.Web.Services.Protocols.SoapParameterStyle.Wrapped)]
Line 110: public System.Data.DataSet getrated() {
Line 111: object[] results = this.Invoke("getrated", new object[0]);
Line 112: return ((System.Data.DataSet)(results[0]));
Line 113: }

hello bro ....

Visual Studio

no no

HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.

Most likely causes:
A default document is not configured for the requested URL, and directory browsing is not enabled on the server.

Things you can try:
If you do not want to enable directory browsing, ensure that a default document is configured and that the file exists.
Enable directory browsing.
Go to the IIS Express install directory.
Run appcmd set config /section:system.webServer/directoryBrowse /enabled:true to enable directory browsing at the server level.
Run appcmd set config ["SITE_NAME"] /section:system.webServer/directoryBrowse /enabled:true to enable directory browsing at the site level.
Verify that the configuration/system.webServer/directoryBrowse@enabled attribute is set to true in the site or application configuration file.

Detailed Error Information:
Module DirectoryListingModule
Notification ExecuteRequestHandler
Handler StaticFile
Error Code 0x00000000
Requested URL http://localhost:51569/
Physical Path E:\mine\ChangerateWS
Logon Method Anonymous
Logon User Anonymous
Request Tracing Directory C:\Users\Srikanth\Documents\IISExpress\TraceLogFiles\CHANGERATEWS

More Information:
This error occurs when a document is not specified in the URL, no default document is specified for the Web site or application, and directory listing is not enabled for the Web site or application. This setting may be disabled on purpose to secure the contents of the server.
View more information »

HTTP Error 403.14 - Forbidden
The Web server is configured to not list the contents of this directory.

Most likely causes:
A default document is not configured for the requested URL, and directory browsing is not enabled on the server.

Things you can try:
If you do not want to enable directory browsing, ensure that a default document is configured and that the file exists.
Enable directory browsing.
Go to the IIS Express install directory.
Run appcmd set config /section:system.webServer/directoryBrowse /enabled:true to enable directory browsing at the server level.
Run appcmd set config ["SITE_NAME"] /section:system.webServer/directoryBrowse /enabled:true to enable directory browsing at the site level.
Verify that the configuration/system.webServer/directoryBrowse@enabled attribute is set to true in the site or application configuration file.

Detailed Error Information:
Module DirectoryListingModule
Notification ExecuteRequestHandler
Handler StaticFile
Error Code 0x00000000
Requested URL http://localhost:51569/
Physical Path E:\mine\ChangerateWS
Logon Method Anonymous
Logon User Anonymous
Request Tracing Directory C:\Users\Srikanth\Documents\IISExpress\TraceLogFiles\CHANGERATEWS

More Information:
This error occurs when a document is not specified in the URL, no default document is specified for the Web site or application, and directory listing is not enabled for the Web site or application. This setting may be disabled on purpose to secure the contents of the server.
View more information »

please tell clearlyyyyy

i can't get u ... please tell step by step

again getting error

ha yeah

Warning 2 Validation (XHTML5): Element 'edititemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 23 18 WebSite8
Warning 3 Unrecognized tag prefix or device filter 'asp'. E:\mine\WebSite8\Default.aspx 24 22 WebSite8
Warning 4 Validation (XHTML5): Element 'itemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 26 18 WebSite8
Warning 5 Unrecognized tag prefix or device filter 'asp'. E:\mine\WebSite8\Default.aspx 27 22 WebSite8
Warning 6 Validation (XHTML5): Element 'edititemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 30 18 WebSite8
Warning 7 Unrecognized tag prefix or device filter 'asp'. E:\mine\WebSite8\Default.aspx 31 22 WebSite8
Warning 8 Validation (XHTML5): Element 'itemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 33 18 WebSite8
Warning 9 Unrecognized tag prefix or device filter 'asp'. E:\mine\WebSite8\Default.aspx 34 22 WebSite8
Warning 10 Validation (XHTML5): Element 'edititemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 37 18 WebSite8
Warning 11 Unrecognized tag prefix or device filter 'asp'. E:\mine\WebSite8\Default.aspx 38 22 WebSite8
Warning 12 Validation (XHTML5): Element 'itemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 40 18 WebSite8
Warning 13 Unrecognized tag prefix or device filter 'asp'. E:\mine\WebSite8\Default.aspx 41 22 WebSite8
Error 14 The server tag is not well formed. E:\mine\WebSite8\Default.aspx 17
Error 15 The server tag is not well formed. E:\mine\WebSite8\Default.aspx 20
Error 16 Type 'System.Web.UI.WebControls.TemplateField' does not have a public property named 'xmlns:asp'. E:\mine\WebSite8\Default.aspx 22
Error 17 System.Web.UI.WebControls.DataControlFieldCollection must have items of type 'System.Web.UI.WebControls.DataControlField'. 'edititemtemplate' is of type 'System.Web.UI.HtmlControls.HtmlGenericControl'. E:\mine\WebSite8\Default.aspx 23
Error 18 The server tag is not well formed. E:\mine\WebSite8\Default.aspx 24
Error 19 Literal content ('<asp:textbox id="textbox1" runat="server" Text="') is not allowed within a 'System.Web.UI.WebControls.DataControlFieldCollection'. E:\mine\WebSite8\Default.aspx 24
Warning 1 Validation (XHTML5): Attribute 'align' is not a valid attribute of element 'table'. E:\mine\WebSite8\Registrationpage.aspx 13 20 WebSite8

Warning 2 Validation (XHTML5): Element 'edititemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 23 18 WebSite8

now iam getting error
Error 3 Unexpected end of file looking for tag. E:\mine\WebSite8\Default.aspx 32

Error 2 The name 'lbl1' does not exist in the current context E:\mine\WebSite8\Default.aspx 17
Error 3 The name 'lbl2' does not exist in the current context E:\mine\WebSite8\Default.aspx 22
Error 4 The name 'lbl3' does not exist in the current context E:\mine\WebSite8\Default.aspx 27
Error 8 The name 'lbl1' does not exist in the current context e:\mine\WebSite8\Default.aspx 17 73 WebSite8
Error 9 The name 'lbl2' does not exist in the current context e:\mine\WebSite8\Default.aspx 22 73 WebSite8
Error 10 The name 'lbl3' does not exist in the current context e:\mine\WebSite8\Default.aspx 27 73 WebSite8
Error 5 The name 'lbl1' does not exist in the current context E:\mine\WebSite8\Default.aspx.cs 36 13 WebSite8
Error 6 The name 'lbl12' does not exist in the current context E:\mine\WebSite8\Default.aspx.cs 36 36 WebSite8
Error 7 The name 'lbl3' does not exist in the current context E:\mine\WebSite8\Default.aspx.cs 36 57 WebSite8
Warning 1 Validation (XHTML5): Attribute 'align' is not a valid attribute of element 'table'. E:\mine\WebSite8\Registrationpage.aspx 13 20 WebSite8

error is didinot connect to database

There is already an open DataReader associated with this Command which must be closed first





Line 21: SqlCommand com = new SqlCommand(checkuser, con);
Line 22: SqlDataReader dr = com.ExecuteReader();
Line 23: int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
Line 24: con.Close();
Line 25: if (temp == 1)

already added

Line 20: string checkuser = "select count(*) from UserData where [User Name]='" + TextBoxUserName.Text + "'";
Line 21: SqlCommand com = new SqlCommand(checkuser, con); SqlDataReader dr = com.ExecuteReader();
Line 22: int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
Line 23: con.Close();
Line 24: if (temp == 1)

There is already an open DataReader associated with this Command which must be closed first

There is already an open DataReader associated with this Command which must be closed first

error is ===Invalid OPeration Exception was Unhandle by user code


There is already an open DataReader associated with this Command which must be closed first.

getting errors....



Error 1 The type or namespace name 'SqlDatareader' could not be found (are you missing a using directive or an assembly reference?) C:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Login.aspx.cs 22 9 C:\...\LoginWebsite1\
Error 2 'System.Data.SqlClient.SqlCommand' does not contain a definition for 'executereader' and no extension method 'executereader' accepting a first argument of type 'System.Data.SqlClient.SqlCommand' could be found (are you missing a using directive or an assembly reference?) C:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Login.aspx.cs 22 32 C:\...\LoginWebsite1\
Error 3 The name 'temp' does not exist in the current context C:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Login.aspx.cs 28 13 C:\...\LoginWebsite1\

s no error
butdoen'tconnect to database connection

it doesn't goes to response.redirect pagen doesn't connect to
database

did not connect to database

did not connect todatabase

2nd error

protected void Button_Login_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser = "select count(*) from UserData where [User Name]='" + TextBoxUserName.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
con.Close();
if (temp == 1)
{
con.Open();
string checkPasswordQuery = "select password from UserData where [User Name]'" + TextBoxUserName.Text + "'";
SqlCommand passcom = new SqlCommand(checkPasswordQuery, con);
string password = passcom.ExecuteScalar().ToString().Replace(" ","");
if (password == TextBoxPassword.Text)
{
Session["New"] = TextBoxUserName.Text;
Response.Write("Password is correct");
Response.Redirect("Mnager.aspx");
}
else
{
Response.Write("password is not correct");
}

Thank so much brother.........

thanks bro

User already ExistsError:System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'User'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Registrationaspx.Button1_Click1(Object sender, EventArgs e) in c:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Registrationaspx.aspx.cs:line 41

now error in


User already ExistsError:System.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'User'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Registrationaspx.Button1_Click1(Object sender, EventArgs e) in c:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Registrationaspx.aspx.cs:line

this was the program


public partial class Registrationaspx : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser = "select count(*) from UserData where User Name='" + TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString());
if (temp == 1)
{
Response.Write("User already Exists");
}
con.Close();
}
}
protected void Button1_Click1(object sender, EventArgs e)
{
try
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string insertQuery = "insert into UserData(User Name,Email,Password,country)values(@Uname,@email,@password,@country)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Uname", TextBoxUN.Text);
com.Parameters.AddWithValue("@email", TextBoxEmail.Text);
com.Parameters.AddWithValue("@password", TextBoxPass.Text);
com.Parameters.AddWithValue("@country", DropDownListCountry.SelectedItem.ToString());

com.ExecuteNonQuery();
Response.Redirect("Mnager.aspx");
Response.Write("Registration is Successfull..........");

con.Close();
}
catch (Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
}
}

An expression of non-boolean type specified in a context where a condition is expected, near 'Name'.

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser="select count(*) from UserData where UserName='" +TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString ());
if (temp == 1)

error in line 20

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser="select count(*) from UserData where UserName='" +TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString ());
if (temp == 1

error is in line 20

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["RegistrationConnectionString"].ConnectionString);
con.Open();
string checkuser="select count(*) from UserData where UserName='" +TextBoxUN.Text + "'";
SqlCommand com = new SqlCommand(checkuser, con);
int temp = Convert.ToInt32(com.ExecuteScalar().ToString ());
if (temp == 1)

yes iam using image control

Image.ImageUrl = "C:\\Avail.Prg";
Button1.Text = "Off";
}
else
{
Image.ImageUrl = "c:\\not avail.prg";
Button1.Text = "on";

no ...but small error in that

s

Error 2 An object reference is required for the non-static field, method, or property 'System.Web.UI.WebControls.Image.ImageUrl.get' C:\Users\bhagya\Documents\Visual Studio 2010\WebSites\image\Default.aspx.cs 23 13 C:\...\image\

bro

Error 1 ; expected C:\Users\bhagya\Documents\Visual Studio 2010\WebSites\server.excute\Default.aspx.cs 20 84 C:\...\server.excute\

in this line
if (string.IsNullOrEmpty(TextBox1.Text))string.IsNullOrEmpty(TextBox2.Text)
{

protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
if (Button1.Text == "ON")
{
Image.ImageUrl = "C:\\Avail.Prg";
Button1.Text = "OFF";
}
else
{
Image4.ImageUrl = "C:\\Not avail>Prog";
Button1.Text = "ON";
}

Label1.Text="Name":+ TextBox1.Text+<br/> "Date Of Birth:"+Calender1.Selected Date.ToString("dd/mm/yyyy");

<asp:Button ID="Submit" runat="server" Text="Submit" Height="26px" />
<input id="Start Over" type="reset" value="Start Over" /></td>

Compilation Error

Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: CS1061: 'ASP.default_aspx' does not contain a definition for 'LinkButton2_Click' and no extension method 'LinkButton2_Click' accepting a first argument of type 'ASP.default_aspx' could be found (are you missing a using directive or an assembly reference?)

Source Error:


Line 45: 30MB</td>
Line 46: <td>
Line 47: <asp:LinkButton ID="LinkButton2" runat="server" onclick="LinkButton2_Click">DOWNLOAD NOW
Line 48: </td>
Line 49: </tr>

Source File: c:\Users\MR003\Documents\Visual Studio 2010\Projects\downloading server to client\downloading server to client\Default.aspx Line: 47


Show Detailed Compiler Output:

Show Complete Compilation Source:


Version Information: Microsoft .NET Framework Vers

iam getting errors in this

can u forward the correct program...

my program is entirely wrong

what is the exact program...

yes ...
lots of errors

entire program

issue solved

hi bro . i want to learn websecurity... is there any forums related ...........