Re: Deploying Database - C# Discussion Boards

SAPI 5 Dictation, how do I define a limited domain grammar?

23-Jan-09 11:52

You're a long way off track. You'll be struggling to make it work doing it the way you are.

Examine the CheckedListBox source to see how Microsoft do it, then adapt that to your own needs. There's alot to learn to create such an advanced control - beyond the scope of a forum such as this until you get into more specific details IMO.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

brossen23-Jan-09 9:48

brossen

23-Jan-09 9:48

Hello all,

I'm working on a program using MS SAPI 5 where people can have a verbal conversation with a virtual person. I know the general content of these conversations, so I could limit the dictation grammar, and hopefully get much better speech recognition. I just can't quite figure out how to limit the dictionary. Does anyone here know how to define a limited domain grammar in SAPI 5?

I'm using C#, here's the instantiation of my dictation grammar and recognizer:

//Dictation recognizer
System.Speech.Recognition.SpeechRecognizer _recognizer = new SpeechRecognizer();

//context Dictation 
DictationGrammar dictGrammarContext = new DictationGrammar("grammar:dictation");
   
dictGrammarContext.Name = "Contextual Dictation Grammar";
dictGrammarContext.Enabled = true;

_recognizer.LoadGrammar(dictGrammarContext);
_recognizer.SpeechRecognized += new EventHandler<speechrecognizedeventargs>(DictReco_Event);
_recognizer.SpeechHypothesized += new EventHandler<speechhypothesizedeventargs>(DictHypo_Event);
</speechhypothesizedeventargs></speechrecognizedeventargs>

Any kick in the right direction (even towards a more appropriate forum) would be appreciated.

Deploying Database

ziwez023-Jan-09 9:21

ziwez0

23-Jan-09 9:21

Hi Guys, working on an app at the mo that has a db,
the thing is, is that at the moment the db is hard coded to point to c:\mydatabase.

but obviosuly what i want to do is deploy the app to the local os drive,
but how do i do this in code, and need to make sure in the code knows where to find the db.

EliottA23-Jan-09 9:23

EliottA

23-Jan-09 9:23

Relative directorys, put your DB in your application folder and then use System.Windows.Forms.Application.ExecutablePath and it will point to the db.

User 665823-Jan-09 9:57

User 6658

23-Jan-09 9:57

EliottA wrote:
put your DB in your application folder

NOOOOOOOOOOOOOOOOO! Sigh | :sigh:

modified 12-Sep-18 21:01pm.

PIEBALDconsult23-Jan-09 12:58

PIEBALDconsult

23-Jan-09 12:58

Not even if it's Access? Big Grin | :-D

ziwez016-Feb-09 21:16

ziwez0

16-Feb-09 21:16

Hi Greeg, what do you recommend?

Re: Deploying Database [modified]

Ennis Ray Lynch, Jr.23-Jan-09 9:47

Ennis Ray Lynch, Jr.

23-Jan-09 9:47

The easiest way I have found to deploy a database is to embed it in the assembly and then on first start check the application data directory for the file. If it doesn't exist write it using GetType().Assembly.GetManifestResourceStream("theEmbeddedName") which returns a stream that I save to a file.

The application data path is
System.Windows.Forms.Application.CommonAppDataPath

embed a file in an assembly is as easy as adding it the project and selecting Build Action:Embedded Resource.

Need software developed? Offering C# development all over the United States, ERL GLOBAL, Inc is the only call you will have to make.

If you don't ask questions the answers won't stand in your way.

Most of this sig is for Google, not ego.

PIEBALDconsult23-Jan-09 13:05

PIEBALDconsult

23-Jan-09 13:05

I suppose that partly depends on what database system is in use and what sort of environment it runs in. And whether or not other such databases are present.

In a corporate environment with "real" databases (i.e. not Access) there will likely be administrators to tell you where to stick it.

For home use you can pretty much do as you please, but try not to put it on a system ( C: ) drive.

modified on Saturday, January 24, 2009 12:50 AM

C# Populate Multi column (2) combobox with existing dataset (hide record #)

Alex Casals23-Jan-09 23:32

Alex Casals

23-Jan-09 23:32

You can try to connect to your database, and if failed, open a connection dialog with this

If you are using an access datatable, it can be adapted for use an oledb connection.

Alex

Wheels01223-Jan-09 9:13

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

23-Jan-09 9:13

Good afternoon.

I would like to create a Multi Column (2)ComboBox populated by existing (SQL) dataset.

The dataset returns the record ID and the item name (e.g. 1, "Apple"). The comboBox would display the item name, and the record ID would be hidden, but still "tied" to the item name.

Also I would like to reference the 1st colums to be used in another SQL statement.

I noticed a couple of examples (some with DataGrids), but they don't seem to suit our needs.

Thank you,

WHEELS

DaveyM6923-Jan-09 9:16

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

23-Jan-09 9:16

If you're returning two values but only want one displayed then you don't need a multi column combobox. You can use the standard one and set the DisplayMember and ValueMember properties to acheive exactly what you describe.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Wheels01223-Jan-09 9:29

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

23-Jan-09 9:29

Hi DaveyM69.

I am very new to C#. More of a VBA master. I took C many moons ago, but am struggling a bit in C#.

I am vaugely familiar with the properties you mentioned, but how do I do what you suggest?

WHEELS

DaveyM6923-Jan-09 10:03

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

23-Jan-09 10:03

Assuming you're returning a DataSet from the database, set the ComboBox's DataSource to the Table you need in the DataSet. Set the ComboBox's DisplayMember to the column that has the text in that Table and the ValueMember to the column that has the ID.

