Consolidation of database - Database Discussion Boards

Re: Like Query & Null Values

rich_wenger18-Sep-05 14:53

rich_wenger

18-Sep-05 14:53

Yes, but I'm not out of the woods yet. When I search on a combined string it (John Smith) it fails to return any rows.

use mySQL with c# applications

Sasuko16-Sep-05 0:55

Sasuko

16-Sep-05 0:55

Ehi guys,
i've tried in the past to make some application in c# that use ADO.NET with Databasa Access.
It is a quite easy stuff, but i know i can use mySQL database too.
I Have no idea in matter, so i don't know if i need during the develope mySQL engine daemon running on my pc and if it is needed also for the final user.
Then i don't know how create a database in this way, connect it to my application and working on.
Finally i don't know how include it in my solution.
Big thanks to everyone can jelp me.

Re: use mySQL with c# applications

enjoycrack16-Sep-05 1:32

enjoycrack

16-Sep-05 1:32

hi there,

Here are just some articles on CP site:
1. http://www.codeproject.com/dotnet/mysqlconnexion.asp
2. http://www.codeproject.com/cs/database/ConnectMySQL.asp#xx1105859xx

Hope that helps

<< >>

Re: use mySQL with c# applications

Sasuko16-Sep-05 4:05

Sasuko

16-Sep-05 4:05

ok tnx for your indication but is there someone that can contribuite?

Re: use mySQL with c# applications

André Ziegler17-Sep-05 11:55

André Ziegler

17-Sep-05 11:55

Why don't you use the MySQL Connector for .NET 1.0.5 from MySQL.com ?

Re: use mySQL with c# applications

Sasuko17-Sep-05 23:20

Sasuko

17-Sep-05 23:20

becouse i don't know it and how use. Smile | :)

Re: use mySQL with c# applications

André Ziegler18-Sep-05 1:14

André Ziegler

18-Sep-05 1:14

Hi,

here is the link: http://dev.mysql.com/downloads/connector/net/1.0.html

Downlaod and install the connector. After finishing the installation, you can use it like any other ADO.NET-Connector.

André

Consolidation of database

utsav_verma15-Sep-05 23:07

utsav_verma

15-Sep-05 23:07

Hi

The situation i m facing is - i have several databases of lower level shops which needed to be consolidated on regional level, shops' DB will be ported on the regional HQ n on the basis of databases imported, reports will be generated.

Well, do u guys have any experiance of such situation or if you can suggest me some link which describes such situation in form of case study or whatever.

Thanks in advance

Utsav Verma

Re: Consolidation of database

Hesham Amin16-Sep-05 2:49

Hesham Amin

16-Sep-05 2:49

This setuation seems to need replication
check this for information about SQL Server replication
http://www.mssqlcity.com/Articles/Replic/Replic.htm[^]

MSDE not connecting in windows 98

Nilesh Gambhava15-Sep-05 21:28

Nilesh Gambhava

15-Sep-05 21:28

I have made windows application using .NET 2.0 BETA 2.0(VC#) with MSDE(Release A) as database tool. Now when I install my application on Windows 2000,XP,2003, it works well. But When I install on Windows 98, application is not connecting to database..
On command prompt, using OSQL, I can list database, table and I can connect to database. But When I try to connect throught application using connection string then it does not work.
Please help me sorting out this problem.
Thanks
1) Connection String is same in all O.S. version and it is SQL Auth.
2) I wrote following things in setup.ini of MSDE
[OPTIONS]
SAPWD="NILESH"
INSTANCENAME="NILESH"
SECURITYMODE=SQL
3) In Windows 98, I have used MDAC 2.8

Nilesh Gambhava,
Life is NP-Complete so don't use Algorithm but use Heuristics

MSDE client tools

Ahsan Askare15-Sep-05 18:48

Ahsan Askare

15-Sep-05 18:48

Friends,
I've just installed MSDE in my machine for the first time. What i've seen is that it only installed Server and no client tools, unlike SQL server 2000.

Are there any client tools available for MSDE (like Enterprise Manager or query analyzer of SQL-server 2000). If not, then how can i manipulate the database of MSDE and create or view databases??

Ahsan

Re: MSDE client tools

enjoycrack15-Sep-05 22:46

enjoycrack

15-Sep-05 22:46

hi there,

have a look at on these:
1.http://www.visoracle.com/ada/bmg.html
2.http://www.itlocation.com/en/software/prd53603,,.htm

remember the google uncle.

<< >>

Re: MSDE client tools

Michael P Butler16-Sep-05 1:54

Michael P Butler

16-Sep-05 1:54

If you have a licence for the Sql server client tools, then you can use that.

Otherwise you are stuck with the commandline tools or 3rd party applications.

I like to use this[^] when I'm working with MSDE. Not as friendly as the MS tools but does the job well.

Michael

CP Blog [^] Development Blog [^]

Fastest way to copy table in SQLServer 2000

mikker_12315-Sep-05 15:46

mikker_123

15-Sep-05 15:46

Let's presume I have Table1 and Table2 already created and with same strucuture. Table1 has all data. So is this fastest way to copy data:

INSERT INTO Table2
SELECT * FROM Table1

?

Tnx

Re: Fastest way to copy table in SQLServer 2000

Alomgir Miah15-Sep-05 17:24

Alomgir Miah

15-Sep-05 17:24

I think this is the fastest. You can try comparing the performance with

SELECT * INTO Table2 FROM Table1

Live Life King Size
Alomgir Miah

Re: Fastest way to copy table in SQLServer 2000

Andy Brummer15-Sep-05 17:26

Andy Brummer

15-Sep-05 17:26

If they are in the same database this should be the fastest or close to it.
If you have the transaction log configured to not log it, then using SELECT * INTO Table2 will create table2 and won't be logged which is faster.

I can imagine the sinking feeling one would have after ordering my book,
only to find a laughably ridiculous theory with demented logic once the book arrives - Mark McCutcheon

Is there any one to HELP ME!!

mostafa_h15-Sep-05 8:06

mostafa_h

15-Sep-05 8:06

Hi All!
I have a variable in Form1 named:GetID(int) and everytime I run Myapplication , its value maybe vary Like 2 or 9 or 5 or ...

THIS variable is in btnOK_Click() :
here is my code in Form1:

..... 
public int GetID; 
.... 
public void btnOK_Click(object sender, System.EventArgs e) 
{ 
..... 
GetID=Convert.ToInt32(UserTable.Rows[0][0]); 
.... 
}

I want to put (this value=GetID) into the another variable in Form2 that named :MyGetID in Form2_Load():
Here is my code on form2:

....... 
Form1 myform1=new Form2(); 
........ 
private void Form2_Load(object sender, System.EventArgs e) 
{ 
int MyGetID;
MyGetID=:zzz:(?GetID); 
.... 
... 
}

infact I want to put the value of GetID(the variable in Form1) into the MyGetID(The variable in Form2)
How Can I do it ...?
Please Help me!
thanks!

mostafa hosseiny b.

Re: Is there any one to HELP ME!!

ACMJ15-Sep-05 8:48

ACMJ

15-Sep-05 8:48

Many ways, all depends on timing... When do you need the value exactly Wink | ;-)

Static variable in form1..

public static int x;<br />
myID = form1.x;

or

Change the form2 constructor, declare a local private variable.
(Note: you can have multiple constructors).

Class Form2{<br />
    private int var;<br />
    Form2(int x){<br />
       var = x;<br />
    }<br />
}

in form1 create as

form2 f = new form2(x);

or

as a property
public int x{get(...)set(...)}

Hope that helps.

Re: Is there any one to HELP ME!!

mostafa_h16-Sep-05 2:37

mostafa_h

16-Sep-05 2:37

hi,dear friend!
Via to:

public static int x;
myID = form1.x;

because of "x" is variable in a Event(btnOK_Click()),
,myGetID return a value=0(Zero),
but,using a property in form1 and form2 , I can solve the problem .
thanks again!
yours!

mostafa hosseiny b.

T-SQL Problem

WDI15-Sep-05 2:09

WDI

15-Sep-05 2:09

Hi
I have a select statement that returns (A int ,B int)
and another select statement that returns (C int , D int)
in a storedprocedure.
I need that sp returns a resultset as (A,B,C,D);
What should i do plz?

Re: T-SQL Problem

miah alom15-Sep-05 3:44

miah alom

15-Sep-05 3:44

You can combine the two queries as following,

select Select1.A, Select1.B, Select2.C, Select2.D
from
(select A, B from Table1) as Select1,
(select C, D from Table2) as Select2

Please note that this will give you the cross product.

Re: T-SQL Problem

Shawn_H17-Sep-05 5:20

Shawn_H

17-Sep-05 5:20

if they are scalar values you are dealing with then just do this.

<br />
declare @a int,<br />
@b int,<br />
@c int,<br />
@d int<br />
select @a = 1, @b= 2<br />
<br />
select @c = 3, @d= 4<br />
<br />
select @a as ColA, @b as ColB, @c as ColC, @d as ColD

Else, if it is a rowset, then do what alam_pune said,
but pull a join column from each of the sub selects in
order to join the rowsets to avoid the cartesian product

<br />
<br />
select Select1.A, Select1.B, Select2.C, Select2.D<br />
from<br />
(select A, B, PriKeyCol from Table1) as Select1<br />
	inner join<br />
(select C, D, ForKeyCol from Table2) as Select2 on select1.PriKeyCol = select2.ForKeyCol

conversion of crystal reports to sql server reports

Ashuu15-Sep-05 0:25

Ashuu

15-Sep-05 0:25

Hi ,
I have around 400 of crystal reports and have been asked to convert them to sql reports using sql 2005 reporting services. I am little puzzled whether is this possible through any tool or I would have to convert it one by one.

Please help

Ashu Sharma
SSE

[Message Deleted]

mostafa_h14-Sep-05 20:54

mostafa_h

14-Sep-05 20:54

[Message Deleted]

Re: SOS!!!

enjoycrack14-Sep-05 22:48

enjoycrack

14-Sep-05 22:48

hi there,

to access the variable GetID of form1 from form2, u have to pass the reference of form1 to form2

Hope this helps

<< >>

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