Re: Stored procedure? - ASP.NET Discussion Boards

Karthick_gc10-Mar-09 20:49

10-Mar-09 20:49

I had created a stored procedure. Now i need to alter the procedure coding. How it is possible without drop the procedure?

Re: Altering Procedure?

Jarek Kruza10-Mar-09 21:34

Jarek Kruza

10-Mar-09 21:34

Have you tried changing create procedure to alter procedure?

People say it helps... Wink | ;)

Re: Altering Procedure?

Rajeesh MP11-Mar-09 1:01

Rajeesh MP

11-Mar-09 1:01

Thats All

Ramkumar_S10-Mar-09 20:45

Ramkumar_S

10-Mar-09 20:45

Please suggest me whether default login control is best to use in production?

Ramkumar(ramkumarishere.blogspot.com)

Re: login control

Xmen Real 10-Mar-09 23:04

Xmen Real

10-Mar-09 23:04

definitely

TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87֦ʻ6ϣN8ȤBcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-iTV.C\y<pjxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can

Stored procedure?

Karthick_gc10-Mar-09 20:37

Karthick_gc

10-Mar-09 20:37

Hi, this s my first project for database operations using procedures.
I created a sample table and executed successfully the procedure.

create procedure ins_sam
@roll varchar(10),@nam varchar(10)
as
insert into sample values(@roll,@nam)

In Dotnet, I wrote the coding as this.

try
{
con.Open();
com = new SqlCommand(ins_sam, con);
com.CommandType=CommandType.StoredProcedure;
com.Parameters.Add("@roll", TextBox1.Text);
com.Parameters.Add("@nam", TextBox2.Text);
com.ExecuteNonQuery();
Response.Write("added");
con.Close();
}
catch (Exception ex)
{
Response.Write(ex.Message);
}

I got this error.
The name 'ins_sam' does not exist in the current context

Can anyone correct it?

Re: Stored procedure?

Anurag Gandhi10-Mar-09 20:41

Anurag Gandhi

10-Mar-09 20:41

Karthick_gc wrote:
com = new SqlCommand(ins_sam, con);

Putting ins_sam within double quote should solve your problem.
com = new SqlCommand("ins_sam", con);

Anurag Gandhi.
http://www.gandhisoft.com
Life is a computer program and every one is the programmer of his own life.

Re: Stored procedure?

Karthick_gc10-Mar-09 20:45

Karthick_gc

10-Mar-09 20:45

Thanks.. Its working.

how to store data in sql server frm a excel sheet

bhii10-Mar-09 19:34

bhii

10-Mar-09 19:34

hi,
i want to fetch 25000 records from a excel sheet and store it in sql server 2000.
please give me a soln on that...

Re: how to store data in sql server frm a excel sheet

Christian Graus10-Mar-09 20:08

Christian Graus

10-Mar-09 20:08

Read the data, then insert it into your SQL database. Which part are you confused about ( seriously, do you want us to give you all the code, have you tried anything your self, did you try google,. etc )

Christian Graus

Driven to the arms of OSX by Vista.

Re: how to store data in sql server frm a excel sheet

kumar_k50812-Mar-09 0:55

kumar_k508

12-Mar-09 0:55

Hi,

By using export/import tasks option of database,you can directly upload any number of rows from excel sheet to the particular table,

when you are uploading you have to set some properties like source,destination and destination table and match the table columns with excel sheet columns Thumbs Up | :thumbsup:

master page in asp

bhii10-Mar-09 19:30

bhii

10-Mar-09 19:30

hi all,

i have a master page in my project on that page have a java script menu.
now i want to add another java script menu on page but while having master page i can't add a menu.
so plz give me some solution...

abhi_kulkarni44@rediffmail.com

Re: master page in asp

Christian Graus10-Mar-09 20:06

Christian Graus

10-Mar-09 20:06

You're not using ASP, you're using ASP.NET. You can add any javascript you want to your page. The issue is you have no idea what you're doing. Until you post code and describe your problem, neither do we.

