Click here to Skip to main content
15,032,024 members

Comments by harshavardhan12345678 (Top 200 by date)

harshavardhan12345678 24-Jan-18 23:32pm View
   
Okay .
harshavardhan12345678 29-Oct-15 13:29pm View
   
And also me added service reference to the application but it doesn't works ...
harshavardhan12345678 22-Mar-15 15:29pm View
   
my action metho

public ActionResult Index()
{
List<employee> Samples = new List<employee>()
{
new Employee{EmpID=1,Empname="Bhagyaraj"},
new Employee{EmpID=2,Empname="Mohan"}
};
return View();
}
harshavardhan12345678 22-Mar-15 15:26pm View
   
error is Object reference not set to an instance of an object.
harshavardhan12345678 19-Sep-14 0:44am View
   
Have u got the Answer
harshavardhan12345678 18-Sep-14 8:46am View
   
how to create a new sqlite database in server explorer
harshavardhan12345678 18-Sep-14 8:01am View
   
sorry sir ,that is previous code ... now tell me sir how to add sqlite database connection in server explorer
harshavardhan12345678 18-Sep-14 7:55am View
   
no , issue not solved sir
harshavardhan12345678 18-Sep-14 6:15am View
   
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
harshavardhan12345678 18-Sep-14 3:32am View
   
Deleted
iam the new one and i can learn each n every thing so , i ask any questions ...... is it wrong
harshavardhan12345678 18-Sep-14 2:21am View
   
dont mind iam a fresher thats y iam asking ...
harshavardhan12345678 18-Sep-14 2:20am View
   
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
harshavardhan12345678 18-Sep-14 1:46am View
   
Error is Unable to open the Database file
harshavardhan12345678 18-Sep-14 1:44am View
   
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();

}
harshavardhan12345678 17-Sep-14 23:50pm View
   
Now iam getting error like this Unable to Open the Database
harshavardhan12345678 17-Sep-14 23:49pm View
   
Now iam getting error like this Unable to Open the Database
harshavardhan12345678 17-Sep-14 23:49pm View
   
now iam getting error like this = Unable to Open the Database
harshavardhan12345678 17-Sep-14 23:48pm View
   
Now the Error is Unable to Open the Database
harshavardhan12345678 17-Sep-14 23:36pm View
   
now the error is Unable to open the database
harshavardhan12345678 17-Sep-14 8:54am View
   
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.
harshavardhan12345678 17-Sep-14 6:41am View
   
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
harshavardhan12345678 17-Sep-14 6:40am View
   
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
harshavardhan12345678 17-Sep-14 3:00am View
   
hello sir ans my question
harshavardhan12345678 17-Sep-14 2:24am View
   
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.
harshavardhan12345678 17-Sep-14 2:23am View
   
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.
harshavardhan12345678 17-Sep-14 2:17am View
   
yeah i got it just now ... but didint connect to sqlite
harshavardhan12345678 17-Sep-14 2:08am View
   
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
harshavardhan12345678 17-Sep-14 2:08am View
   
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
harshavardhan12345678 17-Sep-14 2:07am View
   
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
harshavardhan12345678 13-Sep-14 1:19am View
   
have u got the solution
harshavardhan12345678 13-Sep-14 1:11am View
   
i send example..
harshavardhan12345678 13-Sep-14 1:01am View
   
send me ur code
harshavardhan12345678 4-Sep-14 9:16am View
   
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;
harshavardhan12345678 4-Sep-14 9:16am View
   
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;
harshavardhan12345678 4-Sep-14 9:12am View
   
Again getting same error
harshavardhan12345678 4-Sep-14 9:12am View
   
Again Getting same error
harshavardhan12345678 4-Sep-14 2:12am View
   
okay
harshavardhan12345678 4-Sep-14 2:11am View
   
what
harshavardhan12345678 4-Sep-14 2:04am View
   
issue solved ... thankq for remember the back end code
harshavardhan12345678 1-Sep-14 3:17am View
   
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;
}
harshavardhan12345678 1-Sep-14 2:49am View
   
