ASP.NET

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

Re: percentage signs around sql parameter

28-Jul-08 0:28

Thanks that worked!
Smile | :)

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

Accessing Shared Variables

30-Jul-08 1:17

No problem

Bob
Ashfield Consultants Ltd

Access Denied Error.

Binod K27-Jul-08 22:12

Binod K

27-Jul-08 22:12

Hi,

I have taken refrence of Microsoft Excel 11.0 Object Library in my project to export data in Excel. And included following Name spaces

Imports Microsoft.Office.Interop
Imports System.Runtime.InteropServices.Marshal
Now i have declared following variables.

Dim objExcel As New Excel.Application

When i execute the code it gives Access Denied Error.

I check all the sharing and Security settings.

Your comments will be highly appreciated.

Thanks

Binod K.
(Miles to go before I sleep)

Re: Access Denied Error.

Vasudevan Deepak Kumar28-Jul-08 18:27

Vasudevan Deepak Kumar

28-Jul-08 18:27

Check out this related thread:

http://www.velocityreviews.com/forums/t107560-excel-interop-problem-access-is-denied.html[^]

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

All the world's a stage,
And all the men and women merely players.
They have their exits and their entrances;
And one man in his time plays many parts... --William Shakespeare

nagendrathecoder27-Jul-08 21:46

nagendrathecoder

27-Jul-08 21:46

Hello Friends,

I am developing as application in ASP.Net with code behind as VB.
I have declared a variable as shared in a code behind class like:

Partial Class MyPage Inherits System.Web.UI.Page
    Public Shared MyArray(1,2) as String

Now, how can i access this MyArray in some other code behind class?
Plz help me.

Thanks and regards,
Nagendra.

eyeseetee27-Jul-08 21:56

27-Jul-08 21:56

Why dont you put your array in a common methods class and then just access that from your class pages

nagendrathecoder27-Jul-08 22:10

nagendrathecoder

27-Jul-08 22:10

Sorry, i didn't understand. Can u plz explain.

eyeseetee27-Jul-08 22:28

27-Jul-08 22:28

Put a page class in your app folder and put the array in there. Then you can reference that page from other pages.

nagendrathecoder27-Jul-08 22:53

nagendrathecoder

27-Jul-08 22:53

It worked.....Thanks Smile | :)

eyeseetee27-Jul-08 23:31