Christian Graus

Driven to the arms of OSX by Vista.

Line 1: Incorrect syntax near ')'.

montyhasan10-Mar-09 18:57

montyhasan

10-Mar-09 18:57

when i am inserting data from access to ms sql server table

Re: Line 1: Incorrect syntax near ')'.

Christian Graus10-Mar-09 20:07

Christian Graus

10-Mar-09 20:07

Your SQL has an error, and you are a moron. We can't say more, based on what you've told us ( that you think we can fix your code without seeing it, is what makes you a moron )

Christian Graus

Driven to the arms of OSX by Vista.

invoke webservice with xmlhttprequest

impeesa_0110-Mar-09 15:50

impeesa_01

10-Mar-09 15:50

hi all,

i have code that i believe built in delphi as follows :

xml_string:

<?xml version="1.0" encoding="utf-8"?>
<soap:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">
<soap:Body>
<upload_item xmlns="http://tempuri.org/">
<batch>int</batch>
<customer_id>string</customer_id>
<customer>string</customer>
<city>string</city>
<location>string</location>
<lot_no>string</lot_no>
<net>double</net>
<co_no>string</co_no>
<ln>string</ln>
<item_no>string</item_no>
<del_date>string</del_date>
<do_no>string</do_no>
</upload_item>
</soap:Body>
</soap:Envelope>

XMLHTTPRequest1.open('POST','http://localhost/tmsws/service.asmx?op=upload_item',false);
XMLHTTPRequest1.setRequestHeader('Content-Type','text/xml; charset=utf-8');
XMLHTTPRequest1.Send(xml_string);
XMLResult := XMLHTTPRequest1.responseText;

how can i do it in asp.net?

thanks and regards,
edi

gain new knowledge through knowledge-sharing

Re: invoke webservice with xmlhttprequest

Cybernate11-Mar-09 6:38

Cybernate

11-Mar-09 6:38

You can use WebRequest class to do the same at server end.
Or create a proxy for the web service using the wsdl tool provided by .Net to achieve Stong type safety

Regards,
Cybernate

Re: invoke webservice with xmlhttprequest

impeesa_0111-Mar-09 15:42

impeesa_01

11-Mar-09 15:42

hi Cybernate,
thanks for your reply. but i really new in this field and just a little of web programming. could you give me link where i have to go, meanwhile i am trying to googling. shall i create a webservice to consume it webservice since the target webservice provided by another party, or just create web page to consume the webservice?

thanks and regards,
edi

gain new knowledge through knowledge-sharing

Cannot Use IIS

MrColeyted10-Mar-09 14:40

MrColeyted

10-Mar-09 14:40

Hello all. I am using a laptop that is running Windows XP Professional. The other day, a breaker in my house kept constantly tripping. It was the breaker that my laptop was plugged into. My computer shut down, and when I booted, I got an error that a file in C:\WINDOWS\System32\config was corrupt. I was able to use the XP CD to replace the corrupt file, but now I have some serious issues. Aside from the absence of all of my SQL Server servers (SQLExpress, other named instances), I cannot open or create any ASP.NET Websites that rely on IIS. When I open the MMC for IIS, there is nothing there. I do not know what to do. I have tried:

- Rebooting the machine (several times)
- Running aspnet_regiis -i from the VS cmd in the v2.0.50727 dir
- Running 'regedit.exe add HKLM\system\... to add a variable (this was recommended in another forum that I read)
- Running DCOMCNFG and placing a tick in the use internet services box

Since I cannot do a system restore that restores beyond the time that I repaired the system originally, I do not know what to do! Confused | :confused:

Please help. I need IIS to work for my ASP.NET development.

"If you don't know where you're going, you'll probably end up somewhere else." Yogi Berra

Re: Cannot Use IIS

Yusuf10-Mar-09 15:23

Yusuf

10-Mar-09 15:23

how about reinstalling IIS

Yusuf

