473,385 Members | 1,486 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,385 software developers and data experts.

Datagrid Overrides Question

Hi Folks,

I'm adding some columns to my datagrid which are of Combo Box type. I'm
inheriting DataGridTextBoxColumn and doing all the usual stuff to get them
populated. This is working fine. I have added some functionality where if
the user right clicks the combobox a context menu will appear, saying "Fill
the complete column with value 'XXX'". This value is the value they selected
from the combobox. This is also working fine.

However, to get this working generically for any datagrid, I'm running into
problems. I overload the constructor to pass in the datagrid (by ref) and
datatable, but I need to know the column the user clicked which I'm not
really sure how to do this.

I had this working before for one particular datagrid in my app. I passed in
a reference to the class containing the datagrid when the columns were
created but I'm trying to make it generic now so any datagrid can uses this
context menu function.

The reason I need to know the column selected is when I loop thru all the
rows and columns I know which cell to update.

I'm still fairly green with vb.net (win), ...do I need to get an event to
fire off, ..or add a addhandler to the constructor? The problem is I can't
do the HitTest for the datagrid within the "DataGridComboBoxColumn" class.

Again : I need to know the column the user clicked on the datagrid.

Hope I've explained this well enough. Any help would really be appreciated,
cause this one has got me for days.

Thanks,
Anthony
Nov 21 '05 #1
4 1776
Hi,

Sure you can use hit test info for a data grid in the column style.
Here is a sample column that i wrote that high lights the column the mouse
is under. I hope this helps.
Public Class HotTrackTextBoxColumn

Inherits DataGridTextBoxColumn

Dim c As Integer

Dim rectPaint As New RectangleF

Dim fnt As New Font(MyBase.TextBox.Font.Name, MyBase.TextBox.Font.Size,
FontStyle.Underline)

Dim WithEvents dg As DataGrid

Dim oldCell As New Point(-1, -1)

Dim isInCell As Boolean = False

Public Sub HandleMouseMove(ByVal sender As Object, ByVal e As
MouseEventArgs) Handles dg.MouseMove

Dim g As Graphics = dg.CreateGraphics

Dim bounds As Rectangle

Dim hti As DataGrid.HitTestInfo = dg.HitTest(New Point(e.X, e.Y))

isInCell = (hti.Row > -1 And hti.Column = c)

Static bRedraw As Boolean = False

If isInCell Then

Dim pt As Point

pt = New Point(hti.Row, hti.Column)

If Not pt.Equals(oldCell) Then

'

' Create a region where we want the datagrid to redraw

' So the datagrid doesn't flash.

'

Dim pthToRedraw As New Drawing2D.GraphicsPath

Dim rgnToRedraw As Region

Dim rCell As Rectangle = dg.GetCellBounds(pt.X, pt.Y)

pthToRedraw.AddRectangle(rCell)

If oldCell.X > -1 Then

'

' Have to redraw last cell

'

pthToRedraw.AddRectangle(dg.GetCellBounds(oldCell. X, oldCell.Y))

End If

rgnToRedraw = New Region(pthToRedraw)

dg.Invalidate(rgnToRedraw)

End If

'

' Flag datagrid for redraw

'

bRedraw = True

oldCell = pt

Else

'

' Only redraw when needed

'

If bRedraw Then

dg.Invalidate(dg.GetCellBounds(oldCell.X, oldCell.Y))

End If

bRedraw = False

oldCell = New Point(-1, -1)

End If

End Sub

Protected Overloads Overrides Sub Paint(ByVal g As System.Drawing.Graphics,
ByVal bounds As System.Drawing.Rectangle, ByVal source As
System.Windows.Forms.CurrencyManager, ByVal rowNum As Integer, ByVal
backBrush As System.Drawing.Brush, ByVal foreBrush As System.Drawing.Brush,
ByVal alignToRight As Boolean)

Static bPainted As Boolean = False

'

' First time we paint get a reference to datagrid

' So we can consume its events

'

If Not bPainted Then

dg = Me.DataGridTableStyle.DataGrid

c = -1