click on postback property and select index.aspx k k
harshavardhan12345678 1-Sep-14 2:43am View
   
Deleted
its sample
harshavardhan12345678 27-Aug-14 9:02am View
   
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)
{

}
}
harshavardhan12345678 27-Aug-14 9:02am View
   
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)
{

}
}
harshavardhan12345678 26-Aug-14 6:46am View
   
iam creating register page so i dont know code , pls help me
harshavardhan12345678 26-Aug-14 3:39am View
   
try in ur pc n reply
harshavardhan12345678 25-Aug-14 23:45pm View
   
[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
harshavardhan12345678 25-Aug-14 23:44pm View
   
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
harshavardhan12345678 25-Aug-14 7:00am View
   
so wt , try it once
harshavardhan12345678 25-Aug-14 6:58am View
   
where
harshavardhan12345678 25-Aug-14 6:11am View
   
hellooo
harshavardhan12345678 25-Aug-14 5:56am View
   
hello sir give ur mailid ... my id nandyala.bhagyaraj@gmail.com
harshavardhan12345678 25-Aug-14 5:36am View
   
no sir , iam tired to know that, still trying but no use
harshavardhan12345678 25-Aug-14 5:18am View
   
hi sir
harshavardhan12345678 25-Aug-14 3:07am View
   
i need json code like this
harshavardhan12345678 22-Aug-14 6:16am View
   
xml example
<employees>
<employee>
<firstname>John <lastname>Doe

<employee>
<firstname>Anna <lastname>Smith

<employee>
<firstname>Peter <lastname>Jones

harshavardhan12345678 22-Aug-14 6:16am View
   
json example {"employees":[
{"firstName":"John", "lastName":"Doe"},
{"firstName":"Anna", "lastName":"Smith"},
{"firstName":"Peter", "lastName":"Jones"}
]}
harshavardhan12345678 22-Aug-14 6:15am View
   
json format means just like text
harshavardhan12345678 22-Aug-14 5:55am View
   
okay thankq so much....
harshavardhan12345678 22-Aug-14 5:46am View
   
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
harshavardhan12345678 22-Aug-14 5:35am View
   
hello sir busy aah
harshavardhan12345678 22-Aug-14 5:30am View
   
Do U got it Wt Iam Saying
harshavardhan12345678 22-Aug-14 5:26am View
   
my question is if i give values in (username , countryid , isActive ) and i want to display the values in json format
harshavardhan12345678 22-Aug-14 5:25am View
   
my question is if i give values in (username , countryid , isActive ) and i want to display the values in json format
harshavardhan12345678 22-Aug-14 5:22am View
   
i want display the Username , countryid, isactive in json format ....not 1row submitted like this
harshavardhan12345678 22-Aug-14 5:21am View
   
<string xmlns="http://tempuri.org/">Thank you, 1 number of rows inserted!
harshavardhan12345678 22-Aug-14 5:18am View
   
my mailid= nandyala.bhagyaraj@gmail.com ... cantact me sir i can learn each n eveything from u
harshavardhan12345678 22-Aug-14 5:15am View
   
always open in xml format only
harshavardhan12345678 22-Aug-14 5:14am View
   
did not get json format
harshavardhan12345678 22-Aug-14 5:09am View
   
ok ok no problem
harshavardhan12345678 22-Aug-14 5:07am View
   
oh k k ... in default.aspx page iam getting error like that, and in webservice again same xml code is running ....
harshavardhan12345678 22-Aug-14 4:04am View
   
USERNAME ACCEPTING INTEGER VALUES ONLY . HOW CAN I CHANGE THAT
harshavardhan12345678 22-Aug-14 3:59am View
   
hello sir .. every thing is okay , but did not get out put in json
harshavardhan12345678 22-Aug-14 3:50am View
   
hello sir . i want button code (cs)
harshavardhan12345678 22-Aug-14 3:46am View
   
helllloooooooooooo sir
harshavardhan12345678 22-Aug-14 3:28am View
   
sir pls send button code
harshavardhan12345678 22-Aug-14 3:14am View
   
sorry for late reply. here power issue...
where is button code
harshavardhan12345678 22-Aug-14 0:59am View
   
blank page
harshavardhan12345678 22-Aug-14 0:59am View
   
after click button didn't show anything
harshavardhan12345678 22-Aug-14 0:55am View
   
error in cs page.
return ws.<pre>Inserttblval(eno, ename, salary);
harshavardhan12345678 22-Aug-14 0:31am View
   
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);
}
}
harshavardhan12345678 21-Aug-14 10:01am View
   
