Comments by manishmns12 (Top 84 by date)

Invalid postback or callback argument. Event validation is enabled using <pages enableEventValidation="true"/> in configuration or <%@ Page EnableEventValidation="true" %> in a page. For security purposes, this feature verifies that arguments to postback or callback events originate from the server control that originally rendered them. If the data is valid and expected, use the ClientScriptManager.RegisterForEventValidation method in order to register the postback or callback data for validation.


how to get rid of this?

how can i do this by using command name,...please help me out

yes i had i had


protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
{


if (e.CommandName == "Delete")
{
SqlDataSource3.Delete();
GridView1.DataBind();
}

} and the Image button has commandname = delete

Thanks alot but i want to use an Imagebutton and on clicking it the row should be deleted..can u please help me for it

Thanks A lot...
i want to delete by doing the same..on clicking the button row should get deleted..
please help me out

sorry but i am adding a fresh value to a textbox which is inside gridview, i do not want to edit or update gridview, but instead i want it to be through textboxes..

sorry for that..i know i can make that through java script but i dont want that type of popup..
i need the same as i mentioned in the link..please help me na....

duplicate rows were coming so i suppressed duplicate entries but the issue now is that- because of supressing a large amount of blank space is been made in the detail section..
how to get rid if this??

ya i added it in detail section..
and i had performed suppresing duplicate value but the issue is- now only the first row from the table is been displayed not all the rows..

sir can u plz tell me how to retrieve images from database in datalist??

This is my question

sorry for the tag...
i want to upload a pic from windows form so hw cn i do that?

thanks alot..but i was finding for windows form not web form

sir please provide me some links for good ebooks for windows forms..i tries but was not sucessful....please provide me with some of them

please someone...help me to sort it out

and sir i dont want to authorise on users or accounts i want to change image and make it visible to all..only i admin can change the images..the other users cn only see the images

thanks but i f i give different pages and admin uploads(changes the originl pic with the older one) so how will be the image visible to other normal users..
please help me out

sir i will do that but the .cs page codings of the earliar page(which i excluded) will get to the new page..?????
i have used grid view sql data source...will all the contents and codings will be copied to the new page???

this is my career page directry...
what shld i do n where..


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

sir i have changed the table name to Currentrecruitment

it will work no????

com.Parameters.AddWithValue("@Name", "Test");


com.Parameters.AddWithValue("@Name", txtName.Text);

sir which one is right??

ok i m doing...but sir does the table name can cause issues...??
plz gv me guidance sir....
waiting for ur reply

please look at my issue nad help me out

please sir..hellp me frm this issue......

please sir....help me out....

please sir...looo at this proble...
n in last it was:
Institute nvarchar(MAX)

sorry sir but didnt undrstood...
cn u help me som,e more please.....
where to make what changes please...

thank you sir...
sir can u please look for this issue of mine...

eroor message is:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'Current'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate2.Button1_Click(Object sender, EventArgs e) ClientConnectionId:734911b1-d058-4fcb-a9aa-0bcb2e233ac6Thanks for Applying, We will response on your application shortly


my.cs code is:

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Earth;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into Current (Name,Emailaddress,Contactno,Qualification,Institute) values (@Name,@Emailaddress,@Contactno,@Qualification,@Institute)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@Emailaddress", txtEmailaddress.Text);
com.Parameters.AddWithValue("@Contactno", txtContactno.Text);
com.Parameters.AddWithValue("@Qualification", txtQualification.Text);
com.Parameters.AddWithValue("@Institute", txtInstitute.Text);

com.ExecuteNonQuery();

con.Close();

}



sql datatype is:
Name nvarchar(50)
Emailaddress nvarchar(50)
Contactno varchar(50)
Qualification nvarchar(50)
Institure nvarchar(MAX)

Name nvarchar(50)
Emailaddress nvarchar(50)
Contactno varchar(50)
Qualification nvarchar(50)
Institute nvarchar(MAX)

please sir make a reply..plz help me out

sir still a error is coming...
please help me abt this issue
error msg is:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near the keyword 'Current'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate2.Button1_Click(Object sender, EventArgs e) ClientConnectionId:90c4dbcb-71c0-4fff-809a-575c7a45d272Thanks for Applying, We will response on your application shortly

means....i may just paste the code after mine button click code na????
please sir...just lil more help

so i may just copy n paste, n do some modifications accordng to my mail n etc..n it may work....
i should paste it in button click na???
or any othr place???

as i m a novice so..asking this much

so i may just copy n paste, n do some modifications accordng to my mail n etc..n it may work....
i should paste it in button click na???
or any othr place???

as i m a novice so..asking this much

