473,372 Members | 1,047 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,372 software developers and data experts.

Another SQL vs. Access

Hi All,

As you know, I've made the switch from Access/Jet to MSDE 2K. And I'm now
encountering my first little problem. I have some pictureboxes that display
images from the DB. For each picturebox, I have some buttons (Add/Change
Image, Rotate Image, Delete Image) and a context menu (Copy/Paste, Open,
Edit, and Preview). For open, Edit, and Preview, I'm creating a temporary
file on disk, then writing the file back to the DB and deleting it once the
user is finished with it. this is how I'm creating the temp file:

Dim conn As OLEDBConnection = New OLEDBConnection
conn.ConnectionString = XConn.ConnectionString
If conn.State <> ConnectionState.Open Then
conn.Open()
End If

Dim cmd As OLEDBCommand = New OLEDBCommand(sql, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Try
Dim reader As OLEDBDataReader =
cmd.ExecuteReader(CommandBehavior.SequentialAccess )
reader.Read()
fs = New FileStream(pbfile, FileMode.OpenOrCreate,
FileAccess.Write)
bw = New BinaryWriter(fs)
startIndex = 0
retval = reader.GetBytes(0, 0, outbyte, 0, bufferSize)
bw.Write(outbyte)
bw.Flush()
bw.Close()
fs.Close()
reader.Close()
If conn.State = ConnectionState.Open Then
conn.Close()
conn.Dispose()
End If

When I was using OLE to connect to the JetDB:

If a user pasted an image into a picturebox, then immediately tried to open,
edit, or preview it, an exception was thrown by the OLEDBDataReader,
because, since an update wasn't done after the paste, the image didn't exist
in the DB. I was catching this exception and telling the user that the image
had to be saved before any further actions could be taken with the image.

Upon switching to MSDE 2K:

I switched from using the OLEDBDataReader to using the SQLDataReader (Just
replace the OLEDB stuff above with SQL stuff). Under the same circumstances,
an exception is not thrown. I just get an empty temp file.

What I don't know is this: is it a difference in the reader or in the DB? My
guess is that it's a difference in the DBs, specifically something to do
with how an empty cell is represented. Using Jet, the empty cell was
represented with a DBNull, which caused the reader to throw an exception.
Does an SQL DB use DBNull? If not, any ideas on how to fix this?

TIA
Lee
Nov 21 '05 #1
6 1274
Hi,

Here is a quick example of how to display an image saved in a
database. Loads the northwind databases category names into a listbox
(listbox1) and displays the image in a picture box (picturebox1).

Dim ds As DataSet

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Dim strConn As String

Dim conn As SqlClient.SqlConnection

Dim daCustomer As SqlClient.SqlDataAdapter

ds = New DataSet

' strConn = "Provider = Microsoft.Jet.OLEDB.4.0;"

'strConn &= "Data Source = Northwind.mdb;"

strConn = "Server = " + Environment.MachineName + "\VSdotNet;"

strConn &= "Database = NorthWind;"

strConn &= "Integrated Security = SSPI;"

conn = New SqlClient.SqlConnection(strConn)

daCustomer = New SqlClient.SqlDataAdapter("Select * from Categories", conn)

ds = New DataSet

daCustomer.Fill(ds, "Categories")

ListBox1.DataSource = ds.Tables("Categories")

ListBox1.DisplayMember = "CategoryName"

End Sub

Private Sub ListBox1_SelectedValueChanged(ByVal sender As Object, ByVal e As
System.EventArgs) Handles ListBox1.SelectedValueChanged

Dim dr As DataRow = ds.Tables("Categories").Rows(ListBox1.SelectedInde x)

Dim ms As New System.IO.MemoryStream

Dim bm As Bitmap

Dim arData() As Byte = dr.Item("Picture")

ms.Write(arData, 78, arData.Length - 78)

bm = New Bitmap(ms)

PictureBox1.Image = bm

End Sub

Ken

-----------------
"lgbjr" <lg***@online.nospam> wrote in message
news:ul**************@tk2msftngp13.phx.gbl...
Hi All,

As you know, I've made the switch from Access/Jet to MSDE 2K. And I'm now
encountering my first little problem. I have some pictureboxes that display
images from the DB. For each picturebox, I have some buttons (Add/Change
Image, Rotate Image, Delete Image) and a context menu (Copy/Paste, Open,
Edit, and Preview). For open, Edit, and Preview, I'm creating a temporary
file on disk, then writing the file back to the DB and deleting it once the
user is finished with it. this is how I'm creating the temp file:

Dim conn As OLEDBConnection = New OLEDBConnection
conn.ConnectionString = XConn.ConnectionString
If conn.State <> ConnectionState.Open Then
conn.Open()
End If

Dim cmd As OLEDBCommand = New OLEDBCommand(sql, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Try
Dim reader As OLEDBDataReader =
cmd.ExecuteReader(CommandBehavior.SequentialAccess )
reader.Read()
fs = New FileStream(pbfile, FileMode.OpenOrCreate,
FileAccess.Write)
bw = New BinaryWriter(fs)
startIndex = 0
retval = reader.GetBytes(0, 0, outbyte, 0, bufferSize)
bw.Write(outbyte)
bw.Flush()
bw.Close()
fs.Close()
reader.Close()
If conn.State = ConnectionState.Open Then
conn.Close()
conn.Dispose()
End If

When I was using OLE to connect to the JetDB:

If a user pasted an image into a picturebox, then immediately tried to open,
edit, or preview it, an exception was thrown by the OLEDBDataReader,
because, since an update wasn't done after the paste, the image didn't exist
in the DB. I was catching this exception and telling the user that the image
had to be saved before any further actions could be taken with the image.

Upon switching to MSDE 2K:

I switched from using the OLEDBDataReader to using the SQLDataReader (Just
replace the OLEDB stuff above with SQL stuff). Under the same circumstances,
an exception is not thrown. I just get an empty temp file.

What I don't know is this: is it a difference in the reader or in the DB? My
guess is that it's a difference in the DBs, specifically something to do
with how an empty cell is represented. Using Jet, the empty cell was
represented with a DBNull, which caused the reader to throw an exception.
Does an SQL DB use DBNull? If not, any ideas on how to fix this?

TIA
Lee

Nov 21 '05 #2
Lee,

Do you know this dataset sample that I made for handling images?

This is one of the messages where it is in. Have a look. It handles easier
in my opinion than the datareader. (for what I have as well samples)
http://groups-beta.google.com/group/...75e8834d?hl=en

I hope this helps,

Cor
Nov 21 '05 #3
Hi Guys,

thanks for the replies, but maybe I wasn't clear on the exact problem. I
don't have any problem storing a picture from a picturebox in the DB, and I
don't have any problem showing a picture from the DB in a picturebox. Also,
I don't have any problem extracting a picture from the DB and saving
directly to a disk file. The problem is this:

A user adds a picture to an empty picturebox, but doesn't click save (Update
the DB).

If he then right-clicks on the picture and chooses to open, edit, or preview
the picture, the code goes to the DB to retrieve the picture and write it to
a temp disk file (see code in original post), which is then opened in
whatever program the registry says to open it in for the particular command
selected (open, edit, or preview).

Using the OLEDBDataReader and the JetDB, if the user does this, the reader
throws an exception, which I catch and tell the user he has to update the DB
before doing anything with the picture.

Using the SQLDataReader and MSDE 2K, the exception is not thrown, an empty
file is written to disk, which is then opened by whatever program, but of
course, the picture isn't there ('cause it wasn't in the DB).

As a side note, the context menu items are disabled (except for Paste) if
the Picturebox is empty. Once the user adds or pastes a picture into the
picturebox, all of the menu features are enabled.

So, the main question is why doesn't the SQLDataReader / MSDE 2K throw the
same exception as the OLEDBDataReader / JetDB when trying to read an empty
cell?

If I can understand why they act differently, it would give me some insight
as to the best fix (I know there are several ways to fix this, but
understanding why it happens should lead to the best fix).

TIA,
Lee
"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:e8**************@TK2MSFTNGP09.phx.gbl...
Hi,

Here is a quick example of how to display an image saved in a
database. Loads the northwind databases category names into a listbox
(listbox1) and displays the image in a picture box (picturebox1).

Dim ds As DataSet

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles MyBase.Load

Dim strConn As String

Dim conn As SqlClient.SqlConnection

Dim daCustomer As SqlClient.SqlDataAdapter

ds = New DataSet

' strConn = "Provider = Microsoft.Jet.OLEDB.4.0;"

'strConn &= "Data Source = Northwind.mdb;"

strConn = "Server = " + Environment.MachineName + "\VSdotNet;"

strConn &= "Database = NorthWind;"

strConn &= "Integrated Security = SSPI;"

conn = New SqlClient.SqlConnection(strConn)

daCustomer = New SqlClient.SqlDataAdapter("Select * from Categories",
conn)

ds = New DataSet

daCustomer.Fill(ds, "Categories")

ListBox1.DataSource = ds.Tables("Categories")

ListBox1.DisplayMember = "CategoryName"

End Sub

Private Sub ListBox1_SelectedValueChanged(ByVal sender As Object, ByVal e
As
System.EventArgs) Handles ListBox1.SelectedValueChanged

Dim dr As DataRow = ds.Tables("Categories").Rows(ListBox1.SelectedInde x)

Dim ms As New System.IO.MemoryStream

Dim bm As Bitmap

Dim arData() As Byte = dr.Item("Picture")

ms.Write(arData, 78, arData.Length - 78)

bm = New Bitmap(ms)

PictureBox1.Image = bm

End Sub

Ken

-----------------
"lgbjr" <lg***@online.nospam> wrote in message
news:ul**************@tk2msftngp13.phx.gbl...
Hi All,

As you know, I've made the switch from Access/Jet to MSDE 2K. And I'm now
encountering my first little problem. I have some pictureboxes that
display
images from the DB. For each picturebox, I have some buttons (Add/Change
Image, Rotate Image, Delete Image) and a context menu (Copy/Paste, Open,
Edit, and Preview). For open, Edit, and Preview, I'm creating a temporary
file on disk, then writing the file back to the DB and deleting it once
the
user is finished with it. this is how I'm creating the temp file:

Dim conn As OLEDBConnection = New OLEDBConnection
conn.ConnectionString = XConn.ConnectionString
If conn.State <> ConnectionState.Open Then
conn.Open()
End If

Dim cmd As OLEDBCommand = New OLEDBCommand(sql, conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Try
Dim reader As OLEDBDataReader =
cmd.ExecuteReader(CommandBehavior.SequentialAccess )
reader.Read()
fs = New FileStream(pbfile, FileMode.OpenOrCreate,
FileAccess.Write)
bw = New BinaryWriter(fs)
startIndex = 0
retval = reader.GetBytes(0, 0, outbyte, 0, bufferSize)
bw.Write(outbyte)
bw.Flush()
bw.Close()
fs.Close()
reader.Close()
If conn.State = ConnectionState.Open Then
conn.Close()
conn.Dispose()
End If

When I was using OLE to connect to the JetDB:

If a user pasted an image into a picturebox, then immediately tried to
open,
edit, or preview it, an exception was thrown by the OLEDBDataReader,
because, since an update wasn't done after the paste, the image didn't
exist
in the DB. I was catching this exception and telling the user that the
image
had to be saved before any further actions could be taken with the image.

Upon switching to MSDE 2K:

I switched from using the OLEDBDataReader to using the SQLDataReader (Just
replace the OLEDB stuff above with SQL stuff). Under the same
circumstances,
an exception is not thrown. I just get an empty temp file.

What I don't know is this: is it a difference in the reader or in the DB?
My
guess is that it's a difference in the DBs, specifically something to do
with how an empty cell is represented. Using Jet, the empty cell was
represented with a DBNull, which caused the reader to throw an exception.
Does an SQL DB use DBNull? If not, any ideas on how to fix this?

TIA
Lee

Nov 21 '05 #4
Lee,

Your code snippet is to small to give all that information to use you are
telling now.

However what tackled me direct. Why are you writing something to a temporaly
disk file?

Are you sure you would not have a look at my sample where the Memory Stream
is used?

Cor
Nov 21 '05 #5
Hey Cor,

OK, I've copied the entire CM_Pic_Edit Sub to the bottom of this post. when
a user right-clicks on a picturebox (that has an image), the context menu
has a choice for editing the pic. I don't decide which program to use for
editing. when my app loads, I get all of the information regarding the
current users preferences from the registry.

So, this is the flow:

User right-clicks on picturebox and selects Edit
Create an SQL Statement related to whichever picturebox was the source
Open a connection to the DB
Use the SQLDataReader and a filestream to write the pic to disk
shell to whatever the users preferred editor for pics is
write the edited pic back to the DB
Delete the disk file

Using the OLEDBDataReader with a JetDB throws an exception if the pic isn't
actually in the DB (only in the picbox because the user didn't save/update
the DB yet)

Using the SQLDataReader with MSDE2K, in the same situation does not throw an
exception. It just writes an empty file to disk.

As I said, I'd like to understand why no exception is thrown with the SQL /
MSDE version, but is with the OLE / JetDB version. Once I understand why, it
should be relatively easy to fix. I already know I can check the size of the
disk file and if it's 0, I can throw my own exception. However, my
preference would be to handle this before I get to file creation.

Again, my guess is that it has something to do with the different ways the
JetDB and the SQL DB represent an empty field. DBNull is what causes the
exception to be thrown in the OLE / JetDB case. But I don't know what the
equivalent to a DBNull is in an SQL DB.

regarding the memorystream, I'm not sure a memorystream would work for
sending an image from the DB to an editor, having it edited, then getting it
back to the DB.

Here's the code:

Private Sub CM_Pic_Edit_Click(ByVal sender As System.Object, ByVal e As
System.EventArgs) Handles CM_Pic_Edit.Click
Dim pb, pm, pbfile, sql As String

sql = ""
pm = ""
pbfile = ""

If CM_Pics.SourceControl Is BTS_Pic1 Then
pm = "Picture 1"
pb = "Pic1"
sql = "SELECT BTSDB." + pb + " FROM BTSDB Where
(BTSDB.BTSIndex='" +
CStr(BP_BTS_Pick.Splits(0).DisplayColumns("BTSInde x").DataColumn.Value) +
"')"
pbfile =
Environment.GetFolderPath(Environment.SpecialFolde r.Personal) + "\" + pb +
".jpg"
ElseIf CM_Pics.SourceControl Is BTS_Pic2 Then
pm = "Picture 2"
pb = "Pic2"
sql = "SELECT BTSDB." + pb + " FROM BTSDB Where
(BTSDB.BTSIndex='" +
CStr(BP_BTS_Pick.Splits(0).DisplayColumns("BTSInde x").DataColumn.Value) +
"')"
pbfile =
Environment.GetFolderPath(Environment.SpecialFolde r.Personal) + "\" + pb +
".jpg"
ElseIf CM_Pics.SourceControl Is BTS_Pic3 Then
pm = "Picture 3"
pb = "Pic3"
sql = "SELECT BTSDB." + pb + " FROM BTSDB Where
(BTSDB.BTSIndex='" +
CStr(BP_BTS_Pick.Splits(0).DisplayColumns("BTSInde x").DataColumn.Value) +
"')"
pbfile =
Environment.GetFolderPath(Environment.SpecialFolde r.Personal) + "\" + pb +
".jpg"
End If
If CM_Pics.SourceControl Is Sec_Pic1 Then
pm = "Picture 1"
pb = "Pic1"
sql = "SELECT SectorDB." + pb + " FROM SectorDB Where
(SectorDB.SECTORIndex='" +
CStr(SI_Sector_Pick.Splits(0).DisplayColumns("SECT ORIndex").DataColumn.Value)
+ "')"
pbfile =
Environment.GetFolderPath(Environment.SpecialFolde r.Personal) + "\" + pb +
".jpg"
ElseIf CM_Pics.SourceControl Is Sec_Pic2 Then
pm = "Picture 2"
pb = "Pic2"
sql = "SELECT SectorDB." + pb + " FROM SectorDB Where
(SectorDB.SECTORIndex='" +
CStr(SI_Sector_Pick.Splits(0).DisplayColumns("SECT ORIndex").DataColumn.Value)
+ "')"
pbfile =
Environment.GetFolderPath(Environment.SpecialFolde r.Personal) + "\" + pb +
".jpg"
ElseIf CM_Pics.SourceControl Is Sec_Pic3 Then
pm = "Picture 3"
pb = "Pic3"
sql = "SELECT SectorDB." + pb + " FROM SectorDB Where
(SectorDB.SECTORIndex='" +
CStr(SI_Sector_Pick.Splits(0).DisplayColumns("SECT ORIndex").DataColumn.Value)
+ "')"
pbfile =
Environment.GetFolderPath(Environment.SpecialFolde r.Personal) + "\" + pb +
".jpg"
End If

Dim conn As SqlClient.SqlConnection = New SqlClient.SqlConnection
conn.ConnectionString = XConn.ConnectionString
If conn.State <> ConnectionState.Open Then
conn.Open()
End If

Dim cmd As SqlClient.SqlCommand = New SqlClient.SqlCommand(sql,
conn)
Dim fs As FileStream
Dim bw As BinaryWriter
Dim bufferSize As Integer = 300000
Dim outbyte(300000 - 1) As Byte
Dim retval As Long
Dim startIndex As Long = 0
Try
Dim reader As SqlClient.SqlDataReader =
cmd.ExecuteReader(CommandBehavior.SequentialAccess )
reader.Read()
fs = New FileStream(pbfile, FileMode.OpenOrCreate,
FileAccess.Write)
bw = New BinaryWriter(fs)
startIndex = 0
retval = reader.GetBytes(0, 0, outbyte, 0, bufferSize)
bw.Write(outbyte)
bw.Flush()
bw.Close()
fs.Close()
reader.Close()
If conn.State = ConnectionState.Open Then
conn.Close()
conn.Dispose()
End If

Dim go_edit As String
go_edit = CM_Pic_EditC(1) + " " + """" + pbfile + """"
Shell(go_edit, AppWinStyle.NormalFocus, True)
fs = New FileStream(pbfile, FileMode.OpenOrCreate,
FileAccess.Read)
Dim rawData() As Byte = New Byte(CInt(fs.Length)) {}
fs.Read(rawData, 0, System.Convert.ToInt32(fs.Length))
fs.Close()

If CM_Pics.SourceControl Is BTS_Pic1 Then
_XBTS.DataTable.Rows.Find(BP_BTS_Pick.Splits(0).Di splayColumns("BTSIndex").DataColumn.Value).Item("P ic1")
= rawData
ElseIf CM_Pics.SourceControl Is BTS_Pic2 Then
_XBTS.DataTable.Rows.Find(BP_BTS_Pick.Splits(0).Di splayColumns("BTSIndex").DataColumn.Value).Item("P ic2")
= rawData
ElseIf CM_Pics.SourceControl Is BTS_Pic3 Then
_XBTS.DataTable.Rows.Find(BP_BTS_Pick.Splits(0).Di splayColumns("BTSIndex").DataColumn.Value).Item("P ic3")
= rawData
End If
If CM_Pics.SourceControl Is Sec_Pic1 Then
_XSector.DataTable.Rows.Find(SI_Sector_Pick.Splits (0).DisplayColumns("SectorIndex").DataColumn.Value ).Item("Pic1")
= rawData
ElseIf CM_Pics.SourceControl Is Sec_Pic2 Then
_XSector.DataTable.Rows.Find(SI_Sector_Pick.Splits (0).DisplayColumns("SectoIndex").DataColumn.Value) .Item("Pic2")
= rawData
ElseIf CM_Pics.SourceControl Is Sec_Pic3 Then
_XSector.DataTable.Rows.Find(SI_Sector_Pick.Splits (0).DisplayColumns("SectorIndex").DataColumn.Value ).Item("Pic3")
= rawData
End If
File.Delete(pbfile)
Catch ex As Exception
If SD_Tabs.Current = 4 Then
MessageBox.Show(BP_BTS_Pick.Splits(0).DisplayColum ns("BTSID").DataColumn.Value.ToString
+ " - " + pm + " has not been saved to the Database. Click Update/Save, then
try Opening the picture again.", "Picture Not in DB", MessageBoxButtons.OK,
MessageBoxIcon.Information)
Else
MessageBox.Show(SI_Sector_Pick.Splits(0).DisplayCo lumns("SectorID").DataColumn.Value.ToString
+ " - " + pm + " has not been saved to the Database. Click Update/Save, then
try Opening the picture again.", "Picture Not in DB", MessageBoxButtons.OK,
MessageBoxIcon.Information)
End If
End Try
End Sub
"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2******************@TK2MSFTNGP14.phx.gbl...
Lee,

Your code snippet is to small to give all that information to use you are
telling now.

However what tackled me direct. Why are you writing something to a
temporaly disk file?

Are you sure you would not have a look at my sample where the Memory
Stream is used?

Cor

Nov 21 '05 #6
Hi guys,

I just realized what might be causing some of the confusion related to my
actual question. My pictureboxes are bound to a datatable, so if there's an
image to display, it's displayed via the binding, and if a user adds an
image to the picturebox, it's saved to the table via the binding.

The issue is related to getting the pic from the DB to an external editor
(and back to the DB once the editing is done). Well, actually, I can do that
part. I guess the issue is just the lack of an exception if the image
doesn't exist yet in the DB.

thanks,
Lee

"Cor Ligthert" <no************@planet.nl> wrote in message
news:%2******************@TK2MSFTNGP14.phx.gbl...
Lee,

Your code snippet is to small to give all that information to use you are
telling now.

However what tackled me direct. Why are you writing something to a
temporaly disk file?

Are you sure you would not have a look at my sample where the Memory
Stream is used?

Cor

Nov 21 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Stephen Ghelerter | last post by:
I am moving a web site with a MySql database to another server. Can I create a database on the new server with the same name and then move the tables there, or is life not that simple? Or can I...
2
by: Daniel | last post by:
I use an Access database to basically take data exports, import them, manipulate the data, and then turn them into exportable reports. I do this using numerous macros, and queries to get the data...
5
by: Sami | last post by:
Please bear with me, and if you answer this question, please do it step by step. I am new at Access, not at all sophisticated. I am using Office XP. This will need to be read in Access for...
3
by: eddie wang | last post by:
Hello, I am trying to export all the data from one Access database to another Access database. I selected one of my five tables, then clicked "File"-->"Export". Because my table from database A...
4
by: Ian | last post by:
Can anyone help I have a web server on the internet with and ASP.NET application on it, the application is set to allow Anonymous Access and Integrated Windows. The Web.config is set to use...
3
by: qwerty | last post by:
I have two User controls in a page. Them ID-propertys are example UC1 and UC2. In code behind file they are declared: Public UC1 As UC1 Public UC1 As UC1 From the page I can call them with...
27
by: Javier Martinez | last post by:
Hi I have asp application in a machine with a virtual directory referring a shared directory in another machine When I try to load any aspx page of my portal I get the following error: ...
13
by: George | last post by:
Hi, I am re-writing part of my application using C#. This application starts another process which execute a "legacy" program. This legacy program writes to a log file and before it ends, it...
1
by: vbace2 | last post by:
I have searched this forum, and the web, and I have not been able to find a solution to my issue. I may not have used the right search information to find the answer, but I found a lot of issues...
11
by: fniles | last post by:
One of our application uses VB6 and Access97 database. Another application uses VB.NET 2005. This morning for about 15 seconds when the application tries to read either a query or a table from the...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.