Is it possible to add a Datatable to the project, add columns to it, and then add rows with data in it that i can use in my project?
I need to store some data in my program and i thought the best way was a datatable, but i also need to add some data that exists in it when i build my pogram.
We have a small app that was converted from 2003 to 2005 to 2008. All was fine until i needed to alter the sql associated with a datatable. When i tried to 'configure' the datatable by right-clicking & selecting 'configure', the configure option was not activated. It was decided that what i needed to do was create a new web application in 2008, add the datasets within 2008, then either import &/or cut & paste the old forms & other pices into the new project. However, when i go to configure my new datatable in my new dataset, i have the same problem... configure option is not activated. What can i do to configure these datatables?
View 1 RepliesI am working on a project that takes an xml schema and xml data files and places them into a DataTable, the 2 files are generated from a working table that i have written to disk. I wish to load these 2 files into a DataTable. Here is What i have
vb.net
Friend Function CreateTable(ByVal tableName As String) As Boolean
Dim table As New DataTable(tableName)
table.ReadXmlSchema(tableName & ".xsd")
[code]....
this however produces the following error on line 3
Quote:
System.ArgumentException was unhandled Message=DataTable 'get_item_list' does not match to any DataTable in source.
get_item_list is the parameter passed into this function (tableName)
I have a datatable that has a resource in one field and hours used in another, it looks like this -
Resource Hours Used
Manager 1
Accountant 1
Field Staff 2
Accountant 3
Manager 4
Manager 1
Administrator 6
Field Staff 4
Manager 0.5
Administrator 1
What I want to do is be able to create a summary of the data table above that groups multiple occurrences of a resource and adds up the hours used for that resource, creating a summary that looks like this -
Resource Hours Used
Manager 6.5
Accountant 4
Field Staff 6
Administrator 7
I have created a simple project where I have two forms, one a data entry form where a client name, address, city, state and zip are entered into textboxes. Then, the user clicks a button to add all this data to the datatable via a newrow. The second form includes a datagridview to show the datatable. However, I cannot get the code below to work to update the datatable. I have a button to click to check to see if the data is entered and it returns an error that no row exists.
View 2 RepliesI have original dataTable as [code].....
But I want to edit this table so as when Project P1 recieves some Units then in the next entry of Project P1 the Units ( Actual) Should be equal to Units (Actual) - Units Recieved. after editing the datatable it should be something like this [code].....
Has anyone else had issues with Visual Basic 2010?My visual basic program has been running fine for months but recently every time I try and load a project (any project) the program freezes, then I have to close it down and reload, every time I load Visual basic for the second time I get the following error:
HTML
An error was encountered while opening associated documents the last time this solution was loaded. Document load is being skipped during this solution load in order to avoid that error.Plus when trying to run a project in debug it takes ages to load (around 5 minutes) this has only started happening recently, projects were loading in seconds.
A colleague has written a useful tool. He wrote it as a standalone tool, but it works even better as an includable dll, though it needs a bit of other functionality for it to be a really good drop-in component. What I am wondering is whether a project can be compiled as both an exe and as a dll?
There are alternatives, such as having a dll version and an exe version, since the dll version needs to include a few different methods that the exe version doesn't need, but this alternative sucks, since it would mean changing two sets of code.
Another alternative is to build the dll, then change the exe to be a project that references the dll....and does nothing other than calling one method in the dll. That kind of sucks, too, but not as bad.
I want to be able to use his module in some of my programs, and it really should be built as a component rather than a standalone app, but I want to know whether there are other options that I haven't considered.
I'd like to set the IP address, Subnet mask, gateway and DNS on a windows XP machine though a VB form. I have 2 methods for this. Do everything though VB functions or set environment variables on the machine. I've created a batch file that just uses the netsh command. That works but I'd like the better interface.
View 3 RepliesI'm using the following code successfully with HTTP but I would like to use SSL. When I change the endpoint address to https and modify the security mode to Transport in the web.config I get the error : "The provided URI scheme 'https' is invalid; expected 'http'."
This is a VB.net test form.
Imports WindowsApplication1.WCFService
Imports System.ServiceModel
Public Class Form1
[Code].....
i've trin' to setup in my server, a connection to my Microsoft sql server, in order to develop an web application using this type of tech. Of course, VB.Net. after tryin to research an aspx.net here in msdn, i havent found yet anything.
I have my connection string "on", pointed to Windows Authentication. I've changed to A new login created in Microsoft SQL Management Studio (sql Server 2008), such as a user guest.testing locally, the asp.net develop server is up and running because it uses my domain credentials.If testing by access in my website, like a guest, it throws an execption pointing to a Login Failed. I've tried so, with my own credentials, and not succeded.
i need to set up membership for my first website, as i was told i have followed the following steps:1. website --> ASP .NET configuration2. select teh security tab If my admin tool works fine , then it should display the following
1. users - allows to create and manage users2. Role - enable roles3. Access rules - create and manage access rules But my security tab doesnt display those otpions instead it displays an error as:
Code:"There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store.
The following message may help in diagnosing the problem: An error occurred during the execution of the SQL file 'InstallCommon.sql'. The SQL error number is 1802 and the SqlException message is: CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Cannot create file 'C:VBWEBSITESMEMBERSHIP1APP_DATAASPNETDB_TMP.MDF' because it already exists. Change the file path or the file name, and retry the operation. Creating the ASPNETDB_dbd9891837cf479eab2e5e8a5e483986 database... "
Then i followed it's instructions, clicked on choose datastore and configured the provider, according to the web admin tool the "single provider" passed the test.
Then i closed the adin tool and restarted it. but still the above error occurs. How can i fix this? PS: this happens even when i disable the firewall!
how to configure UDL in windows 7?.im using SQL Server Express Management Studio 2005.
View 1 RepliesCan we configure remoting for the LAN? I studied it halfway but I realised that its for web, but I think it can be possible for LAN too.
View 2 Repliesi made a browser with vb.net 08 pro i made index.html file as i open my browser it should automatically open the index.html where should i keep the index.html file and how to configure the code?
View 1 RepliesI have a VB.NET project in Visual Studio 2010 for an Excel Add-In.I use the "My" namespace,and in general it seems that the "My Project" folder contains configuration information about the project.My problem is that I need to change the name of this folder, because my version manager system won't accept spaces in file or folder names.Edit: There is a hacky way to do it, by renaming the folder and changing all references in the .vbproj file.However, the may work for a command line generation, but it won't work the next time the project will be opened in Visual Studio. The IDE will create a new "My Project" folder, and complain that it can't find the settings in it.
View 3 RepliesImports System.Net.Mail
Partial Class ContactUs
Inherits System.Web.UI.Page
[Code].....
what is wrong with my smtp settings? i cant send emails.
How to configure the proxy for a webbrowser (vb.net)
server has proxy and should login to access internet.
i have a DGV that im filling like so:
Dim SQLconnect As New SqlConnection("server=DEVSERVERDEVSQL;" & _
"integrated security=sspi;database=WDA_SQL")
Dim SQLqry As New SqlCommand("SELECT CustomerID, ContactTitle, ContactFirstName, ContactLastName, ActionDate, OpenedBy, LastAccess, Lock FROM CollectionsVIEW WHERE (FileLocal = 'Coll-DL1 Sent') AND (Lock = '1')", SQLconnect)
[code]....
I need to holds the common settings for all of the apps ona server (UNC path). Previously I used an ini file on the server and the application was told to look there via a command switch.
I understand that I'm trying to use .net in an old fashioned way by not packaging it for web update & delivery but that's a contraint of the architecture I need to work with.
Is there any way to force my application to use the application.exe.config file from a set location rather than the user data area that .net automatically writes it to? Even if not on a server path, then in the application directory where we can push update it?
I'm not sure how to make it work, anything with sendkeys have errors in it.
View 6 RepliesHow can I configure Source Control to work with VS.NET
View 2 RepliesHow to use Datagrid in VB.net. I am about to configure the MySQL Records to the VB.net form having DataGrid. I am using Microsoft Visual Studio 2005 ; Database- MySQL 5.1; Form1 having DataGrid in it. Step by Step procedure to get MySQL Database output in the VB.net DataGrid from beginning to end?
View 1 Replieshow to configure the app.config file in vb.net, especially when I want to set up the smtpmail.smtpserver via it?
View 2 RepliesI have just downloaded SQL Server 2005 express edition from here:To be used as a database for a vb.net program. But I'm confused in using sql server. I do not know where to start from here:If not, where could I create the ms sql database? I'm a beginner and I want to learn.
View 1 RepliesI am building an app that has a number of buttons that will essentially be loading forms into panels.Which button loads which for needs to be user configurable and I am trying to come up with an elegant solution to this.I can hold the user Config and have it load into a datatable; e.g.:
Form Control
Visible Text
Function
[code].....
How do I get the button to pass the configure Form to the Sub
Private Sub btnF13_Click(byVal Sender.Object, ByVal e As System.EventArgs) Handles btnF13.Click
LoadForm(....some sort of lookup that passes back a Form Object?....)
End Sub
I have a custom application I am developing in vba. I have written all the code and the only thing I am confused about is how to configure a button to actually "start" or "run" the program. On the form on the user side, the user will type in an item number, then a button will be pushed that brings up a bunch of fields and textboxes on a new small form for the user to enter, The window displays the default values and will update/save new or updated fields and insert it into the database.
The button is designed in microsoft-gp but I have to manually code it to run the program. Right now, when I click the button, the window pops up, but no information is displayed in the textboxes nor are the combobox values being displayed.
Private rs As Recordset
Public Sub Main()
DisplayWindow
'Item Number is the primary field for pulling data
[code]....
When I run these two methods in vba, the information displays on the form and works 100% Now I have to code the button on the original form so this is what I have ; Test = name of the button
Private Sub Test_Changed()
frmItemProfile.Show
End Sub
How can I code the button to run the program properly?
The situation: when i build my project (or publish) Visual Basic 2010 makes and exe and a couple ddl files. when i run the project with the .exe and the other files the program works perfectly.
My problem: I want to share it with friends and it is just a verry little program ( a n internet radio) so i want it to be 1 .exe with out any other instalation needed so i can easly share it to anyone who wants it. when i make an even smaller program and Debud->build it, it is only 1 exe and no instalation needed. so is there a way to make my program to 1 exe only?
well until a few day ago. I don't know what I have introduced to cause the problem but now, whenever I load the project, VS 2010 (SP1) crahes. If I delete the project's suo file, the project loads (really quickly) and all is well until I exitVS 2010. When I re-run it and try to load the project, it crashes again unless I delete the suo file.The program can be built for x64 and x86. Now, when I reload the project (after deleting the suo file), it comes up in Debug - Any CPU mode. I can change from Debug to Release and from Any CPU to x86 but if I try and change from x86 to x64, VS 2010 crashes.This is not always the case though. If I build the x86 version and then switch to x64, all is well and I can build the x64 version. Obviously, there's something wonky going on.
View 7 RepliesHow do I get rid of the configure icon shown in attached screenshot It opens up the windows taskbar area icon configure window where you config all the
icons shown in the taskbar. Cannot find any property to disable this.
What is this called so I can google for this ? Nothing on msdn.