thanks alot for this...
but as my registrtn page is..if any users registers to me, the mail with his details should come to my address and one thanks mail to him...
"will it work for what i m asking

sorry but i know i m asking a lot n might b irritating u...but please help me out...i really need it importantly...

thanks alot for this...
but as my registrtn page is..if any users registers to me, the mail with his details should come to my address and one thanks mail to him...

sorry but i know i m asking a lot n might b irritating u...but please help me out...i really need it importantly...

thanks alot for this...
but as my registrtn page is..if any users registers to me, the mail with his details should come to my address and one thanks mail to him...

sorry but i know i m asking a lot n might b irritating u...but please help me out...i really need it importantly...

and sir how to get this ajax file upload sample...
its not showing in my toolbox...
can u tell me the entire process..
please i wl b very thankful to u...

ok thanks alot...but i m not awared of this so are there any measures to save it to database
can u help me out abt this plz..
i have used file upload tool

Thanks alot....


sir i had another page n there is one more option of uploading file...
n i want that the file should be saved in database so hw cn i do that..
what codings and in database which dtatype shld i use...as i had never done it before..uploading a file...so cn u please help me..

Thanks alot....


sir i had another page n there is one more option of uploading file...
n i want that the file should be saved in database so hw cn i do that..
what codings and in database which dtatype shld i use...as i had never done it before..uploading a file...so cn u please help me..

Thanks alot....


sir i had another page n there is one more option of uploading file...
n i want that the file should be saved in database so hw cn i do that..
what codings and in database which dtatype shld i use...as i had never done it before..uploading a file...so cn u please help me..

Sir what does this error means...how cn i overcome it...please help me out


Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@Contact". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate.Button1_Click(Object sender, EventArgs e) ClientConnectionId:835d11f0-b699-4386-b653-0c4bf6ed1bf7Thanks for Applying, We will response on your application shortly

Sir what does this error means...how cn i overcome it...please help me out


Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Must declare the scalar variable "@Contact". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Corporate.Button1_Click(Object sender, EventArgs e) ClientConnectionId:835d11f0-b699-4386-b653-0c4bf6ed1bf7Thanks for Applying, We will response on your application shortly

sir for d last time please cn u explain by code that where to add the try catch ....
please..
i just want to not show that ugly error...just show any user friendly error message...
please help me out..
my entire code is as follows..:


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.Configuration;
using System.Data.Common;

public partial class Enquiry2 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue("@Name", txtName.Text);
com.Parameters.AddWithValue("@EmailId", txtEmailid.Text);
com.Parameters.AddWithValue("@Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue("@Address", txtAddress.Text);
com.Parameters.AddWithValue("@Pincode", txtPincode.Text);
com.Parameters.AddWithValue("@Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue("@Enquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue("@Message", txtMessage.Text);



com.ExecuteNonQuery();



con.Close();

}

catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Response.Write("Thanks for Enquiring. We will be available shortly");



}
}

thank you sir...that was as i was entering a bigger size th mentioned...
but sir aftr submitting as the error comes .....how cn i referesh the page the error message should get removed...
and if error is coming it should show that phone no. size lenght increased ..not this bulk error...as users cnt understnd that error..
so user friendly error message shold come...
ho to do this sir....

plz V5709 sir....please help me out...
i m eagerly waiting for ur reply

please sir help me out....
i m eagerly waiting for ur reply sir V5709

please sir look for my prblm...i really need ur help..plz reply about my error as i hd mentioned earliar:

sorry sir but a error is occuring again aftr submitting the values....
please help me out sir:


Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 37 ClientConnectionId:0365041a-ad7e-404d-82db-63aae52e4e83Thanks for Enquiring. We will be available shortly

sorry but again a error sir...

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): String or binary data would be truncated. The statement has been terminated. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 37 ClientConnectionId:0365041a-ad7e-404d-82db-63aae52e4e83Thanks for Enquiring. We will be available shortly

sir once it ran..and then after its showing this error...
i had checkd the Heardfrom, its same everywhere in aspx page, .cs page n db too...
so where the error is coming from


A field or property with the name 'Heard' was not found on the selected data source.

thanks thanks thanks alot.........
very veru very thanks sir...
sir cn i get ur email id so tht if in future required i can ask u....

i tried this sir:


protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue(" @Name", txtName.Text);
com.Parameters.AddWithValue(" @EmailId", txtEmailid.Text);
com.Parameters.AddWithValue(" @Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue(" @Address", txtAddress.Text);
com.Parameters.AddWithValue(" @Pincode", txtPincode.Text);
com.Parameters.AddWithValue(" @Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue(" @ENquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue(" @Message", txtMessage.Text);


com.ExecuteNonQuery();
Response.Write("Thank You for Submitting your query");
Response.Redirect("Home.aspx");

con.Close();
Label.Visible = true;
Label.Text = "Thanks forEnquiring";
}

catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Response.Write("Thanks for Enquiring. We will be available shortly");



}
}

