RowCount property cannot be set on a data-bound DataGridView control. - Database Discussion Boards

meeram3955-Apr-07 1:42

5-Apr-07 1:42

For searching data between two dates, you can also write the query as follows: Suppose that you want to search data between 01/03/2007 and 31/103/2007

Select field1, field2, datefield from tablename
where datediff(day,'01/03/2007',datefield) >= 0 and datediff(day,'31/03/2007',datefield) <=0 order by datefield

Meeram395

Problem with using OLEDB read excel file

kokain4-Apr-07 5:37

kokain

4-Apr-07 5:37

Hi all,

I'm using OLEDB to reading data from an excel file, using connection string below:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\MyExcel.xls;Extended Properties="Excel 8.0;HDR=Yes;IMEX=1";

The problem I'm get in stuck in is OLEDB just read an excel file which have to have the first row is header, and then data row.

My excel file is formatted to use 6 beginning rows for introduction (not have any data), row 7 as header, then below is data row.

I couldn't read the file...Please help me!

Thanks in advance.

Re: Problem with using OLEDB read excel file

Rob Graham4-Apr-07 5:44

Rob Graham

4-Apr-07 5:44

As you have discovered, Oledb will not handle that format. You will have to use the Excel automation / interop to handle that (bizarre) format.

Re: Problem with using OLEDB read excel file

kokain4-Apr-07 16:16

kokain

4-Apr-07 16:16

Thank you. Please give me hint about that...

Image.

nclauder4-Apr-07 4:46

nclauder

4-Apr-07 4:46

HI,
Which Data Type accepts both image and character in one sql column?
Thanks

Re: Image.

mghiassi4-Apr-07 6:15

mghiassi

4-Apr-07 6:15

You can store an address of image file and use a HyperLink in runtime

Re: Image.

Frank Kerrigan4-Apr-07 23:20

Frank Kerrigan

4-Apr-07 23:20

TEXT : but you have to encode the image data to base64 (ie text).

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

RowCount property cannot be set on a data-bound DataGridView control.

kindman_nb4-Apr-07 3:38

kindman_nb

4-Apr-07 3:38

I want to increase the no of rows to prevent the backcolor of the Grid View

When I tried to increase DataGridrows as :
If Me.DataGridView1.RowCount < 20 Then DataGridView1.RowCount = 20

the error message :
RowCount property cannot be set on a data-bound DataGridView control.

can I deal with that to increase no of rows

jooooo

Re: RowCount property cannot be set on a data-bound DataGridView control.

Rob Graham4-Apr-07 4:00

Rob Graham

4-Apr-07 4:00

Since the grid is bound to a dataset, the number of rows in the dataset determine what is displayed in the grid. Why not just change the backcolor of the grid to match the backcolor of a row?

Re: RowCount property cannot be set on a data-bound DataGridView control.

kindman_nb4-Apr-07 4:13

kindman_nb

4-Apr-07 4:13

you are right ..
but I made alternating rows color ,, and some cells has it's own backcolor ,, then I can't make a single color
I hope you are see

jooooo

Re: RowCount property cannot be set on a data-bound DataGridView control.

Rob Graham4-Apr-07 5:45

Rob Graham

4-Apr-07 5:45

I guess you are just out of luck then.

Re: RowCount property cannot be set on a data-bound DataGridView control.

Frank Kerrigan4-Apr-07 23:22

Frank Kerrigan

4-Apr-07 23:22

Use the ItemDataBound property on the Datagrid.

see this for more details

http://www.codeproject.com/aspnet/PrettyDatagrids.asp[^]

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

backup and restore Database

Maira K4-Apr-07 3:25

Maira K

4-Apr-07 3:25

hi,
I want to know if there is a way - other than backup and restore database - to transfer all the data from one database on the server to another on a local SQLServer. it has to be done daily, so that the manager will always have an updated copy of the data on his machine.

Thanks in advance

Re: backup and restore Database

kubben4-Apr-07 3:55

kubben

4-Apr-07 3:55

I guess you could set up replication to do this as well. It might be kind of a pain depending on the number of tables and things like that.

Hope that helps.
Ben

Re: backup and restore Database

Maira K4-Apr-07 4:03

Maira K

4-Apr-07 4:03

ok, thanks. but can you give me any site or reference so i can try the replication, because i don't know much about it,

thanks,

Re: backup and restore Database

