Exporting From Sqlserver To Xml?
Aug 14, 2009I need to be able to export data from an sqlserver to an xml file (just a flat data dump) using visual basic coding - using just your basic select statement.
View 17 Replies
ADVERTISEMENT
Get Values From Sqlserver?
Aug 2, 2010I would like to retrieve data from db whenever i click on a button. I have a table for questions and another table for options. I select questions randomly and trying to get the corresponding options but my code below only returns options one time and stays there even though the random number changes. As an example, if random number is 1 i have options a,b,c,d for question 1 and if random number is 2 i have options e,f,g,h for question 2, etc...
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Label1.Text = ""
Label2.Text = ""
[code]...
Database Connection In .net Using Sqlserver
Mar 9, 2009how to establish a connection in vb.net using sqlserver
View 3 RepliesWay To Connect Remote SQLServer?
May 24, 2010What is the best way to connect a remote SQLServer via window based application?
View 8 RepliesWhich VB Remote SQLServer Access?
Dec 23, 2010I have a web site that connects to a remote SQLServer, and is running just fine.I have some pretty simple 'batch' type tasks that I want to run (as a Windows application) on a scheduler (I'm more comfortable with VB so I prefer that).
Looks like VB Express won't allow me to access the remote data. Everything seems to be pointing to having to buy VS Professional for $545 (I don't have an original one to upgrade). Is there a more economical VB option?
Windows App Using Data From SQLserver Over The Net?
Mar 4, 2009I'm working on a little program - an issue tracker - that I thought I'd put on the web. Now I'm getting really annoyed with Visual Web Developer EE because I find it hard to work with in order to do stuff that's easy in VB. So I got a new idea. Why don't I make a windows app in VB.NET that connects to my database over the net?
Problem is that I wonder how to do this in a sequre way and I have no idea... I figure that the win app would really only be a user interface to the business logic and data that runs at my server...
Connecting Forms To Sqlserver Database Using .net?
Mar 4, 2009im trying to access sqlserver management studio database using forms in vb.net...m using a button and i want to get access to the database when i click on that button....the code is given below....wen i tried the same code without using forms,this is working fine but it is not working when i use forms....
Imports System.Data.SqlClient
Public Class Form1
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim strcon As String = "Data Source=.\sqlexpress;Initial Catalog=employee;Integrated Security=True"
[code]....
m not getting any output using this code....
Converting A VB9 Application From Using Access DB To SQLServer
Jun 26, 2009I have been developing a VB 2008 application which has been using Access as its database. The app is very far a long with about 30 forms and 45 DataSets I now must change the application to use SQLServer. Unfortunately all of the Table & Attributes names have changed in the new DB. Almost all of the data model has stay the same.
I have a few questions on the conversion.
The ConnectionString is currently pointing to the Access DB. I have entered the new ConnectionString into the Setting tab. What is the best approach to make the change?
I have done some testing to change the Table & Attributes names by using Quick Replace. It seams that sometime when I would do the rename I would lose the TableAdepter on some screens.
What is the best approach to performing the renaming task?
Display Image In Picturebox From Sqlserver?
Jan 15, 2012I am new in vb.net. The image has been stored in sql server as and i dont know how to convert it to display in picture box.[code]...
View 14 RepliesHow To Check Version Of Installed Sqlserver
Feb 15, 2012i am working on an application and i want to connect it with mssql database , i dont know about the version of installed mssql server at the pc , how can i get the version of installed mssql server so that i can connect my application with that .(is it possible to check the version of installed mssql server with out connecting it with my application.)
View 2 RepliesInsert Into Sqlserver Thru Code Not Working
Nov 18, 2009I have a database in sql server 2005 named as Addressbook and table Persons with PersonID as PK.I have created 4 textbox on form for FirstName, LastName, Address, CityID and an ADD button. When I input data to text boxes and press F5 then it show some error message. I hv tried eerything but failed.My code is as following and error messae is (The SqlParameterCollection only accepts non-null SqlParameter type objects, not Boolean objects.)[code]
View 1 RepliesInsert More Than 200k Records In Sqlserver DB?
Feb 13, 2012i have to insert more than 200k records in sqlserver DB.
My idea is to add the data into DATA TABLE then doing Bulk Insert, but my TL said: "insert the data into CSV file format and do the bulk insert".
Made A Form To Connect To A SqlServer?
Apr 9, 2011I have made a form to connect to a SqlServer but i have hit a dead end as the PHPMyAdmin password table is encrypted so the Login only works when you enter the encrypted password in. Is they anyway to decode the password so the password can be read?
View 10 RepliesRestore Sqlserver Database From .net Or C# Application?
Jun 1, 2009how can I restore sqlserver database from VB.net or C# Application?
View 2 RepliesRestriction Error On Messages Between SQLSERVER And Dot.net?
May 28, 2009I tried to run this on a local instance of sql-server and sadly it worked!!!now I know that the code is right and there is some kind of DBA restriction I need to find (and ask the DBA to remove)
using System;
using System.Collections.Generic;
using System.Text;
[code].....
Sql Server - Call A Sqlserver Function From .net (or C#)?
Aug 19, 2009Public Sub cleanTables(ByVal prOKDel As Short)
Dim sqlParams(1) As SqlParameter
Dim sqlProcName As String
[code]....
and finally datatable dt = dbConn.Execute(CommandType.StoredProcedure, sqlProcName, sqlParams)
Asp.net - SQLServer INSERT Getdate() Function Using Parameters?
Jul 8, 2011What is the preferred method of adding the current date/time into an SQL Server table with INSERT Command and executenonquery? I'm expecting something like ...
cmd.Parameters.Add("@theDate", SqlDbType.VarChar, 20)
cmd.Parameters("@theDate").Value = "getdate()"
Best Way To Deploy Code / Create An Assembly On A SQLServer
Nov 17, 2009I've created some functions / procedures with VB.NET and want to deploy them to a SQLServer. Within Visual Studio you can click right and select "deploy". An assembly will be created on the server and a lot of functions and procedures. It's really easy.Now I want to script the whole deployment process. What is Visual Studio doing when I make a deployment? Can Visual Studio autoscript all the deployment steps for me? Can I save it to a file and execute it manually?
View 1 RepliesConnect Remote SQLServer Database Programmatically Using VPN?
Jul 28, 2009I can connect to VPN and I can access Sql Server using RDP. Now, I want to access the Sql Server programmatically.
I connected to the VPN and then have the following connection string set up[code]...
Create Setup With Sqlserver Database In Vs2008?
Jun 24, 2011the right direction for creating a setup of my application in which i had used Sql Server 7.0 as a database
View 3 RepliesDataTable Field Type From SQLServer Table
Mar 5, 2009If the field type in the SQLServer db is 'nvarchar 10', what would be / is the field type in a DataTable filled by rows from this SQLServer table? String?
View 1 RepliesGenerating User Instances In SQLServer Is Disabled
Apr 18, 2007I am a beginning programmer and am tying to add a database to my visual basic 2005 express program. I have a nice working window but now a database needs to be attached. Following the add items and selecting the sqldatabase icon (and change the name) I get the following message: "Generating user instances in SQLServer is disabled. Use sp-configure 'user instances enabled' to generate user instances". I am trying for 2 days to find out what to do.
Aparently, all the solutions on the internet are for wizards but not for apprentences. I hope to become a computer wizzard but are far from it now. I scanned my computer for the file sp-configure but it does not exist. I tried sp_configure as a DOS command, checked all VB menu options to find etc. On the internet the language is out of my league and jumps too quickly.
How To Store Time From DTPicker In SQLServer 2000
Mar 3, 2010How to store time from DTPicker in SQLServer 2000 when the front end is in VB2005. I am using the following. In the add form:-
Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
Dim dsNewCustomer As DataSet = DataAccess.AuthorData.DataModule.GetNewAuthor
Dim frm As New frmAuthor
frm.MainForm = Me
frm.LoadData(dsNewCustomer)
[Code] .....
Time is not getting stored in SQLServer2000 database.
Merge Dataset - SQLServer And MSAccess Database ?
Apr 17, 2009I have the same table in SQLServer and MSAccess database named "KHang" with fields : ID int identity(1,1) primary keys , MaKH char(4),TenKH varchar(50)
Here is my data :
MSAccess (" KHang" : Id-MaKH-TenKH)
1-KH01-tes
2-KH01-test
3-KH01-testing
SQLServer (" KHang" : Id-MaKH-TenKH)
1-KH02-testing1
2-KH02-testing2
I connect to MsAccess database using oledb in vb.net and fill data to DataSet1. So I want to update it to SQLServer database. I mean, the result will be like this:
SQLServer(table "KHang") :
(Id-MaKH-TenKH)
1-KH02-testing1
2-KH02-testing2
3 -KH01-tes
4 -KH01-test
5 -KH01-testing
How can I do it in vb.net?
Microsoft.SqlServer.SqlTDiagM File Missing?
Jan 9, 2012I was trying to load MS Access 2007 database using SQL 2008, but it was not successful because of error below,
View 2 RepliesPopulate A Datagridview With Rows In The Sqlserver 2005?
Sep 29, 2011I'm trying to populate a datagridview with rows in the sqlserver 2005.how to use DataAdapters too well so I go back and forth between hard code and controls.I used the Datagridview control and added columns to it this way. 2 combo boxes, a check box, and 2 text boxes.The 2 combo boxes are populated with values that are already in sql Server for users to pick from. The task is displaying the description while the value is the task_ID. Here is my form on load:
Private Sub frmTimeSheet_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
currentDate = Date.Now.ToShortDateString
lblDate.Text = currentDate
[code]....
Saving And Retrieving Images To/from Sqlserver 2005?
Aug 1, 2009now the remaining things are done-able but im stuck in new requirement posted by Client which he needs to upload all images from Sql Server to Oracle Database now since old application stores images Path it is kind of new story now ?(:
i tried to build sample application since am not familiar with kind of above requested modification here is my code so far to upload images
'' Sql connection is over
Dim fs as new fileStream (imgPath , io.fileMod.Open , Io.FileAccess.Read)
Dim imgByte (fs.length -1 ) as byte
[Code]......
Sql Server - How Can SQLServer Notify A .net Application Of An Event
Jul 7, 2011Is there a relatively simple way that my VB.NET application can be notified of the fact that a new value has been written to a table in SQL Server Express 2008? Polling is not an option since I'd need to do that every 10 seconds nonstop.
View 1 RepliesUpdate Data In SQLSERVER With Listview Checkboxes?
Sep 5, 2011I want to update my data in SQLSERVER with listview checkboxes. but how do I update those selected values?
View 2 RepliesUpload Photo Into The Database (sqlserver 2005)?
Dec 14, 2010i need to upload photo into the database (sqlserver 2005)and also want to print it using crystal report..
View 2 Replies