Oh didn't you notice, analogous to square roots, they recently introduced rectangular, circular, and diamond roots to determine the size of the corresponding shapes when given the area. Luc Pattyn[^]

Re: Cannot Use IIS [modified]

MrColeyted10-Mar-09 15:32

MrColeyted

10-Mar-09 15:32

I have tried to reinstall IIS several times. I have used the CD, as well as downloaded what others online have said was a .rar file of the IIS files. But I do not know how to use the latter. While reinstalling IIS (through control panel\add remove programs\add remove windows components) it only gave me an option of where to find the files the first time, which is when I was using the cd. Since that did not work, I suspect that it has something to do with an environment variable, or a setting that I do not know about.

"If you don't know where you're going, you'll probably end up somewhere else." Yogi Berra

modified on Wednesday, March 11, 2009 2:13 AM

Exception handling with web services in ASP.NET 3.5

Member 391904910-Mar-09 14:14

Member 3919049

10-Mar-09 14:14

I used to create web services in ASP.NET 1.1 and the primary exception thrown from a web service back to a caller was (if I remember correctly) a SoapException.

I have created a new asmx web service in 3.5 and was creating some tests for exception handling. I created a DivideByZeroException in the web service but the primary exception being thrown to the caller is a FaultException (not SoapException).

Is FaultException the primary exception thrown by .NET 3.5 for web services -replacing the old SoapExcpetion - or does it have something to do with the type of exception or the way my environment is configured?

Update Database(ACCESS) from ASP page

daks90610-Mar-09 10:13

daks906

10-Mar-09 10:13

Hi, Please help

I am new to programming. and I am trying to update a value in the database(ACCESS) with a value in a textbox on an ASP page.

the conditions are that "value" in database can only change if it is smaller than value in textbox in the ASP page.

I can INSERT, UPDATE, and DELETE values in the database from the ASP page. I just dont know how to write it with the "if" statement so that it can work

thanks for the help

Re: Update Database(ACCESS) from ASP page

Yusuf10-Mar-09 11:20

Yusuf

10-Mar-09 11:20

daks906 wrote:
the conditions are that "value" in database can only change if it is smaller than value in textbox in the ASP page.

This does not need to be done in the database. You can handle it at UI using javascript code.

One way to do this is, set the value in the database to a hidden field, then on submit compare the user value to the hidden value, and if you're not going to accept it show error message.

ASP.Net 1.1, VB.Net 2003 and SQL Server 2005

Ragonastick10-Mar-09 9:43

Ragonastick

10-Mar-09 9:43

Hi I am new to programming with ASP.Net and I am looking for some information.

I currently have a database locally on my machine, and I am trying to connect and read one of the tables through the VB. I have gone to many website, and tried a couple of things but I get up to a point and its still crashing when I go to open it. One thing you will notice is that I do not have a password on my database because there is not one on my machine.

This is the code I have in my page load

Dim oConn As New System.Data.SqlClient.SqlConnection
       Dim oCom As System.Data.SqlClient.SqlCommand
       Dim oDr As System.Data.SqlClient.SqlDataReader
       Dim sSQL As String

       sSQL = "SELECT * FROM AdminTypes"
       oConn = New System.Data.SqlClient.SqlConnection("server=MCF1500\SQLEXPRESS;uid=JWilson;pwd=;database=MCF_Staff;Trusted_Connection=yes")
       oConn.Open()   'Crashes HERE

       oCom = New System.Data.SqlClient.SqlCommand(sSQL, oConn)

       oDr = oCom.ExecuteReader()

       Do While oDr.Read()
           ' Show database data
       Loop
       oConn.Close()

And I have this code in my WEB.config File

<configuration>
    <appsettings>
        <add key="DBConString" value="Uid=JWilson;pwd=;server=MCF1500\SQLEXPRESS;database=MCF_Staff" />
    </appsettings>
  <system.web></system.web></configuration>

I was wondering if anyone could help me out with his. If so it would be much appreciated. If not then I am switching over to PHP for this project because I understand it better.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.