|
My first thought would be to do a selected on table0 and replace the rows in table1 with the resulting rows collection.
only two letters away from being an asset
|
|
|
|
|
thanks for ur reply
What Im trying to do is.........
I got Sql Server Database. One of the table name Volume which is related with five other tables. From Volume table I need to create two other table (VolumeSectors and VolumeThemes) then I need to create some query, where I want to use VolumeSectors and VolumeThemes tables instead of Volume tables.
So far what I have done...........
Added a DataSet into my Project where I have added three tables name Volume, VolumeSectors and VolumeThemes. I have already run a Query to pull all data from Volume Table (Sql Server Database) and put it on DataSet.Volume. Now I need to pull data from DataSet.Volume (specified data (need to write query)) and put it into VolumeSector and VolumeThemes on the basis of query.
Please help me............
If you can write some code for me
I have put data into DataSet.Volume with the following functions below
Public Function Qry_Volume() As DataTable
Dim _DataSet As DataSet = New Publications()
Dim _Qry_Volume_VolumeLessons_Table As DataTable = New DataTable()
Dim _Qry_Volume_Sectors As DataTable = New DataTable()
Dim con As AccessDatabase = New AccessDatabase()
Dim conLessons As SqlConnection = con.SQLConnnect()
Dim cmd As SqlCommand = New SqlCommand()
Dim _DataReader As SqlDataReader
Try
conLessons.Open()
cmd.CommandType = CommandType.Text
cmd.Connection = conLessons
cmd.CommandText = "Select V.Title, V.Voltype, V.Region, VL.Lesson From VolumeLessons VL Inner Join Volumes V ON VL.Volume = V.AutoID Order BY V.Title ASC "
_DataReader = cmd.ExecuteReader()
If _DataReader.HasRows Then
_DataSet.Tables(0).Load(_DataReader)
_DataReader.Close()
conLessons.Close()
End If
Catch ex As Exception
If conLessons.State = ConnectionState.Open Then
conLessons.Close()
End If
End Try
Return _DataSet.Tables(0)
conLessons.Close()
End Function
** Now how can I do it?
Thanks
Sarfarj Ahmed
|
|
|
|
|
If the tables in the dataset are related you can create a relationship and get the child rows from VolumeSectors and VolumeThemes that are related to those in the Volume table
only two letters away from being an asset
|
|
|
|
|
I want to print a float with value 1.98765 with only 2 decimals: (1.99 in this case).
How?
_____________________________
...and justice for all
APe
|
|
|
|
|
myFloat.ToString(0.##);
Sincerely,
Elina
Life is great!!!
Enjoy every moment of it!
|
|
|
|
|
Numeric Format Strings[^]
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
hello
my name surjeet singh how can i change start menu name like "start" to "sidhu" in windows xp sp2.
surjeet_sidhu2007@hotmail.com
surjeet singh sidhu
|
|
|
|
|
A couple of things.
1. Don't put your email address in the post.
2. How is this a C# question?
Deja View - the feeling that you've seen this post before.
|
|
|
|
|
Programmatically you would have to get a handle of the window and then change the window text of the start button window. Programmatically you would have to use API. Otherwise you could use Resource Hacker to alter the dlls of the OS.
Regards,
Thomas Stockwell
Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
Visit my homepage Oracle Studios[ ^]
|
|
|
|
|
hey,
When I'm trying to delete one of my created files. My program saids it is in use (by himself) but that's because the program is to fast. When I let him wait 10sec the lock is gone... But that not zo good if you have to delete 20-50 files.
How can I unlock them automatically?
Thx!!!
|
|
|
|
|
How are the files created? Did you maybe forgot to call close on some streams?
"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook www.troschuetz.de
|
|
|
|
|
There are all created with:
new DirectoryInfo(Path.GetDirectoryName(path)).Create();
StreamWriter writer = new StreamWriter(path);
writer.WriteLine(content);
writer.Close();
But than the locks are fine. But after all the files are created I zip them with "SharpZipLib" and is places locks that last realy long...
thx
|
|
|
|
|
Then there's a bug in the zip library, or in how you're using it.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
I don't think so everything is closed:
using System;
using System.Collections.Generic;
using System.Text;
using System.IO;
using System.Diagnostics;
using System.Threading;
using log4net;
using ICSharpCode.SharpZipLib.Zip;
using System.Collections;
using System.Collections.Specialized;
namespace InterfaceCollector.domain.DAL
{
class Zip
{
private string destination;
private readonly ILog log = LogManager.GetLogger(typeof(Zip));
static Hashtable excludeDirs = new Hashtable();
static string startFolder = String.Empty;
static string outputZipPath = String.Empty;
static string password = String.Empty;
public Zip() {}
static private Zip instance = null;
static public Zip Instance
{
get
{
if (instance == null)
instance = new Zip();
return instance;
}
}
public void ZipIt(string Path,string password)
{
log4net.LogManager.Shutdown();
try
{
ArrayList ar = GenerateFileList(Path); // generate file list
// find number of chars to remove from orginal file path
int TrimLength = (Directory.GetParent(Path)).ToString().Length;
TrimLength += 1; //remove '\'
FileStream ostream = null;
byte[] obuffer;
ZipOutputStream oZipStream = new ZipOutputStream(System.IO.File.Create(Destination)); // create zip stream
if (password != String.Empty) oZipStream.Password = password;
oZipStream.SetLevel(9); // 9 = maximum compression level
ZipEntry oZipEntry;
DateTime timeStap = DateTime.Now;
string output = "";
int lenghtWrittenString = 0;
double percent = 1;
int countFiles = 0;
foreach (string Fil in ar) // for each file, generate a zipentry
{
countFiles++;
percent = countFiles * 100 / ar.Count;
//Display % on progressScreen
if (timeStap <= DateTime.Now)
{
timeStap = DateTime.Now.AddMilliseconds(1000);
ApplicationDirector.Instance.removeCharachtersFromProgressScreen(lenghtWrittenString);
if (percent < 100.0)
{
output = "\r\nCreating zip-file (" + percent + "%)";
ApplicationDirector.Instance.writeToGui(output);
}
lenghtWrittenString = output.Length;
}
oZipEntry = new ZipEntry(Fil.Remove(0, TrimLength));
oZipStream.PutNextEntry(oZipEntry);
if (!Fil.EndsWith(@"/")) // if a file ends with '/' its a directory
{
ostream = File.OpenRead(Fil);
obuffer = new byte[ostream.Length]; // byte buffer
ostream.Read(obuffer, 0, obuffer.Length);
oZipStream.Write(obuffer, 0, obuffer.Length);
}
}
ApplicationDirector.Instance.removeCharachtersFromProgressScreen(lenghtWrittenString);
ApplicationDirector.Instance.writeToGui("\r\nCreating zip-file (Completed)");
oZipStream.Finish();
oZipStream.Close();
}
catch (Exception ex)
{
ApplicationDirector.Instance.writeToGui("Error during zipping.");
Logger.Instance.ExtraInfo.Add("Zip-File nog created" + ex);
}
}
private static ArrayList GenerateFileList(string Dir)
{
ArrayList mid = new ArrayList();
bool Empty = true;
foreach (string file in Directory.GetFiles(Dir)) // add each file in directory
{
mid.Add(file);
Empty = false;
}
if (Empty)
{
if (Directory.GetDirectories(Dir).Length == 0) // if directory is completely empty, add it
{
mid.Add(Dir + @"/");
}
}
foreach (string dirs in Directory.GetDirectories(Dir)) // do this recursively
{
// set up the excludeDir test
string testDir = dirs.Substring(dirs.LastIndexOf(@"\") + 1).ToUpper();
if (excludeDirs.Contains(testDir))
continue;
foreach (object obj in GenerateFileList(dirs))
{
mid.Add(obj);
}
}
return mid; // return file list
}
public string Destination
{
get { return destination; }
set
{
string path = Path.GetDirectoryName(value);
path = path + "Agfa Zip - "+Path.GetFileNameWithoutExtension(value) + "\\" + Path.GetFileName(value);
destination = path;
Directory.CreateDirectory(Path.GetDirectoryName(destination));
}
}
}
}
|
|
|
|
|
But you have to know, he releases the locks It just takes to long
|
|
|
|
|
That means, something is NOT closed, but it is eventually garbage collected.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
that works thx!
GC.Collect();
GC.WaitForPendingFinalizers();
|
|
|
|
|
That's a hack. You should instead figure out what's going wrong with the zip library.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
If we have time at the end :->
|
|
|
|
|
Well, I'd think if it's a problem in the framework, then others will have encountered it. If you find nothing on google, it's a bug in your code. 'If we have time at the end', means, we're going to leave it broken. At least, that's what I'd expect it to mean.
Christian Graus - Microsoft MVP - C++
Metal Musings - Rex and my new metal blog
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
|
What do you mean with that?
|
|
|
|
|
hello again,
well I made a parent child form in C# 2.0 windows application with sql server 2000 and i'm having troble in deleting the parent record bcz it gives a constraint error that the table is also reffered to in another child table that is not being used in the current form. so can u plz tell me what I should do to delete that parent record when there are references in its child table.
thanks in advance
Rocky
|
|
|
|
|
i have also face the same problem in java.
At that time i have to delete the record from the child record and then to the parent node.
U can't simply delete parent record.
Try this out and let me know.
|
|
|
|
|
This isn't strictly true. You can do a cascading delete, but only if the database supports it and the tables have been set up to support it. I wouldn't recommend it, but you can.
Deja View - the feeling that you've seen this post before.
|
|
|
|