currently developing the backup and restore procedure of my database....and im using the SQL UTILITY[URL]..but...i was thinking if is it possible to obtain the Data Source or the Server name automatically...when the form load.
View 1 RepliesI'm new to Visual Basic, VS2005.I've added a Table to the WebForm. At Default.aspx this code was added automatically:
[Code]...
I am usinf VB 2005 Express and I an trying to connect to a SQL Server 2005 Express Database using the "Add New Data Source"I keep gettig the following error.Unable to open physical file "C:Program FilesMicrosoft SQL Server MSSQL.1MSSQLDataHeartland.mdf. Operating system erro 32: "32(The process cannot access the file because it is being used by anither process.)"An attempt to attach an auto-named database for the file C:Program FilesMicrosoft SQL Server MSSQL.1MSSQLDataHeartland.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
View 2 RepliesI'm currently coding an ATM system in VB, and when a user picks a card to 'log on' with, they have 3 attempts to log on before the card is confiscated.
The card numbers are in a combobox (which are retreived from an SQL database using the binding source which is linked to a data adapter), and each card has a boolean 'confiscated' field in the database.
It does actually set the card to confiscated after the 3 tries, however I'd like the form to 'refresh' so the card no longer appears in the combobox, without having to close down the form and reload it. Is there a way to do this? I've tried refreshing the combobox and data adapter (.Refresh) but this does nothing
Am using vb.net 2005. when vb starts i try to connect to mssql server uut i cant. unlike mssql7 desktop edition there is a consol in the start menu where one can configure mssql, creat database, tables etc.
View 5 RepliesI wish to save an image in a mssql database.My function is: Public Sub CalcNomogram(ByVal uid As String, ByVal mNavn As String, ByVal mId As Integer, ByVal ruhed As Single, _ByVal valgteDim As String, ByVal img1 As Image)
[Code]...
How to create a crystal report in vb.net 2005 using data source wizard.
View 1 RepliesI'm working on deploying a visual studio 2005 windows application executable with an embedded crystal report using visual basic. It seems to install everything just fine, however, the system dsn isn't being setup.
How do you configure a setup project to setup the system dsn during the installation?
I am looking to make a data connection with a network server(sql server 2005). When I run the data source configuration wizard, it allows me only to pick a local database file. I want to use a connection string like this "Data Source=SQLSERVER;Initial Catalog=mydb;User Id=username;Password=password;" I know I can do that programmatically. But I would like to know whether I can do that using the data source wizard so that I will be able to use Bindingsources and tableadapters.
View 4 RepliesI have to attach an excel file to a MSSQL 2005 database, using a project written in VB.NET 2005.
View 1 RepliesDoes anyone have any suggestions how I might store the contents of a RichTextBox that also includes images to a MSSQL 2005 database?I suppose a possible answer to this would be to convert the entire content of the RichTextBox to a Byte Array, and then insert the array as a varbinary(max) datatype.But how do I convert the content ?
View 1 RepliesI refreshed my data sources to include additional items from the SQL Server databases and it appears that my entire data source from my VB.NET project disappeared.I am using Entity Framework. I may have clicked on something wrong, not quite sure. Unfortunately I can't recreate the Data Source without creating a new Entity and Data Model.I can delete the entry in the App.Config file and recreated it, however things aren't quite right.Is there a way that I can recreate my Data Source from the entry that is in my App.Config file...since that appears to have remained intact.BTW, I can go to my Data Model and successfully refresh from there, however my project isn't connecting to the database so I have quite a number of errors until I can get reconnected.
View 4 RepliesI'm watching tutorials about creating Web Site and about controls.I think I added SQL Database to the project (it's not empty) properly. Suppose it has two columns: FirstName, LastName.I have TextBox1, TextBox2 and Button1 on the web site form.I enter any integer number (5, 10, 15 or whatever) into TextBox1. I want to press Button1 and get a value of 5th person (10th, 15th or whatever) from SQL Database into TextBox2.Who can help me with that? Should I read about ADO.NET and use something from there?Later I want to use VB for work with that strings.
View 2 RepliesHow to Find data using a combobox? I make a code to search or find it's work but cannot find the data..this is my code:
[code]...
but when i try using a textbox it's works.
I want to store rich text from vb.net to mssql database. My question is what will be data type in mssql to store rtf information.Also is there any free control availble to show basic buttons to conntrol formatting for rich text box like colors , fonts, etc. as i found standard rtf control in vb.net just show the text box and no way to format the text in rich text box.
View 2 Repliesfrom picture at above, i just generate all file to get filename , title and MD5 hash.. but, how can i save all data from picture (datagridview) into MSSQL server?
View 5 RepliesDim Dr2 As New OleDb.OleDbCommand
Dr2.CommandType = CommandType.Text
Dr2.CommandText = "SELECT... FROM... WHERE..."
Dim Dr1 As OleDb.OleDbDataReader
Dr1 = Dr2.ExecuteReader
The above code was originally written in VS2003 to retrieve and display data from Access 03 database, and runs without error. In VS2010, this code is throwing a "Command Text was not set for the Command Object" error and points to the last line as the source of the error.
How fast did the VB.net inserts a data in a Mssql database??
View 1 RepliesI have a problem with transfering data from MSSQL Server 2005 to Access.
I need to make a VBScript that can take out all data from one table in mssql and update one table in Access. The tables exist in both databases and looks the same, but there can be more data in the table from MSSQL Server so i need to update the table in Access with this data.
E.g. I have a table called: SMP_Alert in both database's. So i want to do something like this (dunno if that is possiable):
Set objConMSSQL = CreateObject("ADODB.Connection")
conMSSQL = "Provider=SQLNCLI;Server=127.0.0.1SMP;Database=SMP;Uid=SA; Pwd=smp;"
objConMSSQL.Open(conMSSQL)
[Code].....
Or do i need to create a recordset of the table (SMP_Alert) from MSSQL, and loop through it to transfer the data into the table in the Access database?
I have 200,000 rows data need to be inserted into MSSQL 2005 express. I have 4G memory. From the beginning, there is 2.0G used. Then, I use microsoft text driver to load text file into datagridview. Memory rise to about 2.8 GB.I start write data row by row from datagrid view. Memory usage keep rising , then OutOfMemory exception is catched.I try to use GC.Collect and for System.Data.Odbc.OdbcConnection , I also try .Dispose(). But it is no use.How can I keeing the memory within about 3.0GB for this usage ? I monitor .vhost.exe. It rise to more than 1G.
View 2 RepliesUsing Table control: how to display data from connected MSSQL?
View 2 RepliesI have an Access database and I want to view on a datagridview specific rows. For that I used the following :
CasesBindingSource.Filter =
"OfferDate Between #1/1/1997# And #12/31/1997#"
Cases is the table, OfferDate a field of the table wich is DateTime type.
When I use Between operator I get the following error :The expression contains unsupported operator 'Between'.
Modifying data with the ListView's EditItemTemplate by programmatically settings its DataSource property and calling its DataBind method. I don't have option to use data source control for ListView. All ListViews are bound with data from code-behind. So, I have to handle the Edit/Update mode of ListView manually. [Code]
View 2 RepliesI'm trying to connect a VB application (2010) to an MS Access DB by adding a data source from the data menu but I receive this error message "The connection you selected uses a local data file that is not in the current project.Would you like to copy the file to your project and modify the connection ?
If you copy the data file to your project, it will be copied to the project's output directory each time you run the application" and the options are (yes , No , Help)
If I choose Yes I will not be able to make the application 'device independent ' since it will not be copied under the bin , and if I choose No , changes won't be applied to the DB
how to use the VS 2010 IDE tools in a way the Microsofties didn't specifically intend. But since this is something I immediately tried without success.
I have defined a .NET 4.0 WPF Application project with a simple class that looks like this:
Public Class Class1
Public Property One As String = "OneString"
Public Property Two As String = "TwoString"
[Code]....
The expected result was that "OneString" would appear next to "One" and "TwoString" next to "Two" in the running window.
The question is: Why didn't this work? What will work instead? If I put bindings in a DataTemplate, it works. Blend, with its sample data stuff, implied that this should work, but it doesn't.
I have 5 combo boxes that need to show the same list of items that come from a single dataset table. I have managed to bind the datatable to the combo boxes no problem at all.. but when I run the application and select an item from one of the combo boxes all the others change to the item I selected. After some research I believe that this problem is something to do with using the one datasource so I have tried assigning the dataset datatable to 2 different variables and used them as datasources for 2 of the comboboxes but the same still happens.
A work around to this I can see is to call the same methods and SQL select statements 5 times over to get individual datasources for each combo box but this doing that sounds crazy to me. how I can get around this easily? Code snippet below shows 2 combox boxes and their datasources. I'm using VS2005, .Net 2
ComboBox1.DropDownStyle = ComboBoxStyle.DropDownList
ComboBox1.DataSource = AllergyListDataSet.Tables("ListOfAllergies")
ComboBox1.DisplayMember = "Condition"
[Code]....
can data reader be used as a data source for a grid control?
View 5 RepliesI am trying to get the webpage source code using HttpWebRequest instead of using ebbrowser. So i can use it as a string and use regular expression on that string.I have googled "HttpWebRequest" but all i found was this code which isnt working or i dont know how to use it.
VB
1. Public Shared Function GetPageAsString(ByVal address As Uri) As String
Dim request As HttpWebRequest
[code]....
I have a combo box with a data source. This box shows one column of a table and allows me to select one item.Next, I have an ordinary text LABEL that I need to put text from another column of the item selected above.I tried to set the data binding field of the label, but this grabs only the first row or data and shows the selected column. That is nice, but I can not figure out how to update the selected selected ROW when the combo box item is changed.In this case the combo box lists a bunch of inventory parts. When I select a specific part, I need the change the text in a label to show the manufacturer. (like a sub-form). This same behavior will be used in several other places, but the relationships can cascade.
View 4 Repliesi'm got this sql query code in dataset designer
SELECT pkt.fldPackageID, pkt.fldPSID, pkt.fldQuantity, pkt.fldQuantityUsed, pkt.fldRetail, pkt.fldPK, ps.fldName
FROM tblPaketRow AS pkt INNER JOIN
tblProdukDanService AS ps ON ps.fldID = pkt.fldPSID
WHERE (pkt.fldPSID = @param)
I'm trying to display the results in datagridview,i drag from the data source in vs 2008..I can't figure out to do that.I use this code to set the @param on form_load event.
Me.TblPaketRowTableAdapter.JoinTable(SalonDataSet.tblPaketRow, modCommon.s)