ASP.NET

exception in stored procedure

8-Mar-09 20:35

krishnavaradharajan wrote:
I have done this but from local system i can able to read a file not from the uploaded folder.

You can write a page that takes an id and feeds the excel file to the client from your DB.

Christian Graus

Driven to the arms of OSX by Vista.

Re: To read excel

Krishna Varadharajan8-Mar-09 20:44

Krishna Varadharajan

8-Mar-09 20:44

Thanks for ur reply.....

the connection string wht i given was this..
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='

c:/valuefirst.xls

';Extended Properties=Excel 8.0"; (its working)

Aboue connection string is for reading from localsystem, so if i want to read from server folder the link wht can i give in Data Source.

And i tryed by giving complete link like below..

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=http://justmypixels.com/escorts/sms/sms.xls; Extended Properties=Excel 8.0";

It was showing the error like "Invalid internet address."

Can u pls short this out....

Thanx

krishna

Re: To read excel

Jack Li8-Mar-09 22:54

Jack Li

8-Mar-09 22:54

String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='c:/valuefirst.xls';Extended Properties=Excel 8.0"; (its working)

This file working from local system, but uploaded to server folder happened error,

1.Don't find file, Data Source path is error, you'll use server map path.
2.is it Uploaded file in folder?check this file.

NRHSR8-Mar-09 19:47

NRHSR

8-Mar-09 19:47

Procedure or Function 'SubmitRecord1' expects parameter '@ID', which was not supplied.this is the error i am getting while insert into data base using stored procedure can any body help me plz...

N a v a n e e t h8-Mar-09 19:49

N a v a n e e t h

8-Mar-09 19:49

NRHSR wrote:
Procedure or Function 'SubmitRecord1' expects parameter '@ID', which was not supplied

How can an error message be more clear?

Smile | :)

Navaneeth

How to use google | Ask smart questions

monu nair8-Mar-09 19:50

monu nair

8-Mar-09 19:50

pass parameter '@ID' value to Procedure or Function 'SubmitRecord1'

Mahendra Bisht.

Christian Graus8-Mar-09 19:50

8-Mar-09 19:50

I recommend a job at McDonalds. It seems that computing is too hard for you. The error means what it says.

Christian Graus

Driven to the arms of OSX by Vista.

_Maxxx_8-Mar-09 20:43

_Maxxx_

8-Mar-09 20:43

"What do you mean, 'I din't give you any fries?'

Nah - too complex.

