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...
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...
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...
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...
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 =...
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...
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!
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
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 =...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.