I am Trying to add some information to a data base server, a person's ID, the experiment he is participating in, and the date of the experiment.This is my code:
SQLConnection1.ConnectionString = MyConn
Dim drNewRow As DataRow = DtsLabSystem1.tables("SubjectExperiment").NewRow
drNewRow("SubjectID") = lblSubjectID.Text
is it possible to print information stored in a SQL database from a visual basic ASPX.net website 2010. I am having problems. I do not have code at the moment as this is my first line of code i want to add I can show u my database structure its only one table:[code]This is not MVC3 this is just Visual Studio 2010 aspx.net
I am using one web project in the name of "AAA", it is working fine in the production. I am trying to add two new aspx pages in the existing website without affecting the existing AAA.dll file, so I planned to create a new web project inside the same solution in the name of "BBB". In AAA - I have one web.config, In BBB - web project I have one web.config. In the live I am using AAA's web.config. Here I am trying add the new aspx files and bbb.dll in the hosting place. My question is "How to add BBB web project's web.config settings ?
I need to know if it recompiles my site at all or if there are any issues doing this. I have tested the changes locally and in a test environment and I don't want to do a full deployment for one tiny change. I'm just not familiar with aspx.vb files and how they interact with a website.
My current solution consists of several Class Libraries and a Website. I'm in the process of globalizing the application and I realized that my resources need to be accessed by all the projects not just the website so placing my resources in the App_GlobalResources folder didn't work. I added my resources to one my class Libraries and now I'm trying to figure out what the best way of accessing the resources are from my markup. When my resources were in the App_GlobalResources folder I was able to access them by using an expression such as this: <$ Resources: MyApp.Name %> for server controls
Or <%=Resources.MyApp.Name %> for plain text
What's the best way of accessing my Resources from my website aspx files now that they are in a Class Library DLL?
I have multiple aspx pages in my web site but i want to secure only one page.I used the asp.net membership and role manager but it require user name and password for all pages but i want to secure only a single page.please any one can help me how can i do this in vb.net with asp.net .I have used the following code in web.config but it applies on all pages which i dnt want
I have been piecing together bits of code that I have found and customized it to work with my app. Now the following code works find out of a separate thread, but as soon as I put it into its on threads it doesn't want to connect.[code]...
I'm looking to have a program connect to a specific website, enter data, and then return something but without using the WebBrowser.For instance, I want it to:
Connect to a website Login to the website Return if it logged me in or some error etc
I'm kindof new to VB so I'm not sure how to go about this Edit: I read up a little bit about using WebClient and I understand a small bit of it but not much
I have the following pages structure in my asp.net 3.5 website ...i want if anybody directly access any page of my site as [URL] then it will automatically redirected to [URL] How to do this using vb.net, asp.net
Iam a pretty much beginner to all this stuff. Bassicly i want to connect to a website, and read the RSS feed. I've googled for a few hours now without luck, i can only find something about database connection and some socket connection to a client and so on. Searched on msdn too, without luck.
Ive been trying to connect to the MySQL database located on my website using vb.net 2008 express... i have been failing, when i run my code i have i get the following error,
ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
That error comes from this code,
Code: Dim connectionString As String = "Driver={MySQL};SERVER=coolness.something.com;DATABASE=Citys;UID=admin;PASSWORD=p975311;" ' Dim conn As New OdbcConnection(connectionString)
withautopostback=true? i am using vb.net and have 50 checkboxes that shall show up from the database data depending on the selected value of the previous dropdownlist. also can i change the label of the checkbox
I am writing a small VB 2008 application which connects to a SQL Server 2008 database,which is hosted with Fasthosts in the UK. The connection string I am using is;"connectionString="Data Source=xxx.xxx.xxx.xxx;Initial Catalog=xxxxxxxxxx;User ID=xxxxxxxxxxx;Password=xxxxxxxxxxxx"I can connect to the remote data using the "add data source" within Visual Studio and can preview thehosted data without anyssues however when I try to run the application I get an error stating;"The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
I have this connection string (IP and port number changed)Public ConnectString As String = "Data Source=207.167.717.614,8711;Network Library=DBMSSOCN;Initial Catalog=TableName; User=User; Password=Password;"It does not all a connection, i've opened this port for port fowarding and have unlocked the TCP port of the firewall what else could be wrong?
I am bignner in vb.net and i have develo[ed a small application of vb forms in which i have use a service based sql server databas(.mdf)i want to make its msi installer last time i have made it and after installation application giving error for connecting to sql server
its been a long time but sincerely, am happy to be back. now i've got a problem on my mind and that is; am trying to develop a database application but i want it to be a console application. the major issue is that i dont know how to go about connecting vb.net console application to sql server or if its possible at all, but am sure its possible in this world of ours...
I would like to create a OPC Client... But fist of all how do I connect a OPC-Server to me application. anyone who have done this? and maby hade some sample code??
im using SQL Server 2005 as my back end for an information system im currently developing. Im a total beginner with SQL, so i came across a huge blockade.An error appeared while i was configuring my server,"Login failed for 'username'. Reason: Account disabled".i tried searching EVERYWHERE in the net, but nothing helped me.
I have installed Visual Basic 2008 express edition, but I didn't get SQL server. Therefore, I installed SQL server 2008 separately, and it works fine..But I want to use the SQL server in Visual Basic, but it doesn't show up when i click Add New Item. Is there some way of connecting VB to SQL server?
I want to understand the concept of connecting to a remote PC or server. I'm working on an app that will connect to a remote server. Read a value from a registry key and then display the results in a text box. It will also connect and search for a specific log file on a server. I understand how to read the files. I'm just not sure how to connect to a machine remotely if I have valid credentials. There seems to be sever ways to accomplish this. I want the most efficient way using vb2008.
I'm been learning about connection strina I have been able to succesfully connect to a sql database stored locally on my Pc.The next logical step would be to connect to a database stored on a remote server. My question is does anyone of a sql database ( or any other type of database ) which can be openly accessed by the general public. Does anyone know if a web hosting service would allow me to remotely connect to a sql database ? Could I for instance upload my database onto a web hosting service and try connect to a remote database that way
i am having alot of trouble finding the source code to establish a connection to a remote sql server ( at my university) for vb. All i have is the IP adress and the username and password to the database. I tried coding it with a sqlconnection, sqlreader and a command to execute the statement with no luck.
i am trying to develop a multi user application. this is the first time i am doing it. my database is sql server 2005. and using vb.net as the programming language.i have few questions,
1. my database is in one computer. this computer is not actually a database server. it is just a computer. and the database is created in local drive (e:) of the computer. when i develop the application. so, if i am writing an application for the computer where the database is created. i can give the location of the database as my connection string (is there any better way to do this. because there might be problems, if the database location is changed). how can i connect to the database from the other computers in the same network?
2. this is my second question. i have a table which stores customer details (customer id is primary key and its auto number). one customer can have many hobbies. so i took it as a separate table (customer ID as the foreign key of that table) . when i enter data, i use single form to enter the customer details and their hobbies. so when i insert the record into two tables, will the second table take the new customer ID automatically into dat tables customer ID which is a foreign key.
I'm building an application that connects to a SQL Server 2008 database via connection string. The thing is, since the computer loading the app (or the user, in either case) is outside the Active Directory domain, I can't use Windows Authentication to connect to the DB. But when I include the database credentials, it won't let me connect either, telling me that since the computer logging in is from an untrusted domain, access is denied.
I created application database by vb.net and sql server 2005 now I have some computer on the one of them I installed sqlserver 2005 and other (Clients) computers I installed Application how I can connecting my application to sql server on the pc1 or how I can using connection string.
I am trying to connect with SQL Server Database using VB.Net. In Datasource of Binding Source, I selected 'Add project datasource' Clicked 'Database and New Connection in Choose Connection Wizard.
In New Connection, what to select 'SQL Server' or SQL server Database? I tried both but when Tested Connection, it failed to connect.Also, what type of password to be chosen, Windows based or SQL Server based?