I'm new to vb but have some experience with sql server. I'm trying to learn to build sql server 2005 front end apps with vb.net 2008. I would like to create a login form for my startup form an...
Good Day
Experts:
How can I replace double quotes(") in a String? I am using VB.net.
ie. This " is double quotes --> This is double quotes
Hello Experts,
I am fairly new to VB.net...and seem to have come to a bit of a problem....
I am adding datareader values into an array list then i want to check if a certain string value e...
Hello Experts,
I'm running a SQL Report inside a VB.Net windows application through MicrosoftReportViewer.
The report is running smoothly using a fixed query, but whenever I change the q...
Good Day
Experts:
How can I test for Null in a Date defined field? When I look at the newly added Date defined field in Visual Studio Manager it says NULL. In my VB.net program I want ...
Hey guys,
I just installed VB.NET 2005 and converted a .net 2003 project over so that I could use the datagridview to display my datatable instead of the datagrid in 2003. I wanted to do this...
Select a range of cells, delete the range, shift the remaining cells up, then select a new range of "old range +1". Run a loop until a specified row is reached.
I need to get the page source from a web browser that is running. I need to get the page source every time it changes (like when the user navigates to a new page). My first solution was to ju...
Hi,
How to get list of database of SQL SERVER 2005 EXPRESS.
In SQL 7, we could we use "SELECT name
FROM master.dbo.sysdatabases
WHERE name NOT IN ('master','model','msdb','tempdb') ...
I build a routine which makes the combobox for the popupmenu and it indeed pops up on right clicking the associated textbox. The problem is that the box only closes upon clicking elsewhere. ...
Hello I very new ath VB.Net I've created a Login database using MS Access. I need to add new users to the database. I've created the input form and have was able to connect to database. here i...
Hey all,
I've a problem to compare two text files and to get the differences of the files....
Until now it is just possible to get an info if "textfile1" equals "textfile2" ....
I want to g...
I want my setup project to add folder "C:\MyFolderTest" when the setup file is run. has anyone got any ideas? Please note I am using VS 2008 and cant seem to find out how to do it.
hi,
I am new to vb.net. I have an excel file which have different sheets. For each sheet I have to retrieve all values which are not null and store them in mysql database after filling in...
How may I convert the formatted date which is a string:
Format(Now, "dd/MM/yyyy HH:mm")
into a valid DateTime?
Thanks!
I'm developing a web site in ASP.NET with VB.NET. I'm drawing a blank on how to properly convert the current time now() into proper datetime format to Insert or Update a varchar field in SQL ...
HI all,
I created a folder tree as code attachment. When I open form, it take a long time.
- How can I speed up the time to open form.
- How can I move to my selected node (Ex: C:\Test) ...
I am having some trouble with the following.
I have a dataset that I am adding rows to by:
rowNew = dt.NewRow()
rowNew("FieldName") = "Blue"
dt.Rows...
I need a dropdown listbox (combobox) that will allow multiple items to be selected, either through checkboxes or highlighting one or more items. I believe the web dropdown list box works this...
Good Day
Experts:
I have a need to get the value between double quotes. Here are some examples:
1) "1" ---> 1
2)"12" --->12
3)"123" --->123
I would like to do this all in one line...
I have an access 2007 table that I want to use as datasource for Crystal reports.
The data is received as a .csv file that I want to import into the access table. Want to delete old records b...
I know there must be an easier way to calculate difference between dates or if one date is less than another. Problem is I am trying to calculate a date in at text box against Date.Now.
Th...
For navigation I append a querystring to the URL:
http://www.MyWebSite.com/new_page.aspx?id=71
In the Page_Load event I call a function to get the id:
Function GetCategoryID()
Dim c...
Good Day
Experts:
I have tried for some time here to get the filename of a file that is in a directory.
First I use the following to ensure there is only one file in the directory(pe...
Hi,
We have an old solution for document management that opens Word files from the application, and disables the save buttons so that the document cannot be saved through Word when it is open...
