Click here to Skip to main content
16,009,847 members
Home / Discussions / C#
   

C#

 
GeneralRe: Text.Length Command Pin
Henry Minute9-Jan-09 12:22
Henry Minute9-Jan-09 12:22 
GeneralRe: Text.Length Command Pin
Colin Angus Mackay9-Jan-09 13:44
Colin Angus Mackay9-Jan-09 13:44 
GeneralRe: Text.Length Command Pin
asquaredtech9-Jan-09 19:13
asquaredtech9-Jan-09 19:13 
GeneralRe: Text.Length Command Pin
Guffa10-Jan-09 0:52
Guffa10-Jan-09 0:52 
AnswerRe: Text.Length Command Pin
Guffa9-Jan-09 17:34
Guffa9-Jan-09 17:34 
GeneralRe: Text.Length Command Pin
asquaredtech9-Jan-09 19:20
asquaredtech9-Jan-09 19:20 
GeneralRe: Text.Length Command Pin
Guffa9-Jan-09 20:10
Guffa9-Jan-09 20:10 
QuestionMultiple values in a querystring Pin
ferronrsmith9-Jan-09 8:48
ferronrsmith9-Jan-09 8:48 
I am a noob working a webpage, i wanna pass multiple values from a select box in a query string so that a report may be generated any one can help me please. So basically, if the user enters only one value, only 1 report is queried if they entered more than 1 then more than one report is generated one after another. this is the code i already have, it only make one query to the database now. I want the reports to be created one below the other.... and so on.


using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace SealRegister
{
    public partial class _Default : System.Web.UI.Page
    {
        
        
        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                string connstring = @"Data Source=FGVMDEVSVR;Initial Catalog=FGBInvestment;uid=sa;pwd=Wizard1;";
                //string connstring = @"Data Source=FGBMIS01\SQLEX;Database=FGBInvestments;Trusted_Connection=yes;User Id;Password=";
                SqlConnection conn = new SqlConnection(connstring);
                SqlCommand cmd = conn.CreateCommand();
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "sp_getTransfer";

                //create parameters to provide the input
                SqlParameter parInput1 = cmd.Parameters.Add("@TRANSFER_ID", SqlDbType.Int);
                parInput1.Direction = ParameterDirection.Input;
                parInput1.Value =  Request.QueryString["TRANSFER_ID"];


                //execute stored procedure
                conn.Open();

                SqlDataReader dtaReader;
                dtaReader = cmd.ExecuteReader();
                while (dtaReader.Read())
                {
                    //Associate service fields names and types from database to elements in smsValues array
                     lblIMID.Text = Convert.ToString(dtaReader["IMID"]);
                     lblDESCRIPTION.Text = Convert.ToString(dtaReader["DESCRIPTION"]);
                     lblAMOUNT.Text = Convert.ToString(dtaReader["AMOUNT"]);
                     lblAMOUNT_TRANSFER.Text = Convert.ToString(dtaReader["AMOUNT_TRANSFER"]);
                     lblCONSIDERATION.Text = Convert.ToString(dtaReader["CONSIDERATION"]);
                     lblCURR.Text = Convert.ToString(dtaReader["CURR"]);
                     lblCons_Curr.Text = Convert.ToString(dtaReader["Cons_Curr"]);
                     lblNAME1.Text = Convert.ToString(dtaReader["CMF_NAME_1"]);
                     lblNAME2.Text = Convert.ToString(dtaReader["CMF_NAME_2"]);
                     lblADDR1.Text = Convert.ToString(dtaReader["CMF_ADDR_1"]);
                     lblADDR2.Text = Convert.ToString(dtaReader["CMF_ADDR_2"]);
                     lblADDR3.Text = Convert.ToString(dtaReader["CMF_ADDR_3"]);
                     lblADDR4.Text = Convert.ToString(dtaReader["CMF_ADDR_4"]);

                }
                dtaReader.Close();
                conn.Close();


            } //end try
            catch (Exception Ex)
            {
                lblCONSIDERATION.Text =Ex + "\n\n\nAn  SQL error occurred when trying to retrieve Param Field Info.  Please contact Admin";
            } //end catch

            finally
            {

            }//end finally


        }


    }
}


Ferron

AnswerRe: Multiple values in a querystring Pin
sudhanvag10-Jan-09 5:18
sudhanvag10-Jan-09 5:18 
GeneralRe: Multiple values in a querystring Pin
ferronrsmith10-Jan-09 9:55
ferronrsmith10-Jan-09 9:55 
GeneralRe: Multiple values in a querystring Pin
sudhanvag10-Jan-09 15:59
sudhanvag10-Jan-09 15:59 
QuestionRead and copy .docx Pin
Xtrme_XJ9-Jan-09 8:23
Xtrme_XJ9-Jan-09 8:23 
Questionunisgned integers and global cases in C# Pin
Xarzu9-Jan-09 7:54
Xarzu9-Jan-09 7:54 
AnswerRe: unisgned integers and global cases in C# Pin
Eddy Vluggen9-Jan-09 8:24
professionalEddy Vluggen9-Jan-09 8:24 
AnswerRe: unisgned integers and global cases in C# Pin
JByrd20069-Jan-09 9:02
JByrd20069-Jan-09 9:02 
AnswerRe: unisgned integers and global cases in C# Pin
Guffa9-Jan-09 17:52
Guffa9-Jan-09 17:52 
Questionany body idea in viterbi algorithm Pin
lawrenceinba9-Jan-09 7:39
lawrenceinba9-Jan-09 7:39 
AnswerRe: any body idea in viterbi algorithm Pin
Christian Graus9-Jan-09 7:46
protectorChristian Graus9-Jan-09 7:46 
GeneralRe: any body idea in viterbi algorithm Pin
lawrenceinba9-Jan-09 8:00
lawrenceinba9-Jan-09 8:00 
AnswerRe: any body idea in viterbi algorithm Pin
EliottA9-Jan-09 8:01
EliottA9-Jan-09 8:01 
GeneralRe: any body idea in viterbi algorithm Pin
Luc Pattyn9-Jan-09 8:20
sitebuilderLuc Pattyn9-Jan-09 8:20 
GeneralRe: any body idea in viterbi algorithm Pin
Eddy Vluggen9-Jan-09 8:40
professionalEddy Vluggen9-Jan-09 8:40 
GeneralRe: any body idea in viterbi algorithm Pin
Luc Pattyn9-Jan-09 9:55
sitebuilderLuc Pattyn9-Jan-09 9:55 
GeneralRe: any body idea in viterbi algorithm Pin
Eddy Vluggen9-Jan-09 11:03
professionalEddy Vluggen9-Jan-09 11:03 
QuestionHow to export a bitmap from a crystal report? Pin
davebarkshire9-Jan-09 6:00
davebarkshire9-Jan-09 6:00 

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.