Blank datagrid--parameter issue? - C# Discussion Boards

Single process instance object implemetation

22-Jun-06 8:28

Well, it's definitely the curly braces. That's confusing the Format method. When you want to put a '{' in the string use '{{'.

Logifusion[^]

h4rdw4re122-Jun-06 8:11

h4rdw4re1

22-Jun-06 8:11

Hi.
I'm new to C# but want to learn.
Can someone tell me how to implement (where to enter code mentioned below) a single process instance object that I found on:
http://www.codeproject.com/csharp/cssingprocess.asp?&forumid=11773
I can make that work, but then I don't see title bar of my program, so I'm sure I'm missed up somewhere Frown | :(

Thanks in advance.

Re: Single process instance object implemetation

Dustin Metzgar22-Jun-06 8:22

Is the text box value a number

22-Jun-06 8:22

I'm not sure where your problem is. Create a new windows application project in visual studio. Download the code that goes with the article you have. It's a CS file. Add that to your project. Make sure the namespaces are the same. Look in the Form1 code and find the Main method and add the following (as detailed in the article):

using(SingleProgramInstance spi = new SingleProgramInstance())
{
   if (spi.IsSingleInstance)
   {
      Application.Run(new Form1());
   }
   else
   {
      spi.RaiseOtherProcess();
   }
}

Logifusion[^]

sas949122-Jun-06 7:26

sas9491

22-Jun-06 7:26

I want to check the input to a text box is numeric (e.g., mmddyyyy). Is there a command for this?

sas

Re: Is the text box value a number

Stefan Troschuetz22-Jun-06 7:39

Stefan Troschuetz

22-Jun-06 7:39

If you're using framework 2.0 you could use DateTime.TryParse or the MaskedTextBox. Otherwise use DateTime.Parse.

"Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning." - Rick Cook

www.troschuetz.de

Re: Is the text box value a number

User 665822-Jun-06 7:47

User 6658

22-Jun-06 7:47

Int.TryParse

Will return true if the string is a number

regards

modified 12-Sep-18 21:01pm.

Blank datagrid--parameter issue?

leckey22-Jun-06 6:53

leckey

22-Jun-06 6:53

Hello again all. I found an example of a fully editable datagrid that was attached to the Northwind database. I have been tinkering with it to use with my own data. The code uses the Microsoft SQL Helper.cs class.

Originally the code opened the page, and returned all the employees in the NW database. I ran the project and everything was fine.

Original code:

private void BindData()<br />
		{<br />
			 ds = new DataSet();<br />
			//ds= SqlHelper.ExecuteDataset(this.connectionString, "dbo.GetEmployees", null);<br />
			Session["ds"]=ds;<br />
			dt = ds.Tables[0];<br />
			Session["dt"]=dt;<br />
			DataGrid1.DataSource=dt;<br />
			DataGrid1.DataBind();<br />
			<br />
		}

I changed it to take a parameter. The user enters a part number in a text box, and clicks a search button and then I want the datagrid to populate. It returns 3 blank rows. When I went through the debugger it looks like it tries to run through the SQLHelper code before it looks at the button click function.

I think it has to do with how I'm sending the parameters but I'm not sure because if I change the stored procedure and code for no parameters, it works.
Current code:

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtSearchPart.Text;<br />
			ds = new DataSet();<br />
			SqlParameter param = new SqlParameter("@PartID", strPartNumberInputReference);<br />
			ds=SqlHelper.ExecuteDataset(this.connectionString, CommandType.StoredProcedure, "dbo.GetPartInfoTest", param);<br />
			//ds=SqlHelper.ExecuteDataset(this.connectionString, CommandType.StoredProcedure, "dbo.GetPartInfoTest");<br />
			Session["ds"]=ds;<br />
			dt = ds.Tables[0];<br />
			Session["dt"]=dt;<br />
			dgParts.DataSource=dt;<br />
			dgParts.DataBind();<br />
			txtSearchPart.Text = "";<br />
			<br />
		}

