Re: datagridview in tabcontrol! - Database Discussion Boards

E_Gold26-Sep-09 8:25

26-Sep-09 8:25

hi
how i can run this:

select * from men where Tdate between 01/01/01 and 02/02/02

but, Tdate is nvarchar type

i work with sqlCE

thank's

Re: run date query in nvarchar type, how ?

Luc Pattyn26-Sep-09 10:10

Luc Pattyn

26-Sep-09 10:10

Hi,

I would convert the string to a real datetime using convert(datetime, Tdate), then use that in a WHERE clause.
it could be something like ... where convert(datetime, Tdate, 1)>='01/01/01' and convert(datetime, Tdate, 1)<='02/02/02'

The '1' code specifies the format, see here[^].

I would also suggest to STORE dates as such, not as strings.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: run date query in nvarchar type, how ?

Mycroft Holmes26-Sep-09 15:07

Mycroft Holmes

26-Sep-09 15:07

Luc has given you the solution but he was not forceful enough on storing the data as a datetime data type. If you do not change your data format to datetime then you will continiously run into this problem and all the associated datetime issues we see here regularly.

STORE YOUR DATA IN THE RIGHT FORMAT.

Never underestimate the power of human stupidity
RAH

Re: run date query in nvarchar type, how ?

Luc Pattyn26-Sep-09 16:44

Luc Pattyn

26-Sep-09 16:44

Mycroft Holmes wrote:
he was not forceful enough

Sorry, I must be having an off-day then.

Smile | :)

Luc Pattyn

Local announcement (Antwerp region): Lange Wapper? Neen!

Re: run date query in nvarchar type, how ?

Mycroft Holmes26-Sep-09 17:51

Mycroft Holmes

26-Sep-09 17:51

As we are no longer encouraged to beat them with the sarcasm stick Sigh | :sigh:

, I see no reason not to scream it in their face.

Never underestimate the power of human stupidity
RAH

Re: run date query in nvarchar type, how ?

Richard MacCutchan26-Sep-09 22:00

Richard MacCutchan

26-Sep-09 22:00

Mycroft Holmes wrote:
As we are no longer encouraged to beat them with the sarcasm stick Sigh , I see no reason not to scream it in their face.

Even though neither method has the desired effect in too many cases Mad | :mad:

datagridview in tabcontrol!

jeshra27925-Sep-09 18:31

jeshra279

25-Sep-09 18:31

hi everyone,
I have a tab control with 3 tabs, A,B,C.
I have one one database "student" in which i have 4 columns.
There are two datagridviewB and datagridviewC in the two tabs B and C.
I am updating the entries of a datagridviewB by entering details in a form present in Tab A.

Now when I am working in tab C to update the datagridviewC, say for example filtering "student" database and displaying filtered results in datagridviewC; while updating datagridviewC, I noticed that datagridviewB in tab B also getting updated.
My code for filter "student" database in tab C is like this:

cmd = New SqlCommand("SELECT * FROM student WHERE [Name] <= '" + name + "'", con)
myDA = New SqlDataAdapter(cmd)
myDataSet = New DataSet()

myDA.Fill(myDataSet, "student")
datagridviewC.DataSource = myDataSet.Tables("student").DefaultView

Can someone tell me, how to update the datagridviewC in tab C without altering the entries present in datagridviewB in tab B?
FYI : my datagridviewB contains all the student data and in tab C i am filtering the database based on "Name" and displaying in datagridviewC.

Re: datagridview in tabcontrol!

Mycroft Holmes26-Sep-09 15:12

Mycroft Holmes

26-Sep-09 15:12

If your datasource for the datagridviews is the same then naturally the data is the same. You can separate the datasources into bindingsources or copy the dataview to a new table for each datagridview.

BTW this should be in the Windows Forms forum.

Never underestimate the power of human stupidity
RAH

Take a databse back up with LINQ ?

Mohammad Dayyan25-Sep-09 15:58

Mohammad Dayyan

25-Sep-09 15:58

Hi guys.
I'm using LINQ to modify a database.
I want to take a back up from the database.

Could you please guide me , how I can do it with LINQ ?

Re: Take a databse back up with LINQ ?

Not Active25-Sep-09 17:19

Not Active

25-Sep-09 17:19

You don't need Linq to backup a database. What is it that you want to accomplish?

only two letters away from being an asset

Re: Take a databse back up with LINQ ?

Mohammad Dayyan25-Sep-09 17:26

Mohammad Dayyan

25-Sep-09 17:26

I've created a SQL database beside my exe file, I'm trying to take backup from it through my application.
At first , I've used File.Copy, but I receive this Exception cannot access because it is being used by another process

Could you guide me, how I can do it ?

Re: Take a databse back up with LINQ ?

Not Active26-Sep-09 5:05

Not Active

26-Sep-09 5:05

Mohammad Dayyan wrote:
cannot access because it is being used by another process

Perhaps your application? If the app uses a mdf file as a resource then it is possibly loading the file at start up. That should give you a start of where to look.

only two letters away from being an asset

Re: Take a databse back up with LINQ ?

Abhishek Sur26-Sep-09 6:48

Abhishek Sur

26-Sep-09 6:48

Run normal backup code from your application, rather than to use File.Copy. File.Copy needs the mdf files to be detached from your server instance which is not good technique.

BACKUP DATABASE [DbName] TO  DISK = N'C:\dbName.bak' WITH NOFORMAT, NOINIT,  NAME = N'DbName-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

Just change the dbName, disk location for your backup and Name of the Backup file and run this using command.ExecuteNonQuery().

And believe me... you dont require LINQ for doing this . Big Grin | :-D