For Each grdCol As DataGridColumnStyle In
Me.DataGridTableStyle.GridColumnStyles

c += 1

If grdCol.MappingName = Me.MappingName Then Exit For

Next

End If

Dim pt As New Point(rowNum, c)

bPainted = True

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)

Dim brHot As New SolidBrush(Color.FromArgb(128, SystemColors.HotTrack))

If MouseOverCell(rowNum) Then

bounds.Inflate(-1, -1)

g.FillRectangle(brHot, bounds)

g.DrawRectangle(Pens.Blue, bounds)

End If

Dim r As New RectangleF(bounds.X, bounds.Y, bounds.Width, bounds.Height)

rectPaint = r

End Sub

Public ReadOnly Property MouseOverCell(ByVal rownum As Integer) As Boolean

Get

Dim pt As New Point(rownum, c)

Trace.WriteLine(String.Format("{0} {1}", oldCell.ToString, pt.ToString))

Return pt.Equals(oldCell)

End Get

End Property

End Class

Ken

-------------------------

"Anthony" <an*****@sysdel.com.au> wrote in message
news:eR**************@TK2MSFTNGP12.phx.gbl...
Hi Folks,

I'm adding some columns to my datagrid which are of Combo Box type. I'm
inheriting DataGridTextBoxColumn and doing all the usual stuff to get them
populated. This is working fine. I have added some functionality where if
the user right clicks the combobox a context menu will appear, saying "Fill
the complete column with value 'XXX'". This value is the value they selected
from the combobox. This is also working fine.

However, to get this working generically for any datagrid, I'm running into
problems. I overload the constructor to pass in the datagrid (by ref) and
datatable, but I need to know the column the user clicked which I'm not
really sure how to do this.

I had this working before for one particular datagrid in my app. I passed in
a reference to the class containing the datagrid when the columns were
created but I'm trying to make it generic now so any datagrid can uses this
context menu function.

The reason I need to know the column selected is when I loop thru all the
rows and columns I know which cell to update.

I'm still fairly green with vb.net (win), ...do I need to get an event to
fire off, ..or add a addhandler to the constructor? The problem is I can't
do the HitTest for the datagrid within the "DataGridComboBoxColumn" class.

Again : I need to know the column the user clicked on the datagrid.

Hope I've explained this well enough. Any help would really be appreciated,
cause this one has got me for days.

Thanks,
Anthony

Nov 21 '05 #2
Hi,

Sure you can use hit test info for a data grid in the column style.
Here is a sample column that i wrote that high lights the column the mouse
is under. I hope this helps.
Public Class HotTrackTextBoxColumn

Inherits DataGridTextBoxColumn

Dim c As Integer

Dim rectPaint As New RectangleF

Dim fnt As New Font(MyBase.TextBox.Font.Name, MyBase.TextBox.Font.Size,
FontStyle.Underline)

Dim WithEvents dg As DataGrid

Dim oldCell As New Point(-1, -1)

Dim isInCell As Boolean = False

Public Sub HandleMouseMove(ByVal sender As Object, ByVal e As
MouseEventArgs) Handles dg.MouseMove

Dim g As Graphics = dg.CreateGraphics

Dim bounds As Rectangle

Dim hti As DataGrid.HitTestInfo = dg.HitTest(New Point(e.X, e.Y))

isInCell = (hti.Row > -1 And hti.Column = c)

Static bRedraw As Boolean = False

If isInCell Then

Dim pt As Point

pt = New Point(hti.Row, hti.Column)

If Not pt.Equals(oldCell) Then

'

' Create a region where we want the datagrid to redraw

' So the datagrid doesn't flash.

'

Dim pthToRedraw As New Drawing2D.GraphicsPath

Dim rgnToRedraw As Region

Dim rCell As Rectangle = dg.GetCellBounds(pt.X, pt.Y)

pthToRedraw.AddRectangle(rCell)

If oldCell.X > -1 Then

'

' Have to redraw last cell

'

pthToRedraw.AddRectangle(dg.GetCellBounds(oldCell. X, oldCell.Y))

End If

rgnToRedraw = New Region(pthToRedraw)