Does anyone have any ideas? I didn't post the SQLHelper code as it is LONG but if someone is willing to help and needs it let me know.

Thanks again to all who help!

led mike22-Jun-06 7:45

led mike

22-Jun-06 7:45

So it looks like changing the ExecuteDataset() call resolved your previous problem?

leckey wrote:
if I change the stored procedure

Did you test the sp with the parameter in your Database environment?

leckey22-Jun-06 8:19

leckey

22-Jun-06 8:19

Yes, changing the ExecuteDataset to use Command.StoredProcedure got rid of the previous error.

I did test the sp with a parameter.
SP with parameter:

CREATE PROCEDURE [dbo].[GetPartInfoTest]<br />
@PartInfo varchar<br />
<br />
 AS<br />
SELECT * FROM Parts<br />
GO

BindData with parameter:

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtSearchPart.Text;<br />
			ds = new DataSet();<br />
			SqlParameter param = new SqlParameter("@PartID", strPartNumberInputReference);<br />
			ds=SqlHelper.ExecuteDataset(this.connectionString, CommandType.StoredProcedure, "dbo.GetPartInfoTest", param);<br />
			<br />
			Session["ds"]=ds;<br />
			dt = ds.Tables[0];<br />
			Session["dt"]=dt;<br />
			dgParts.DataSource=dt;<br />
			dgParts.DataBind();<br />
			txtSearchPart.Text = "";<br />
			<br />
		}

DataBind without parameter

private void BindData()<br />
		{<br />
			strPartNumberInputReference = txtSearchPart.Text;<br />
			ds = new DataSet();<br />
			SqlParameter param = new SqlParameter("@PartID", strPartNumberInputReference);<br />
						ds=SqlHelper.ExecuteDataset(this.connectionString, CommandType.StoredProcedure, "dbo.GetPartInfoTest");<br />
			Session["ds"]=ds;<br />
			dt = ds.Tables[0];<br />
			Session["dt"]=dt;<br />
			dgParts.DataSource=dt;<br />
			dgParts.DataBind();<br />
			txtSearchPart.Text = "";<br />
			<br />
		}

Josh Smith22-Jun-06 8:37

Josh Smith

22-Jun-06 8:37

The problem might be that your SP declares the parameter as @PartInfo, but you are creating an SqlParameter whose Name is @PartID.

leckey22-Jun-06 8:52

leckey

22-Jun-06 8:52

Okay, got my names matching.
I commented out the BindData call in th Page_Load

private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			<br />
			if(!Page.IsPostBack)<br />
			{<br />
				//BindData();				 <br />
			}<br />
			<br />
		}

So now I don't get three blank lines. But I don't get the data to return either. So I think my problem is how I'm setting up the page_load.

led mike22-Jun-06 9:49

led mike

22-Jun-06 9:49

leckey wrote:
I commented out the BindData call in th Page_Load

You have to call BindData() to get the Grid binding to execute. Also since this is a ASP.NET environment you might get more help in that forum.

Josh Smith22-Jun-06 10:01

Josh Smith

22-Jun-06 10:01

I wasn't implying that another call to BindData() would be problematic. It was just a way of explaining why the SqlHelper method was executing before the Button's Click handler. Without that call in Page.Load, I wouldn't expect the grid to show any data because that call is what initially populates it.

Josh

how to refresh or keep the graphics

Josh Smith22-Jun-06 7:52

Josh Smith

22-Jun-06 7:52

leckey wrote:
When I went through the debugger it looks like it tries to run through the SQLHelper code before it looks at the button click function.

Perhaps some other code in your app is calling SqlHelper methods too.

I assume that your BindData method (or the SqlHelper method) is being called from somewhere else in the application. You can do a global search in Visual Studio (hit Ctrl + Shift + F10) and search for DataBind or SqlHelper. See what you come up with. Alternatively you can set a breakpoint in the SqlHelper method, run in Debug mode, and when the breakpoint is hit you can check the Call Stack window to see what method called it.

If there is such a thing as Hell, it appears that you have entered it. Cool | :cool:

Cheers,
Josh

donkaiser22-Jun-06 6:37

donkaiser

22-Jun-06 6:37

hello im using the graphics class to draw some stuff on a form.

Graphics Draw = this.form1.CreateGraphics();
Draw.FillEllipse(Brushes.Red, Circles);

something like that. But once the graphic is drawn and i move another form over, it disappears. so how can i keep my graphic display all the time.

Thank you

Donkaiser

Dustin Metzgar22-Jun-06 6:49

22-Jun-06 6:49

You could create an image, get the graphics context off of the image, and draw it there. Then just keep that image up on the form.

Logifusion[^]

donkaiser22-Jun-06 7:05

donkaiser

22-Jun-06 7:05

do you have an example? I know the logic but im sure C# has some class that will take care that.
and by image u mean a bitmap image or jpg image.

Donkaiser

Dustin Metzgar22-Jun-06 7:33

22-Jun-06 7:33

Absolutely. Take your form and add a PictureBox control to it. Then in your constructor you can do this:

this.pictureBox1.Image = new Bitmap(this.pictureBox1.Width, this.pictureBox1.Height);
Graphics g = Graphics.FromImage(this.pictureBox1.Image);
g.FillEllipse(Brushes.Red, 5, 5, 50, 50);

You don't have to set anything on PictureBox, just put it on the form.

Logifusion[^]

A program to organize and fix data.

atuldeore22-Jun-06 7:16

atuldeore

22-Jun-06 7:16

The graphics drawn disappears because when you move the form, paint event occurs and it rpaints the form which eventually overwrites what you have written.
To make the drawn graphics persistant try to override the Paint event of the form.
Put your painting code in it.

Hope this helps.

Every bit counts

ADD

Noah Moerbeek22-Jun-06 5:38

Noah Moerbeek

22-Jun-06 5:38

Hi,

I am working on a little project right now and I need a little help getting started. I have an access database that is a giant mess with disorganized fields, data put in the wrong places etc.

What I want to be able to do is organize the data, export the new data to either a CVS file or some other readable file and put the garbage in a seperate notes feild. Then import all of the new data into an organized Access database. The problem is of course that the data is not organized and I thought it would be a fun project that could be usefull to other people. Also their is some redundancy in the database I would like to eliminate and sometimes abbreviations are not consistent.

I was wondering if this would be the best way of doing it (or even if I could complete the project this way)

Create An application to load the Access Database

Be able to search within the fields of information and replace inconsistent abbreviations with the one I that i have picked (I of course will have to allow the user to change this input per column) and delete what it is replacing.

Can I use a string split to create tokens to bust up the different data in some way and then reorder it in a specefic order.

Is it possible to have something that reads Agoodkid Johnny Smith

bust it up then reorder it to be Smith Johnny A goodkid and then have it proceed onto the next one that maybe even more messed up like 8989879RobCell Robert Smith

I had planned to use Regular Expressions but sense the data is not consistent in the way it is structured is it still possible to do this.

Would it be more advisable to tokenize all of the data just by cutting it up into pieces, saving it in some way (although I am not sure how I would do that) export all of the data to an XML file, tear it apart, then just call different parts of it in the right order based upon just querying on the XML document.

In summary after that somewhat confusing text

What would be the best method of fixing a very disorganized database by creating a utility to correctly order, change, edit and export the data into a new table (or data source of some kind)?

Selecting leaf node directly !!!

ankushmn22-Jun-06 4:57

ankushmn

22-Jun-06 4:57

Hello,

i have a problem while working with tree view control in window application.

Consider below tree

Window Application
|___ Language
|____ C++
|____ VB
|____ VC++
|____ . Net
|___ C#
|___ VB.Net

I am filling tree on form load and if i want to directly focus to node C# (it gets selected) and i want that tree to be expand up to that level.
and i have the imageindex of C#.

How to do it ???

Its urg Frown | :-(

(((

Thanx in Advance Smile | :)

))

Re: Selecting leaf node directly !!!

Dustin Metzgar22-Jun-06 5:07