Abhishek Sur

My Latest Articles
Create CLR objects in SQL Server 2005
C# Uncommon Keywords
Read/Write Excel using OleDB
Don't forget to click "Good Answer" if you like to.

Re: Take a databse back up with LINQ ?

Mohammad Dayyan26-Sep-09 7:54

Mohammad Dayyan

26-Sep-09 7:54

Thanks Abhishek Sur.
I'm using LINQ, so I've used the following code :

public static void GetBackUp()
{
    if (!Directory.Exists(StaticVariables.BackUPFolder))
        Directory.CreateDirectory(StaticVariables.BackUPFolder);

    using (RezaRestaurant.SQL.DataClasses1DataContext dbc = new RezaRestaurant.SQL.DataClasses1DataContext())
    {
        dbc.ExecuteCommand(@"BACKUP DATABASE " + dbc.Mapping.DatabaseName + " TO DISK='c:\aaa.bak'");//Exception
    }
}

and this Exception has occurred :
http://www.codeguru.com/forum/attachment.php?attachmentid=25454&d=1253973435[^]

Convert scripts for Postgresql to SQL Server

Not Active25-Sep-09 5:32

Not Active

25-Sep-09 5:32

I have a project to convert a database from Postgresql to SQL Server. I know of tools to convert the database from one to the other but all I have are scripts right now. Does anyone know of a utility that can take scripts created for Postgresql and create a SQL Server database from them?

only two letters away from being an asset

Re: Convert scripts for Postgresql to SQL Server

Mycroft Holmes26-Sep-09 15:16

Mycroft Holmes

26-Sep-09 15:16

Depending on the size of the database it would almost be worth installing postgre just to use the conversion tools. I'm assuming they have an express type product.

Never underestimate the power of human stupidity
RAH

Re: Convert scripts for Postgresql to SQL Server

Not Active26-Sep-09 15:21

Not Active

26-Sep-09 15:21

There is no express version but I already have Postgresql installed. The problem in the scripts I've been provided with won't run. I wanted to try converting them to TSQL and running them against SQL Server directly since the ultimate goal is to port it to SQL Server anyway.

only two letters away from being an asset

Re: Convert scripts for Postgresql to SQL Server

Mycroft Holmes26-Sep-09 15:45

Mycroft Holmes

26-Sep-09 15:45

Sounds like a hand job to me Laugh | :laugh:

That my double entendre for today....

I'd try splitting the scripts to types ie tables, procs and views, see if there are any standard conversions and try running them individually. Sounds like a LOT of work even if there are no constraints and key involved. I'd go back to the client and try and get a backup.

Never underestimate the power of human stupidity
RAH

Re: Convert scripts for Postgresql to SQL Server

Not Active27-Sep-09 3:40

Not Active

27-Sep-09 3:40

Mycroft Holmes wrote:
I'd go back to the client and try and get a backup.

Trying. Unfortunately, I've taken over this project after the original team's failure. They are uncooperative to the point of potential legal actions by the client. I had the suspicion that it would a tedious manual process but had ask just in case.

only two letters away from being an asset

Re: Convert scripts for Postgresql to SQL Server

Tim Carmichael28-Sep-09 6:54

Tim Carmichael

28-Sep-09 6:54

As others have said, this is going to be a tedious manual process.
I work with Ingres and SQLServer on almost a daily basis; Ingres isn't PostreSQL, but I'm assuming it isn't too far off either.

If you have the scripts to create tables, etc, can you write a script to extract the table name, columns, datatypes and null settings? Having these, you should then be able to script the tables creation in SQLServer.

I will help as I can.

Tim

Synchronization

Shalini_U25-Sep-09 2:04

Shalini_U

25-Sep-09 2:04

I want to Synchronize two Database in two server in sql server 2008. Database Mirroring is not working for me... I've created Master key, Certificate, endpoints... Everything is perfect.. But, even though, the Mirroring is not working.. Is there any other way to attain synchronization... Plz, Anybody Could help me???

Problem connecting to sql server 2008 database from sql server 2005 express..

Nada Adel25-Sep-09 1:19

Nada Adel

25-Sep-09 1:19

I have a sql server 2008 database installed on windows server 2008, I enabled remote access to it and enabled TCP/IP and added rules for the TCP/IP port on the firewall exceptions and I restarted all sql server services.
I try to connect to the database from my pc remotely using the sa account but it fails.
I even created a new user account and tried to connect using this account but also fails.
What am I missing?
Do I have to download sql server 2008 on my pc to connect to the database remotely instead of sql server 2005?

can someone help me out?

Re: Problem connecting to sql server 2008 database from sql server 2005 express..

Vimalsoft(Pty) Ltd25-Sep-09 1:44

Vimalsoft(Pty) Ltd

25-Sep-09 1:44

What is the Error that you Receive ?

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: Problem connecting to sql server 2008 database from sql server 2005 express..

Henry Minute25-Sep-09 2:03

Henry Minute

25-Sep-09 2:03

Nada Adel wrote:
Do I have to download sql server 2008 on my pc to connect to the database remotely instead of sql server 2005?

I believe that you do. Given that it should not take too long, depending on the speed of your connection, I would try that. The reason I say that is because I have 2005 and 2008, on two different PCs and 2005 will not connect to a copied 2008 database.

However, as Vuyiswa Maseko asked, do you get an error message? The answer to that might help to pin down the problem.

Henry Minute

Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”

Re: Problem connecting to sql server 2008 database from sql server 2005 express..

Nada Adel25-Sep-09 2:25

Nada Adel

25-Sep-09 2:25

An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: TCP Provider, error: 0 -

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