getting error like this....
Input string was not in a correct format.
harshavardhan12345678 21-Aug-14 9:51am View
   
again getting same error
harshavardhan12345678 21-Aug-14 9:50am View
   
again getting error
harshavardhan12345678 21-Aug-14 9:34am View
   
sry dont mind pls..im tired to get result...
harshavardhan12345678 21-Aug-14 9:22am View
   
again getting same error
harshavardhan12345678 21-Aug-14 9:16am View
   
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
harshavardhan12345678 21-Aug-14 6:13am View
   
oh k k
then what i do next
harshavardhan12345678 21-Aug-14 6:05am View
   
and the values are displaying in json format
harshavardhan12345678 21-Aug-14 6:05am View
   
i want this html value in json
harshavardhan12345678 21-Aug-14 5:52am View
   
sir how can we display values after click button [username , countryid,isactive]
harshavardhan12345678 21-Aug-14 5:47am View
   
please tell sir . i want to know that ..
harshavardhan12345678 21-Aug-14 5:42am View
   
hello Sir you Tell I can Learn From uu
harshavardhan12345678 21-Aug-14 5:00am View
   
hello sir .. i want UserName,CountryId,IsActive in Json Format
harshavardhan12345678 21-Aug-14 3:59am View
   
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>
harshavardhan12345678 21-Aug-14 3:38am View
   
protected void Button1_Click(object sender, EventArgs e)
{
WebService ws = new WebService();
Label1.Text = ws.Inserttblval("UserName,CountryId,IsActive").ToString();
}
harshavardhan12345678 21-Aug-14 3:36am View
   
<%@ 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>
harshavardhan12345678 21-Aug-14 3:23am View
   
iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}
harshavardhan12345678 21-Aug-14 3:22am View
   
iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}
harshavardhan12345678 21-Aug-14 3:22am View
   
iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}
harshavardhan12345678 21-Aug-14 3:22am View
   
iam getting error like this
public object Inserttblval(string p)
{
throw new NotImplementedException();
}
harshavardhan12345678 21-Aug-14 3:17am View
   
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
harshavardhan12345678 21-Aug-14 0:54am View
   
tell me process from start to end ...
harshavardhan12345678 21-Aug-14 0:52am View
   
please tell step by step ...process plsssssss
harshavardhan12345678 21-Aug-14 0:50am View
   
yes
harshavardhan12345678 21-Aug-14 0:48am View
   
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
harshavardhan12345678 21-Aug-14 0:46am View
   
i dont know about webservice thats y iam asking each n everything
harshavardhan12345678 21-Aug-14 0:45am View
   
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
harshavardhan12345678 21-Aug-14 0:31am View
   
countryId Int IsActive int
harshavardhan12345678 20-Aug-14 3:45am View
   
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
harshavardhan12345678 20-Aug-14 3:38am View
   
i dont know about webservices , thats y am asking everything, so dont mind tell step by step
harshavardhan12345678 20-Aug-14 3:26am View
   
hello Vashishtha i dont get output (xml or Json).
harshavardhan12345678 20-Aug-14 3:18am View
   
yeah issue solved
harshavardhan12345678 20-Aug-14 3:12am View
   
hmm programme successfully , after click button it doesn't goes to db
harshavardhan12345678 20-Aug-14 2:54am View
   
do u got it wt iam saying
harshavardhan12345678 20-Aug-14 2:54am View
   
