Hi. i try a membership program with visual c# dotnet (vs.net 2005 beta). Here is the code. But i couldnt understand the problem at the beginning with red text. If anyone can help me.....
regards & thanks
Serkan
----------------------------------------------------------------------
using System;
using System.Data.SqlClient;
namespace serdar
{
SQLDMO.SQLServerClass srv; /* THERE IS A PROBLEM HERE. IT SAYS �A namespace does not directly contain members such as fields or methods�. I COULDNT UNDERSTAND. HOW CAN I USE A NAMESPACE FOR IT? */
SQLDMO.DatabaseClass db;
SQLDMO.TableClass tbl;
private void btnConnect_Click(object sender, System.EventArgs e)
{
srv=new SQLDMO.SQLServerClass();
srv.LoginSecure=false;
try
{
srv.Connect("CHN","serdar","serdar");
durumCubugu.Text="Sunucuya baglanildi..."+srv.Status.ToString();
}
catch(Exception hata)
{
MessageBox.Show(hata.Message);
}
}
private void btnVeritabaniOlustur_Click(object sender, System.EventArgs e)
{
try
{
db=new SQLDMO.DatabaseClass();
db.Name=this.txtVeritabaniAdi.Text;
srv.Databases.Add(db);
durumCubugu.Text=db.Name.ToString()+" veritabani "+srv.Name.ToString()+" SQL Sunucusunda olusturuldu";
}
catch(Exception hata)
{
MessageBox.Show(hata.Message);
}
}
private void btnTabloOlustur_Click(object sender, System.EventArgs e)
{
try
{
tbl=new SQLDMO.TableClass();
tbl.Name=txtTabloAdi.Text;
SQLDMO.ColumnClass dc;
dc=new SQLDMO.ColumnClass
dc.Name="ID";
dc.Datatype="Int";
dc.Identity=true;
dc.IdentitySeed=1000;
dc.IdentityIncrement=1;
tbl.Columns.Add(dc);
dc=new SQLDMO.ColumnClass();
dc.Name="ISIM";
dc.Datatype="char";
dc.Length=50;
tbl.Columns.Add(dc);
dc=new SQLDMO.ColumnClass();
dc.Name="SOYISIM";
dc.Datatype="char";
dc.Length=50;
tbl.Columns.Add(dc);
db.Tables.Add(tbl);
durumCubugu.Text=tbl.Name.ToString()+" olusturuldu...";
}
catch(Exception hata)
{
MessageBox.Show(hata.Message);
}
}
private void btnSunucuVeritabanlari_Click(object sender, System.EventArgs e)
{
this.lstDatabases.Items.Clear();
this.lstDatabases.Items.Add("Sunucudaki veritabani sayisi="+srv.Databases.Count);
for(int i=1;i<srv.Databases.Count;++i)
{
this.lstDatabases.Items.Add(srv.Databases.Item(i,srv).Name.ToString());
}
}
private void btnTablolar_Click(object sender, System.EventArgs e)
{
this.lstTabels.Items.Clear();
this.lstTabels.Items.Add("Tablo Sayisi="+srv.Databases.Item(this.lstDatabases.SelectedIndex,srv).Tables.Count.ToString());
for(int i=1;i<srv.Databases.Item(this.lstDatabases.SelectedIndex,srv).Tables.Count;++i)
{
this.lstTabels.Items.Add(srv.Databases.Item(this.lstDatabases.SelectedIndex,srv).Tables.Item(i,srv). Name.ToString());
}
}
}
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/Microsofts_C_Sharp/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
