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!

  • Congratulations biv343 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: tsp1lrk72
  • Content: Threads
  • Order by date
  1. tsp1lrk72

    checkboxlist - gridview

    hello, I have a gridview with 2 checkbox lists; I'm editing/updating the database with my new comma delimited string of values. the first part, chkThursEvents, updates with no issues, the second one, chkFridayEvents, does not update at all- not sure what is wrong with the code... help...
  2. tsp1lrk72

    Checkboxlist Formview

    Hello- okay I'm trying out the formview... with the checkboxlist control, I can response.write the comma delimited string of values which is fine, how can i insert this to my SQL table? Protected Sub InsertButton_Click(ByVal sender As Object, ByVal e As System.EventArgs) Dim FormView...
  3. tsp1lrk72

    gridview/checkbox list

    using a detailsview and a radiobutton checklist- trying to loop through checkboxlist and collect the values separating with a comma (I want to add them to one field in a SQL table) Protected Sub HChkEvents_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Dim...
  4. tsp1lrk72

    same file, 2 different sizes when sent

    Hello, Okay - this is weird, I'm hoping someone can shed some light on this one. Creating an HTML newsletter in Dreamweaver, that's all good. Open it in WORD, choose send to mail recipient, send the file... from my PC to one person- it's 18K - Perfect I do this on another PC, same version of...
  5. tsp1lrk72

    Works in IE, not Firefox - anything obvious here?

    Just using this code to fill in contact info if it's the same to save typing and it works fine in IE but not Firefox... any ideas? <script language="javascript" type="text/javascript"> function fill_contact() { if (frmContact.chbsame.checked == true) { frmContact.vnds_scntct_fnm.value =...
  6. tsp1lrk72

    Need SQL string or SP

    Hello- The following code gives me the data I need, but now I need to get it into my VB.net code- can I call this as a SQL string right in the sub? SELECT SUM(Quantity), CASE Product WHEN 'FIR-UPPERS' THEN 'MBF' WHEN 'Nantucket Beadboard' THEN 'Truckload' WHEN 'Plywood Treads and...
  7. tsp1lrk72

    TO field blank

    Hi, I want to send an email to multiple recipients but I don't want them to see each other's email address- I've read about the "Undisclosed Recipient" option but I'd rather leave the "To" field blank- I have seen this before-- how can I get this to work? Outlook 2003... Thanks!
  8. tsp1lrk72

    problem with file download

    Hello- for some reason, my file download is not working correctly- I'm creating folders dynamically on the server based on the ID of the record, that is fine, I have a button with the following code: FuelSurchargeID = Request.QueryString("FuelSurchargeID").ToString Dim root As String...
  9. tsp1lrk72

    Datagrid export to excel: color extends over gridlines

    Hi! I have a datagrid that I export to excel which I have dynamically colored on export- when I export it into excel, the colors are there (the green is gray for some reason??) but the color just keeps extending out over the boundaries of the grid lines- can I have the colors just stay in the...
  10. tsp1lrk72

    Datagrid export to excel - color extends over gridlines

    hello- I have a datagrid that I export to excel which I have dynamically colored on export- when I export it into excel, the colors are there (the green is gray for some reason??) but the color just keeps extending out over the boundaries of the grid lines- can I have the colors just stay in...
  11. tsp1lrk72

    One query?

    How can i put this into one query? Select * From tblVendorInfo where RankComplete IS NOT NULL AND DivisionName = 'BP' Order by RankComplete Select * From tblVendorInfo where RankInProgress IS NOT NULL AND DivisionName = 'BP' Order by RankInProgress Select * From tblVendorInfo where...
  12. tsp1lrk72

    Multiple records for one ID, show only first one

    Hi- I'm writing a query to show data from a table; the data has multiple records for the same ID: Vendor Comment 1 Inovis as being a common practice that we both use. 1 Tom keeps getting VM. He will try again. CH 1 Tom spoke to contact and will help him get in touch Here is my...
  13. tsp1lrk72

    Column name invalid

    Hello, I have some code: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not Page.IsPostBack Then End If 'Define connection to read the data Dim myConn As New...
  14. tsp1lrk72

    Invalid Column Name weird---

    Hello, I have some code: Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load If Not Page.IsPostBack Then End If 'Define connection to read the data Dim myConn As New...
  15. tsp1lrk72

    Radiobuttonlist - get value from SQL DB

    I have this code: If Not Page.IsPostBack Then 'Define connection to read the data Dim myConn As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) Dim MyCmd As New SqlCommand("SELECT...
  16. tsp1lrk72

    Radiobuttonlist - get value from SQL DB

    Hi- I have this code: If Not Page.IsPostBack Then 'Define connection to read the data Dim myConn As New SqlConnection(ConfigurationSettings.AppSettings("connectionString")) Dim MyCmd As New SqlCommand("SELECT...
  17. tsp1lrk72

    VB.net SUB?

    Hi, I'm trying to do an update with a Case Statement to a SQL DB, but I want to do it from my .NET Windows App I have this, doesn't work... Sub FindReplace() Dim cn As New SqlClient.SqlConnection Dim cmd As New SqlClient.SqlCommand Dim ISAID As String Select...
  18. tsp1lrk72

    Parameter not supplied?

    This is driving me nuts... I can't seem to figure out what is wrong with this, I keep getting: Prepared statement '(@VendorID int)Select VI.VendorID, VI.DivisionName, VI.DeptName,' expects parameter @VendorID, which was not supplied. " Sub Page_Load(ByVal sender As System.Object, ByVal e As...
  19. tsp1lrk72

    Expects Parameter not supplied

    This is driving me nuts... I can't seem to figure out what is wrong with this, I keep getting: Prepared statement '(@VendorID int)Select VI.VendorID, VI.DivisionName, VI.DeptName,' expects parameter @VendorID, which was not supplied. " Sub Page_Load(ByVal sender As System.Object, ByVal e As...
  20. tsp1lrk72

    VB.NET Outlook

    bgaines72 posted this code: Dim olApp As Outlook.Application = New Outlook.Application() Dim olNS As Outlook.NameSpace = olApp.GetNamespace("MAPI") olNS.Logon("Brian Gaines", "", False, True) Dim olInbox As Outlook.MAPIFolder =...

Part and Inventory Search

Back
Top