|
1. Either dtAdapter or dtAdapter is null.
2. txtUserId and txtPassword look like names of textboxes rather than string. If they are textboxes, you will need to add .Text as well. If they are string, you may want to revisit the naming convention guidelines you are using.
|
|
|
|
|
Hy everyone,
I am desperate, a newbie to programming and I really need your help guys. I work a lot with sound files in Sound Forge 10 and I started to use the included C# scripts, but I don't know how to personalize them for my personal use. If somebody can help me I'll appreciate it very much.
Here is what I want my script to do:
1. - with the file open, get the path and name of the file.
2. - render the file in the same format to a specified location with the name from an .xml file in the same location and
the same name as the sound file ex:
The name of the opened file is : oldies_20110206144516.wav there is a oldies_20110206144516.xml also,
and I want to replace "oldies" with <artist> from the xml file, insert a character between date and time like
20110206144516 to 2011-02-06_14.45.16 then add two more fields from xml; final name should be something like
<artist>_2011-02-06_14.45.16_<song>-<album>.wav
3. - Close the opened file without saving and without confirmation.
Here is a sample script from sound forge:
______________________________________________________________________________
/* =======================================================================================================
* Script Name: Normalize and Render to Multiple Formats
* Description: This script applies an effect the open file and renders it to each of the given formats.
*
* Initial State: Run with one file open and the Script Editor visible (Menu: View, Script Editor)
*
* Parameters (Args):
* Dir - the directory to render the file to - DEFAULT: prompts user
* fx - the effect to apply - DEFAULT: Normalize
* preset - the preset to use for the given effect - DEFAULT: Maximize peak values
*
* Output: The rendered file names and the format used
*
* ==================================================================================================== */
using System;
using System.IO;
using System.Windows.Forms;
using SoundForge;
//Run with a file open and the Script Editor visible (Menu: View, Script Editor)
//BEHAVIOR:
//- Normalize to maximize peak value
//- If needed, prompts for a target folder
//- Saves the file to one or more formats
//NOTE: Look for MODIFY HERE to quickly update the Script Args with your own preferences
public class EntryPoint {
public string Begin(IScriptableApp app) {
//start MODIFY HERE -------------------------
// the array called outputs stores the file formats used for rendering
//NOTE: some file formats share extensions (WAV) (MPG)
// For MainConcept MPEG-1 use this : "6529C198-A432-409f-8A91-3F62198B0E1A|Default Template"
// For Scott Studio WAV use this: "D284C499-FE95-11d3-BB48-0050DA1A5B06|Default Template"
string[] outputs = new string[] {
".pca|Default Template",
".wma|64 Kbps Stereo Music",
// ".mp3|192 Kbps, CD Transparent Audio", //Commented out because MP3 fails until it's registered.
};
string szDir = GETARG("Dir", @""); //type a default output folder between the quotes
string szPlug = GETARG("fx", "Normalize"); //change the effect here
string szPreset = GETARG("preset", "Maximize peak value"); //change the preset for the effect here
// GETARG is a function that defines the default script settings. You can use the Script Args field to over-ride
// the values within GETARG().
// Example: To over-ride GETARG(Key, valueA), type Key=valueB in the Script Args field.
// Use an ampersand (&) to separate different Script Args: KeyOne=valueB&KeyTwo=valueC
//Example Script Args: Dir=f:\Media&fx=Insert Silence&preset=[Sys] 1 second at end of file
//end MODIFY HERE -------------------------
ISfFileHost file = app.CurrentFile;
if (null == file)
return "No files are open. Script canceled.";
// make sure that the directory exists...
if (szDir == null || szDir.Length <= 0)
szDir = PromptForPath("C:\\");
if (szDir == null || szDir.Length <= 0)
return "No output directory. Script canceled.";
ISfRendererList rends = app.Renderers; // this can take a while, so do it before we show the dialog.
Directory.CreateDirectory(szDir);
// ok, now do the deed.
try
{
file.DoEffect(szPlug, szPreset,
new SfAudioSelection(0, file.Length),
EffectOptions.EffectOnly | EffectOptions.WaitForDoneOrCancel);
} catch(Exception)
{
return "Normalize did not complete, script canceled.";
}
string szBase = file.Window.Title;
DPF("Start Rendering... ");
foreach (string output in outputs)
{
string[] fmt = output.Split(new char[]{'|',';'},2);
if (fmt.Length != 2)
{
DPF("'{0}' is not a valid render format specifier - use \"<renderer name>|<preset name>\" ", output);
continue;
}
// find the renderer
//
ISfRenderer rend = null;
if (fmt[0].StartsWith("."))
rend = app.FindRenderer(null, fmt[0]);
else
rend = app.FindRenderer(fmt[0], null);
if (null == rend)
{
DPF("renderer for type {0} not found - skipping to next", fmt[0]);
continue;
}
// determine if the preset is a string or an integer
//
object vPreset = fmt[1];
try {
int iPreset = int.Parse(fmt[1]);
vPreset = iPreset;
} catch (FormatException) {}
string szName = String.Format("{0}-({1}).{2}", szBase, fmt[1], rend.Extension);
DPF("rendering {0}", szName);
string szFilename = Path.Combine(szDir, szName);
DPF(" ~ {0}", szFilename);
DPF(rend.Guid + " " + vPreset + " '" + szDir + "'");
// now, render the file
//
file.RenderAs(szFilename, rend.Guid, vPreset, null, RenderOptions.RenderOnly);
SfStatus result = file.WaitForDoneOrCancel();
if (result != SfStatus.Success)
continue;
} // foreach
return null;
}
public string PromptForPath(string szDir) {
FolderBrowserDialog dlg = new FolderBrowserDialog();
dlg.Description = "Select folder for rendered files:";
if (null != szDir && "" != szDir)
dlg.SelectedPath = szDir;
else
dlg.SelectedPath = @"C:\";
dlg.ShowNewFolderButton = true;
DialogResult res = dlg.ShowDialog();
if (res == DialogResult.OK)
return dlg.SelectedPath;
return null;
}
public void FromSoundForge(IScriptableApp app) {
ForgeApp = app; //execution begins here
app.SetStatusText(String.Format("Script '{0}' is running.", Script.Name));
string msg = Begin(app);
app.SetStatusText(msg != null ? msg : String.Format("Script '{0}' is done.", Script.Name));
}
public static IScriptableApp ForgeApp = null;
public static void DPF(string sz) { ForgeApp.OutputText(sz); }
public static void DPF(string fmt, object o) { ForgeApp.OutputText(String.Format(fmt,o)); }
public static void DPF(string fmt, object o, object o2) { ForgeApp.OutputText(String.Format(fmt,o,o2)); }
public static void DPF(string fmt, object o, object o2, object o3) { ForgeApp.OutputText(String.Format(fmt,o,o2,o3)); }
public static string GETARG(string k, string d) { string val = Script.Args.ValueOf(k); if (val == null || val.Length == 0) val = d; return val; }
public static int GETARG(string k, int d) { string s = Script.Args.ValueOf(k); if (s == null || s.Length == 0) return d; else return Script.Args.AsInt(k); }
public static bool GETARG(string k, bool d) { string s = Script.Args.ValueOf(k); if (s == null || s.Length == 0) return d; else return Script.Args.AsBool(k); }
} //EntryPoint
_______________________________________________________________________________
Thank you in advance for your time.
1000000xxxxxxx
|
|
|
|
|
Firstly: Don't just dump code: post only the relevant fragments. Otherwise we have to wade through it all to work out what is going on.
Secondly: Use <pre> tags or the "code block" widget around your code: it preserves the formatting and makes it easier to read.
Thirdly: What have you tried? Where are you stuck?
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
I know I must get the path of the .xml file then extract the needed fields from it but I don't know how to do it.
Here is the script I use:
using System;
using System.IO;
using System.Windows.Forms;
using SoundForge;
public class EntryPoint {
public string Begin(IScriptableApp app) {
string[] outputs = new string[] {
".wav|Default Template",
};
string szDir = GETARG("Dir", @"c:\");
ISfFileHost file = app.CurrentFile;
if (null == file)
return "No files are open. Script canceled.";
string szBase = file.Window.Title;
DPF("Start Rendering... ");
foreach (string output in outputs)
{
string[] fmt = output.Split(new char[]{'|',';'},2);
ISfRenderer rend = null;
if (fmt[0].StartsWith("."))
rend = app.FindRenderer(null, fmt[0]);
else
rend = app.FindRenderer(fmt[0], null);
if (null == rend)
{
DPF("renderer for type {0} not found - skipping to next", fmt[0]);
continue;
}
object vPreset = fmt[1];
string szName = String.Format("{0}", szBase, fmt[1], rend.Extension);
DPF("rendering {0}", szName);
string szFilename = Path.Combine(szDir, szName);
DPF(" ~ {0}", szFilename);
file.RenderAs(szFilename, rend.Guid, vPreset, null, RenderOptions.RenderOnly);
SfStatus result = file.WaitForDoneOrCancel();
if (result != SfStatus.Success)
continue;
file.Close(CloseOptions.DiscardChanges);
}
return null;
}
public void FromSoundForge(IScriptableApp app) {
ForgeApp = app;
app.SetStatusText(String.Format("Script '{0}' is running.", Script.Name));
string msg = Begin(app);
app.SetStatusText(msg != null ? msg : String.Format("Script '{0}' is done.", Script.Name));
}
public static IScriptableApp ForgeApp = null;
public static void DPF(string sz) { ForgeApp.OutputText(sz); }
public static void DPF(string fmt, object o) { ForgeApp.OutputText(String.Format(fmt,o)); }
public static void DPF(string fmt, object o, object o2) { ForgeApp.OutputText(String.Format(fmt,o,o2)); }
public static void DPF(string fmt, object o, object o2, object o3) { ForgeApp.OutputText(String.Format(fmt,o,o2,o3)); }
public static string GETARG(string k, string d) { string val = Script.Args.ValueOf(k); if (val == null || val.Length == 0) val = d; return val; }
public static int GETARG(string k, int d) { string s = Script.Args.ValueOf(k); if (s == null || s.Length == 0) return d; else return Script.Args.AsInt(k); }
public static bool GETARG(string k, bool d) { string s = Script.Args.ValueOf(k); if (s == null || s.Length == 0) return d; else return Script.Args.AsBool(k); }
}
Thank you.
|
|
|
|
|
Aargh...that is just too much code to go through!
Using String.indexOf and string concatenation, you should be able to get _ into the xml file name (if that is what you were looking for).
The funniest thing about this particular signature is that by the time you realise it doesn't say anything it's too late to stop reading it.
My latest tip/trick
|
|
|
|
|
Hi.
My goal is:
I wont to create for every user his private data base, thus after I've received his user name I create an accdb file for him, connect to this data base and create tables.
The problem:
after I create the file it won't connect to it, it throws an exception at line :DataBaseManager.conn.Open();, says that the file already in use.
Help please, thanks.
modified on Monday, February 7, 2011 6:23 AM
|
|
|
|
|
Be sure your connection string is correct when you write
sqlconnection obj=new sqlconnection(@"connection string");
to have true connection string don't write own go in properties and copy and past it.
also use @ before.
make sense?
|
|
|
|
|
When you create the file, how are you doing that?
Please show the code, as it sounds like the file creation process is not fully releasing the file...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
here:
public DataBaseManager(String userName)
{
this.userName = userName;
if (!File.Exists(Environment.CurrentDirectory + "\\" + userName + ".accdb"))
{
using (fs = File.Create(Environment.CurrentDirectory + "\\" + userName + ".accdb"))
{
}
}
}
public void connectToDatabase()
{
DataBaseManager.conn = new OleDbConnection(this.dbConnPath);
if (DataBaseManager.conn == null)
{
MessageBox.Show("Can't connect to database", "WorkManager", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
String state = DataBaseManager.conn.State.ToString();
using (File.Open(Environment.CurrentDirectory + "\\" + userName + ".accdb", FileMode.Open))
{
if (state.Equals("Closed"))
{
DataBaseManager.conn.Open();
}
}
}
}
|
|
|
|
|
Thanks - that makes it easier.
public void connectToDatabase()
{
DataBaseManager.conn = new OleDbConnection(this.dbConnPath);
if (DataBaseManager.conn == null)
{
MessageBox.Show("Can't connect to database", "WorkManager", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
else
{
String state = DataBaseManager.conn.State.ToString();
using (File.Open(Environment.CurrentDirectory + "\\" + userName + ".accdb", FileMode.Open))
{
if (state.Equals("Closed"))
{
DataBaseManager.conn.Open();
}
}
}
}
When you do the
DataBaseManager.conn.Open();
you have just opened the file immediately above...
using (File.Open(Environment.CurrentDirectory + "\\" + userName + ".accdb", FileMode.Open))
Since it is open, the connection cannot be made: the file is in use. Get rid of the File.Open code, and you should be fine...
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
did it, still the same 
|
|
|
|
|
Do you ever close the connection?
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
Only when I close the program. Why?
|
|
|
|
|
Because the normal way to do things is:
1) Open connection
2) Do transaction
3) Close connection
This reduces the connections to a database and the load on the system.
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
After I removed the line you told me to, and added fs.close() I've got a new exception:
Unrecognized database format 'file name.accdb'.
I do have the file created.
|
|
|
|
|
That's a good start! The problem now, is probably that the file is empty. So when Access tries to use it, it expects it to be a valid (if blank) Access DB.
Probably the easiest way is to:
1) Manually prepare a blank database (set up your tables and so forth, but do not add any data: call it "MyBlankDB.accdb") and add it to your project.
2) Set it's properties to "embedded resource"
3) Use this to create your file:
System.Reflection.Assembly objAssembly = System.Reflection.Assembly.GetExecutingAssembly();
using (Stream blankDBData = objAssembly.GetManifestResourceStream("MyBlankDB.accdb"))
{
byte[] data = new Byte[blankDBData.Length];
blankDBData.Read(data, 0, (int) blankDBData.Length);
blankDBData.Close();
using (FileStream newDBFile = new FileStream(pathToWhereIWantToPutTheDatabase, FileMode.Create))
{
newDBFile.Write(data, 0, (int) blankDBData.Length);
newDBFile.Close();
}
}
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
Marat Beiner wrote: I wont to create for every user his private data base
..and how many users are you expecting?
Marat Beiner wrote: I create an accdb file for him, connect to this data base and create tables
..and why did you choose Access over Sql Express?
I are Troll 
|
|
|
|
|
Amongst the things that others have mentioned your main problem is that the file you create is not an Access Database file.
The suggestion that you have an empty database file and copy it then rename it (from OriginalGriff, I think) will work but you can actually create an access database file programmatically, if you want to.
Here's how.
1) Create a new Windows Forms project. (Call it CreateAccessACCDB, or whatever takes your fancy)
2) Add two TextBoxes and one Button. In order to match the code below name the TextBoxes txtDbName and txtDBPath, otherwise modify the code to match what you name them.
3) Add a reference to the project. Select the 'Com' tab, in the References Dialog, and scroll down till you find 'Microsoft ADO Ext. 2.8 for DDL and Security' and add a reference to it. If you don't find it on your system, you will have to download and install it from Microsoft[^].
4) Double-Click the Button and add the code below into the blank handler that you get.
if (File.Exists(this.txtDBPath.Text + this.txtDbName.Text + ".accdb"))
{
File.Delete(this.txtDBPath.Text + this.txtDbName.Text + ".accdb");
}
Catalog cat = new Catalog();
try
{
string creationString = "Provider=Microsoft.ACE.OLEDB.12.0;" +
" Data Source=" + this.txtDBPath.Text + this.txtDbName.Text + ".accdb";
cat.Create(creationString);
MessageBox.Show("Database Created Successfully");
}
catch (Exception ex)
{
MessageBox.Show("Oh deary, deary me." + Environment.NewLine + ex.ToString(), "Oooops");
return;
}
cat = null;
OleDbConnectionStringBuilder connBuilder = new OleDbConnectionStringBuilder();
connBuilder.DataSource = this.txtDBPath.Text + this.txtDbName.Text + ".accdb";
connBuilder.Provider = "Microsoft.ACE.OLEDB.12.0";
OleDbConnection tablesConn = new OleDbConnection(connBuilder.ConnectionString);
this.CreateTables(tablesConn);
Note that the code uses the run-time driver for Access 2010. If you don't have it, download and install it from Microsoft[^], or edit the code to use the version that you have.
All you have to do then is run it, enter a path into the path box (make sure it ends with a '\') and the name you want for the database (without the '.accdb' extension) in the name textbox, then click the button.
An example of a simple CreateTables() method
private void CreateTables(OleDbConnection conn)
{
string tableSql = @"CREATE TABLE FoodTable(FoodID SHORT NOT NULL , FoodName VARCHAR(30) NOT NULL , FoodType VARCHAR(15) NOT NULL , FoodPrice CURRENCY NOT NULL )";
OleDbCommand tableCommand = new OleDbCommand(tableSql, conn);
conn.Open();
tableCommand.ExecuteNonQuery();
conn.Close();
}
this is cut down a bit, as in my app I use a table definition file which allows for Primary Keys and Indexes etc., but you can look up the syntax for that on MSDN or elsewhere.
This was tested on a machine running XP, so if you are on Vista or Windows 7 you might get security errors. I cannot help with those. Also this was done for just goofing around so there is very little error checking.
Hope it helps.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
Thanks to everybody I've sold it, by creating static database, and then every time I create new one by System.IO.Copy, in other words I copy a static one to new one.
|
|
|
|
|
Well done.
Could you edit your original question to mark it 'Solved'. When you click the 'edit' widget under your question you will see "[Modified]" in the subject line. Simply replace the 'Modified' with 'SOLVED'.
That way people will know that you no longer need help.
Henry Minute
Do not read medical books! You could die of a misprint. - Mark Twain
Girl: (staring) "Why do you need an icy cucumber?"
“I want to report a fraud. The government is lying to us all.”
I wouldn't let CG touch my Abacus!
When you're wrestling a gorilla, you don't stop when you're tired, you stop when the gorilla is.
|
|
|
|
|
I am implementing Unity in a business app for the first time.
Here is some sample code to implement logging DI with Unity:
UnityContainer uc = new UnityContainer();<br />
uc.RegisterType<ILogger, FileLogger>();<br />
ILogger logger = uc.Resolve<ILogger>();<br />
<br />
logger.Write();
One way to implement this in an app would be to put this code in an AppConfig.cs class and implement GetLogger as a singleton.
What's your preferred way to implement Unity in this scenario?
|
|
|
|
|
I think Singleton is best way of implementing. Why would you choose other way? any specific requirements?
|
|
|
|
|
Ok - so to implement this as a singleton how would you envision the solution structure?
For example, would you see a singleton class in its own class library with a namespace like:
"MyCompany.MyDivision.MyApp.DI"? With the singleton class named something like "DIManager"?
Then I suppose that every library that needed the DI info would need to add a reference to the custom DI class library? Is this correct?
|
|
|
|
|
hello
i am reading a Wrox.Beginning.Microsoft.Visual.C.Sharp.2008 and i have question from exercises and it says
Create a delegate and use it to impersonate the Console.ReadLine() function when asking for
user input.
i am not sure i get the idea so please let me know
thank you
Gilberto
|
|
|
|
|
All it means is to create a delegate which allows you to call a method (in this case Console.ReadLine) without using that name.
delegate string MyMethodDelegate();
static void MyMethod()
{
MyMethodDelegate readALineFromUser = new MyMethodDelegate(Console.ReadLine);
Console.WriteLine("Enter your name:");
string inp = readALineFromUser();
Console.WriteLine("Your name is\"{0}\". ", inp);
}
Why would we use it?
Because we could change the input source from Console.ReadLine to MyBatchFileReadLine at run time without changing any of the code that uses readALineFromUser:
delegate string MyMethodDelegate();
static void MyMethod()
{
MyMethodDelegate readALineFromUser = new MyMethodDelegate(MyBatchFileReadLine);
Console.WriteLine("Enter your name:");
string inp = readALineFromUser();
Console.WriteLine("Your name is\"{0}\". ", inp);
}
Real men don't use instructions. They are only the manufacturers opinion on how to put the thing together.
Digital man: "You are, in short, an idiot with the IQ of an ant and the intellectual capacity of a hose pipe."
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