dg.Invalidate(rgnToRedraw)

End If

'

' Flag datagrid for redraw

'

bRedraw = True

oldCell = pt

Else

'

' Only redraw when needed

'

If bRedraw Then

dg.Invalidate(dg.GetCellBounds(oldCell.X, oldCell.Y))

End If

bRedraw = False

oldCell = New Point(-1, -1)

End If

End Sub

Protected Overloads Overrides Sub Paint(ByVal g As System.Drawing.Graphics,
ByVal bounds As System.Drawing.Rectangle, ByVal source As
System.Windows.Forms.CurrencyManager, ByVal rowNum As Integer, ByVal
backBrush As System.Drawing.Brush, ByVal foreBrush As System.Drawing.Brush,
ByVal alignToRight As Boolean)

Static bPainted As Boolean = False

'

' First time we paint get a reference to datagrid

' So we can consume its events

'

If Not bPainted Then

dg = Me.DataGridTableStyle.DataGrid

c = -1

For Each grdCol As DataGridColumnStyle In
Me.DataGridTableStyle.GridColumnStyles

c += 1

If grdCol.MappingName = Me.MappingName Then Exit For

Next

End If

Dim pt As New Point(rowNum, c)

bPainted = True

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)

Dim brHot As New SolidBrush(Color.FromArgb(128, SystemColors.HotTrack))

If MouseOverCell(rowNum) Then

bounds.Inflate(-1, -1)

g.FillRectangle(brHot, bounds)

g.DrawRectangle(Pens.Blue, bounds)

End If

Dim r As New RectangleF(bounds.X, bounds.Y, bounds.Width, bounds.Height)

rectPaint = r

End Sub

Public ReadOnly Property MouseOverCell(ByVal rownum As Integer) As Boolean

Get

Dim pt As New Point(rownum, c)

Trace.WriteLine(String.Format("{0} {1}", oldCell.ToString, pt.ToString))

Return pt.Equals(oldCell)

End Get

End Property

End Class

Ken

-------------------------

"Anthony" <an*****@sysdel.com.au> wrote in message
news:eR**************@TK2MSFTNGP12.phx.gbl...
Hi Folks,

I'm adding some columns to my datagrid which are of Combo Box type. I'm
inheriting DataGridTextBoxColumn and doing all the usual stuff to get them
populated. This is working fine. I have added some functionality where if
the user right clicks the combobox a context menu will appear, saying "Fill
the complete column with value 'XXX'". This value is the value they selected
from the combobox. This is also working fine.

However, to get this working generically for any datagrid, I'm running into
problems. I overload the constructor to pass in the datagrid (by ref) and
datatable, but I need to know the column the user clicked which I'm not
really sure how to do this.

I had this working before for one particular datagrid in my app. I passed in
a reference to the class containing the datagrid when the columns were
created but I'm trying to make it generic now so any datagrid can uses this
context menu function.

The reason I need to know the column selected is when I loop thru all the
rows and columns I know which cell to update.

I'm still fairly green with vb.net (win), ...do I need to get an event to
fire off, ..or add a addhandler to the constructor? The problem is I can't
do the HitTest for the datagrid within the "DataGridComboBoxColumn" class.

Again : I need to know the column the user clicked on the datagrid.

Hope I've explained this well enough. Any help would really be appreciated,
cause this one has got me for days.

Thanks,
Anthony

Nov 21 '05 #3
Thanks for your solution Ken, but I've just figured it out.

Would you believe, ...
m_DataGrid.CurrentCell.ColumnNumber

That's it, ...I can call this in my DataGridComboBoxColumn class (Inherits
DataGridTextBoxColumn) and Bobs your mothers brother.

I will have a look at you solution too, ...(looks quite hard core)


"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:Ok**************@tk2msftngp13.phx.gbl...
Hi,

Sure you can use hit test info for a data grid in the column style. Here is a sample column that i wrote that high lights the column the mouse
is under. I hope this helps.
Public Class HotTrackTextBoxColumn

Inherits DataGridTextBoxColumn

Dim c As Integer