Frank Kerrigan4-Apr-07 4:33

Frank Kerrigan

4-Apr-07 4:33

Have you tried using Google.

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Re: backup and restore Database

kubben4-Apr-07 4:37

kubben

4-Apr-07 4:37

Here's a Microsoft link so start off with:
http://msdn2.microsoft.com/en-us/library/ms151198.aspx[^]

Ben

Re: backup and restore Database

Aaron VanWieren4-Apr-07 4:50

Aaron VanWieren

4-Apr-07 4:50

How complicated is your database? You could use SMO and transfer to move the database to the new database. The transfer method is a little gimpy, but pro grammatically it allows you to move the entire database and relations to a different server.

_____________________________________________________________________

Our developers never release
code. Rather, it tends to escape, pillaging the countryside all around.

The Enlightenment Project (paraphrased comment)

Visit Me at GISDevCafe

SQL Date and Time Queries...

Illegal Operation4-Apr-07 1:51

Illegal Operation

4-Apr-07 1:51

I need some help.

I want to create a dropdownlist with the options "Day" "Week" and "Month". I need to write a stored procedure so that if the user selects "Day" then he only queries the day(Today), if he selects "Month" he must get the data for the month.

How will I go about doing this? I know I should use the If...Else or CASE in C#. I want to know how the Stored Procedure will look?

Thanks Guys !!! and GALS!!!

Illegal Operation

Making Computer Software Talk

Re: SQL Date and Time Queries...

Frank Kerrigan4-Apr-07 23:29

Frank Kerrigan

4-Apr-07 23:29

Here you go, this is really simple and you should consider doing better date arith with DAY using CONVERT

<br />
create proc myproc <br />
<br />
@Type as varchar(10)<br />
<br />
AS<br />
BEGIN<br />
<br />
if @Type = 'DAY'<br />
BEGIN<br />
  select * <br />
  from table<br />
  Where  YEAR(DATE)  = YEAR(getdate())<br />
     and MONTH(DATE) = MONTH(getdate())<br />
     and DAY(DATE)   = DAY(getdate()) <br />
END<br />
<br />
if @Type = 'MONTH'<br />
BEGIN<br />
  select * <br />
  from table<br />
  Where  YEAR(DATE)  = YEAR(getdate())<br />
     and MONTH(DATE) = MONTH(getdate())<br />
END<br />
<br />
<br />
if @Type = 'YEAR'<br />
BEGIN<br />
  select * <br />
  from table<br />
  Where  YEAR(DATE)  = YEAR(getdate())<br />
    <br />
END<br />
<br />
<br />
<br />
END<br />
go<br />
<br />

Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture)

http://www.frankkerrigan.com/[^]

Updating Database through datagrid

Raheem MA4-Apr-07 1:22

Raheem MA

4-Apr-07 1:22

Hi Friend'z...

I need to update the database tables though datagrid only.(in windows form c#).

How can I update the database through datagrid ? pl help me in doing this.

thanks in advance,

Re: Updating Database through datagrid

joon _vh.4-Apr-07 1:26

joon _vh.

4-Apr-07 1:26

is it a datagrid or datagridView?

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

Re: Updating Database through datagrid

Raheem MA4-Apr-07 1:37

Raheem MA

4-Apr-07 1:37

It is Datagrid,
i'm using Visual Studio.Net 2003
pl help me...

Transactions in a stored procedure

gauthee4-Apr-07 1:20

gauthee

4-Apr-07 1:20

Hi,

I have a sp where in few values would be passed as input parameters, now using these values insertion opertion should be done for 11 tables.

Now if anyone insert statement fails it need not perform the remaining insert statements.

What i've done:
begin transaction

insert
insert
insert
insert...
....
...
11statements total

if(@@error<>0)
rollback transaction
else
commit transaction

Is this correct! this is leading to some problems, like other users if trying to use any of the tables i used it is giving errors

Gautham

Re: Transactions in a stored procedure

joon _vh.4-Apr-07 1:35

joon _vh.

4-Apr-07 1:35

it seems correct to me, I always use

IF @@ERROR <> 0
BEGIN
    ROLLBACK TRANSACTION TRANS
END

COMMIT TRANSACTION TRANS

Visual Studio can't evaluate this, can you?

public object moo<br />
        {<br />
__get { return moo; }<br />
__set { moo = value; }<br />
}

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.