___________________________________________
.\\axxx
(That's an 'M')

NRHSR8-Mar-09 22:55

NRHSR

8-Mar-09 22:55

Procedure or Function 'SubmitRecord1' expects parameter '@ID', which was not supplied. this is the exception i am getting when i run.and my code is

protected void Submit1_ServerClick(object sender, EventArgs e)
{
string constr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd = new SqlCommand("SubmitRecord1", con);
cmd.CommandType = CommandType.StoredProcedure;
SqlParameter sp1 = new SqlParameter("@ID",SqlDbType.NVarChar,10);
sp1.Value = TextBox1.Text;
SqlParameter sp2 = new SqlParameter("@Password",SqlDbType.NVarChar,50);
sp2.Value = TextBox2.Text;
SqlParameter sp3 = new SqlParameter("@ConfirmPassword",SqlDbType.NVarChar,50);
sp3.Value = TextBox3.Text;
SqlParameter sp4 = new SqlParameter("@EmailID",SqlDbType.NVarChar,200);
sp4.Value = TextBox4.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
//cmd.ExecuteNonQuery();
}
my stored procedure is

CREATE PROCEDURE dbo.SubmitRecord1
(
@ID varchar(10),
@Password varchar(50),
@ConfirmPassword varchar(50),
@EmailID varchar(200)
)
AS
INSERT INTO login1(ID,Password,ConfirmPassword,EmailID)VALUES(@ID,@Password,@ConfirmPassword,@EmailID)
RETURN

i am passing parameter ... then also its throwing exception......
can any body help me ...

_Maxxx_8-Mar-09 23:57

_Maxxx_

8-Mar-09 23:57

You're not adding any of the parameters to the command object

something like

cmd.Parameters.Add(sp1);

(Look it up - I don't have an example in front of me - but that's the issue here - upir cmd object doesn't know about the parameters.

___________________________________________
.\\axxx
(That's an 'M')

about gridview [modified]

NRHSR9-Mar-09 0:33

NRHSR

9-Mar-09 0:33

protected void Submit1_ServerClick(object sender, EventArgs e)
{
string constr = @"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True";
SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand();
cmd.Connection = con;
cmd = new SqlCommand("SubmitRecord1", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@ID", SqlDbType.NVarChar,10).Value = TextBox1.Text;
cmd.Parameters.Add("@Password", SqlDbType.NVarChar, 50).Value = TextBox2.Text;
cmd.Parameters.Add("@ConfirmPassword", SqlDbType.NVarChar, 50).Value = TextBox3.Text;
cmd.Parameters.Add("@EmailID", SqlDbType.NVarChar, 200).Value = TextBox4.Text;
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}

stored procedure
ALTER PROCEDURE dbo.SubmitRecord1
(
@ID varchar(10),
@Password varchar(50),
@ConfirmPassword varchar(50),
@EmailID varchar(200)
)
AS
INSERT INTO login1(ID,Password,ConfirmPassword,EmailID)VALUES(@ID,@Password,@ConfirmPassword,@EmailID)
RETURN

this worked fine.....
for reference u can see link

Thanks any ways

prateekfgiet8-Mar-09 19:38

prateekfgiet

8-Mar-09 19:38

i m using asp.net with c# and in backend using sql server 2000.
i have a table1(material_incoming) and i m using gridview for showing data of table1,when i click edit button at gridview,present value save in table2(edit_tab)with remark "before edit" and after updation,updated value save in table2 with remark "after edit" and also update table1.

prateek srivastava
prateekfgiet@gmail.com

modified on Monday, March 9, 2009 3:20 AM

Re: about gridview

N a v a n e e t h8-Mar-09 19:47

N a v a n e e t h

8-Mar-09 19:47

I am sorry, but your question makes no sense. Try to rephrase it.

Navaneeth

How to use google | Ask smart questions

Re: about gridview

Christian Graus8-Mar-09 19:49

how to prevent right click in a browser.

8-Mar-09 19:49

Is this a question ? If it is, is it a 'I did some research and tried this but it doesn't work' question, or an 'I'm a dumbass, do my job for me' question ?

Christian Graus

Driven to the arms of OSX by Vista.

souravghosh188-Mar-09 19:27

souravghosh18

8-Mar-09 19:27

I am developing an ASP.NET application and i want to prevent the right click option for a particular page .How can it be achieved is there any javascript.

Thanx in advance.

how to prevent right click in a browser.

Member 38513068-Mar-09 19:34

Member 3851306

8-Mar-09 19:34

Just Add this line in body tag
oncontextmenu="return false;"

Fastrythem

Jerry.Wang8-Mar-09 19:39

Jerry.Wang

8-Mar-09 19:39

<HTML>
<script language="javascript">
function preventEvt(evt)
{
	evt.returnValue = false;
	if( evt.preventDefault ) evt.preventDefault();
	return false;
}
</script>
 <BODY oncontextmenu="return preventEvt(event)" onmousedown="return preventEvt(event)">
  
 </BODY>
</HTML>

This code can works in IE and Firefox, but no way in Opera

Christian Graus8-Mar-09 19:44

8-Mar-09 19:44

There are ways to convince an ignorant client that you did this, but I guarantee you that I can circumvent all of them, if I really wanted to right click on your web page.

Christian Graus

Driven to the arms of OSX by Vista.

fred_10-Mar-09 8:55

fred_

10-Mar-09 8:55

amen.

What exactly are you trying to prevent?