Click here to Skip to main content
12,358,863 members (60,016 online)
   

Database

 
QuestionRe: Staging Area Pin
Phanindra26116-Nov-12 8:11
memberPhanindra26116-Nov-12 8:11 
AnswerRe: Staging Area Pin
mark merrens16-Nov-12 8:34
membermark merrens16-Nov-12 8:34 
AnswerRe: Staging Area Pin
Mycroft Holmes16-Nov-12 15:20
memberMycroft Holmes16-Nov-12 15:20 
GeneralRe: Staging Area Pin
S Douglas27-Nov-12 19:38
memberS Douglas27-Nov-12 19:38 
GeneralRe: Staging Area Pin
Mycroft Holmes27-Nov-12 20:31
memberMycroft Holmes27-Nov-12 20:31 
GeneralRe: Staging Area Pin
S Douglas29-Nov-12 7:52
memberS Douglas29-Nov-12 7:52 
Questionfirst linq for entity frame work? Pin
Member 875182715-Nov-12 1:02
memberMember 875182715-Nov-12 1:02 
AnswerRe: first linq for entity frame work? Pin
digimanus15-Nov-12 3:17
memberdigimanus15-Nov-12 3:17 
QuestionBEGIN TRANSACTION AND COMMIT TRANSACTION Pin
vanikanc14-Nov-12 7:40
membervanikanc14-Nov-12 7:40 
AnswerRe: BEGIN TRANSACTION AND COMMIT TRANSACTION Pin
Phanindra26114-Nov-12 8:40
memberPhanindra26114-Nov-12 8:40 
QuestionFault Exception in WCF Services Pin
Phanindra26114-Nov-12 6:15
memberPhanindra26114-Nov-12 6:15 
AnswerRe: Fault Exception in WCF Services Pin
Eddy Vluggen14-Nov-12 6:36
memberEddy Vluggen14-Nov-12 6:36 
GeneralRe: Fault Exception in WCF Services Pin
Phanindra26114-Nov-12 8:05
memberPhanindra26114-Nov-12 8:05 
QuestionRelation multiple table using in C# Pin
YBG13-Nov-12 2:53
memberYBG13-Nov-12 2:53 
Hi All ... in my form app. i have textboxs related databindings yonet_ogrt and I have 2 datagridview yonet_prg
and yonet_nbt.. so I want to all together navigate but textboxs and datagridview related yonet_prg is working but
datagridview related yonet_nbt not working... this is my trouble...
My code like this...

public void vt_iliski()
{
try
{
string sorgu_ogretmen = "select * from ogretmen";
string sorgu_program = "select * from program";
string sorgu_nobet = "select * from nobet";


ds_gnd = new DataSet();
DataTable tablo = new DataTable();
adpt_ogrt = new SqlCeDataAdapter(sorgu_ogretmen, baglan());
adpt_prg = new SqlCeDataAdapter(sorgu_program, baglan());
adpt_nbt = new SqlCeDataAdapter(sorgu_nobet, baglan());

adpt_ogrt.Fill(ds_gnd, "ogretmen");
adpt_prg.Fill(ds_gnd, "program");
adpt_nbt.Fill(ds_gnd, "nobet");

/* ********** relation -1 ****************** */

DataColumn ogrt_kolon = ds_gnd.Tables["ogretmen"].Columns["ogrt_ID"];
DataColumn prg_kolon = ds_gnd.Tables["program"].Columns["ogrt_ID"];

iliski1 = new DataRelation("Ogretmen_To_Program", ogrt_kolon, prg_kolon);


ForeignKeyConstraint kisitla = new ForeignKeyConstraint(ogrt_kolon, prg_kolon);

kisitla.UpdateRule = Rule.Cascade;
kisitla.DeleteRule = Rule.Cascade;
kisitla.AcceptRejectRule = AcceptRejectRule.Cascade;

ds_gnd.Tables["program"].Constraints.Add(kisitla);
ds_gnd.EnforceConstraints = true;

ds_gnd.Relations.Add(iliski1);

yonet_ogrt = new BindingSource(ds_gnd, ds_gnd.Tables["ogretmen"].ToString());
yonet_prg = new BindingSource(yonet_ogrt, "Ogretmen_To_Program");



/* ********** relation-2 ****************** */
DataColumn prg_kolon_nobet = ds_gnd.Tables["program"].Columns["prg_ID"];
DataColumn nobet_kolon = ds_gnd.Tables["nobet"].Columns["prg_ID"];

iliski2 = new DataRelation("Program_To_nobet",prg_kolon_nobet , nobet_kolon );


ForeignKeyConstraint kisitla2 = new ForeignKeyConstraint(prg_kolon_nobet, nobet_kolon);


kisitla2.UpdateRule = Rule.Cascade;
kisitla2.DeleteRule = Rule.Cascade;
kisitla2.AcceptRejectRule = AcceptRejectRule.Cascade;

ds_gnd.Tables["nobet"].Constraints.Add(kisitla2);
ds_gnd.EnforceConstraints = true;

ds_gnd.Relations.Add(iliski2);

yonet_prg = new BindingSource(ds_gnd, ds_gnd.Tables["Program"] .ToString());

yonet_nbt = new BindingSource(yonet_prg , "Program_To_nobet");

}
catch (Exception hata)
{
MessageBox.Show("Okul Günlük Nöbet Defteri iliskilendirme Hatasi olustu : " + hata.Message + " " + hata.StackTrace );

}

finally
{
baglanti.Dispose();
adpt_ogrt.Dispose();
adpt_prg.Dispose();
adpt_nbt.Dispose();

}
AnswerRe: Relation multiple table using in C# Pin
Phanindra26114-Nov-12 8:23
memberPhanindra26114-Nov-12 8:23 
QuestionTrying to get a MySQL subquery to return multiple records Pin
SQL Ed12-Nov-12 8:19
memberSQL Ed12-Nov-12 8:19 
AnswerRe: Trying to get a MySQL subquery to return multiple records Pin
Eddy Vluggen12-Nov-12 11:33
memberEddy Vluggen12-Nov-12 11:33 
QuestionSending data to database Pin
Phanindra26111-Nov-12 19:03
memberPhanindra26111-Nov-12 19:03 
AnswerRe: Sending data to database Pin
jschell12-Nov-12 10:08
memberjschell12-Nov-12 10:08 
AnswerRe: Sending data to database Pin
Mycroft Holmes12-Nov-12 12:51
memberMycroft Holmes12-Nov-12 12:51 
GeneralRe: Sending data to database Pin
Phanindra26113-Nov-12 18:40
memberPhanindra26113-Nov-12 18:40 
QuestionHow to create reports effectively Pin
Frygreen9-Nov-12 0:52
memberFrygreen9-Nov-12 0:52 
AnswerRe: How to create reports effectively Pin
David Mujica9-Nov-12 2:32
memberDavid Mujica9-Nov-12 2:32 
AnswerRe: How to create reports effectively Pin
Mycroft Holmes9-Nov-12 4:08
memberMycroft Holmes9-Nov-12 4:08 
AnswerRe: How to create reports effectively Pin
Frygreen9-Nov-12 4:10
memberFrygreen9-Nov-12 4:10 
Suggestionsql server 2008 security Pin
Member 36227527-Nov-12 8:00
memberMember 36227527-Nov-12 8:00 
GeneralRe: sql server 2008 security Pin
Mycroft Holmes7-Nov-12 11:27
memberMycroft Holmes7-Nov-12 11:27 
GeneralRe: sql server 2008 security Pin
jschell8-Nov-12 8:56
memberjschell8-Nov-12 8:56 
QuestionHelp me my Sql expired Pin
mehdi_nassiri00986-Nov-12 10:03
membermehdi_nassiri00986-Nov-12 10:03 
AnswerRe: Help me my Sql expired Pin
Jörgen Andersson6-Nov-12 10:22
memberJörgen Andersson6-Nov-12 10:22 
AnswerRe: Help me my Sql expired Pin
Joy Sinha22-Nov-12 20:09
memberJoy Sinha22-Nov-12 20:09 
QuestionADO.NET Pin
M.T.H.Danish6-Nov-12 6:25
memberM.T.H.Danish6-Nov-12 6:25 
AnswerRe: ADO.NET Pin
Richard MacCutchan6-Nov-12 7:28
mvpRichard MacCutchan6-Nov-12 7:28 
AnswerRe: ADO.NET Pin
Eddy Vluggen6-Nov-12 9:18
memberEddy Vluggen6-Nov-12 9:18 
GeneralADO.NET Pin
M.T.H.Danish6-Nov-12 6:11
memberM.T.H.Danish6-Nov-12 6:11 
AnswerRe: ADO.NET Pin
ihoecken6-Nov-12 6:27
memberihoecken6-Nov-12 6:27 
QuestionSQL SERVER 2008 Pin
M.T.H.Danish6-Nov-12 2:49
memberM.T.H.Danish6-Nov-12 2:49 
AnswerRe: SQL SERVER 2008 Pin
David Mujica6-Nov-12 3:27
memberDavid Mujica6-Nov-12 3:27 
AnswerRe: SQL SERVER 2008 Pin
J4amieC6-Nov-12 3:31
memberJ4amieC6-Nov-12 3:31 
AnswerRe: SQL SERVER 2008 Pin
djj556-Nov-12 4:43
memberdjj556-Nov-12 4:43 
AnswerRe: SQL SERVER 2008 Pin
Michael Potter6-Nov-12 4:47
memberMichael Potter6-Nov-12 4:47 
GeneralAwesome solution Pin
David Mujica6-Nov-12 8:39
memberDavid Mujica6-Nov-12 8:39 
GeneralRe: Awesome solution Pin
Srini Sydney14-Nov-12 11:24
memberSrini Sydney14-Nov-12 11:24 
GeneralRe: SQL SERVER 2008 Pin
Mycroft Holmes6-Nov-12 12:11
memberMycroft Holmes6-Nov-12 12:11 
GeneralRe: SQL SERVER 2008 Pin
Michael Potter7-Nov-12 5:23
memberMichael Potter7-Nov-12 5:23 
SuggestionRe: SQL SERVER 2008 Pin
Eddy Vluggen7-Nov-12 5:47
memberEddy Vluggen7-Nov-12 5:47 
GeneralRe: SQL SERVER 2008 Pin
Michael Potter8-Nov-12 8:54
memberMichael Potter8-Nov-12 8:54 
GeneralRe: SQL SERVER 2008 Pin
Eddy Vluggen8-Nov-12 8:57
memberEddy Vluggen8-Nov-12 8:57 
GeneralRe: SQL SERVER 2008 Pin
Mycroft Holmes7-Nov-12 11:25
memberMycroft Holmes7-Nov-12 11:25 
QuestionException in Win 7 while trying to connect the application to Access DB. Pin
rskuchimanchi6-Nov-12 1:52
memberrskuchimanchi6-Nov-12 1:52 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 30 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid