Jaime del Palacio - All Comments

re: MySql and Tableadapters

jaimedp — Fri, 20 Jan 2012 15:07:59 GMT

@dave Which connector version do you have?

re: MySql and Tableadapters

dave — Fri, 20 Jan 2012 09:05:32 GMT

Sad to see this issue still persisting.

I have 2 sql statements (1 is a general get all records, other has a parameter for selective return of records) and cannot get updating to the table done via generated code :(.

re: Custom HTML Dropdown control (part 1)

jaimedp — Mon, 03 Oct 2011 16:25:55 GMT

@Hernando I'm not familiar with Drupal, but the basic concept (part 1) is only based on html and CSS, so as long as you can edit HTML & CSS directly into your CMS (being Drupal or any other), you can implement this concept.

re: Custom HTML Dropdown control (part 1)

Hernando Cadet — Mon, 03 Oct 2011 16:12:26 GMT

How could I accomplish this for Drupal? My email is h.cadet@gmx.us is for my website at www.hernandocadet.info

re: MySql and Tableadapters

weblogs.asp.net — Wed, 25 May 2011 04:07:01 GMT

Mysql and tableadapters.. Nifty :)

re: A way to organize your javascript code

Dostava Hrane — Thu, 24 Mar 2011 14:03:47 GMT

Hmm, interesting approach. I'll try.

A way to organize your javascript code

A way to organize your javascript code — Thu, 24 Mar 2011 00:21:04 GMT

Pingback from A way to organize your javascript code

re: Custom HTML Dropdown control (part 1)

Daniel Tsadok — Wed, 16 Jun 2010 19:03:12 GMT

Great work!

Ditto re the missing source code, though...

re: Custom HTML Dropdown control (part 2) - The server control

webcosmo — Mon, 14 Jun 2010 23:31:40 GMT

I am getting little problem with this. I am getting this error:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 1.0.3705; .NET CLR 2.0.50727; InfoPath.2; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)

Timestamp: Mon, 14 Jun 2010 23:29:59 UTC

Message: Object expected

Line: 7

Char: 5

Code: 0

URI: localhost/.../WebResource.axd

All the files are loading fine as I checked. The image is loading, menu is loading but expanded, and this error.

Any idea?

re: Compatibility of bit type between SqlServer 2000 and SqlServer 2005

Keyur Patel(MCP) — Mon, 15 Mar 2010 05:58:20 GMT

I have also faced same issue, while we were developing using SqlServer 2005 (express) and the hosting company uses SqlServer 2000 and as soon as we deploy, we got the following exception on one of the operations:

"Syntax error converting the varchar value 'true' to a column of data type bit"

I have resolved the problem without changing dbtype in our existing DB. If you are using storeproce for inserting data in table then may be this solution helpful for you.

For this problem, we have changed all parameter type bit to varchar(@IsPermenant [varchar](10)). After that cast with bit type when passing values in storeprocedure(CAST(@IsPermenant as bit)).

Same as shown in below line.

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

Create PROCEDURE [dbo].[EmployeeInsert]

@FirstName [varchar](30),

@MiddleName [varchar](30),

@State [int],

@IsPermenant [varchar](10)

Begin

INSERT INTO EmployeeInsert

(FirstName

,MiddleName

,State

,IsPermenant)

VALUES

(@FirstName,

@MiddleName,

@LastName,

CAST(@IsPermenant as bit))

Set @ID=SCOPE_IDENTITY()

END

This above solution succefully running on our prodiction site also. With this solution we can resolve our problem without changing dbtype in our existing table.

Happy Programming :-)