Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vpekulas
  • Order by date
  1. vpekulas

    Validation controls and non server controls

    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.
  2. vpekulas

    If Then statement in HTML with bind data

    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...
  3. vpekulas

    Insert records returned in select

    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...
  4. vpekulas

    Casting Integer to String

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

    Casting Integer to String

    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.
  6. vpekulas

    Casting Integer to String

    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...
  7. vpekulas

    Casting Integer to 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...
  8. vpekulas

    Casting Integer to String

    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.
  9. vpekulas

    Casting Integer to String

    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)...
  10. vpekulas

    DataRepeater Controls in Item

    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...
  11. vpekulas

    2 DataReaders in 1 connection

    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.
  12. vpekulas

    2 DataReaders in 1 connection

    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]...
  13. vpekulas

    Using Functions in a module on ASPX pages

    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.
  14. vpekulas

    Using Functions in a module on ASPX pages

    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.
  15. vpekulas

    Using Functions in a module on ASPX pages

    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...
  16. vpekulas

    Where to Open Database Connection - How many times

    Thanks guys, makes it clear. The connection pooling is done by default in .NET right ? No need to set-up anything ? &quot;Taxes are the fees we pay for civilized society&quot; G.W.
  17. vpekulas

    Where to Open Database Connection - How many times

    I think the "Connection = Nothing" argument was my ASP 3.0 talking :) What you are saying is that if I need to tap into my DB say 4 times on 1 page, it doesn't matter that I have to open the DB connection 4 times as well. It's better then opening it once and closing it once. Right ...
  18. vpekulas

    Where to Open Database Connection - How many times

    My questions is very simple (I think) I'd like your opinion where to open the DB connection. In classic ASP I'd open the connection near the top of the page where I'd need it and close it with the last trip to the DB near the bottom of the page. I'd only have 1 connection per page. Can I...
  19. vpekulas

    Getting data out of DB - How

    Yes, that'd be too easy :) I'm looking for a solution not to bound it to a control. There will be only 1 row returned (summary, average, count etc.) so there is no need to use a Datagrid. &quot;Taxes are the fees we pay for civilized society&quot; G.W.
  20. vpekulas

    Getting data out of DB - How

    How can I get a simple return of data from my DB using ASP.NET (VB.NET). In classic ASP I'd do something like this: SQL = "SELECT COUNT(ID) AS C_COUNT FROM table" Set RS = Server.CreateObject("ADODB.Recordset") RS.Open SQL, MyConn IF NOT RS.EOF THEN COUNTER = trim(RS("C_COUNT")) END...

Part and Inventory Search

Back
Top