sorry sir but after submitting the values...error is still somin and is as:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '@Name'. Must declare the scalar variable "@Name". at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 36 ClientConnectionId:ea9b27e2-1948-49c5-be6d-7cddd8c54571Thanks for Enquiring. We will be available shortly

sir i had tried this...but getting a error....
please look at this

the projet is runnning but aftr giving the values to textnboxes the error is coming.., means run time error is
error message is:

Error Occured! Try AgainSystem.Data.SqlClient.SqlException (0x80131904): Incorrect syntax near '@Name'. Incorrect syntax near the keyword 'where'. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose) at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady) 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, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Enquiry2.Button1_Click(Object sender, EventArgs e) in c:\Users\HP\Documents\Visual Studio 2010\WebSites\Grapple\Enquiry2.aspx.cs:line 36 ClientConnectionId:994391c8-ae81-46d7-ad86-1c7aa68a74ceThanks for Enquiring. We will be available shortly






and sir the code is:

protected void Button1_Click(object sender, EventArgs e)
{
try
{
string str = "Data Source=HP-PC\\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True";
SqlConnection con = new SqlConnection(str);
con.Open();
string insertQuery = "insert into EnquiryTable where (Name,Emailid,Phoneno,Address,Pincode,Heardfrom,Enquiryabout,Message) values (@Name,@Emailid,@Phoneno,@Address,@Pincode,@Heardfrom,@Enquiryabout,@Message)";
SqlCommand com = new SqlCommand(insertQuery, con);
com.Parameters.AddWithValue(" @Name", txtName.Text);
com.Parameters.AddWithValue(" @EmailId", txtEmailid.Text);
com.Parameters.AddWithValue(" @Phoneno", txtPhoneno.Text);
com.Parameters.AddWithValue(" @Address", txtAddress.Text);
com.Parameters.AddWithValue(" @Pincode", txtPincode.Text);
com.Parameters.AddWithValue(" @Heardfrom", txtHeardfrom.Text);
com.Parameters.AddWithValue(" @ENquiryabout", txtEnquiryabout.Text);
com.Parameters.AddWithValue(" @Message", txtMessage.Text);


com.ExecuteNonQuery();
Response.Write("Thank You for Submitting your query");
Response.Redirect("Home.aspx");

con.Close();
Label.Visible = true;
Label.Text = "Thanks forEnquiring";
}

catch (Exception ex)
{
Response.Write("Error Occured! Try Again" + ex.ToString());
}

Response.Write("Thanks for Enquiring. We will be available shortly");



}

sir cn u please explain me about sp_userinformation
what is this about..
i copied it over internet..so plz help me out

ya sir..please can u gv me some code which might work..
as i m creating an enquiry form and want to link values to data base...
Data base is SQl which is integrtd in Visual studio..
Database name: Enq
Table: Enqtable
these are final names...cn u plz help me out.......

instead i have tried thisone by my one...
but the data is not going to the database..



using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Collections;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Configuration;
public partial class Enquiry : System.Web.UI.Page
{

SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString);

protected void Page_Load(object sender, EventArgs e)
{
con.Open();

}
protected void Button1_Click(object sender, EventArgs e)
{
SqlCommand cmd = new SqlCommand("insert into EnqTable values('" + txtName.Text + "','" + txtEmailid.Text + "','" + txtPhoneno.Text + "','" + txtAddress.Text + "','" + txtPincode.Text + "','" + txtHeardfrom.Text + "','" + txtEnquiryabout.Text + "','" + txtMessage.Text + "')", con);
cmd.ExecuteNonQuery();
con.Close();
Label1.Visible = true;
Label1.Text = "your data has been stored, we will be back shortly";
txtName.Text = " ";
txtEmailid.Text = " ";
txtPhoneno.Text = " ";
txtAddress.Text = " ";
txtPincode.Text = " ";
txtHeardfrom.Text = " ";
txtEnquiryabout.Text = " ";
txtMessage.Text = " ";

}
}

where i will get my stored procedure???

i just copied a code over internet..
i dnt know what to write instead of "sp_userinformation"

i used using.system.data;

and i wrkd smhow..but still error message is:

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

Source Error:


