C#.Net error(Front end Visual studio 2010,Back end:SQL server 2008)-) - C# Discussion Boards

Excellent. I look forward to seeing some articles/blogs on this. Sounds fascinating.

*pre-emptive celebratory nipple tassle jiggle* - Sean Ewington

"Mind bleach! Send me mind bleach!" - Nagy Vilmos

CodeStash - Online Snippet Management | My blog | MoXAML PowerToys | Mole 2010 - debugging made easier

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.

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.

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.

the article is published here: Build a plug-in for Universal Patch Finder

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! Thumbs Up | :thumbsup:

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?[^]

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.

C#

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

C#

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).

A Color Picker[^]

Hosting UITypeEditors in WinForms dropdowns[^]

And there are many more on this site, just use the search and pray to the hamsters that it works!

2.0.82.7292 SP6a

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.

2.0.82.7292 SP6a

Yes please, buddy. I'd appreciate that. Smile | :)

"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.

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.

2.0.82.7292 SP6a

Zac, I ran into a problem which I'll explain. I downloaded the ColorDialogEx, unzipped it and loaded the solution in VS2012, compiled it, successful. There were a couple of minor warnings telling me == and != were implemented but no override for Object.Equals and Object.GetHashCode have been defined, but nothing serious.

I then created a new winform app in 2012 and I added the ColorDialogExe.dll to the General toolbox category. It added a few components. I selected the ColorPickerCombobox component and dropped it on the form. It shows correctly. I didn't change any of the properties, etc.

When I run the app it throws an exception in ImagesUtil's GetToolbarImageList. Here's an extract of the exception:

System.ArgumentException was unhandled
HResult=-2147024809
Message=Resource 'ColorPicker.Resources.popupcontainerbuttons.bmp' cannot be found in class 'resfinder'.
Source=System.Drawing
StackTrace:
at System.Drawing.Bitmap..ctor(Type type, String resource)
at ColorPicker.ImagesUtil.GetToolbarImageList(Type type, String resourceName, Size imageSize, Color transparentColor) in c:\Temp\ColorDialogEx\ColorDialogEx\Resources\Images.cs:line 13
at ColorPicker.PopupContainerImages.ImageList() in c:\Temp\ColorDialogEx\ColorDialogEx\Resources\Images.cs:line 63
at ColorPicker.PopupContainerImages.Image(eIndexes index) in c:\Temp\ColorDialogEx\ColorDialogEx\Resources\Images.cs:line 68
at ColorPicker.DropdownContainer`1.OnPaint(PaintEventArgs e) in c:\Temp\ColorDialogEx\ColorDialogEx\DropdownContainerControl.cs:line 335
at System.Windows.Forms.Control.PaintTransparentBackground(PaintEventArgs e, Rectangle rectangle, Region transparentRegion)
at System.Windows.Forms.Control.PaintBackground(PaintEventArgs e, Rectangle rectangle, Color backColor, Point scrollOffset)
at System.Windows.Forms.Control.PaintBackground(PaintEventArgs e, Rectangle rectangle)

Do you think I need to do something else before I can use it?

"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).

Let me look at it again. I thought I fixed that.

2.0.82.7292 SP6a

Fixed it. Try downloading it again. Same link as before.

I forgot to modify one of the resource finder things.

Why the original author did not use the built in resource management and basically (and incorrectly) rebuilt it is beyond me.

2.0.82.7292 SP6a

Thank you, Mr. Speedy Zac. I will download it and try again.

"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).

That's a first. I usually am called 'Slow' by people because I like to think things through before trying them. It usually works out better that way.

2.0.82.7292 SP6a