Recent content by vpekulas

That's right, you can only use the validation controls for controls that have runtat=server parameter. You can always use JavaScript to do validation on the client instead. "Taxes are the fees we pay for civilized society" G.W.

I have a repeated control that I populate from my MS SQL DB. Now I check one of the returned values, so far I'm using this code: <%If Container.DataItem("fldSHARE") = "1" Then %> <td>Shared</td> <%else%> <td>Not Shared</td> <%End IF%> When I run the code I receive an error: BC30451...

Is there a way to insert records that are returned by a select statement ? I have 2 identical tables, each with the same structure, but different names. I want to query one table and insert the result into another one. I'm using MS SQL. Thanks :) &quot;Taxes are the fees we pay for civilized...

Either null or whtever the length is as a string &quot;Taxes are the fees we pay for civilized society&quot; G.W.

Nothing worked until I've used strVALUE(2) = MyRead.GetValue(2) & "" That's the only thing that wors :) Who knows why ..... Thanks guys! &quot;Taxes are the fees we pay for civilized society&quot; G.W.

Nope, still nothing, this fails on the first line: Dim strVal2 As Int32 = CType(MyRead.GetInt32(2), Int32) The reason is that even though the character_maximum_length is supposed to be an int32 datatype, it's not. I even tried to convert (cast) the character_maximum_length from the SQL string...

I'm completely lost, no matter what I try I can not get it to work ... thanks for the suggestions above ... still not working. Apparently the datatype for character_maximum_length is dbtype_I4 returned using GetDatTypeName, the GetFieldType returns system.int32. When I try to get the value...

I did just that, thinking it could be int16, eventhough the return datatype is int32, doesn't work :) Same error. &quot;Taxes are the fees we pay for civilized society&quot; G.W.

I'm using the following to get the table structure: SQL = "SELECT column_name, data_type, character_maximum_length FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = '" & strTABLE & "'" Call OPEN_DB() Dim MyCMD As New OleDb.OleDbCommand(SQL, MyConn)...

I have a DataRepeater that I bind my data to, now I want a checkbox to be placed in each item and then when I click the button I want to get list of values from those checkboxes. How can I do that ? For some reason I can not reference controls I place in the <ItemTemplate> of the DataRepeater...

Thanks JCruz063, do you have any samplec code that I can look at to see how to do it ? &quot;Taxes are the fees we pay for civilized society&quot; G.W.

I have 2 tables, 1 containing categories (parent) and another one containing sub-categories (children). The sub-categories table has a reference to the parent in fldPID field: CREATE TABLE [tbl_m_cate] ( [ID] [int] IDENTITY (1, 1) NOT NULL , [fldNAME] [varchar] (150) NULL , ) ON [PRIMARY]...

This would be per page setting though, is there a way to that for the entire project wihtout having to import the namespace for each page ? &quot;Taxes are the fees we pay for civilized society&quot; G.W.

Thanks link9, worked like a charm :) Do you know how I can import it so I can use only the function name rather then the whole reference project.module.function ...... I'm using VS.NEt 2002 &quot;Taxes are the fees we pay for civilized society&quot; G.W.

I have a module where I keep all my common functions, now I want to use one of the functions like this in the page.aspx file: <td align="Center"><%#CONVERT_TXT(Container.DataItem("fldACTIVE"))%></td> The function CONVERT_TXT is decalred pulic in the module. When I put the function in the...