How to convert vb.net and sql server 2005 into .exe file the exe file can be run in the another system but it cannot be save the data. the connection string can be errored because my computer name and another computer name is different .
View 2 RepliesHow do I achieve the same in VB.NET which is so easily done in SQL Server.
Select Case(GetDate() as VarBinary(8)) --Gives the Current Time in Hex
How can I create the same string in VB.NET so that I can compare in SQL Server as such -
Select Case When GetDate()=Cast(0X00009F5E00D8DF7C As DateTime) Then 'True' Else 'False' End -- 0X00009F5E00D8DF7C Will be the value I get in VB.NET When I convert it Date.Now() To Hex
I am using memorystream to get and store images into sqlserver 2005 table image field. This process is working and I am able to display image in picture box. I need to be able to store PDF files into the same field and be able to display in a picture box.
View 2 RepliesI'm trying to make an application that edits '.dds' files. I want to be able to load the file, edit it and then save it again.
If it's not possible to load & save it then does anyone know how I could convert it to another picture format like '.png' or '.jpg'?
i want to get the safari history in VB.Net..Safari maintains its history in history.plist file.....I want to know that how to convert this file to XML format??
View 11 RepliesI need to make an E-Search engine for collage library , i can make it by using streamReader and streamWriter , but unfortunately i have to use Binary to make this project ... i've to many fields to put it on DAT file , and i've to use SPLIT to split lines and make arrays ..
what is the best way to do that ? how can i write an opened binary file on textbox and convert text to array ?
May I ask a question to you all.I have vb.net project that generate sales report from SQL Server Database.I changed SQL Server 2005 Express to SQL Server 2005 Standard Edition.
After that my program can't run properly and every time I got Time Out Expire message.
That program work properly with SQL Server 2005 Express.May I request suggestion how to fix this.
I am using a database file Database1.mdf which have a tabel called student. This Database1.mdf is simply added by using the option Add New Item in Solution Explorer. The problem is that I am to able to update the database through form and code. The code is as:
Dim conn As SqlClient.SqlConnection
Dim ada As SqlClient.SqlDataAdapter
Dim cp As SqlClient.SqlCommandBuilder
[code]....
The ds is updated at run time, but as form is closed and run again the actual database table student is not updated.I have no idea what is going on. The same code work right with Access database and SQL database but in this case it is not working. I've tried on google but not getting satisfactory answer. I've also seen a post on this site but that is about ConnectionString, not about the database update.
i need to create an application(VB.net or VBA) which will convert text file contents into excel. u the contents fromt he text file have delimiters(special characters).The condition is while converting it should remove all the delimiters and paste teh content between two delimiters in to one cell.For Eg:
Text fiel content
|WGS|123123123|[Rxxxxx~CXXXXXCCCC~ADVANCED PPPPPPPP ASSOC
Excel sheet content:
WGS 123123123 Rxxxxx CXXXXXCCCC ADVANCED PPPPPPPP ASSOC
How to import an Excel file into SQL Server 2005.
View 7 Repliesi am using asp.net and vb.net 2008 ,sql server 2005 for my web application.i want to upload files(.PDF ,.DOC, .DOCX file extenstion in to my table) i did the followin:
create table filetable(filename varchar(300),filesize int,filedata text,contentType varbinary(max))
does the data type of each column correct?
Dim con As SqlConnection
Dim cmdinsert As SqlCommand
con = New SqlConnection("server=(local); Data Source=gig;Initial Catalog=mydb;User ID=sa;Password=test")
Dim str As String
[code]....
can u drop me a line how to uplad pdf, and word files in to a table and then how to get them back?
I would like help with a script component in Visual Studio 2005 to take a text file as a source and convert it to Excel file (output). The text file uses a ~ (tilde) as the column delimiter.Also, can this be done without installing Excel on the server? Any and all suggestions are welcome. Below is sample I am having a problem with in the script component:
[Code]...
I keep getting an error stating that Excel.Application is not defined and I also get Option Strict On requires all vairable declarations to have an 'AS' clause. Can someone point me into the right direction?
I am trying to access a file using the following
CODE:
However I am getting the following error: "Object reference not set to an instance of an object."
I am trying to create an application, which in first phase will read the content of an XML file, count the products, and copy the content of the XML to a sql server database TEMP table, which i have already created. I have already created the code to read the content of the XML file and view it in a datagrid view. But i dont know how i should copy the content to the database i have created....
The code i wrote till now:
Imports System
Imports System.Xml
Public Class FrmXMLRead
[code]....
I need to copy each product (code, category, subcategory, part_no, titlos, timi, availability, anakykl, lianiki) to the TEMP table of ABC databaseHow should i proceed to copy the data to a database ABC and table TEMP?
I want to know how to connect to a remote system having some shared folder.(ex, \myservermysharedfolder).Actually, I was supposed to copy a particular file which is available in a shared location of a system. To copy that file, first i need to connect to that system with an user id and password.I know copying of file (), But not getting clear idea on how to connect to the shared folder. I have tried with System.Management class, but no use..
View 2 Replieshow to load a .bak file of database backup in sql server 2005 using vb.net 2008 windows application?
View 5 RepliesI work with vb.net I have a sqlServer database and i need to migrate to a DBF database.I know that a dbf file sctructure is a hexadecimal text file.I want to generate this file without a provider...building this file with this hexadecimal structure.
View 1 RepliesI need to read the email from the mail server that is in my intranet from my application server.
View 9 RepliesHow 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 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]...
the remote server returned an error: (503) server not available m getting this error...wen i m trying to extract email id from a webpage...
View 2 RepliesI recently upgraded the MS SQL Server installed on my personal computer from 2005 Express to 2008 Express. Problem is when I try to add an SQL database file to a project using VS 2005 I get an error message saying that the version of my database server is not supported, I must have SQL Server 2005 Beta 2 or later installed. I didn't do it yet but I'm pretty sure that when I open the other projects that I included a database file to it, I'm going to get the same error.
My question is it possible to have two SQL Servers installed on my machine? If so, is it a good idea to have two DB servers in the same machine?
Using vb.net 2005 - FtpWebRequest for ListDirectory always gets 550 error The remote server returned an error: (550) File unavailable (e.g., file not found, no access).
On both FTPListDirRequest.Method = System.Net.WebRequestMethods.Ftp.ListDirectory
FTPListDirRequest.Method = System.Net.WebRequestMethods.Ftp.ListDirectoryDetails
[Code]...
i have installed visual studio 2005 in my computer i want to create a sql server 2005 file i saw a sql server 2005 option in my installed components i want to know how to create a sql server 2005 from my visual studio 2005 it is possible or not.
View 1 Repliesi wrote a software which would work perfectly fine on vb.net with connection string: [code] but if i try and run it on a pc with sql server 2005 installed it fails to run what changes do i need to do to make it run
View 5 RepliesI had made a project in VB.NET 2005 with SQL SERVER 2005 used as database. Now i want to make a setup of this project but i am unable to integrate sqldatabase and .net framework in this setup project. Is there any way to do this. Because it is assumed that the client does not have .NET Framework installed nor he has SQL Server on his system and the worst condition would be he does not have even internet connection from where these two setups can be downloaded if we give the condition for downloading these programs from the net if the client does not have these programs installed on his machine.
View 2 RepliesWhat is the best way to convert an int (bit value from SQL Server) to a Boolean value in vb.net? I am currently using Cbool, but believe this is now obsolete.
View 3 RepliesI am having trouble getting server variables remotely in VB .Net I need to basically mimic this PHP Function.
function showvar($string)
{
if(isset($_SERVER[$string]))
[Code]....
Atleast show me how to return one variable.
I have a field in the database that is XML because it represents a class that is used in C#/VB.Net. Problem is after the initial manipulation most, but not all, of themanipulation is done in SQL Server. This means that the XML field is converted on the fly.As we are getting more fields and more records, this operation is getting slow. I think the slow down is the converting all of those fields to other data types.So to speed it up I was thinking of a couple of ways:Have a set of tables that represent the different pieces of the XML data. I would make these tables read only using a trigger on Insert/Update that would reject any changes. My 'main' table with the XML in it when it updates the XML would turn off the triggers, update the tables with the new values then turn the triggers back on.
The only real reason we use the XML is because it's really easy to convert it to the class in C#/VB.Net. But I'm getting the point where I may end up writing a routine that will take all the bits and pieces and convert it to a class and also a function to go the other way (class -> tables).
I have an array list on my server side that i want to use on my client side as an array how can i do this.
View 1 Replies