|
Well I should give you years of fun then as written English is a subject that I have always struggled with since my childhood. It takes a lot of concentration to make sure something that I write is spelt correctly and the grammar is good.
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
You've no idea how much I struggled not to correct you on that; my fingers almost did it on their own.
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
One of these days I'm going to think of a really clever signature.
|
|
|
|
|
If you are interested in audio development, I made a simple SDK to tag audio libraries patches. There is ton of things people are waiting for on this topic:
- analyze a WAV file and extract tagging informations (Percussive, Smooth ...)
- extract informations from REX files and convert them in tags
Plug-ins can be .NET assemblies or native DLL
as Universal Patch Finder is free,
the idea is to let all of this entirely free.
|
|
|
|
|
Write and article!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Excellent. I look forward to seeing some articles/blogs on this. Sounds fascinating.
|
|
|
|
|
Okay, cool. Write an article about it rather than just posting a quick forum post. There is more value with an article as it can introduce your library to people and they can learn how to use it.
"Any sort of work in VB6 is bound to provide several WTF moments." - Christian Graus
|
|
|
|
|
Well, I thing there is some kind of misunderstanding here. My sdk provide only a way to call a plug-in. It does not provide any algorithm to do audio classification. So writing an article for a single .H seems not a good idea for me.
anyway, there is a manual in PDF here, you can take a look from page 24: http://hypercube-softwares.dyndns.org/wp-content/uploads/2013/01/UserGuideV1.3.pdf[^]
maybe I can make a REX parser and make an article if you want an article.
|
|
|
|
|
droopy6 wrote: So writing an article for a single .H seems not a good idea for me.
Well, even Pete O'Hanlon mentioned that an article or a technical blog about the basic usage would be cool. There are people out there that would find it useful. The pdf looks really good. You could always write a nice little bit summarizing the coding that is mentioned later on in the user guide.
droopy6 wrote: maybe I can make a REX parser
That would be very interesting as well.
"I've seen more information on a frickin' sticky note!" - Dave Kreskowiak
|
|
|
|
|
ok, I will write an article with a REX parser as an example.
|
|
|
|
|
|
As I did not see the article I cannot comment on why CP would have removed it you should probably argue the toss with them, I'm not going to be able to help.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
View visit link is given on Registration form, when user will click that link, it is showing following MessageBox 3 times:
Index was out of range.Must be non-negative and less than the size of the collection.
Parameter name:Index
After clicking ‘OK’ button on this MessageBox 3 times it will show The data in DataGridView as follows:
Also it is showing that MessageBox again.
Following is the blank OPD visit Form through which user can fill particular OPD visit details:
When user will click on any row of DataGridView(which is showing OPD visits) from ‘View visit’ form,
it has to show particular OPD visit details on ‘OPD visit’ form given above.
But now problem is that many times I have to click on any row of DataGridView showing OPD /IPD visits.
And when I click on any row of DataGridView showing IPD visits then it shows the error:
Object reference not set to instance of an object.
After clicking on ‘Ok’ it shows result.
SqlConnection con = new SqlConnection("Data Source=AKSHAY-PC;Initial Catalog=Paranjpe_Hospital;User ID=sa;Password=akshay;Pooling=False");
try
{
con.Open();
// string sqlqry = "select distinct PRN,OPD_Visit_No,OPD_visit_Date from OPD_visit where PRN= '" + PRN + "'"; original query
SqlCommand cmd = new SqlCommand("View_OPD_visits", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PRN", PRN); //Convert.ToInt32(PRN));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
//DataTable dt = new DataTable();
//DataTable dt = new DataTable();
//dt.Columns.Add("PRN");
//dt.Columns.Add("OPD_Visit_No");
//dt.Columns.Add("OPD_visit_Date");
//dt.Columns.Add("OPD_subcase");
//dt.Columns.Add("Diagnosis");
//dt.Columns.Add("obs_LMP");
//dt.Columns.Add("obs_EDD");
//dt.Columns.Add("Remark");
//dt.Columns.Add("Abnormal_findings");
//select PRN,OPD_Visit_No as Visit_No,OPD_visit_Date as Visit_Date,OPD_subcase as subcase,Diagnosis,obs_LMP as LMP,obs_EDD as EDD,Remark,Abnormal_findings from OPD_visit
da.Fill(ds); //, "OPD_visit");
//da.Fill(ds);
//BindingSource bSource = new BindingSource();
if (ds.Tables[0].Rows.Count > 0)
{
dataGridView_view_OPD_visits.Refresh();
dataGridView_view_OPD_visits.DataSource = ds.Tables[0];//ds.Tables[0];
//dataGridView_view_OPD_visits.DataBindings.Add(dt);
//dataGridView_view_OPD_visits.DataBind();
//dataGridView_view_OPD_visits.DataBindings.ToString();
//dataGridView_view_OPD_visits.BindingContext[ds.Tables[0], "OPD_visit"];//,"OPD_visit"];
}
/*
Datagridview.DataSource = < THE DATA SOURCE>
DataTable dt = new DataTable();
dt.Columns.Add("Name");
dt.Columns.Add("Age");
dt.Columns.Add("Salary");
for (int i = 1; i <= 10; i++)
dt.Rows.Add(
string.Concat("Name", i)
, i + 10
, i * 2000
);
dgView.DataSource = dt;
*/
//bSource.DataSource = ds;
//dataGridView_view_OPD_visits.AutoGenerateColumns = true;
//dataGridView_view_OPD_visits.Refresh();
//dataGridView_view_OPD_visits.DataSource = bSource;//ds.Tables["OPD_visit"]; //"OPD_visit"]; //.Tables["OPD_visit"]; //.Tables[0];
//dataGridView_view_OPD_visits.DataBindings.Add(ds);
/*
DataGridView dgView = new DataGridView();
//BindingSource to sync DataTable and DataGridView
BindingSource bSource = new BindingSource();
//set the BindingSource DataSource
bSource.DataSource = dTable;
//set the DataGridView DataSource
dgView.DataSource = bSource;
*/
//dataGridView_view_OPD_visits.AutoGenerateColumns = true;
//dataGridView_view_OPD_visits.DataSource = ds.Tables[0];
//dataGridView_view_OPD_visits.DataBindings=dt; //.Tables[0];
//dataGridView_view_OPD_visits.DataMember = "OPD_visit";
/*
use like this :-
gridview1.DataSource = ds.Tables[0]; <-- Use index or your table name which you want to bind
gridview1.DataBind();
*/
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
con.Close();
}
SqlConnection con1 = new SqlConnection("Data Source=AKSHAY-PC;Initial Catalog=Paranjpe_Hospital;User ID=sa;Password=akshay;Pooling=False");
try
{
con1.Open();
// string sqlqry = "select distinct PRN,OPD_Visit_No,OPD_visit_Date from OPD_visit where PRN= '" + PRN + "'"; original query
SqlCommand cmd = new SqlCommand("View_IPD_visits", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PRN", Convert.ToInt32(PRN));
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);//, "IPD_visit");
//if (dataGridView_View_IPD_visits.RowCount == 0)
//{
// break;
//}
//BindingSource bSource = new BindingSource();
//bSource.DataSource = ds;
dataGridView_View_IPD_visits.Refresh();
// dataGridView_View_IPD_visits.DataSource = ds.Tables[0];
//dataGridView_View_IPD_visits.AutoGenerateColumns = true;
dataGridView_View_IPD_visits.DataSource = ds.Tables[0]; //bSource;//ds.Tables[0];//"IPD_visit"];//.Tables["IPD_visit"];
//dataGridView_View_IPD_visits.DataMember = "IPD_visit";
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
con1.Close();
}
private void dataGridView_view_OPD_visits_RowEnter(object sender, DataGridViewCellEventArgs e)
{
try
{
int prn_view_visits = 0;
int OPD_visit_no_view_visits = 0;
prn_view_visits = Convert.ToInt32(dataGridView_view_OPD_visits.SelectedRows[0].Cells[0].Value);
OPD_visit_no_view_visits = Convert.ToInt32(dataGridView_view_OPD_visits.SelectedRows[0].Cells[1].Value);
OPD_visit ov = new OPD_visit(prn_view_visits, OPD_visit_no_view_visits);
ov.txtBx_PRN.Text = prn_view_visits.ToString();
ov.txtBx_OPD_visit_no.Text = OPD_visit_no_view_visits.ToString();
ov.txtBx_patient_name.Text = P_name;
ov.Show();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
//con.Close();
}
//SqlConnection con = new SqlConnection("Data Source=AKSHAY-PC;Initial Catalog=Paranjpe_Hospital;User ID=sa;Password=akshay;Pooling=False");
//try
//{
// con.Open();
// // string sqlqry = "select distinct PRN,OPD_Visit_No,OPD_visit_Date from OPD_visit where PRN= '" + PRN + "'"; original query
// SqlCommand cmd = new SqlCommand("Patient_Select_by_PRN", con);
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@PRN",prn_view_visits);
// SqlDataAdapter da = new SqlDataAdapter(cmd);
// DataSet ds = new DataSet();
// ds.Clear();
// da.Fill(ds);
// if (ds.Tables[0].Rows.Count > 0)
// {
// ov.txtBx_patient_name.Text = ds.Tables[0].Rows[0][1].ToString();
// }
// else
// {
// MessageBox.Show("Patient is not registered!");
// }
//}
}
private void dataGridView_View_IPD_visits_RowEnter(object sender, DataGridViewCellEventArgs e)
{
try
{
int prn_view_visits = 0;
int IPD_visit_no_view_visits = 0;
prn_view_visits = Convert.ToInt32(dataGridView_view_OPD_visits.SelectedRows[0].Cells[0].Value);
IPD_visit_no_view_visits = Convert.ToInt32(dataGridView_view_OPD_visits.SelectedRows[0].Cells[1].Value);
IPD_visit iv = new IPD_visit(prn_view_visits, IPD_visit_no_view_visits);
iv.txtBx_PRN.Text = prn_view_visits.ToString();
iv.txtBx_IPd_visit_no.Text = IPD_visit_no_view_visits.ToString();
iv.textBox_IPD_patient_name.Text = P_name;
iv.Show();
}
catch (Exception exception)
{
MessageBox.Show(exception.Message);
}
finally
{
//con.Close();
}
}
Please tell me solution of the problem.
|
|
|
|
|
Edit your message. Put the code in tags: <pre lang="c#">Your Code Here</pre>
Ciao,
luker
|
|
|
|
|
Try using the debugger (set a break point) to find the line where the code fails. I suspect it is the query to the database which fails 3 times!
Next do not use sa as your credentials to the database, even during development, create a SQL identity and use that. It is good that you are using sql parameterised queries!
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
The storedprocedures have you tried to execute them in SQL Server Management studio?
I suspect that your SQL Stored procedures are not returning any values hence not filling up the dataset(s)
I would have a read of these to see how to test the dataset is empty or not
How to test if a DataSet is empty?[^]
how to check if a dataset is empty? whats the correct c# syntax to use?[^]
Lobster Thermidor aux crevettes with a Mornay sauce, served in a Provençale manner with shallots and aubergines, garnished with truffle pate, brandy and a fried egg on top and Spam - Monty Python Spam Sketch
|
|
|
|
|
Hi,
This is little bit of a oops question. As I am not a full time programmer, I am struggling with little bit of basics. any kind of favor would be appreciated.
namespace NameSpaceX.DataModel
{
class BFPFDataObject
{
public WDataObject thisObject { get; set; }
List<BFPFDataObject> children = new List<BFPFDataObject>();
public IList<BFPFDataObject> Children
{
get { return children; }
}
public BFPFDataObject(WDataObject wdoObj)
{
thisObject = wdoObj;
List<WDataObject> wdoDBContents = PFAPIUtils.GetContents(wdoObj, false);
foreach (WDataObject tempobj in wdoDBContents)
{
BFPFDataObject _children = new BFPFDataObject(wdoObj);
children.Add(_children);
}
}
}
}
I would like to know if its a legitimate class definition
WDataObject is the object what i get from a third part lib
using this I can make calls and navigate the tree
List<WDataObject> wdoDBContents = PFAPIUtils.GetContents(wdoObj, false);
above function that do this for me,
However if pass the second parameter to be true, then the function make recursive call and return a list which is all in the same hierarchy.
if the parameter is false then it return only the list objects in the next level.
I am struggling to build a hierarchical list and show it on a tree view, can some body offer some help ?!!!
My gut feeling is if I can build the list sucessfully as indicated above I would be able to do the WPF part myself.
Please throw some light on the subject
Regards
Krish
|
|
|
|
|
The standard color dialog lets you select from a pallette of fixed colours or, if you click the define custom colors button, you can select your own variations. Now, compare this to say the BackColor of a button. that lets you select from three tabs, Custom, Web and system. If you click the Web tab you can select colours by name such Fuschia, Goldenrod, and what have you.
I'm creating a property editor for a custom control and I'd like to implement something similar. I know I could have a form in my property and have a ColorDialog on it but I like the idea of selecting colours by name which ColorDialog can't do. Does anyone know of some easier way to do this at the custom level or perhaps knows of a freeware component I could use that does.
Another way I could approach it is to run through the KnownColor enumeration and then get the colou's ARGB values and then somehow perhaps have a listbox and paint small rectangles in it with the colour and its name. I guess it's do-able but hardly convenient.
Anyone have any ideas I can investigate and research further?
"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).
|
|
|
|
|
|
Thanks Zac. I'll download it and see if I can pull out the ColorPicker as that's what I want.
"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).
|
|
|
|
|
I can upload the source to a color picker dialog I made with the control if you want me to.
Bob Dole The internet is a great way to get on the net.
2.0.82.7292 SP6a
|
|
|
|
|
Yes please, buddy. I'd appreciate that.
"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).
|
|
|
|
|
Here you go![^]
The file is the ColorDialogEx.zip one.
Bob Dole The internet is a great way to get on the net.
2.0.82.7292 SP6a
|
|
|
|
|
Many thanks, Zac. I've downloaded it and I'll look at implementing it into the control I've been working on.
"I do not have to forgive my enemies, I have had them all shot." — Ramón Maria Narváez (1800-68).
"I don't need to shoot my enemies, I don't have any." - Me (2012).
|
|
|
|
|
No problem.
Bob Dole The internet is a great way to get on the net.
2.0.82.7292 SP6a
|
|
|
|