Dim rectPaint As New RectangleF

Dim fnt As New Font(MyBase.TextBox.Font.Name, MyBase.TextBox.Font.Size,
FontStyle.Underline)

Dim WithEvents dg As DataGrid

Dim oldCell As New Point(-1, -1)

Dim isInCell As Boolean = False

Public Sub HandleMouseMove(ByVal sender As Object, ByVal e As
MouseEventArgs) Handles dg.MouseMove

Dim g As Graphics = dg.CreateGraphics

Dim bounds As Rectangle

Dim hti As DataGrid.HitTestInfo = dg.HitTest(New Point(e.X, e.Y))

isInCell = (hti.Row > -1 And hti.Column = c)

Static bRedraw As Boolean = False

If isInCell Then

Dim pt As Point

pt = New Point(hti.Row, hti.Column)

If Not pt.Equals(oldCell) Then

'

' Create a region where we want the datagrid to redraw

' So the datagrid doesn't flash.

'

Dim pthToRedraw As New Drawing2D.GraphicsPath

Dim rgnToRedraw As Region

Dim rCell As Rectangle = dg.GetCellBounds(pt.X, pt.Y)

pthToRedraw.AddRectangle(rCell)

If oldCell.X > -1 Then

'

' Have to redraw last cell

'

pthToRedraw.AddRectangle(dg.GetCellBounds(oldCell. X, oldCell.Y))

End If

rgnToRedraw = New Region(pthToRedraw)

dg.Invalidate(rgnToRedraw)

End If

'

' Flag datagrid for redraw

'

bRedraw = True

oldCell = pt

Else

'

' Only redraw when needed

'

If bRedraw Then

dg.Invalidate(dg.GetCellBounds(oldCell.X, oldCell.Y))

End If

bRedraw = False

oldCell = New Point(-1, -1)

End If

End Sub

Protected Overloads Overrides Sub Paint(ByVal g As System.Drawing.Graphics, ByVal bounds As System.Drawing.Rectangle, ByVal source As
System.Windows.Forms.CurrencyManager, ByVal rowNum As Integer, ByVal
backBrush As System.Drawing.Brush, ByVal foreBrush As System.Drawing.Brush, ByVal alignToRight As Boolean)

Static bPainted As Boolean = False

'

' First time we paint get a reference to datagrid

' So we can consume its events

'

If Not bPainted Then

dg = Me.DataGridTableStyle.DataGrid

c = -1

For Each grdCol As DataGridColumnStyle In
Me.DataGridTableStyle.GridColumnStyles

c += 1

If grdCol.MappingName = Me.MappingName Then Exit For

Next

End If

Dim pt As New Point(rowNum, c)

bPainted = True

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)
Dim brHot As New SolidBrush(Color.FromArgb(128, SystemColors.HotTrack))

If MouseOverCell(rowNum) Then

bounds.Inflate(-1, -1)

g.FillRectangle(brHot, bounds)

g.DrawRectangle(Pens.Blue, bounds)

End If

Dim r As New RectangleF(bounds.X, bounds.Y, bounds.Width, bounds.Height)

rectPaint = r

End Sub

Public ReadOnly Property MouseOverCell(ByVal rownum As Integer) As Boolean

Get

Dim pt As New Point(rownum, c)

Trace.WriteLine(String.Format("{0} {1}", oldCell.ToString, pt.ToString))

Return pt.Equals(oldCell)

End Get

End Property

End Class

Ken

-------------------------

"Anthony" <an*****@sysdel.com.au> wrote in message
news:eR**************@TK2MSFTNGP12.phx.gbl...
Hi Folks,

I'm adding some columns to my datagrid which are of Combo Box type. I'm
inheriting DataGridTextBoxColumn and doing all the usual stuff to get them
populated. This is working fine. I have added some functionality where if
the user right clicks the combobox a context menu will appear, saying "Fill the complete column with value 'XXX'". This value is the value they selected from the combobox. This is also working fine.

However, to get this working generically for any datagrid, I'm running into problems. I overload the constructor to pass in the datagrid (by ref) and
datatable, but I need to know the column the user clicked which I'm not
really sure how to do this.

