Click here to Skip to main content
14,661,501 members
Home » Discussions » ASP.NET
   

ASP.NET

 
GeneralRe: How dynamic objects work during a post back Pin
compninja2516-Sep-09 2:21
Membercompninja2516-Sep-09 2:21 
QuestionPassing Credentials from ASP.NET to OWA Pin
ahayw0115-Sep-09 12:51
Memberahayw0115-Sep-09 12:51 
AnswerRe: Passing Credentials from ASP.NET to OWA Pin
Not Active15-Sep-09 13:26
mentorNot Active15-Sep-09 13:26 
GeneralRe: Passing Credentials from ASP.NET to OWA Pin
Abhijit Jana15-Sep-09 18:31
professionalAbhijit Jana15-Sep-09 18:31 
GeneralRe: Passing Credentials from ASP.NET to OWA Pin
Not Active16-Sep-09 1:51
mentorNot Active16-Sep-09 1:51 
AnswerRe: Passing Credentials from ASP.NET to OWA Pin
Abhijit Jana15-Sep-09 18:36
professionalAbhijit Jana15-Sep-09 18:36 
GeneralRe: Passing Credentials from ASP.NET to OWA Pin
mzuc30-Sep-09 22:01
Membermzuc30-Sep-09 22:01 
QuestionStored Procedures retrieving values Pin
greendragons15-Sep-09 12:48
Membergreendragons15-Sep-09 12:48 
I am new to stored procedures. I want to know how to retrieve string values from stored procedures.
Like i created a website in which when user clicks a particular artists image then it's file location is
picked up from sql server. But im not getting way to retrieve from there through procedures.
-----stored procedure-------
create procedure arts
(@Artist nchar(50))
AS
return
(SELECT ret =   Location from Artist_loc
where Artist = @Artist
)

in aspx.cs page-----------
string Artist = Request.QueryString["art"];
               SqlConnection cn = new SqlConnection(@"Data Source=BLACK_RHYMES-PC\MSSMLBIZ;Initial Catalog=Muzik;Integrated Security=True");
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = "dbo.arts";
            cmd.Parameters.Add("@Artist",SqlDbType.NChar,50).Value = Artist;
              
            cmd.CommandType = CommandType.StoredProcedure;
           
            cmd.Connection = cn;


i got struck after this what lines should i add to retrieve results.....
*THNX*
AnswerRe: Stored Procedures retrieving values Pin
Abhishek Sur15-Sep-09 12:54
professionalAbhishek Sur15-Sep-09 12:54 
GeneralRe: Stored Procedures retrieving values Pin
greendragons15-Sep-09 13:08
Membergreendragons15-Sep-09 13:08 
AnswerRe: Stored Procedures retrieving values Pin
Abhishek Sur15-Sep-09 13:14
professionalAbhishek Sur15-Sep-09 13:14 
GeneralRe: Stored Procedures retrieving values Pin
greendragons15-Sep-09 13:29
Membergreendragons15-Sep-09 13:29 
GeneralRe: Stored Procedures retrieving values Pin
Christian Graus15-Sep-09 14:00
mveChristian Graus15-Sep-09 14:00 
AnswerRe: Stored Procedures retrieving values Pin
Abhishek Sur15-Sep-09 22:38
professionalAbhishek Sur15-Sep-09 22:38 
QuestionCould not load file or assembly 'MySql.Data, Version=5.2.3.0, Culture=neutral, PublicKeyToken Pin
mark_me15-Sep-09 12:16
Membermark_me15-Sep-09 12:16 
AnswerRe: Could not load file or assembly 'MySql.Data, Version=5.2.3.0, Culture=neutral, PublicKeyToken Pin
Christian Graus15-Sep-09 12:34
mveChristian Graus15-Sep-09 12:34 
GeneralRe: Could not load file or assembly 'MySql.Data, Version=5.2.3.0, Culture=neutral, PublicKeyToken Pin
mark_me17-Sep-09 12:55
Membermark_me17-Sep-09 12:55 
QuestionConfiguration and Trust levels Pin
mbangh15-Sep-09 12:12
Membermbangh15-Sep-09 12:12 
AnswerRe: Configuration and Trust levels Pin
egenis15-Sep-09 20:01
Memberegenis15-Sep-09 20:01 
GeneralRe: Configuration and Trust levels Pin
mbangh16-Sep-09 5:58
Membermbangh16-Sep-09 5:58 
GeneralRe: Configuration and Trust levels Pin
egenis16-Sep-09 18:04
Memberegenis16-Sep-09 18:04 
QuestionSilverlight error when not using silverlight -edit resolved. Pin
thrakazog15-Sep-09 11:22
Memberthrakazog15-Sep-09 11:22 
AnswerRe: Silverlight error when not using silverlight Pin
Christian Graus15-Sep-09 11:27
mveChristian Graus15-Sep-09 11:27 
GeneralRe: Silverlight error when not using silverlight Pin
thrakazog15-Sep-09 11:45
Memberthrakazog15-Sep-09 11:45 
GeneralRe: Silverlight error when not using silverlight Pin
Christian Graus15-Sep-09 11:52
mveChristian Graus15-Sep-09 11:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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