Looking for the simplest way to get a single value from a database. This gets confusing when you consider all of the 9,000 ways that exist to do this in a .NET language. SqlCommands, DataReaders, Recordsets... Assume I already have a connection to the DB opened. I simply want to do something like this:
Dim age As Integer = <SQL statement here>
I am using help of SqlServer.Management.Smo to rename an attached MS-SQL database.
Dim db As New Database = ActiveSQLServer.Databases(OLD_NAME)
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " SET SINGLE_USER WITH ROLLBACK IMMEDIATE")
db.ExecuteNonQuery("ALTER DATABASE " & OLD_NAME & " MODIFY NAME = " & NEW_NAME)
The problem is that after renaming the database is set as a Single User.So what am i doing wrong?
Trying to use asp.net for the first time. I want to read a single value from a sql server database.
I have configured the SqldataSource as:
CODE:
I have the above asp:SqlDataSource code on the website page. The connection string is in the web.config file. When I run the page it is all works but the required data is not shown. Am I right to think that where I dragged the sqldatasource entity is where the data result should be shown?
I am trying to update a row or a single cell in ms access through vb.net. But when i update the text box named NRIC, say for example i want to update "s4522147B" to "tr4521856C" and mean while leaving the other fields the same.
But the thing is when i make the changes in nric.text (textbox), the dataset actually updates the whole column in the table instead of the selected textbox.
Below is my code for the update part
[Code].....
I have a column in a table that contains a message and I want this message to be displayed in a label. Here is my code which currently doesn't populate the label.
Protected conString As String = ConfigurationManager.AppSettings("sqldirectory")
Dim cnn As New SqlConnection(conString)
Dim cmd As New SqlCommand("select message from [database].[dbo].[table]")
[Code]....
Developing an application that will serve as an application server (Similar to 'Run Advertised Program' that is present in Windows Server). The downside to using Microsofts current system is that it a) requires Windows Server and b) Works only with systems setup in a proper Domain. I have a number of systems in my house and I'm fed up of downloading from the net or setting up network drives etc etc. I've tried using the code in a similar topic posted a few threads down, but it obviously doesn't support multiple client connections.
View 9 Repliesi want to take single table backup on sql server 2000 how can i take only selected table backup ??
View 1 Repliesi need to import a Single Column Excel File to an Existing SQl Server Table.
View 1 RepliesOk, the basic situation: Due to a few mixed up starts, a project ends up with not one, but three separate databases, each containing a portion of the overall project data. All three databases are the same, it's just that, say 10% of the project was run into the first, then a new DB was made due to a code update and 15% of the project was run into the new one, then another code change required another new database for the rest of the project. Again, the pertinent tables are all exactly the same across all three databases.
Now, assume I wanted to take all three of those databases - bearing in mind that they can't just be compiled into a single databases due to Primary Key issues and so on - and run a single query that would look through all three of them, select a given set of data from each, then compile those three sets into one single result and return it to the reporting page I'm working on.
I have a stored procedure (I cannot edit) that I am calling via linq.
The stored procedure returns values (more complex but important data below):
Customer Stock Item Date Price Priority Qty
--------------------------------------------------------
CUST1 TAP 01-04-2012 £30 30 1 - 30
CUST1 TAP 05-04-2012 £33 30 1 - 30
CUST1 TAP 01-04-2012 £29 20 31 - 99
CUST1 TAP 01-04-2012 £28 10 1 - 30
I am trying to limit this list to rows which have unique Dates and unique quantities in LINQ. I want to remove items with the HIGHER priority leaving rows with unique dates and qty's.
I have tried several group by's using Max and order by's but have not been able to get a result.
Is there any way to do this via linq?
EDIT:
Managed to convert brad-rem's answer into VB.net.
Syntax below if anyone needs it:
returnlist = (From p In returnlist
Order By p.Qty Ascending, p.Priority
Group By AllGrp = p.Date, p.Qty Into g = Group
Select g.First).ToList
I'm trying to get a single value from my table in a database. They are all given a unique id when stored. Here is the code I use to put the in:
[Code]....
That was so you could get an idea of what I was looking for, I'm not looking for sql statements, I don't know how to use them. Just keep in mind, this is all vb.net/asp.net.
[Code]....
I have created my site using ASP.NET Personal Starter Kits 3.5. I use Visual Studio 2008 only . .with its built-in SQL Server (2005 Express) ... my database in App_Data is ASPNETDB.MDF ...I have created some of my tables also ....in ASPNETDB ..In my local PC the site was running fine ...But when I publish my site on production server it doesn't work and shows the following error
<!-- Web.Config Configuration File -->
<configuration>
<system.web>
[code].....
I have developed a VB.NET program using a strongly typed dataset. This dataset has its connection to a SQL Server 2008 R2. The software should now be additionally used offline. The database should be exported to a *.sdf database. If no connection to the SQL server is produced, the software have to try to connect to the *.sdf database.I would like to achieve:
1. Export the data in the SQL Server 2008 R2 database to a local *.sdf file.
2. This *.sdf file has to work as an alternate connection string in the strongly typed dataset.
How can I write a connection string? I has four different computer that can be connect via ethernet.How can I maintain a inserting data if to computer insert on same table at a single time..??
View 1 RepliesI'm creating a database for photos'.
The issue is that I have a need to upload a set of photos to the database instead of a single photo.
This would be all fine and dandy if I knew how many photos would be added at once but in this case it could be 1 or 100.
I have my database (setup in details) and dragged onto my form. Right now I only have a picture box for my picture to place into the database.
So what's the best way to upload numerous photos to a database without having to create 10000 cells in my database?
In my contact manager program I have been storing information by reading and writing comma delimited files for each individual contact, and storing notes in a file for each note, and I'm wondering how I could go about shrinking them all into one file effectively. I have attempted using data entry tools in the visual studio toolbox and template class, though I have never quite figured out how to use them. What would be especially convenient is if I could store data as data type IOwner (a class I created) as opposed to strings.
I'd also need to figure out how to tell the program what to do when a file is opened (I've noticed in the properties how to associate a file type with the program though am not sure how to tell it what to do when it's opened).
Edit:
How about rephrasing the question: I have a class IContact with various properties some of them being lists of other class objects. I have a public list of IContact. Can I write Contacts as List(Of IContact) to a file as opposed to a bunch of strings?
Second part of the question: I have associated .cms files with my program. But if a user opens the file, what code should the program run through in an attempt to deal with the file? This file is going to contain data that the program needs to read, how do I tell it to read a file when the program is opened vicariously because the file was opened?
with editing a single field of a database. variable dS is my dataset variable in which i have filled with the tables of my database. since its my first time in database management with vb.net
Private Sub btnSave_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnSave.Click
If txtPOno.Text = "" Or txtDate.Text = "" Or txtSuppCode.Text = "" Or rBOM < 0 Or
[Code].....
inorder to pass. honestly, i really think that im using a BRUTE FORCE method.
I am trying to read a single result from an SQL table. I tested my query in MySQL Query Browser and it returns a result of USER_ID=4. My query:
SELECT USER_ID FROM aaalogin where NAME = 'administrator'
I believe my error is due to some "double quoting". I have a "txtUsername" textbox on my login form. I want to inject the typed entry from this textbox into my SQL QUERY. Notice the end of this line, I have tried tons of combinations, nothing works.
myCommand.CommandText = "SELECT USER_ID FROM aaalogin where NAME = " & " ' txtUsername.Text ' "
The result is ALWAYS "0" though, which is useless to me.
Full code below:
Imports MySql.Data.MySqlClient
Imports System.Data
Public Class frmLogin
Private Sub cmdCancel_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCancel.Click
Application.Exit()
[Code] .....
I am tring to make the below application work with SQL Server 2005 Database Currently it works for test.mdb, which is in the same folder with the application. How shoud I modify the MapPath to work with SQL Server.
[Code]...
i have a app in visual basic mobile 2008, so i finish but now i need to tranfer the data generate in the in the app mobile to data base in sql server 2008.
View 1 RepliesI'm using an access database in a program that I'm making for my school, the user is able to select an item from the menu, then it sends it to a list box, there is also a textbox to put a quantity of how much of the item you want. I have a field in my database called Amout Ordered, I want to update it with the amount of each item ordered, and I can't figure out how.
View 1 RepliesI have an application which takes input on a local machine and sends it to a database stored on a server. I'd like to be able to deploy my application over a number of computers (all on the same network), all of them updating the same database (on the network server).First of all, will this be possible without putting together a completely new application to handle all connections to the database and sorting the entries?
View 7 RepliesI am using MS Access Database. Now I have to update a particular cell value. Here is my code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim str As String
Dim Presc As New System.Text.StringBuilder
Dim prs As String(), j As Integer
[Code]....
This code updates all the cells in that column. I want to update only the particular cell having Case_ID = str Where I have to add the WHERE clause (WHERE Case_ID = " & str & "
I am using vb.net and sqlite as database. I am using below scenario to insert multiple records in database using a single query.
INSERT INTO TableName (FirstCol, SecondCol)
SELECT 'First' ,1
UNION ALL
SELECT 'Second' ,2
UNION ALL
SELECT 'Third' ,3
[Code] .....
For less records it is working very well.But when I am inserting about 800 records at a time, executenonquery is throwing the following exception:
SQLite error
Too many terms in compound SELECT.
i connect database with vb.net and also i receive a single value from my receiver through serial port. now i want to match this single data with one field of database. i have attached my code.
Public Class Form1
Private Sub OPEN_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
[Code].....
I am trying to combine some data into a RTB from a Database into a single RTB with formatting. Let me try and explain... In my Database I have some Fields that Contain RichText (formatted) and Some that are only Text (nvarchar) and I need to combine these into one RTB with formatting.
[Code]...
I have two buttons on a form , clock in and clock out, and i have two fields in an access database, fldCheckIn and fldCheckOut, when i click the check in button i want it to get the current time and set it to the field in the database
View 13 Repliesi have imported names from database table into combobox..i want to add item"all" above all names..how can i just add one single item in combobox after populating it form database tabel.
View 1 RepliesThe apostrophe is used to separate data when adding records to an Access Database data table using the "INSERT INTO" SQL statement. Having apostrophes in the data really screws things up with this new software. Is there a simple workaround? Is it possible to specify a different character? Is it possible to add data without using SQL Statements? I also noticed that the new OleDbDataAdapter Add Method generates the same SQL Error because it apparently creates an "INSERT INTO" SQL Statement.gh
View 4 RepliesI have three textbox ... textbox1 and textbox2 and textbox3
I want when I choose from date in textbox1 say 1-May-2011 and to date in textbox2 say 30-May-2011 and in textbox I type 1,2,3,4,5
I want on button click ... event the values will be entererd in database from 1-May-2011 to 30-May2011 as : mentioned below :
DATABASE STRUCTURE
ID Date Items
1 1-May-2011 1,2,3,4,5
2 2-May-2011 1,2,3,4,5
3 3-May-2011 1,2,3,4,5
so on till 30_may-2011
Record will be inserted in database according to from date and to date choosen in textbox1 and textbox2 respectively ...