|
open docx file
Hi all
I'm trying to open a docx file after upload it to Sqlserver in a binary field.
I'm using this code:
Dim dtFoto As New DataTable
dtFoto = myclasses.get_Doc(id_foto).Tables(0)
If dtFoto.Rows.Count > 0 Then
Dim image_byte() As Byte
image_byte = dtFoto.Rows(0)("MyFile")
Response.AddHeader("Content-disposition", "attachment; filena...
|
1 |
12/30/2008 5:34:10 PM |
|
|
Database Update Problem
I am using VB Express 2008 with Sql Server. for the first time (new to
programing) MS is playing a sick joke or What! The save or update to
database table won't work. I have researched the glitch on Google and done
the suggested settings to the "Copy to Output Directory" and set it to Copy
if newer. Still when I open the Table to Show Data Table theres nothing
there. I have spent 4 days ...
|
5 |
12/30/2008 12:25:24 AM |
|
|
Probem on vb 2008 with WindowsXP-64 in connecting access database
I do coding VB 2008 on windows XP-64 amd occure problem with connecting
database to Access 2003 my friends can excute this code but not with my
computer
This is my code
Option Explicit On
Option Strict On
Imports System.Data
Imports System.Data.OleDb
Imports System.Text
Public Class Form1
Dim Conn As New OleDbConnection()
Private Sub Form1_Load(ByVal sender As System.Obj...
|
1 |
12/17/2008 6:46:26 AM |
|
|
Data Binding to a password protected Access database?
Hello all,
I have been searching on the net for a
solution for days and have tried many different ways to no avail..:(
Here is my project using VB 2008...
I have an MS Access database with a password, a Main form with a
BindingNavigator, a Bbindingsource, a DataViewGrid, and a Login form with
two textboxes..
I have connected all except the login form. The project works well when I
s...
|
1 |
12/4/2008 8:03:05 PM |
|
|
vb.net 2008 and CE 3.5 - Table Does Not Exist error
I am just starting a project that will use a SQL Server Compact db on the
desktop. I am trying to write my data access classes and getting an odd
error.
This code:
Sub BindGridCE_Fails()
Dim cx As SqlCeConnection
Try
cx = New SqlCeConnection("Data Source = croe2db.sdf")
cx.Open()
Dim cm As SqlCeCommand = cx.CreateCommand()
cm.CommandText = "sel...
|
7 |
12/3/2008 2:30:03 PM |
|
|
OLE Dbase connection
VS2008 pro
I'm trying to connect to an old Dbase table using either OLEDB or ODBCDb.
I can connect to c:\companydata\sbd\Customer.dbf from either Excel or
DBWorkbench (a database utility program), so I'm pretty sure everything is
ok with the table itself.
The connection opens ok, but when I get to "da.Fill(ds,"Customer")" I fail
with a message:
System.Data.OleDb.OleDbException: T...
|
3 |
12/2/2008 10:12:14 AM |
|
|
DataTable.Select() bug?
I'm pretty sure I've found a bug in DataTable.Select(). I'm running
Visual Studio 2008.
I have an XML file with the following structure:
<schedules>
<schedule>
<userid>123</userid>
<entrypointid>12345678</entrypointid>
<sunday>FFFFFF</sunday>
<monday>FFFFFF</monday>
<tuesday>FFFFFF<...
|
1 |
11/26/2008 7:10:00 PM |
|
|
VB - ACCESS UPDATE QUERY THROWS ERROR
strQuery = "Update ArtCenter set HorizontalCenter=@HorizontalCenter,
VerticalCenter=@VerticalCenter"
dbCommand = db.GetSqlStringCommand(strQuery)
db.AddInParameter(dbCommand, "@ImageName", DbType.String,
ImageName)
db.AddInParameter(dbCommand, "@HorizontalCenter", DbType.Int32,
HorizontalCenter)
db.AddInParameter(dbCommand, "@VerticalCenter", DbType.Int32,
Ve...
|
2 |
11/25/2008 7:44:51 PM |
|
|
Connecting to remote MySQL database
Is it possible to connect to a remote MySQL database using an
OleDbConnection?
If so what is the connection string syntax?
I tried this:
Provider=MySQLProv;Location=remote-server;Data Source=database-name;User
Id=user-name;Password=xxxx;
but I get an error saying that the MySQL provider is not registered.
Any help appreciated,
TIA
Phil.
...
|
12 |
11/25/2008 9:35:02 AM |
|
|
Refreshing the data.
I am very new to VB. I am creating a vb program that connects to a Microsoft
SQL db and displays the data. Is there a way to refresh the data every 10
seconds within the program without having to exit and re open the application?
...
|
7 |
11/24/2008 7:29:43 PM |
|
|
Problem inserting new records into SQL Server 2005 table
I am usins VB in VS2008, with SQL Server 2005. I have a stored
procedure that inserts a record into a table, and returns, as an
output parameter the ID that got assigned to the new record (in
autoincrementing integer field). So, I'm not passing in an ID to
assign...just letting SQL Server assign it, incrementally, and then
pass it back to me.
Well, this has worked just great for a long tim...
|
2 |
11/20/2008 3:09:28 PM |
|
|
FileMaker Server 9 Connection string?
I guess this would be a fairly common question in this forum...
I would like to write a VB.NET program that accesses a FileMaker 9 Server
database.
I think the ODBC client is the way to go, but I am having trouble working
out the connection string. Can anyone help?
--
David Streeter
Synchrotech Software
Sydney Australia...
|
2 |
11/17/2008 2:02:04 AM |
|
|
how to import raw data to SQL or MS Access
GOOD200810122315 DC SAN FRAN => from notepad with alot more
rows
=>
Type Year Month Day Hr Game Place
GOOD 2008 10 12 2315 DC SAN FRAN
How do i make the raw data from notepad into the expected result above
in SQL or MS Access? By using columns?
Thanks in advance....
|
5 |
10/31/2008 12:43:15 AM |
|
|
Moving through a database
Hi all,
Based on some help from this forum, I have been able to convert some of my
VB6 apps to .net. My biggest problem (so far) has been in data access. I am
currently connecting to our files as follows:
Public as400Con As New OleDb.OleDbConnection
Public as400Command As OleDb.OleDbCommand
Public as400dr As OleDb.OleDbDataReader
Public FileQuery As String
F...
|
2 |
10/29/2008 5:39:07 PM |
|
|
Help with DSN Connection
Hi all,
I am currently trying to re-write a VB6 application in vb .net. The VB6 app
connects to our iSeries(AS/400) as follows:
Public con400 As ADODB.Connection
Set con400 = New ADODB.Connection
con400.Open "DSN=as400;UID=pcuser;PWD=pcuser;"
Set rs400 = New ADODB.Recordset
rs400.Open inSQL, con400, adOpenDynamic, adLockOptimistic
This is simple enough for even me to ...
|
3 |
10/28/2008 6:07:01 PM |
|
|
Switching between Development and live
Hello,
I have an app where I am switching between development mode and live mode,
phyically seperate networks. What I would like to try and figure out is,
how can I have my app know which db server to hit? Right now, I just change
the connection string information that I have stored in the Settings....
These are SQL 2005 databases and the only difference is the Data Source.
Thanks,
...
|
2 |
10/27/2008 5:55:30 PM |
|
|
please help: an error in connecting to SQL server
please it is urgent,
i have got this error when i connect to Microsoft SQl Server 2005
An error has occurred while establishing a connection to the server. When
connecting to SQL Server, this failure may be caused by the fact that under
the default settings SQL Server does not allow remote connections. (provider:
Named Pipes Provider, error: 40 - Could not open a connection to SQL Serve...
|
2 |
10/27/2008 5:52:11 PM |
|
|
VB2005 Datacontrols and Autonumbering Row
Hi,
I'm starting a new project and wanted to learn to work with the datacontrols
in VB2005.
I have a connection to a database using a dataset and a tableadapter,
the dataset is connected to a Bindingsource which I use as datasource in a
grid.
With the wizard I added the update, select, delete and insert commands to
the dataset's tableadapter.
Everything works realy fine, at startup I f...
|
1 |
10/23/2008 7:35:50 AM |
|
|
Connecting to remote ORACLE DB?
Hi all.
I am writen an app that needs to connect to remote Oracle DB via local
network.
I found out that in vb.net it can be done using objects of OracleClient
namespace. But I found no usefull examples on how to do this.
The DB is located on server '\\QServer', the DB name is "Q77", username is
`kevin`, password is `mypass`.
So, how to make a correct connection string?
Thanks ...
|
3 |
10/15/2008 4:55:02 PM |
|
|
XSD validation in VB .NET
Hi,
I'm doing validation of a xml file with a xsd schema and it works
fine.
I get validation errors in the form:
«Message:{0} The 'NAM' attribute has an invalid value according to its
data type. An error occurred at file:///A:/myfile.xml, (526, 12).»
I can isolate line and column using the args.Exception.LineNumber and
args.Exception.LinePosition properties.
Unfortunately, there ...
|
1 |
6/28/2007 3:41:38 PM |
|
|
Sharepoint List - vb.net
I have a Windows Forms Vb.net program written in vstudio2005 that I would
like to have access a MOSS (Microsoft Office Sharepoint Server 2007) List,
and have the ability to add records to that list. Additionally it would be
nice to loop through existing MOSS list rows (records).
...
|
1 |
6/28/2007 9:40:56 AM |
|
|
vb.net add records to MOSS 2007 List
I have a Windows Forms Vb.net program written in vstudio2005 that I would
like to have access a MOSS (Microsoft Office Sharepoint Server 2007) List,
and have the ability to add records to that list. Additionally it would be
nice to loop through existing MOSS list rows (records).
If anyone from Microsoft is reading this... it sure would be nice if VStudio
could view a MOSS List as a Dat...
|
2 |
6/27/2007 1:10:58 PM |
|
|
SQL Server application - User instance?
Hi
I'm about to start working on a simple SQL server based application. Since
I'm often on the road I have to do development both from my workstation on
the office, and from my laptop. What's the easiest way to develop towards a
SQL server? I was thinking about configuring a user instance on SQL server
express during the development phase, so it would be easier to move both
sourcecode...
|
2 |
6/26/2007 4:07:22 PM |
|
|
Run a query in Access db
I'm a vb.net newbie.
I have an query that is entirely within an Access database. It's a
simple update query - "usp_Append_tbl_RefNos". It works in Access,
How can I run that query from a vb .net program? I have an vb app that
does update another Access table using a stored procedure but it updates
fields with info from a file.
I've tried the code below and I get an error on the Exe...
|
7 |
6/25/2007 12:48:46 PM |
|
|
BindingNavigator event when BindingSource changes
VS 2005
I have some custom business objects (BindingList(of T)) connected through
BindingSources to a BindingNavigator.
When the user moves focus the BindingSource of the navigator can be changed
to reflect the new BindingSource.
I want to trap an event for this change (BindingSourceChanged), but I can't
find anything.
The BindingContext event for the BindingNavigator is fired wh...
|
1 |
6/24/2007 1:44:16 PM |