I want to pass an array of Id's to a stored proc to be processed, but i keep getting an error saying : Error converting data type varchar to numeric.

set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go

ALTER PROCEDURE [dbo].[sp_getTranfer] @TRANSFER_ID int = null, @COMPANY VARCHAR(5),@FORMTYPE VARCHAR(30), @TRANSFER_IDS VARCHAR(500) = NULL, @SEAL_DATE datetime = NULL AS
-- Declare variables
DECLARE @rc Int, @ThisID varchar (10), @Pos int

IF @SEAL_DATE IS NULL
BEGIN
SELECT
COMPANY,
FORMTYPE,
COMPANY_NAME,
COMPANY_ADDRESS1,
COMPANY_ADDRESS2,
IMID,[DESCRIPTION],AMOUNT,AMOUNT_TRANSFER,
CONSIDERATION,
TRANSFER_ID,
[DATE],
CURR,
CMF_NAME_1,
CMF_NAME_2,
CMF_ADDR_1,
CMF_ADDR_2,
CMF_ADDR_3,
CMF_ADDR_4,
CMF_POSTAL_CODE,
Cons_Curr = CASE
WHEN LTRIM(RTRIM(Cons_Curr)) <> '' THEN Cons_Curr
ELSE CURR
END,
-- Cons_Curr,
TRANSFERYEAR,
TRANSFERMONTH,
TRANSFERDAY,
dbo.CurrencyToWords(CURR) AS CURR_WORDS,
---dbo.CurrencyToWords(Cons_Curr) AS CONNS_CURR_WORDS

CONS_CURR_WORDS = CASE
WHEN LTRIM(RTRIM(CONS_CURR)) <> '' THEN dbo.CurrencyToWords(CONS_CURR)
ELSE dbo.CurrencyToWords(CURR)
END

FROM
VW_TRANSFERS
WHERE
TRANSFER_ID= @TRANSFER_ID
AND
FORMTYPE= @FORMTYPE
AND
COMPANY = @COMPANY
OR
TRANSFER_ID IN (@TRANSFER_IDS)
END

ELSE
SELECT
COMPANY,
FORMTYPE,
COMPANY_NAME,
COMPANY_ADDRESS1,
COMPANY_ADDRESS2,
IMID,[DESCRIPTION],AMOUNT,AMOUNT_TRANSFER,
CONSIDERATION,
TRANSFER_ID,
[DATE],
CURR,
CMF_NAME_1,
CMF_NAME_2,
CMF_ADDR_1,
CMF_ADDR_2,
CMF_ADDR_3,
CMF_ADDR_4,
CMF_POSTAL_CODE,
--Cons_Curr,
Cons_Curr = CASE
WHEN LTRIM(RTRIM(Cons_Curr)) <> '' THEN Cons_Curr
ELSE CURR
END,
TRANSFERYEAR,
TRANSFERMONTH,
TRANSFERDAY,
dbo.CurrencyToWords(CURR) AS CURR_WORDS,
---dbo.CurrencyToWords(Cons_Curr) AS CONNS_CURR_WORDS

CONS_CURR_WORDS = CASE
WHEN LTRIM(RTRIM(CONS_CURR)) <> '' THEN dbo.CurrencyToWords(CONS_CURR)
ELSE dbo.CurrencyToWords(CURR)
END
FROM
VW_TRANSFERS
WHERE
FORMTYPE= @FORMTYPE
AND
COMPANY = @COMPANY
AND
DATE = @SEAL_DATE
OR
TRANSFER_ID IN (@TRANSFER_IDS)

Ferron

tried using that code, it doesn't work

Ferron

I am trying to convert datalist control to pdf. Are there any third party tool that can do this or any tutorials on how to accomplish this? I have been googling and trying stuff, but they do not work. Anyways, please help :) :) :)

Ferron

modified on Wednesday, July 1, 2009 4:48 PM

Error 646 'System.Web.UI.WebControls.Label' does not contain a definition for 'Location' and no extension method 'Location' accepting a first argument of type 'System.Web.UI.WebControls.Label' could be found (are you missing a using directive or an assembly reference?)

That's the error is got when i tried using the Location.Y method

Ferron

Ferron

I was trying to move some the labels with the location.Y method but it doesn't seem to be working. Any help on how get rid of the empty labels as well?

Ferron

visible doesn't remove the space there. jst don't show

Ferron

thanks guys for the help. It was gladly appreciated

Ferron

just one value for each text field. I have the address one under the other and there are making my page look bad. I want to format the empty spaces out

Ferron

I have written a code that fills a form with data from a database into textboxes, the thing is some of the textbox comes up with empty information and they leave gaps within my document, is there any way to get rid of them?

Ferron

I am trying to implement paging in a datalist control but it seems so complicated anyways, i am using a stored procedure instead of a data list and the value is inputted from a querystring, but i just can't seem to find any example that implemented it my way. Anyone with any great walk through?

Ferron

I used a data list control to display all my records, but i have been trying to add paging capability. :(

Ferron

I have used a form view, its working well, the thing is how do I get it to display records one under the other instead of paging?

Ferron

Yes I want to show the results in the text box? I have it created in a form. Is the the data bound control flexible? Can the realit be formatted in a form like manner, for say a application form?

Ferron

i know, that's why i need your help to sort it out the write way. basically what i have is 3 textbox text[1] text[2] text[3] if three records are in the database it should bring back three sets of record all in their respective textbox. Plz can u help

Ferron

i wanna pull multiple records in from a database and display them in different labels I was thinking of returning them in an array then adding them to the specified labels, can anyone point me to the an example or aid me. sample code

public partial class _Default : System.Web.UI.Page
{
SqlConnection con = new SqlConnection("server=BABOO;uid=sa;password=sa;database=quiz");
protected void Page_Load(object sender, EventArgs e)
{
con.Open();
string query;
query = "select QuestionText,AnswerA,AnswerB,AnswerC,AnswerD from quest where QuestionID='1'";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader dr;
dr = cmd.ExecuteReader();
while (dr.Read())
{
nt rbCount = Convert.ToInt32(TextBox2.Text);
//iin textbox enter how many record want to display
RadioButton[] radioButtons = new RadioButton[rbCount];
for (int i = 0; i < rbCount; ++i)
{
radioButtons[i] = new RadioButton();

radioButtons[i].Text = dr.GetValue(1).ToString();
}

Please i need your help

Ferron

actually got it fixed, thanks man

Ferron

I want to link a application to another website via relative path and it's giving me hell, any help?

Ferron

yes man, that's exactly what i want too do, thank you man, thank you. Can you show me how ? an example maybe?

Ferron

It would be nice if you directed me to them :confused:

Ferron