|
|
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
|
|
|
|
|
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.
Bob Dole The internet is a great way to get on the net.
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.
Bob Dole The internet is a great way to get on the net.
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).
|
|
|
|
|
PHS241 wrote: Mr. Speedy Zac.
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.
Bob Dole The internet is a great way to get on the net.
2.0.82.7292 SP6a
|
|
|
|
|
Here is my code:
class dbLocalDB : DataManager
{
private System.Data.Common.DbConnectionStringBuilder BldrLocalDB = new System.Data.Common.DbConnectionStringBuilder();
public System.Data.Common.DbConnectionStringBuilder ConnectionString
{
get { return BldrLocalDB; }
set
{
BldrLocalDB.ConnectionString = XenoManager.Properties.Settings.Default.csLocalDB;
}
}
}
public partial class Form1 : Form
{
dbLocalDB LocalDB = new dbLocalDB();
public Form1()
{
InitializeComponent();
try
{
tb_LocalDBServerURL.Text = LocalDB.ConnectionString["Data Source"].ToString();
tb_LocalDBDatabase.Text = LocalDB.ConnectionString["Initial Catalog"].ToString();
tb_LocalDBUsername.Text = LocalDB.ConnectionString["User ID"].ToString();
tb_LocalDBPassword.Text = LocalDB.ConnectionString["Password"].ToString();
}
catch (Exception ex)
{
textBox1.Text = ex.ToString();
}
}
}
I get the following error "System.ArgumentException: Keyword not supported: 'Data Source'. at System.Data.Common.DbConnectionStringBuilder.get_Item(String keyword)"
I think what's happening is BldrLocalDB.ConnectionString isn't being populated. If I had:
System.Data.Common.DbConnectionStringBuilder bldrLocalDB = new System.Data.Common.DbConnectionStringBuilder();
bldrLocalDB.ConnectionString = Properties.Settings.Default.csLocalDB;
in "public partial class Form1 : Form", it'll populate, but how do I populate it in the dbLocalDB class?
Thanks!
|
|
|
|
|
Not every connectionstring provides a datasource[^]; what does the actual string look like?
|
|
|
|
|
Hi,
Ive got a Treeview with scrollable enabled. On my developing PC everything works fine. When i resize my window, the scrollbar appears.
But when I run the .exe on another PC (even when its installed by an setup installer), there are no scrollbars! I've tried on 3 different PCs. All PCs are using Windows 7 and the required .Net4 is installed. I dont know whats the problem. Everything else works . Please help.
Edit: Okay, the Problem appears when i use the treeview in a SplitContainer. Is this a know issue and is there a workaround? i really need those splitcontainers.
Edit: Got it! Each Element within a splitcontainer panel has to have the dock property set to "Fill". Now it works .
Any ideas?
Thanks
|
|
|
|
|
I've done that, although it took me about 6 months to notice than anything was wrong!
|
|
|
|
|
Hi there!
I am trying to compare the rows of a Datagridview and that it removes the rows that are repeated.
I think that I´m doing something wrong, need some of help!!
my mind is not clear today! (maybe x-mas holyday!  )
here´s the code:
public void Compare(DataGridView grv)
{
grv.Sort(grv.Columns[0],ListSortDirection.Ascending);
for ( int row = 0; row < grv.Rows.Count; row++)
{
for ( int col = 0; col < grv.Columns.Count; col++)
{
int rowx=1;
if (grv.Rows[row].Cells[col].Value != null && grv.Rows[row].Cells[col].Value.Equals(grv.Rows[rowx].Cells[col].Value))
{
if (col == grv.Columns.Count - 1)
{
grv.Rows.RemoveAt(row);
grv.Sort(grv.Columns[0], ListSortDirection.Descending);
}
}
else
{
grv.FirstDisplayedScrollingRowIndex = grv.RowCount - 1;
grv.Rows[grv.RowCount - 1].Selected = true;
}
}
}
}
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
2.0.82.7292 SP6a