I had this working before for one particular datagrid in my app. I passed in a reference to the class containing the datagrid when the columns were
created but I'm trying to make it generic now so any datagrid can uses this context menu function.

The reason I need to know the column selected is when I loop thru all the
rows and columns I know which cell to update.

I'm still fairly green with vb.net (win), ...do I need to get an event to
fire off, ..or add a addhandler to the constructor? The problem is I can't
do the HitTest for the datagrid within the "DataGridComboBoxColumn" class.

Again : I need to know the column the user clicked on the datagrid.

Hope I've explained this well enough. Any help would really be appreciated, cause this one has got me for days.

Thanks,
Anthony

Nov 21 '05 #4
Thanks for your solution Ken, but I've just figured it out.

Would you believe, ...
m_DataGrid.CurrentCell.ColumnNumber

That's it, ...I can call this in my DataGridComboBoxColumn class (Inherits
DataGridTextBoxColumn) and Bobs your mothers brother.

I will have a look at you solution too, ...(looks quite hard core)


"Ken Tucker [MVP]" <vb***@bellsouth.net> wrote in message
news:Ok**************@tk2msftngp13.phx.gbl...
Hi,

Sure you can use hit test info for a data grid in the column style. Here is a sample column that i wrote that high lights the column the mouse
is under. I hope this helps.
Public Class HotTrackTextBoxColumn

Inherits DataGridTextBoxColumn

Dim c As Integer

Dim rectPaint As New RectangleF

Dim fnt As New Font(MyBase.TextBox.Font.Name, MyBase.TextBox.Font.Size,
FontStyle.Underline)

Dim WithEvents dg As DataGrid

Dim oldCell As New Point(-1, -1)

Dim isInCell As Boolean = False

Public Sub HandleMouseMove(ByVal sender As Object, ByVal e As
MouseEventArgs) Handles dg.MouseMove

Dim g As Graphics = dg.CreateGraphics

Dim bounds As Rectangle

Dim hti As DataGrid.HitTestInfo = dg.HitTest(New Point(e.X, e.Y))

isInCell = (hti.Row > -1 And hti.Column = c)

Static bRedraw As Boolean = False

If isInCell Then

Dim pt As Point

pt = New Point(hti.Row, hti.Column)

If Not pt.Equals(oldCell) Then

'

' Create a region where we want the datagrid to redraw

' So the datagrid doesn't flash.

'

Dim pthToRedraw As New Drawing2D.GraphicsPath

Dim rgnToRedraw As Region

Dim rCell As Rectangle = dg.GetCellBounds(pt.X, pt.Y)

pthToRedraw.AddRectangle(rCell)

If oldCell.X > -1 Then

'

' Have to redraw last cell

'

pthToRedraw.AddRectangle(dg.GetCellBounds(oldCell. X, oldCell.Y))

End If

rgnToRedraw = New Region(pthToRedraw)

dg.Invalidate(rgnToRedraw)

End If

'

' Flag datagrid for redraw

'

bRedraw = True

oldCell = pt

Else

'

' Only redraw when needed

'

If bRedraw Then

dg.Invalidate(dg.GetCellBounds(oldCell.X, oldCell.Y))

End If

bRedraw = False

oldCell = New Point(-1, -1)

End If

End Sub

Protected Overloads Overrides Sub Paint(ByVal g As System.Drawing.Graphics, ByVal bounds As System.Drawing.Rectangle, ByVal source As
System.Windows.Forms.CurrencyManager, ByVal rowNum As Integer, ByVal
backBrush As System.Drawing.Brush, ByVal foreBrush As System.Drawing.Brush, ByVal alignToRight As Boolean)

Static bPainted As Boolean = False

'

' First time we paint get a reference to datagrid

' So we can consume its events

'

If Not bPainted Then

dg = Me.DataGridTableStyle.DataGrid

c = -1

For Each grdCol As DataGridColumnStyle In
Me.DataGridTableStyle.GridColumnStyles

c += 1

If grdCol.MappingName = Me.MappingName Then Exit For

Next

End If

Dim pt As New Point(rowNum, c)

bPainted = True

MyBase.Paint(g, bounds, source, rowNum, backBrush, foreBrush, alignToRight)
Dim brHot As New SolidBrush(Color.FromArgb(128, SystemColors.HotTrack))

If MouseOverCell(rowNum) Then

bounds.Inflate(-1, -1)

g.FillRectangle(brHot, bounds)

g.DrawRectangle(Pens.Blue, bounds)

End If

Dim r As New RectangleF(bounds.X, bounds.Y, bounds.Width, bounds.Height)

rectPaint = r

End Sub

Public ReadOnly Property MouseOverCell(ByVal rownum As Integer) As Boolean

Get

Dim pt As New Point(rownum, c)

Trace.WriteLine(String.Format("{0} {1}", oldCell.ToString, pt.ToString))

Return pt.Equals(oldCell)

End Get

End Property

End Class

Ken

-------------------------

"Anthony" <an*****@sysdel.com.au> wrote in message
news:eR**************@TK2MSFTNGP12.phx.gbl...
Hi Folks,

I'm adding some columns to my datagrid which are of Combo Box type. I'm
inheriting DataGridTextBoxColumn and doing all the usual stuff to get them
populated. This is working fine. I have added some functionality where if
the user right clicks the combobox a context menu will appear, saying "Fill the complete column with value 'XXX'". This value is the value they selected from the combobox. This is also working fine.

However, to get this working generically for any datagrid, I'm running into problems. I overload the constructor to pass in the datagrid (by ref) and
datatable, but I need to know the column the user clicked which I'm not
really sure how to do this.

I had this working before for one particular datagrid in my app. I passed in a reference to the class containing the datagrid when the columns were
created but I'm trying to make it generic now so any datagrid can uses this context menu function.

The reason I need to know the column selected is when I loop thru all the
rows and columns I know which cell to update.

I'm still fairly green with vb.net (win), ...do I need to get an event to
fire off, ..or add a addhandler to the constructor? The problem is I can't
do the HitTest for the datagrid within the "DataGridComboBoxColumn" class.

Again : I need to know the column the user clicked on the datagrid.

Hope I've explained this well enough. Any help would really be appreciated, cause this one has got me for days.

Thanks,
Anthony

Nov 21 '05 #5

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

Similar topics

4
by: The Alchemist | last post by:
I am having a problem with a dynamically-generated Datagrid. It is important to point out that this problem does not exist with a design-time created Datagrid, but only with a dynamically generated...
2
by: pmcguire | last post by:
I have derived a ComboBoxColumnStyle that inherits DataGridColumnStyle. It works fine except for one behavior. If the user selects a new value from the ComboBox's pulldown list on a brand new...
1
by: jimb | last post by:
I can get the dropdownlist into the datagrid, and I can populate it, but I can't read it. Anybody have a working example of a dropdownlist in an editable grid? Thanks. -- .....
1
by: Doug Bell | last post by:
Hi, Can you lock the colum in a datagrid so that it can not be resized by th user? Thanks Doug
4
by: Jan Nielsen | last post by:
Hi all I'm a former Access developer who would like to implement a many-to-many relation in about the same way you do in Access: With a subform and a combo box. Is it possible to use a...
13
by: pmcguire | last post by:
I have a DataGrid control for which I have also created several new extended DataGridColumnStyles. They behave pretty nicely, but I can't figure out how to implement Selected Item formatting for...
1
by: Geroge D. Lake | last post by:
Hi, I need to disable the resizing of a datagrid. I have tried al day and no luck. Any Ideas? Thanks. George.
2
by: Nina | last post by:
Hi there, I've tried everything that I know to prevent usre resizing datagrid columns, but nothing works. Following are the code that I used. Please tell me what's wrong with them. Thank you....
0
by: Familjen Karlsson | last post by:
Hi I have downloaded some code and tried it and nothing happens with the datagrid. Explain what is wrong and what I have to do please. I have tried to Import the namespace Hamster and it didn't...
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: 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
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
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...
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.