marylipscomb
Last Activity: Mar 6 '08, 08:10 PM
Joined: Apr 2 '07
Location: Charleston, WV
-
Very Helpful!!! THANKS VERY MUCH!!!!!!!!!!! !!!!!!!!!!!!! :) -
-
That wasn't the problem at all. After reviewing my code and trying different things I figured out that it wanted Company/Event to be in brackets.
[Company/Event]
Thanks for your help though!!!...Leave a comment:
-
Error 3141????
I keep getting this error. EVerything looks like it is spelled correctly.
My code is:
SELECT [tbl_Company Visit].Rep, [tbl_Company Visit].Company As Company/Event, [tbl_Company Visit].CompanyInfoInd ustry As Industry,
[tbl_Company Visit].CompanyInfoRes ponse As Response, [tbl_Company Visit].[Visit Type] As Activity,
[Choices_County].County As County, [Choices_State].State As State, [tbl_Company... -
For some reason it won't let me change the dataset name to just dataset without an error.
It is either dataset1 or dataset2.
I am not sure what you mean by CompaniesTableA dapter object is declared as a member of the form your button is in. Is there any way to simplify that any more. lol I am lost.
thank you very much...Leave a comment:
-
VB.NET Reference to a non-shared member requires an object reference??
I don't understand why this isn't working. I am trying to have the button create a fill a table I guess when they click a button. I am having so much trouble with this.
The table adapter is called CompaniesTableA dapter and the dataset is called GetActiveCompan ies.
Protected Sub btnCompanyLooku p_Click(ByVal sender As Object, ByVal e As System.EventArg s) Handles btnCompanyLooku p.Click
Dim GetActiveCompan ies... -
Thank you so much. Makes perfect sense!!!...Leave a comment:
-
Access query criteria question
I am going over code that I am now responsible for but did not write. Can someone tell me what this means? Thank you so much
Also this is on a query, criteria.
Like "*" & [Forms]![Switchboard]![county] & "*"
What does ! mean in this and the & sign mean in this.. -
oh. It is in my switchboard.asp x.vb code.. so that code probably goes in my aspx code.. got it.
Thank you for all your help and quick replys!!!...Leave a comment:
-
VB.NET Simple error for closing bracket
Keeps giving an error of missing closing bracket. It is here, I have even tried adding one in different spots but still doesn't help.
Function GetData(ByVal queryString As String) As System.Data.Dat aSet
<connectionStri ngs><Add Name = "myconstrin g" connectionStrin g="Data Source = MLIPSCOMB737;In itial Catalog=BID; Integrated Security = True" /></connectionStrin g>
Dim... -
marylipscomb replied to Error: Value of type '1-dimensional array of System.Data.Dataset' cannot be convertedin .NETDim ConnectionStrin g As String = ConfigurationMa nager.Connectio nStrings("Conne ctionString").C onnectionString
is ("ConnectionStr ing") where I put my connection string??? for example it would look like this:
Dim ConnectionStrin g As String = ConfigurationMa nager.Connectio nStrings
(Data Source=MLIPSCOM B737; Initial Catalog=BID; Integrated Security = True.Connection String...Leave a comment:
-
marylipscomb replied to Error: Value of type '1-dimensional array of System.Data.Dataset' cannot be convertedin .NETyes thats the problemLeave a comment:
-
marylipscomb replied to Error: Value of type '1-dimensional array of System.Data.Dataset' cannot be convertedin .NETnow I am getting this error when I go to the page.
Object reference not set to an instance of an object.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullRefe renceException: Object reference not set to an instance...Leave a comment:
-
marylipscomb started a topic Error: Value of type '1-dimensional array of System.Data.Dataset' cannot be convertedin .NETError: Value of type '1-dimensional array of System.Data.Dataset' cannot be converted
I am using VB.NET. I am trying to connect a button so that when it is clicked the gridview pops up the data.
Partial Class Switchboard
Inherits System.Web.UI.P age
Protected Sub btnLookup_Load( ByVal sender As Object, ByVal e As System.EventArg s) Handles btnLookup.Load
If Not Page.IsPostBack Then
Dim queryString As String = "Select CompanyID As CompanyID, Company As... -
Clicking button and Gridview popping up question???
I want to click a button and then have the data come up in the gridview.
Here is what isn't working.
Partial Class Switchboard
Inherits System.Web.UI.P age
Protected Sub btnLookup_Click (ByVal sender As Object, ByVal e As System.EventArg s) Handles btnLookup.Click
Dim SqlDataSource1 = "SELECT [Companies_Type].[CompanyID], [Companies_Type].[Company],[Companies_Type].[City... -
when I use this line it says there is a declaration expected on the Driver.
Driver={SQL Server};Server= local;Database= PDDB;Trusted_Co nnection=Yes;Leave a comment:
-
no but I will try it, thanks!!
How do I know where my server address is??Leave a comment:
-
by the way, I am using VB.NET and ASP.NET... trying to connect to the SQL Server 2000Leave a comment:
-
SQL Connection ??
I am trying to connect to a sql server 2000.
I keep getting errors.. HELP Please!!!
Partial Class projectdevelopm entmain
Inherits System.Web.UI.P age
DIM SQLClient.SqlCo nnection as conn
Dim conSQL As New SQLClient.SqlCo nnection()
conSQL.Connecti onString= "Integrated Security=True;" &_
"Data Source =LocalHost;Init ial Catalog=PDDB;"... -
I FIGURED IT OUT!!!!!!!!!!!! !!!!!!!!!! WOOOOOOOHOOOOOO O
*pats self on back*Leave a comment:
No activity results to display
Leave a comment: