|
Consider two tables as follows.
1)
Parenttable--------------(tablename)
code description-------------(column names)
1111 Red
1112 Blue
1113 Green
1114 Purple
1115 Yellow
2)
childtable---------------------(tablename)
code customer qty address -------------(column names)
1111 Kmart 3 fdsf
1112 Myer 4 ujjjjj
1111 Myer 5 gfjsfs
1111 BigW 2 hsvfs
1112 Kmart 12 sugs
1113 Coles 432 ssghs
1113 Myer 2 rfweq
1115 SafeWay 7 eepoo
1114 Biggg 788 uhff
create these two tables in a xml file and read it to a dataset. create a relation ship for item code column. Now I have to add two datagrids in the program.Add data biniding for both the grids.
Andshould bind one grid to parent table and bind one grid to child table. using dataviewmanager I have to do this. Now implement the binding context
And add a button to your form in the click event of that button increase the binding context by 1.
then u will see that according to parents table's code in the grid it will show only that items i n the child table grid..
This is my requirement.
I have created 2 xml files with the data and added 2 datgrids.
Private DataSet ds= new DataSet()
Private void fngetconnected()
{
DataSet xml1 = new DataSet();
xml1.ReadXml("C:\\relation\\parentable.xml");
DataTable dt1 = xml1.Tables["parenttable"].Copy();
DataSet xml2 = new DataSet();
xml2.ReadXml("C:\\relation\\childtable.xml");
DataTable dt2 = xml2.Tables["childtable"].Copy();
ds.Tables.Add(dt1);
ds.Tables.Add(dt2);
DataColumn parentCol = ds.Tables["parenttable"].Columns["code"];
DataColumn childCol = ds.Tables["childtable"].Columns["code"];
DataRelation relTable1Table2;
relTable1Table2 = new DataRelation("parentchild", parentCol, childCol);
ds.Relations.Add(relTable1Table2);
//Create Dataview setting for each table
//using DataView Manager
DataViewManager myDVM = new DataViewManager(ds);
myDVM.DataViewSettings["parenttable"].Sort = "code DESC";
myDVM.DataViewSettings["childtable"].Sort = "code Desc";
dataGrid1.SetDataBinding(myDVM, "parenttable");
dataGrid2.SetDataBinding(myDVM, "childtable");
}
I have added 2 datagrids and vreated a relation and set databinding to two grids such that one grid shows parenttable and another shows childtable.
Now I have to add a button and when clicked, I have to see that according to parents table's code in the grid it will show only that items i n the child table grid..using binding context.
How to do this.Pls anyone help to do this.
j o h n
|
|
|
|
|
Is it possible to "Cast Down" in C#? If so, does anyone have any examples? Thanks in advance.
Dizzle
|
|
|
|
|
You mean this: Convert Class[^]?
Hope this helps.
Good luck.
No hurries, no worries.
|
|
|
|
|
Just use the normal casting operator. Like this
string s = "Senthil Rocks";
object obj = s;
string s2 = (string) obj;
If you want to safely cast down, you can use the is and as operators.
Regards
Senthil
_____________________________
My Blog | My Articles | WinMacro
|
|
|
|
|
Thanks for everyone's help.
|
|
|
|
|
Hi,
I'm creating a C# win app with a rather large Resource Assembly (many small movies), so I don't want the resources to be installed on the harddisk. Rather on runtime I want to extract some resources from the assembly and save it somewhere in a temp dir on the hard disk. After using it, it will be deleted from the harddisk.
Is it possible to access resource assemblies that reside on a CD? and if yes how? If no, what would be another good way to store these resources on the disk, but not in a way that just any user can copy the movies from the disk and distribute them without our permission?
Thanks!!
|
|
|
|
|
You say they're videos..If the routines you're using to play them are capable of taking byte[]'s, you could store the videos in an arbitrary binary format....What I mean is you can perhaps create a struct that holds a string describing the video and a byte[] that has the actual video data, then serialize that out to a binary file...Your customers would probably have a hard time getting anything out of that.
|
|
|
|
|
Great, I'll give it a try.
|
|
|
|
|
If you get stuck with serializing the struct's out to a binary file, I can help you with some marshalling code that will give you a byte[] from pretty much anything.
--SeveredCross
|
|
|
|
|
Hi,
I sometimes get an OutOfLicenseException when I call a report on a server through a thin client app.
Searched google and cp, but no luck getting a descent answer.
There could be several users calling for reports at the same time.
the licenses are correctly installed (we ran into that one earlier )
Does anyone know a solution to this? Do we need to upgrade?
tnx!
No hurries, no worries.
|
|
|
|
|
Hello i'm having a problem with the following code fragment:
//----------------------------------------------------------------------
//loop through each sub directory in the current dir
//and look for each folders contained in folders array
foreach(DirectoryInfo subDir in dirs)
{
//this line eliminates an IO error, although I dont know why it is an error
if (subDir.ToString().Equals("System Volume Information"))
Console.WriteLine();
else
{
for (int i =0; i < 7; i++)
{
currentFolder = folders[i];
if (subDir.Exists)//make sure directory exists
{
subDir.GetDirectories("*" + currentFolder + "*");
Console.WriteLine(subDir.ToString());
subDir.Equals(null);
} //end if
} //end for
}//end else
}//end foreach
//recursive statements
DirectoryInfo[] subDirs = dirInfo.GetDirectories();
for (int i = 0; i < subDirs.Length; i++)
{
String dirName = subDirs[i].FullName.ToString();
findFolders(dirName);
}
}//end method
//---------------------------------------------------------------------
Basically it should search the directory hierarchy and ouput to the console the names of the directories that match search criteria contained in the array []folders. Problem is it returns the entire directory hierarchy!!
CAN ANYONE HELP ME!!!!
|
|
|
|
|
hi to all,
i have a c# win application, how can i get the user connected to windows xp ?
i want to put this user in the connection form of my application.
best regards and thanks in advance
fady
|
|
|
|
|
If you want to get just a user name you can use static property UserName of Environment class:
String userName = Environment.UserName
or you can use this:
Thread.CurrentPrincipal.Identity
hth
"We contend that for a nation to try to tax itself into prosperity is like a man standing in a bucket and trying to lift himself up by the handle." — Winston Churchill
|
|
|
|
|
HI! does anyone out there knows what dll is needed in order to
export a crystal report file to a txt file.
i wrote this code, i can only export report to
"PDF, Excel, Word Doc, RTF Doc,HTML 3.2, HTML 4.0 or CrystalReport"
// The path/location where the exported file will be saved
string exportFilePath = ALOHA_PATH+"\\RPTFOH\\Report1.DOC";
// Create an instance of the untyped report object
ReportDocument oRpt = new ReportDocument();
// Load the report from disk
oRpt.Load(@"C:\Aloha\RPTFOH\Report_1.rpt");
// Set the options for saving the exported file to disk
DiskFileDestinationOptions oDest = new DiskFileDestinationOptions();
oDest.DiskFileName = exportFilePath;
// Set the exporting information
ExportOptions oExport = oRpt.ExportOptions;
// Set the destination options
oExport.DestinationOptions = oDest;
// Set the location, this can be:
// DiskFile, ExchangeFolder, MicrosoftMail or NoDestination
oExport.ExportDestinationType = ExportDestinationType.DiskFile;
// Set the Export type, this can be:
// PDF, Excel, Word Doc, RTF Doc,
// HTML 3.2, HTML 4.0 or CrystalReport
oExport.ExportFormatType = ExportFormatType.WordForWindows;
// Call the Export method to export the report
oRpt.Export();
thx
|
|
|
|
|
Here we go:
Probably you'll need to add a reference to all of the following dlls:
CrystalDecisions.CrystalReports.Engine
CrystalDecisions.ReportSource
CrystalDecisions.Shared
And you'll be using the followings in your code:
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;
Thanks.
modified 17-Jul-19 21:02pm.
|
|
|
|
|
Hi
I am using following code:
folderBrowserDialog1.ShowNewFolderButton=false;
folderBrowserDialog1.RootFolder = Environment.SpecialFolder.MyComputer;
folderBrowserDialog1.SelectedPath="c:\\temp";
DialogResult dr=this.folderBrowserDialog1.ShowDialog();
in windows 2000 it is still showing New Folder Button and in windows xp it is working fine.
If anyone have solution then please help me.
thanks
|
|
|
|
|
This is a known bug[^]. There is no work around.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
HI im making an asp.net web application using c# can anyone please tell me.. how to use the hyperlink control.
if im on webForm 1 .. and i want to go to webForm 2. of the same project, wat should i write in the NavigateURL property of the HyperLink????
thnx
|
|
|
|
|
webForm2.aspx
i tried to sign but the pen keeps scratching my monitor.
|
|
|
|
|
|
i can send you an e-book on Developing web applications. It is published by Microsoft specifically for ASP.NET web applications. You can get all the info you need in it! Problem is, it is about 4.5MB. Does your ISP allow you to receive emails that size???
|
|
|
|
|
if your LinkButton is called LinkButton1:
private void LinkButton1_Click(object sender, System.EventArgs e)
{
Response.Redirect("Form2.aspx");
}
|
|
|
|
|
hi imk making an
|
|
|
|
|
ashkitt wrote:
hi imk making an
an incomplete statement.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Can anyone tell me the most ideal way to store configurations in C#...what should you choose App.config, .INI files, or the registry? If there are any more modes of storing setting, please let me know.
|
|
|
|