Re: Creating relationships among selfcreated tables - C# Discussion Boards

Re: Creating relationships among selfcreated tables

31-Oct-06 20:22

hello all.
i'm trying to create relationship among tables in a database. can anyone tell me how to create a one to one/ one to many/ many to many relationship between two tables. i'm trying to create them at runtime not statically.

please reply soon. Cry | :((

ur help will be greatly appreciated.
thanks

Russell Jones31-Oct-06 21:25

Russell Jones

31-Oct-06 21:25

hi there,

I'm not sure what you're trying to do here. Do you actually need the relationships created between the tables or are you just trying to query data using joins. I believe that each DB engine will have a slightly different way of creating things like relationships.

this is the code for sql2000

ALTER TABLE Person
ADD CONSTRAINT Person_AddressID
FOREIGN KEY (AddressID)
REFERENCES Address(AddressID)

HTH

Russ

Re: Creating relationships among selfcreated tables

Saira Tanwir31-Oct-06 22:03

Re: Creating relationships among selfcreated tables

31-Oct-06 22:03

thanks buddy for the idea.
however i'm encountering another problem.

i'm using the following sql query to display all information of a table.

string table_name1=comboBox1.Text;<br />
      string sql_query="DESCRIBE "+table_name1;<br />
<br />
	try<br />
	{<br />
	        cmd=new SqlCommand(sql_query,conn);<br />
		cmd.ExecuteNonQuery();<br />
	}<br />
	catch(SqlException ae)<br />
	{<br />
		MessageBox.Show(ae.Message.ToString());<br />
	}

the error i'm gettin is

could not find stored procedure 'DESCRIBE'

could u please guide me about this.
is there any error with the query??
i tried using the keyword DESC also but it still gives an error.

plz help

thanks

sam#31-Oct-06 22:45

Re: Creating relationships among selfcreated tables

31-Oct-06 22:45

Sql Server doesn't have any defination for Desc or Describe .use following query to get column information of a table

SELECT Column_Name, Data_TYPE FROM Information_Schema.Columns WHERE (TABLE_NAME = 'TableName')

sameer

Saira Tanwir31-Oct-06 23:22

Re: Creating relationships among selfcreated tables

31-Oct-06 23:22

hi
i want to get information of all columns of a table at once by only giving the table name in the query.
how can i do this.
one way of doing this is through stored procedures.
can anyone guide me about them, that where do i save the procedure and how do i call it ????

thanks and regards

sam#31-Oct-06 23:35

Re: Creating relationships among selfcreated tables

31-Oct-06 23:35

above query gives the the same result.

sameer

Russell Jones31-Oct-06 23:31

Russell Jones

31-Oct-06 23:31

which database engine are you using? this kind of code is often very DBMS specific.

if you are using SQL and are never likely to point your code at any other dbms i would recommens using the SQL SMO objects

Russell

Re: Creating relationships among selfcreated tables

Saira Tanwir31-Oct-06 23:33

location in c# program for creating object

31-Oct-06 23:33

i'm using SqlServer 2000 desktop edition.
and what object were u talking about D'Oh! | :doh:

yogita charhate31-Oct-06 20:01

yogita charhate

31-Oct-06 20:01

Good Morning,
I have to create object of c# class in aspx.cs class .
I'm not sure whether it is good to create instance of that class globaly or to create its instance in every evnt block in aspx.cs file.Which one would be efficient and good way of programming?Please guide.

yog
hui gfgh kgdgrt njjn hjgkn

Re: location in c# program for creating object

Haseeb Mukhtar31-Oct-06 20:14

Haseeb Mukhtar

31-Oct-06 20:14

Hello yogita ,

It depands on your working scenerio.

If its just class with some methods to call then I suggest to Create instance in every aspx but please dispose that object too.

If that class contains session or user information then you may use in global class.

Thank You.

Re: location in c# program for creating object

yogita charhate31-Oct-06 20:28

yogita charhate

31-Oct-06 20:28

Thank you.

yog
hui gfgh kgdgrt njjn hjgkn

How can I get MAC address of computers inlocal network in C# programming

samirawww31-Oct-06 19:54

samirawww

31-Oct-06 19:54

Re: How can I get MAC address of computers inlocal network in C# programming

Haseeb Mukhtar31-Oct-06 20:10

Haseeb Mukhtar

31-Oct-06 20:10

Hello Samira
Please Reffer http://www.codeguru.com/cpp/i-n/network/networkinformation/article.php/c5451/[^]

There are three differen methods provided or gettign mac address and it works good.

Thank You
Haseeb

Re: How can I get MAC address of computers inlocal network in C# programming

hswuzh17-May-09 21:54

hswuzh

17-May-09 21:54

WHAT？NO ANYONE！

How can I get MAC address of computers inlocal network

samirawww31-Oct-06 19:50

samirawww

31-Oct-06 19:50

Re: How can I get MAC address of computers inlocal network [modified]

Irfan Kothari1-Nov-06 1:48

Irfan Kothari

1-Nov-06 1:48

Hello Samira,

Here is a code with you can get the Mac adrress of local machine
i hope this will help full to you. Smile | :)

private static string GetMacAddress()
{
string macAddr = "";
try
{
ManagementClass mc = new ManagementClass("Win32_NetworkAdapter");
foreach (ManagementObject mo in mc.GetInstances())
{
macAddr = mo["MACAddress"] as string;
if (macAddr != null && macAddr.Trim() != "")
return macAddr;
}
}
catch (Exception exp)
{
}
Random ranGenerator = new Random(6);
macAddr = ranGenerator.Next(100000, 999999).ToString();
return macAddr;
}
Regards,
Irfan.

how to get installed browser plugins names of a pc

souravmoy sau31-Oct-06 19:02

souravmoy sau

31-Oct-06 19:02

hello
i have developed a desktop application in C#.net 2.0 where i need to retrieve all installed browser plugins names in the loacal machine.That means the application will retrieve all the installed browser plugin names from the pc where this application run.

Please helpme to find a way to retrive the installed plugin names.

Thanks and regards
Sourav

NEC MAC Address

Reader Man San31-Oct-06 18:51

Reader Man San

31-Oct-06 18:51

:|Hi,
can any one give me a win32 api and also a control or library that can get the NEC MAC address from the Hardware itself not from the registry. it will be good if it can be used in C#.

May god give u good health and knowledge.

Removing the Close button on Modal Dialog

bankai12331-Oct-06 18:06

bankai123

31-Oct-06 18:06

Hi, I'm wondering how I can remove the 'Close' button on a modal dialog. The reason is I don't want the user to accidentally close this partiulcar window, or at least display a confirmation to the user to ask whether if they really want to close it. I can't do that with the Form_Closing event as it stills closes it.

sam#31-Oct-06 18:26

31-Oct-06 18:26

write your code int Dispose Method.e.g

protected override void Dispose( bool disposing )<br />
		{<br />
                      // put your message here <br />
<br />
                        if(DialogResult.Yes==MessageBox.Show("Do you Want to quit?","Quit",MessageBoxButtons.YesNo))<br />
                       {<br />
			if( disposing )<br />
			{<br />
				if(components != null)<br />
				{<br />
					components.Dispose();<br />
				}<br />
			}<br />
			base.Dispose( disposing );<br />
                       }<br />
                        else<br />
                          return;<br />
		}<br />

bankai12331-Oct-06 18:31

bankai123

31-Oct-06 18:31

Thanks for the help!

Robert Rohde31-Oct-06 19:21

Robert Rohde

31-Oct-06 19:21

When the Form is getting disposed it is already closed. So this doesn't work. Dispose is about freeing resources - no more no less.

Robert

Robert Rohde31-Oct-06 19:23

Robert Rohde

31-Oct-06 19:23

Hi,

why can't you do this with the Closing event? This is exactly what it is meant for. Post some code. You have most probably some mistake in your code.

Robert

sam#31-Oct-06 19:33