hmm then how can we use that page
harshavardhan12345678 20-Aug-14 2:45am View
   
after that its display blank page
harshavardhan12345678 20-Aug-14 2:44am View
   
after That it display blank page
harshavardhan12345678 19-Aug-14 1:47am View
   
Deleted
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Services;
using System.Data;
using System.Data.SqlClient;
using System.Web.Script.Serialization;
using System.Web.Script.Services;
///
/// 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
{

public WebService()
{

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

[WebMethod]
public string HelloWorld()
{
return "Hello World";

}
[WebMethod]
public void db_insert(string UserName ,int countryId ,string IsActive)
{
SqlConnection con = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
SqlCommand cmd = new SqlCommand("insert into Table_1 values(@a,@b,@c)", con);

cmd.Parameters.AddWithValue("a", UserName);
cmd.Parameters.AddWithValue("b", countryId);
cmd.Parameters.AddWithValue("c", IsActive);
int i = cmd.ExecuteNonQuery();
}

}
harshavardhan12345678 8-Aug-14 5:00am View
   
Issued solved ... Thankq bro
harshavardhan12345678 8-Aug-14 3:45am View
   
Issue solved Thanks alot to Hard_Rockz ,ClimerChinna
harshavardhan12345678 8-Aug-14 3:43am View
   
issue solved .... thanks alot
harshavardhan12345678 8-Aug-14 3:43am View
   
issue solved thanks alot
harshavardhan12345678 8-Aug-14 3:34am View
   
<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

harshavardhan12345678 8-Aug-14 3:08am View
   
The AdRotator AdRotator1 could not find the AdvertisementFile or the file is invalid.
harshavardhan12345678 8-Aug-14 3:08am View
   
The AdRotator AdRotator1 could not find the AdvertisementFile or the file is invalid.
harshavardhan12345678 8-Aug-14 1:27am View
   
No No Issue is nOt Solved
harshavardhan12345678 8-Aug-14 1:18am View
   
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
harshavardhan12345678 8-Aug-14 1:16am View
   
<!--?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

harshavardhan12345678 8-Aug-14 1:16am View
   
Deleted
i did this ...

<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

harshavardhan12345678 8-Aug-14 1:05am View
   
And 2nd error is


The AdRotator AdRotator1 could not find the AdvertisementFile or the file is invalid.
harshavardhan12345678 8-Aug-14 0:53am View
   
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
harshavardhan12345678 5-Aug-14 0:38am View
   
<applicationsettings>
<webapplication1.properties.settings>
<setting name="WebApplication1_Raj_changerate" serializeas="String">
<value>http://localhost:51569/changerate.asmx

harshavardhan12345678 5-Aug-14 0:37am View
   
<applicationsettings>
<webapplication1.properties.settings>
<setting name="WebApplication1_Raj_changerate" serializeas="String">
<value>http://localhost:51569/changerate.asmx

harshavardhan12345678 5-Aug-14 0:27am View
   
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
harshavardhan12345678 5-Aug-14 0:24am View
   
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: }
harshavardhan12345678 4-Aug-14 9:41am View
   
hello bro ....
harshavardhan12345678 4-Aug-14 9:29am View
   
Visual Studio
harshavardhan12345678 4-Aug-14 7:26am View
   
no no
harshavardhan12345678 4-Aug-14 7:17am View
   
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 »
harshavardhan12345678 4-Aug-14 7:15am View
   
Deleted
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 »
harshavardhan12345678 4-Aug-14 7:14am View
   
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 »
harshavardhan12345678 4-Aug-14 7:14am View
   
Deleted
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 »
harshavardhan12345678 4-Aug-14 6:11am View
   
please tell clearlyyyyy
harshavardhan12345678 4-Aug-14 6:10am View
   
i can't get u ... please tell step by step
harshavardhan12345678 4-Aug-14 5:59am View
   
again getting error
harshavardhan12345678 4-Aug-14 5:52am View
   
ha yeah
harshavardhan12345678 30-Jul-14 1:02am View
   
Deleted
source code



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

<!DOCTYPE html>

<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" AutoGenerateColumns="False" EnableModelValidation="True" OnRowDeleted="GridView1_RowDeleted" OnRowEditing="GridView1_RowEditing">
<columns>
<asp:TemplateField HeaderText="EmployeeID">
<itemtemplate>
<asp:Label ID="Lbl1EmployeeName" runat="server" Text='<%# Eval("EmployeeID") %>'>


<asp:TemplateField HeaderText="EmployeeName">
<itemtemplate>
<asp:Label ID="Lbl2EmployeeName" runat="server" Text='<%# Eval("EmployeeName") %>'>


<asp:TemplateField HeaderText="Qualification">
<itemtemplate>
<asp:Label ID="Lbl3Qualification" runat="server" Text='<%# Eval("Qualification") %>'>


<asp:TemplateField HeaderText="Gender">
<itemtemplate>
<asp:Label ID="Lbl4Gender" runat="server" Text='<%# Eval("Gender") %>"'>


<asp:TemplateField HeaderText="Address">
<itemtemplate>
<asp:Label ID="Lbl5Address" runat="server" Text='<%# Eval("Address") %>'>


<asp:TemplateField HeaderText="Operations">
<itemtemplate>
<asp:Button ID="btnedit" runat="server" CommandName="btnedit" Height="35px" Text="Edit" Width="70px" />
<asp:Button ID="btndelete" runat="server" CommandName="btndelete" Height="35px" Text="Delete" Width="62px" />



<emptydatatemplate>
Enter Employee Details



</div>
</form>
</body>
</html>
harshavardhan12345678 30-Jul-14 1:00am View
   
Deleted
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;
using System.Configuration;
public partial class Gridview : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("Data Source=SREENI\\SQLEXPRESS;Initial Catalog=TestDB;User ID=sa;Password=sa123");
SqlCommand cmd;
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter("Select * from tblEmployees", con);
DataSet ds = new DataSet();
da.Fill(ds);
con.Close();
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
protected void GridView1_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
s = WebConfigurationManager.ConnectionStrings["ChartDatabaseConnectionString"].ConnectionString;
con = new SqlConnection(s);
con.Open();
cmd = new SqlCommand();
cmd = new SqlCommand("delete from Employee where employee_name='", con);
cmd.ExecuteNonQuery();
con.Close();

}
}
harshavardhan12345678 24-Jul-14 7:27am View
   
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
harshavardhan12345678 24-Jul-14 7:26am View
   
Warning 2 Validation (XHTML5): Element 'edititemtemplate' is not supported. E:\mine\WebSite8\Default.aspx 23 18 WebSite8
harshavardhan12345678 24-Jul-14 7:14am View
   
now iam getting error
Error 3 Unexpected end of file looking for tag. E:\mine\WebSite8\Default.aspx 32
harshavardhan12345678 24-Jul-14 7:05am View
   
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
harshavardhan12345678 1-Mar-14 4:16am View
   
error is didinot connect to database
harshavardhan12345678 1-Mar-14 4:14am View
   
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)

harshavardhan12345678 1-Mar-14 3:33am View
   
already added
harshavardhan12345678 1-Mar-14 3:01am View
   
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)
harshavardhan12345678 1-Mar-14 2:16am View
   
There is already an open DataReader associated with this Command which must be closed first
harshavardhan12345678 1-Mar-14 2:14am View
   
There is already an open DataReader associated with this Command which must be closed first
harshavardhan12345678 1-Mar-14 1:53am View
   
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.
harshavardhan12345678 1-Mar-14 1:40am View
   
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\
harshavardhan12345678 1-Mar-14 1:32am View
   
s no error
butdoen'tconnect to database connection
harshavardhan12345678 27-Feb-14 6:31am View
   
it doesn't goes to response.redirect pagen doesn't connect to
database
harshavardhan12345678 27-Feb-14 6:29am View
   
did not connect to database
harshavardhan12345678 27-Feb-14 6:28am View
   
did not connect todatabase
harshavardhan12345678 27-Feb-14 6:01am View
   
2nd error
harshavardhan12345678 27-Feb-14 6:01am View
   
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");
}
harshavardhan12345678 27-Feb-14 2:00am View
   
Thank so much brother.........
harshavardhan12345678 27-Feb-14 1:47am View
   
thanks bro
harshavardhan12345678 27-Feb-14 1:27am View
   
Deleted
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..........");


}
catch (Exception ex)
{
Response.Write("Error:" + ex.ToString());
}
finally
{
con.Close();
}
}
harshavardhan12345678 27-Feb-14 1:22am View
   
Deleted
Error 1 The name 'con' does not exist in the current context C:\Users\MR002\Documents\Visual Studio 2010\WebSites\LoginWebsite1\Registrationaspx.aspx.cs 54 17 C:\...\LoginWebsite1\
harshavardhan12345678 27-Feb-14 1:07am View
   
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
harshavardhan12345678 27-Feb-14 0:01am View
   
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
harshavardhan12345678 26-Feb-14 23:47pm View
   
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());
}
}
}
harshavardhan12345678 26-Feb-14 23:39pm View
   
An expression of non-boolean type specified in a context where a condition is expected, near 'Name'.
harshavardhan12345678 26-Feb-14 23:32pm View
   
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)
harshavardhan12345678 26-Feb-14 23:30pm View
   
error in line 20
harshavardhan12345678 26-Feb-14 23:30pm View
   
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
harshavardhan12345678 26-Feb-14 7:03am View
   
error is in line 20
harshavardhan12345678 26-Feb-14 7:00am View
   
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)
harshavardhan12345678 14-Feb-14 1:37am View
   
yes iam using image control
harshavardhan12345678 14-Feb-14 1:27am View
   
Image.ImageUrl = "C:\\Avail.Prg";
Button1.Text = "Off";
}
else
{
Image.ImageUrl = "c:\\not avail.prg";
Button1.Text = "on";
harshavardhan12345678 14-Feb-14 1:24am View
   
no ...but small error in that
harshavardhan12345678 14-Feb-14 1:23am View
   
s
harshavardhan12345678 14-Feb-14 1:18am View
   
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\
harshavardhan12345678 14-Feb-14 0:15am View
   
bro
harshavardhan12345678 14-Feb-14 0:13am View
   
Error 1 ; expected C:\Users\bhagya\Documents\Visual Studio 2010\WebSites\server.excute\Default.aspx.cs 20 84 C:\...\server.excute\
harshavardhan12345678 14-Feb-14 0:07am View
   
in this line
if (string.IsNullOrEmpty(TextBox1.Text))string.IsNullOrEmpty(TextBox2.Text)
{
harshavardhan12345678 13-Feb-14 2:17am View
   
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";
}
harshavardhan12345678 13-Feb-14 1:12am View
   
Label1.Text="Name":+ TextBox1.Text+<br/> "Date Of Birth:"+Calender1.Selected Date.ToString("dd/mm/yyyy");
harshavardhan12345678 5-Feb-14 6:20am View
   
<asp:Button ID="Submit" runat="server" Text="Submit" Height="26px" />
<input id="Start Over" type="reset" value="Start Over" /></td>
harshavardhan12345678 1-Feb-14 1:08am View
   
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
harshavardhan12345678 1-Feb-14 0:23am View
   
iam getting errors in this
harshavardhan12345678 1-Feb-14 0:07am View
   
can u forward the correct program...
harshavardhan12345678 1-Feb-14 0:05am View
   
my program is entirely wrong
harshavardhan12345678 1-Feb-14 0:04am View
   
what is the exact program...
harshavardhan12345678 31-Jan-14 23:59pm View
   
yes ...
lots of errors
harshavardhan12345678 31-Jan-14 23:57pm View
   
entire program
harshavardhan12345678 30-Jan-14 23:51pm View
   
issue solved
harshavardhan12345678 30-Jan-14 6:59am View
   
hi bro . i want to learn websecurity... is there any forums related ...........