After much frustration I was able to update my data store via code only.
Using the data adapter was the only way I was able to set up all the objects
written in my code. Basically, I cheated by creating an adapter and then
copy, paste, modify it's code to suite my needs. This was the end result:
Private sub updateTable( )
Dim myData As DataSet
'Command is a form level oledbcommand object
Dim Adapter1 As New OleDbDataAdapter(Command)
myData = New DataSet()
myData = Me.DataGrid1.DataSource
Dim Cno As OleDbConnection
Cno = New OleDbConnection(Me.strConnectionString)
'************************************************* *
' here is where my copy, paste, modify code from
'adapter control starts
'*************************************************
Adapter1.UpdateCommand = New OleDbCommand()
'best way to get parameters and update string is to create them
'using an oledbdataadapter control
Dim strUpdate As String = "UPDATE employee SET [Employee Number] = ?, [First
Name] = ?, [Last Name] = ? WHER" & _
"E ([Employee Number] = ?) AND ([First Name] = ? OR ? IS NULL AND [First
Name] IS" & _
" NULL) AND ([Last Name] = ? OR ? IS NULL AND [Last Name] IS NULL)"
With Adapter1.UpdateCommand
..CommandText = strUpdate
..Connection = Cno
..Parameters.Add(New OleDbParameter("Employee_Number",
System.Data.OleDb.OleDbType.SmallInt, 0,
System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte),
"Employee Number", System.Data.DataRowVersion.Current, Nothing))
..Parameters.Add(New OleDbParameter("First_Name",
System.Data.OleDb.OleDbType.VarWChar, 25, "First Name"))
..Parameters.Add(New OleDbParameter("Last_Name",
System.Data.OleDb.OleDbType.VarWChar, 25, "Last Name"))
..Parameters.Add(New OleDbParameter("Original_Employee_Number",
System.Data.OleDb.OleDbType.SmallInt, 0,
System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte),
"Employee Number", System.Data.DataRowVersion.Original, Nothing))
..Parameters.Add(New OleDbParameter("Original_First_Name",
System.Data.OleDb.OleDbType.VarWChar, 25,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte),
"First Name", System.Data.DataRowVersion.Original, Nothing))
..Parameters.Add(New OleDbParameter("Original_First_Name1",
System.Data.OleDb.OleDbType.VarWChar, 25,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte),
"First Name", System.Data.DataRowVersion.Original, Nothing))
..Parameters.Add(New OleDbParameter("Original_Last_Name",
System.Data.OleDb.OleDbType.VarWChar, 25,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte),
"Last Name", System.Data.DataRowVersion.Original, Nothing))
..Parameters.Add(New OleDbParameter("Original_Last_Name1",
System.Data.OleDb.OleDbType.VarWChar, 25,
System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte),
"Last Name", System.Data.DataRowVersion.Original, Nothing))
End With
'***************************************
'here is where it ends
'***************************************
Try
Adapter1.Update(myData.Tables(0))
Catch prob As OleDbException
MsgBox(prob.Message)
End Try
end sub
I was never able to get the commandbuilder to work. I just think this is a
lot of coding where is previous version doing this in code was much simpler.
Have I just been spoiled by vb6 and it's simplicity? 4 1815
I haven't flipped through all of this code b/c it's working so I can't tell
what was wrong with the commandbuilder. Usually it's very easy to use - the
only catch is you must have a PK field in it and you can't control your
concurrency options. With that in mind, all you need is a valid Select
statement so it can infer the rest of the CRUD info and you're good to go.
If you want to post the code, I'll be glad to take a look at it.
--
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups?
Let Microsoft know! https://www.windowsembeddedeval.com/...ity/newsgroups
"William" <no**@none.com> wrote in message
news:35***************@bignews6.bellsouth.net... After much frustration I was able to update my data store via code only. Using the data adapter was the only way I was able to set up all the
objects written in my code. Basically, I cheated by creating an adapter and then copy, paste, modify it's code to suite my needs. This was the end result:
Private sub updateTable( )
Dim myData As DataSet 'Command is a form level oledbcommand object Dim Adapter1 As New OleDbDataAdapter(Command) myData = New DataSet() myData = Me.DataGrid1.DataSource
Dim Cno As OleDbConnection Cno = New OleDbConnection(Me.strConnectionString)
'************************************************* * ' here is where my copy, paste, modify code from 'adapter control starts '*************************************************
Adapter1.UpdateCommand = New OleDbCommand() 'best way to get parameters and update string is to create them 'using an oledbdataadapter control
Dim strUpdate As String = "UPDATE employee SET [Employee Number] = ?,
[First Name] = ?, [Last Name] = ? WHER" & _ "E ([Employee Number] = ?) AND ([First Name] = ? OR ? IS NULL AND [First Name] IS" & _ " NULL) AND ([Last Name] = ? OR ? IS NULL AND [Last Name] IS NULL)"
With Adapter1.UpdateCommand .CommandText = strUpdate .Connection = Cno
.Parameters.Add(New OleDbParameter("Employee_Number", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0,
Byte), "Employee Number", System.Data.DataRowVersion.Current, Nothing))
.Parameters.Add(New OleDbParameter("First_Name", System.Data.OleDb.OleDbType.VarWChar, 25, "First Name"))
.Parameters.Add(New OleDbParameter("Last_Name", System.Data.OleDb.OleDbType.VarWChar, 25, "Last Name"))
.Parameters.Add(New OleDbParameter("Original_Employee_Number", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0,
Byte), "Employee Number", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_First_Name", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "First Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_First_Name1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "First Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_Last_Name", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Last Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_Last_Name1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Last Name", System.Data.DataRowVersion.Original, Nothing)) End With
'*************************************** 'here is where it ends '***************************************
Try Adapter1.Update(myData.Tables(0)) Catch prob As OleDbException MsgBox(prob.Message) End Try end sub
I was never able to get the commandbuilder to work. I just think this is
a lot of coding where is previous version doing this in code was much
simpler. Have I just been spoiled by vb6 and it's simplicity?
IMHO Command Builder and Wizards are only good for quick tests when your
trying to look at functionality of something or to get a connection string
etc.
You are really better off buying an ADO.NET books and working through it,
yes its slow, yes it can be painfull, but ultimatley it is worth the effort
because at least then you know how it all hangs together.
CommandBuilder/Wizards are only any good for simple Select Statements.
Regards - OHM
--
OHM ( Terry Burns )
. . . One-Handed-Man . . .
Time flies when you don't know what you're doing
"William" <no**@none.com> wrote in message
news:35***************@bignews6.bellsouth.net... After much frustration I was able to update my data store via code only. Using the data adapter was the only way I was able to set up all the
objects written in my code. Basically, I cheated by creating an adapter and then copy, paste, modify it's code to suite my needs. This was the end result:
Private sub updateTable( )
Dim myData As DataSet 'Command is a form level oledbcommand object Dim Adapter1 As New OleDbDataAdapter(Command) myData = New DataSet() myData = Me.DataGrid1.DataSource
Dim Cno As OleDbConnection Cno = New OleDbConnection(Me.strConnectionString)
'************************************************* * ' here is where my copy, paste, modify code from 'adapter control starts '*************************************************
Adapter1.UpdateCommand = New OleDbCommand() 'best way to get parameters and update string is to create them 'using an oledbdataadapter control
Dim strUpdate As String = "UPDATE employee SET [Employee Number] = ?,
[First Name] = ?, [Last Name] = ? WHER" & _ "E ([Employee Number] = ?) AND ([First Name] = ? OR ? IS NULL AND [First Name] IS" & _ " NULL) AND ([Last Name] = ? OR ? IS NULL AND [Last Name] IS NULL)"
With Adapter1.UpdateCommand .CommandText = strUpdate .Connection = Cno
.Parameters.Add(New OleDbParameter("Employee_Number", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0,
Byte), "Employee Number", System.Data.DataRowVersion.Current, Nothing))
.Parameters.Add(New OleDbParameter("First_Name", System.Data.OleDb.OleDbType.VarWChar, 25, "First Name"))
.Parameters.Add(New OleDbParameter("Last_Name", System.Data.OleDb.OleDbType.VarWChar, 25, "Last Name"))
.Parameters.Add(New OleDbParameter("Original_Employee_Number", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0,
Byte), "Employee Number", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_First_Name", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "First Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_First_Name1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "First Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_Last_Name", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Last Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_Last_Name1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0,
Byte), "Last Name", System.Data.DataRowVersion.Original, Nothing)) End With
'*************************************** 'here is where it ends '***************************************
Try Adapter1.Update(myData.Tables(0)) Catch prob As OleDbException MsgBox(prob.Message) End Try end sub
I was never able to get the commandbuilder to work. I just think this is
a lot of coding where is previous version doing this in code was much
simpler. Have I just been spoiled by vb6 and it's simplicity?
Try setting the QuotePrefix and QuoteSuffix properties to '[' and ']',
respectively. I believe the problem is that some of your column's have
spaces in the name, and without these symbols around the names, there is a
syntax error.
"William" <no**@none.com> wrote in message
news:wS*******************@bignews3.bellsouth.net. .. William, thanks for the help. Here is the last version of my
commandbuilder code I used after many revision that never worked.
Private Sub btnCommandBuilder_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnCommandBuilder.Click
Dim cb As OleDbCommandBuilder Dim con As New OleDbConnection(Me.strConnectionString) Dim myDat As New DataSet()
'form level adapter Adapter.SelectCommand = New OleDbCommand("select * from employee", con)
cb = New OleDbCommandBuilder(Adapter)
myDat = Me.DataGrid1.DataSource
Try Adapter.Update(myDat.Tables(0))
Catch prob As Exception MsgBox(prob.Message)
End Try
End Sub
This one keeps barking about Syntax error in update statement. I am
curious as to the PK field since I never implemented it in my commandbuilder. It
is implemented in the data store however. I am thinking this might be part
if not all the problem "William Ryan eMVP" <do********@comcast.nospam.net> wrote in message news:OK**************@TK2MSFTNGP11.phx.gbl... I haven't flipped through all of this code b/c it's working so I can't tell what was wrong with the commandbuilder. Usually it's very easy to use - the only catch is you must have a PK field in it and you can't control your concurrency options. With that in mind, all you need is a valid Select statement so it can infer the rest of the CRUD info and you're good to
go. If you want to post the code, I'll be glad to take a look at it.
--
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups? Let Microsoft know! https://www.windowsembeddedeval.com/...ity/newsgroups "William" <no**@none.com> wrote in message news:35***************@bignews6.bellsouth.net... After much frustration I was able to update my data store via code
only. Using the data adapter was the only way I was able to set up all the objects written in my code. Basically, I cheated by creating an adapter and then copy, paste, modify it's code to suite my needs. This was the end result: Private sub updateTable( )
Dim myData As DataSet 'Command is a form level oledbcommand object Dim Adapter1 As New OleDbDataAdapter(Command) myData = New DataSet() myData = Me.DataGrid1.DataSource
Dim Cno As OleDbConnection Cno = New OleDbConnection(Me.strConnectionString)
'************************************************* * ' here is where my copy, paste, modify code from 'adapter control starts '*************************************************
Adapter1.UpdateCommand = New OleDbCommand() 'best way to get parameters and update string is to create them 'using an oledbdataadapter control
Dim strUpdate As String = "UPDATE employee SET [Employee Number] = ?,
[First Name] = ?, [Last Name] = ? WHER" & _ "E ([Employee Number] = ?) AND ([First Name] = ? OR ? IS NULL AND
[First Name] IS" & _ " NULL) AND ([Last Name] = ? OR ? IS NULL AND [Last Name] IS NULL)"
With Adapter1.UpdateCommand .CommandText = strUpdate .Connection = Cno
.Parameters.Add(New OleDbParameter("Employee_Number", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte), "Employee Number", System.Data.DataRowVersion.Current, Nothing))
.Parameters.Add(New OleDbParameter("First_Name", System.Data.OleDb.OleDbType.VarWChar, 25, "First Name"))
.Parameters.Add(New OleDbParameter("Last_Name", System.Data.OleDb.OleDbType.VarWChar, 25, "Last Name"))
.Parameters.Add(New OleDbParameter("Original_Employee_Number", System.Data.OleDb.OleDbType.SmallInt, 0, System.Data.ParameterDirection.Input, False, CType(5, Byte), CType(0, Byte), "Employee Number", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_First_Name", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "First Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_First_Name1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "First Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_Last_Name", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Last Name", System.Data.DataRowVersion.Original, Nothing))
.Parameters.Add(New OleDbParameter("Original_Last_Name1", System.Data.OleDb.OleDbType.VarWChar, 25, System.Data.ParameterDirection.Input, False, CType(0, Byte), CType(0, Byte), "Last Name", System.Data.DataRowVersion.Original, Nothing)) End With
'*************************************** 'here is where it ends '***************************************
Try Adapter1.Update(myData.Tables(0)) Catch prob As OleDbException MsgBox(prob.Message) End Try end sub
I was never able to get the commandbuilder to work. I just think this is a lot of coding where is previous version doing this in code was much simpler. Have I just been spoiled by vb6 and it's simplicity?
Mariana you are a genass (genious). You know how when you get so entrenched
in a problem that you start to believe that the problem is so complex that
the only solution is a complex solution. Now it all seems so much simpler.
That first step is a doozy.
Thanks again
"Marina" <so*****@nospam.com> wrote in message
news:OD**************@TK2MSFTNGP10.phx.gbl... Try setting the QuotePrefix and QuoteSuffix properties to '[' and ']', respectively. I believe the problem is that some of your column's have spaces in the name, and without these symbols around the names, there is a syntax error.
"William" <no**@none.com> wrote in message news:wS*******************@bignews3.bellsouth.net. .. William, thanks for the help. Here is the last version of my commandbuilder code I used after many revision that never worked.
Private Sub btnCommandBuilder_Click(ByVal sender As System.Object, ByVal
e As System.EventArgs) Handles btnCommandBuilder.Click
Dim cb As OleDbCommandBuilder Dim con As New OleDbConnection(Me.strConnectionString) Dim myDat As New DataSet()
'form level adapter Adapter.SelectCommand = New OleDbCommand("select * from employee", con)
cb = New OleDbCommandBuilder(Adapter)
myDat = Me.DataGrid1.DataSource
Try Adapter.Update(myDat.Tables(0))
Catch prob As Exception MsgBox(prob.Message)
End Try
End Sub
This one keeps barking about Syntax error in update statement. I am curious as to the PK field since I never implemented it in my commandbuilder.
It is implemented in the data store however. I am thinking this might be
part if not all the problem "William Ryan eMVP" <do********@comcast.nospam.net> wrote in message news:OK**************@TK2MSFTNGP11.phx.gbl... I haven't flipped through all of this code b/c it's working so I can't tell what was wrong with the commandbuilder. Usually it's very easy to
use - the only catch is you must have a PK field in it and you can't control
your concurrency options. With that in mind, all you need is a valid
Select statement so it can infer the rest of the CRUD info and you're good to go. If you want to post the code, I'll be glad to take a look at it.
--
W.G. Ryan, eMVP
Have an opinion on the effectiveness of Microsoft Embedded newsgroups? Let Microsoft know! https://www.windowsembeddedeval.com/...ity/newsgroups "William" <no**@none.com> wrote in message news:35***************@bignews6.bellsouth.net... > After much frustration I was able to update my data store via code only. > Using the data adapter was the only way I was able to set up all the objects > written in my code. Basically, I cheated by creating an adapter and then > copy, paste, modify it's code to suite my needs. This was the end result: > > Private sub updateTable( ) > > Dim myData As DataSet > 'Command is a form level oledbcommand object > Dim Adapter1 As New OleDbDataAdapter(Command) > myData = New DataSet() > myData = Me.DataGrid1.DataSource > > Dim Cno As OleDbConnection > Cno = New OleDbConnection(Me.strConnectionString) > > '************************************************* * > ' here is where my copy, paste, modify code from > 'adapter control starts > '************************************************* > > Adapter1.UpdateCommand = New OleDbCommand() > 'best way to get parameters and update string is to create them > 'using an oledbdataadapter control > > Dim strUpdate As String = "UPDATE employee SET [Employee Number] =
?, [First > Name] = ?, [Last Name] = ? WHER" & _ > "E ([Employee Number] = ?) AND ([First Name] = ? OR ? IS NULL AND [First > Name] IS" & _ > " NULL) AND ([Last Name] = ? OR ? IS NULL AND [Last Name] IS NULL)" > > With Adapter1.UpdateCommand > .CommandText = strUpdate > .Connection = Cno > > .Parameters.Add(New OleDbParameter("Employee_Number", > System.Data.OleDb.OleDbType.SmallInt, 0, > System.Data.ParameterDirection.Input, False, CType(5, Byte),
CType(0, Byte), > "Employee Number", System.Data.DataRowVersion.Current, Nothing)) > > .Parameters.Add(New OleDbParameter("First_Name", > System.Data.OleDb.OleDbType.VarWChar, 25, "First Name")) > > .Parameters.Add(New OleDbParameter("Last_Name", > System.Data.OleDb.OleDbType.VarWChar, 25, "Last Name")) > > .Parameters.Add(New OleDbParameter("Original_Employee_Number", > System.Data.OleDb.OleDbType.SmallInt, 0, > System.Data.ParameterDirection.Input, False, CType(5, Byte),
CType(0, Byte), > "Employee Number", System.Data.DataRowVersion.Original, Nothing)) > > .Parameters.Add(New OleDbParameter("Original_First_Name", > System.Data.OleDb.OleDbType.VarWChar, 25, > System.Data.ParameterDirection.Input, False, CType(0, Byte),
CType(0, Byte), > "First Name", System.Data.DataRowVersion.Original, Nothing)) > > .Parameters.Add(New OleDbParameter("Original_First_Name1", > System.Data.OleDb.OleDbType.VarWChar, 25, > System.Data.ParameterDirection.Input, False, CType(0, Byte),
CType(0, Byte), > "First Name", System.Data.DataRowVersion.Original, Nothing)) > > .Parameters.Add(New OleDbParameter("Original_Last_Name", > System.Data.OleDb.OleDbType.VarWChar, 25, > System.Data.ParameterDirection.Input, False, CType(0, Byte),
CType(0, Byte), > "Last Name", System.Data.DataRowVersion.Original, Nothing)) > > .Parameters.Add(New OleDbParameter("Original_Last_Name1", > System.Data.OleDb.OleDbType.VarWChar, 25, > System.Data.ParameterDirection.Input, False, CType(0, Byte),
CType(0, Byte), > "Last Name", System.Data.DataRowVersion.Original, Nothing)) > End With > > '*************************************** > 'here is where it ends > '*************************************** > > Try > Adapter1.Update(myData.Tables(0)) > Catch prob As OleDbException > MsgBox(prob.Message) > End Try > end sub > > > I was never able to get the commandbuilder to work. I just think
this is a > lot of coding where is previous version doing this in code was much simpler. > Have I just been spoiled by vb6 and it's simplicity? > >
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: shank |
last post by:
Visually, the page will look somewhat like a spreadsheet. It could have
hundreds of records (rows) displayed. I want to enable the user to edit any
one or any number of records and any fields, then...
|
by: gooday |
last post by:
Table test2 has multiple amounts for each account, I would like to sum
the amounts for the same account and use the result to update the
variable 'tot_amount' in table test1. But SQL does not allow...
|
by: Hank1234 |
last post by:
Can I use one Data Adapter and one Command Builder to update amny tables?
Currently in my data adapter I query two tables and fill them into two tables
in a data set. When I make a change to a...
|
by: Jim |
last post by:
Hi,
Let me explain how I'd generally do things. For a page where the user
edits data, I'd generally call it something like editfred.php (for
example), the page which updates the data would be...
|
by: Simon |
last post by:
Hi everyone,
I have a small problem regarding a wizard that I'm making on my website.
The wizard is obviously a series of pages that take values from the user. My
question is:
- Should I...
|
by: Mark Whitton |
last post by:
Hi, I am developing using ASP.Net using SQL Server and also have several
layers in between, eventually producing a custom business object that is
used to populate the web form. I don't use...
|
by: Charles Law |
last post by:
Here's one that should probably have the sub-heading "I'm sure I asked this
once before, but ...".
Two users are both looking at the same data, from a database. One user
changes the data and...
|
by: Stephen Plotnick |
last post by:
I'm very new to VB.NET 2003
Here is what I have accomplished:
MainSelectForm - Selects an item
In a public class I pass a DataViewRow to
ItemInformation1 Form
ItemInformation2 Form
|
by: Miro |
last post by:
I will ask the question first then fumble thru trying to explain myself so i
dont waste too much of your time.
Question / Statement - Every mdb table needs a PrimaryKey ( or maybe an
index - i...
|
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...
|
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...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
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...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
| |