ASP.NET

Re: Not considering "If condition in inside the foreach statement"

28-Jul-08 4:59

Because maybe he didn't debug his code.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Sherin Iranimose28-Jul-08 3:23

Sherin Iranimose

28-Jul-08 3:23

New one wrote:
DS.Tables[DS.Tables.Count - 1].Rows

If there is only one Table in the DS always, Why cant you use a DataTable.

New one wrote:
drc.Table.Rows[k][1].ToString()

Set a break point a check what value is there in the above code.

percentage signs around sql parameter

eyeseetee28-Jul-08 0:08

eyeseetee

28-Jul-08 0:08

Hopefully an easy one guys
Need to put % signs around an sql parameter in a stored procedure
something like %@value%

anyone have any ideaS?
thanks

Re: percentage signs around sql parameter

Blue_Boy28-Jul-08 0:15

Re: percentage signs around sql parameter

28-Jul-08 0:15

this works for me in SQL 2000

CREATE PROCEDURE SpName AS<br />
<br />
declare @paramVal as varchar(4000)<br />
set @paramVal='value'<br />
select * from TableName where columnName like '%'+@paramVal+'%'<br />
GO

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

eyeseetee28-Jul-08 0:28

eyeseetee

28-Jul-08 0:28

Thanks that worked!
Smile | :)

Re: percentage signs around sql parameter

Blue_Boy28-Jul-08 0:30

28-Jul-08 0:30

You are welcome dude Wink | ;)

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

OnClientClick

Reelix27-Jul-08 23:44

Reelix

27-Jul-08 23:44

Hi all!

I've been using the OnClientClick with the Button control for awhile now to execute JavaScript without causing page validation:

Button1.OnClientClick += "javascript:doThis(); return false;";

but one thing still eludes me...

Is it possible to execute the OnClientClick event on a textBox?

If anyone can figure out any solution, I would be highly grateful!

-= Reelix =-

Re: OnClientClick

Blue_Boy28-Jul-08 0:08

28-Jul-08 0:08

try
TextBox1.Attributes.Add("OnClick", "javascript:alert('This is just sample');");

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

Re: OnClientClick

Reelix28-Jul-08 0:11

Reelix

28-Jul-08 0:11

Thanks!

Works perfectly! Big Grin | :-D

-= Reelix =-

Re: OnClientClick

Blue_Boy28-Jul-08 0:16

28-Jul-08 0:16

You are welcome.

I Love T-SQL
"Don't torture yourself,let the life to do it for you."

sqlbulk copy asp.net c#

VijayVishwakarma27-Jul-08 22:20

27-Jul-08 22:20

Hi,

i am inserting records from a datatable to sql server 2005 database using sqlbulk copy.
The problem is that the datasource datatype is different from sql server table datatype.

Is there any way to convert the datatype to there corresponding datatypes in the table.

thanks

VijayVishwakarma28-Jul-08 0:04

28-Jul-08 0:04

no one has the answer???????????

Vijay V.

Ashfield28-Jul-08 1:12

28-Jul-08 1:12

Usually I import into a staging table where every column is a varchar, then validate the contents to the real data type before moving them to the actual destination table. This gives you a chance to perform other validation too.

Bob
Ashfield Consultants Ltd

VijayVishwakarma28-Jul-08 20:10

28-Jul-08 20:10

HI,

is there any way to detect that what kind of value is there in an .csv file rows??

thanks

Vijay V.

Yash Softech

Ashfield28-Jul-08 21:04

28-Jul-08 21:04

Not until its in a table. You should be able to do some basic checks as you know the final destination table.

Bob
Ashfield Consultants Ltd

VijayVishwakarma28-Jul-08 21:20

28-Jul-08 21:20

Hi Bob,

thanks for reply.

I was googling and found that I can use Namespace System.Microsft.SqlServer.SMO that has a class datatype using which I can set the datatype depending on my requirement but this I m not able to import this class in my project.

Do u have any idea regarding this
here is the code

public DataType GetDataType(string dataType)
{
DataType DTTemp = null;

switch (dataType)
{
case ("System.Decimal"):
DTTemp = DataType.Decimal(2, 18);
break;
case ("System.String"):
DTTemp = DataType.VarChar(50);
break;
case ("System.Int32"):
DTTemp = DataType.Int;
break;
}
return DTTemp;
}

Thanks

Vijay V.

Yash Softech

Ashfield29-Jul-08 9:37

29-Jul-08 9:37

You can do it from there, or this sql works too

select column_name,data_type
from information_schema.columns
where table_name = '<yourtable>'</yourtable>

|For details on using the smo method see my CP article [^]

Bob
Ashfield Consultants Ltd

VijayVishwakarma29-Jul-08 19:44

29-Jul-08 19:44

Hi Bob,

thanks for the help.

Vijay V.

Yash Softech

Ashfield30-Jul-08 1:17