That's all there is to it!

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Wheels01226-Jan-09 1:32

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

26-Jan-09 1:32

Thank you Dave.

I beleive that should do the trick.

WHEELS

Wheels01228-Jan-09 2:05

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 2:05

Hi Dave.

I have the following code:

ds = d.GeneralDropDown("Dept");

foreach (DataRow dr in ds.Tables[0].Rows)
{
//cboDeptID.Items.Add(dr[constrDeptID].ToString());
//cboDepartment.Items.Add(dr[constrDeptID].ToString() + " " + dr[constrDeptColumn].ToString());
cboDepartment.Items.Add(dr[constrDeptColumn].ToString());
cboDepartment.DisplayMember = dr[constrDeptColumn].ToString();
cboDepartment.ValueMember = dr[constrDeptID].ToString();
}

private void cboDeptID_SelectedIndexChanged(object sender, EventArgs e)
{
//ds = new DataSet();
//ds = d.FillDataGrid(this.cboDepartment,this.cboAcronym);
MessageBox.Show(this.cboDepartment.ValueMember);
MessageBox.Show(this.cboDepartment.DisplayMember);
}

Am I using the DisplayMemeber and ValueMember correctly? The combobox is poppulated, but the MessageBoxes don't come up when the value in the combobox changes.

Any ideas? WHEELS

DaveyM6928-Jan-09 7:08

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 7:08

There's no need to add your items in a loop, just assign the combo's DataSource to the DataSet's DataTable (ds.Tables[0]) and set the DisplayMember and ValueMember to the table's respective ColumnNames and that should fill the combo.

To get the value just get the combobox's SelectedValue. Working example below Smile | :)

void InitializeCombo()
{
    // Constructing data set in code, obviously this would come from your DAL
    DataSet ds = new DataSet();
    ds.Tables.Add();
    ds.Tables[0].Columns.Add("ID");
    ds.Tables[0].Columns.Add("Display");
    ds.Tables[0].Rows.Add(new object[] { 1, "One" });
    ds.Tables[0].Rows.Add(new object[] { 2, "Two" });
    ds.Tables[0].Rows.Add(new object[] { 3, "Three" });
    ds.Tables[0].Rows.Add(new object[] { 4, "Four" });
    ds.Tables[0].Rows.Add(new object[] { 5, "Five" });
    // the next three lines fill your combo and set the members
    comboBox1.DataSource = ds.Tables[0];
    comboBox1.DisplayMember = "Display";
    comboBox1.ValueMember = "ID";
    // subscribe to SelectedIndexChanged event
    comboBox1.SelectedIndexChanged += new EventHandler(
        comboBox1_SelectedIndexChanged);
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
    MessageBox.Show(comboBox1.SelectedValue.ToString());
}

P.S. There's no need for all the x.ToString()s that you have everywhere!

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Wheels01228-Jan-09 8:37

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 8:37

Thank you Dave.

I greatly appreciate you help.

WHEELS

DaveyM6928-Jan-09 9:41

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

28-Jan-09 9:41

No problem, that's what's these forums and all the users are here for Big Grin | :-D

Any more problems, just post back.

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

DaveyM6930-Jan-09 9:28

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

30-Jan-09 9:28

Did you get it working OK?

Dave
BTW, in software, hope and pray is not a viable strategy. (Luc Pattyn)
Visual Basic is not used by normal people so we're not covering it here. (Uncyclopedia)

Wheels01230-Jan-09 9:31

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

30-Jan-09 9:31

Hi Dave.

I am on a differwnt project, but we experiment with the code using the dataset from the DAL layer next Wednesday.

Have a great weekend,

DAVE

Wheels0124-Feb-09 2:47

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

4-Feb-09 2:47

Hi Dave.

Finding it challenging to get it working.

I have a form with a comboBox and the following code:

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Data.OleDb;

namespace WindowsFormsApplication3
{
public partial class Form1 : Form
{
const string constrLetterColumn = "Letter";
const string constrDeptID = "DeptID";
const string constrDeptColumn = "Department";
const string constrExpandColumn = "Expansion";

DAL d = new DAL();
DataSet ds;
DataTable dt;

public Form1()
{
InitializeComponent();
}

private void Form1_Load(object sender, EventArgs e)
{
}

void InitializeCombo()
{
// Constructing data set in code, obviously this would come from your DAL
DataSet ds = new DataSet();
ds.Tables.Add();
ds.Tables[0].Columns.Add("ID");
ds.Tables[0].Columns.Add("Display");
ds.Tables[0].Rows.Add(new object[] { 1, "One" });
ds.Tables[0].Rows.Add(new object[] { 2, "Two" });
ds.Tables[0].Rows.Add(new object[] { 3, "Three" });
ds.Tables[0].Rows.Add(new object[] { 4, "Four" });
ds.Tables[0].Rows.Add(new object[] { 5, "Five" });
// the next three lines fill your combo and set the members
comboBox1.DataSource = ds.Tables[0];
comboBox1.DisplayMember = "Display";
comboBox1.ValueMember = "ID";
// subscribe to SelectedIndexChanged event
comboBox1.SelectedIndexChanged += new EventHandler(comboBox1_SelectedIndexChanged);
}

private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
MessageBox.Show(comboBox1.SelectedValue.ToString());
}
}
}

Where am I going wrong?

WHEELS

Wheels0124-Feb-09 8:08

Re: C# Populate Multi column (2) combobox with existing dataset (hide record #)

4-Feb-09 8:08

HI Dave.

I had a coworker work with me on the code.

It works well.

When I cut and pasted some code from another project, it didn't work because I was missing an event handler.

Thank you,

DAVE

DaveyM694-Feb-09 13:16