Line 30: cmd.Parameters.AddWithValue("@Message", Message);
Line 31: cmd.ExecuteNonQuery();
Line 32: con.close();
Line 33: }
Line 34: }

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=HP-PC\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("sp_userinformation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Emailid", Emailid);
cmd.Parameters.AddWithValue("@Phoneno", Phoneno);
cmd.Parameters.AddWithValue("@Address", Address);
cmd.Parameters.AddWithValue("@Pincode", Pincode);
cmd.Parameters.AddWithValue("@Heard", Heard);
cmd.Parameters.AddWithValue("@Enquiryabout", EnquiryAbout);
cmd.Parameters.AddWithValue("@Message", Message);
cmd.ExecuteNonQuery();
con.close();
}
}





Error:

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: CS0103: The name 'CommandType' does not exist in the current context

Source Error:


Line 19: con.Open();
Line 20: SqlCommand cmd = new SqlCommand("sp_userinformation", con);
Line 21: cmd.CommandType = CommandType.StoredProcedure;
Line 22: cmd.Parameters.AddWithValue("@Name", Name);
Line 23: cmd.Parameters.AddWithValue("@Emailid", Emailid);




plz plz help me out

protected void Button1_Click(object sender, EventArgs e)
{
SqlConnection con = new SqlConnection(@"Data Source=HP-PC\SQLEXPRESS;Initial Catalog=Enquiry;Integrated Security=True");
con.Open();
SqlCommand cmd = new SqlCommand("sp_userinformation", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Name", Name);
cmd.Parameters.AddWithValue("@Emailid", Emailid);
cmd.Parameters.AddWithValue("@Phoneno", Phoneno);
cmd.Parameters.AddWithValue("@Address", Address);
cmd.Parameters.AddWithValue("@Pincode", Pincode);
cmd.Parameters.AddWithValue("@Heard", Heard);
cmd.Parameters.AddWithValue("@Enquiryabout", EnquiryAbout);
cmd.Parameters.AddWithValue("@Message", Message);
cmd.ExecuteNonQuery();
con.close();
}
}





Error:

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: CS0103: The name 'CommandType' does not exist in the current context

Source Error:


Line 19: con.Open();
Line 20: SqlCommand cmd = new SqlCommand("sp_userinformation", con);
Line 21: cmd.CommandType = CommandType.StoredProcedure;
Line 22: cmd.Parameters.AddWithValue("@Name", Name);
Line 23: cmd.Parameters.AddWithValue("@Emailid", Emailid);




some plz plz help me out

sorry sir..but how to make a slider...i cnt get any help from the above site..
plz help me out

sorry sir to ask u gain..but what to add here..

<img src="img/img1.jpg" alt="" class="active" />
<img src="img/img2.jpg" alt="" />
<img src="img/img3.jpg" alt="" />

in the alt" " part....
mine page is running but it is not teaking the images which i had set...so what to write in commas of alt..
please tell me

just trying....do i need to import any java script files too in my project..or just copy n paste the code given by you....

sir as i saw some over internet,,,they saved a jquery file and then imported it ,
so here just i may paste the codings above given by you , and the desired output will b achievd na???

sir i am adding the audio control and then playing the audio. but the audio toolbar is visible on run page but the sound is not ben played..... a m ute sign is shown but my system is not muted..so what to do....

is it any prblm with my browser?? as i m using chrome..
please help me out

thanks alot sir..
sir can u also tell me how to add audio in pageload of the page....

thanks alot..but can u suggest me some video tutorials..it wld b more helpful...

thanks alot..but can u suggest me some video tutorials..it wld b more helpful...

Sir i want to show values from textbox to gridview....
when i click the button then the values gets into gridview

i did but was surrounded with much much errors..........
so can u please help me with entire code..please

i m not using templates....
i just want to create a web page with about 8-10 textboxes and with some values to b inserted...
and there will be a gridview...
On clicking the button i may get the text box values fetched to the gridview...

can someone help me with the entire code for this..please someone help me...

sir... i started but got many many of errors...so can u please send me the entire code for that..please..fetchhing textbox values into gridview..please sir

In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.....

this is not understood...where do i find object explorer..i cnt find that???
plz help me

when i run the setup of visual studio 2010..the installation starts but suddenly fails saying that "Microsoft .NET framework 4 failed the component failed to install........Setup Failed There were errors during setup.

when i run the setup of visual studio 2010..the installation starts but suddenly fails saying that "Microsoft .NET framework 4 failed the component failed to install........Setup FailedThere were errors during setup.
"

on double clicking the .exe file the first dialof box comes with the msg "The installation package is not supported by this package type"... so in cant choose x64/x86

no itt's package type only not processor type..
i think those are not supporting windows 7 Ultimate N thats why they are not installed...
can u suggest me some links from where i can download sql server 64bit for windows Ultimate N...