Re: fill a textbox from a dataset - C# Discussion Boards

11-Mar-04 4:43

Hi. This is probably real easy, but I just can't seem to figure it out. I have a dataset that returns a unique value. I would like to move that value to a textbox. No matter what I try, I can't get my code to fill the textbox.

I use a dataadapter, dataset, sqlcommand and sqlparm to read a sql2000 stored procedure. I put in the city name and get out the unique city id number we use. I've run teh stored procedure separately and I know it works. Do I databind the textbox to the dataset?

This is the code I'm currently using:
da = new SqlDataAdapter("ap_prs_frm_addr_urbn_cmty_id", addr_urbn_conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
ds = new DataSet();
SqlParameter addr_urbn_parm;

addr_urbn_parm = new SqlParameter("@cmty_desc", System.Data.SqlDbType.VarChar);
addr_urbn_parm.Direction = ParameterDirection.Input;
addr_urbn_parm.Value = ddlAddrUrbnCmty.SelectedItem.Text;

addr_urbn_parm = new SqlParameter("@cmty_id", System.Data.SqlDbType.VarChar);
addr_urbn_parm.Direction = ParameterDirection.Input;
addr_urbn_parm.Value = ds.ToString();
da.SelectCommand.Parameters.Add(addr_urbn_parm);

addr_urbn_conn.Open();
da.Fill(ds);
addr_urbn_conn.Close();

this.txtAddrUrbnCmtyID.DataBind();

Help!!!!!!!

Krisman

Guinness4Strength11-Mar-04 4:47

Guinness4Strength

11-Mar-04 4:47

try this

DataSet dSet = new DataSet;
///fill DataSet here
if(dSet.Tables["YourTable"].Rows.Count >0)
TextBox.Text=dSet.Tables["YourTable"].Rows[0]["YouFieldName"].ToString();

krisman11-Mar-04 5:28

11-Mar-04 5:28

Not quite getting result I thought, but at least there is a result! I'll do some more tinkering.

Thanks!

Krisman

partyganger11-Mar-04 5:56

partyganger

11-Mar-04 5:56

Or try using a Convert.ToString() around your DataSet result. Somehow ToString sometimes returns the Class name, i.e. DataColumn

Edbert P11-Mar-04 16:22

Edbert P

11-Mar-04 16:22

You can't just call DataBind() and expect .NET to solve everything for you.
You need to specify to which property of the textbox you want to bind the data to, and the table and column in the dataset.
Here's an example to bind the data to textbox's text property:

this.txtAddrUrbnCmtyID.DataBindings.Add(new Binding("Text", ds, "tableName.columnName"));

For more information, check the MSDN site for Binding Class[^].

Edbert P.
Sydney, Australia.

krisman15-Mar-04 2:56

15-Mar-04 2:56

This will only work in a Windows Form, I've learned that much. I'm building WebForms, so I have to come up with different round-about ways to do things. Microsoft has never been known for being user and/or developer friendly.

Krisman

Edbert P15-Mar-04 11:11

Edbert P

15-Mar-04 11:11

I doubt that, because I have used data binding in my web project.
Here's an excerpt of the code that I used:

cbApplication.DataSource = dsApplication.Tables(0)
cbApplication.DataTextField = "DirectoryName"
cbApplication.DataValueField = "IDDirectory"
cbApplication.DataBind()

Edbert P.
Sydney, Australia.

krisman16-Mar-04 2:51

16-Mar-04 2:51

I'll have to try again. But I keep getting errors and our .Net gurus where I work (our network guys) said it's because I'm trying to use a Windows Forms functionality with a Web Form. But I'm also working without a Localhost because of the way .Net was installed on our systems and servers.

Krisman

Windows XP and Shell

Guinness4Strength11-Mar-04 4:11

Guinness4Strength

11-Mar-04 4:11

I've been looking around the forums for hints on adding to the Windows context menu. I think I've figured it out reading eh Windows Shell programming guide. But I noticed i have install the DOSHere PowerToy some time ago, but I have never seen the DOS Here menu option in the Windows shell menu for directories. Does anyone know if XP no allows Context menu extensions for Directories anymore ?

here is the registry seetings for the DOS Here shel entry that does not show up:
Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Directory\shell]
@="none"

[HKEY_CLASSES_ROOT\Directory\shell\DosHere]
@="Command &Prompt Here"

[HKEY_CLASSES_ROOT\Directory\shell\DosHere\command]
@="C:\\WINDOWS\\System32\\cmd.exe /k cd \"%1\""

I even tried my own but it didn't work

Re: Windows XP and Shell

Mike Dimmick12-Mar-04 2:28

Mike Dimmick

12-Mar-04 2:28

Works fine for me.

Microsoft have a new 'Open Command Window Here' PowerToy for Windows XP which does the same thing. You can download it from http://www.microsoft.com/windowsxp/pro/downloads/powertoys.asp[^].

Stability. What an interesting concept. -- Chris Maunder

printing

cmarmr11-Mar-04 4:01

cmarmr

11-Mar-04 4:01

i know this sounds simple but can someone please tell me how i can draw boxes and circles to the printer

thanks
chad

Re: printing

Not Active11-Mar-04 4:30

Not Active

11-Mar-04 4:30

Check out the PrintDocument and Graphics classes. Printing is essentially no different from drawing on a windows form, the medium is just different.

Lock a file?

Anonymous11-Mar-04 3:29

Anonymous

11-Mar-04 3:29

How can you lock a file in .NET? I have a windows application that reads xml files. If two users are trying to read the same file, I want to lock the file so the second user can't read or change the file.

I'm looking for the most bare bones lock and unlock functionality.

Thanks
Wink | ;)

Heath Stewart11-Mar-04 5:25

11-Mar-04 5:25

The System.IO.FileStream can do this. Read the .NET Framework SDK for more information:

FileStream stream = new FileStream(path, FileMode.Open, FileAccess.Read, FileShare.None);
XmlTextReader reader = new XmlTextReader(stream);
try
{
  // Read from "reader" or something.
}
finally
{
  reader.Close();
  stream.Close();
}

This is a very simplistic example. Read about the FileStream constructor for more information.

Microsoft MVP, Visual C#
My Articles

Manster11-Mar-04 5:46

Manster

11-Mar-04 5:46

I just figured this out:

		private bool LockFile( string sFilePathToLock )<br />
		{<br />
			bool bFileLocked = false;<br />
<br />
			if( File.Exists( sFilePathToLock ) && ( File.GetAttributes( sFilePathToLock ) != FileAttributes.ReadOnly ) )<br />
			{<br />
				File.SetAttributes( sFilePathToLock, FileAttributes.ReadOnly );<br />
				// Use the FileAttributes.Archive to mark a file for deletion.<br />
<br />
				bFileLocked = true;<br />
			}<br />
<br />
			return bFileLocked;<br />
		}<br />
<br />
		private bool UnLockFile( string sFilePathToUnLock )<br />
		{<br />
			bool bFileUnLocked = false;<br />
<br />
			if( File.Exists( sFilePathToUnLock ) && ( File.GetAttributes( sFilePathToUnLock ) == FileAttributes.ReadOnly ) )<br />
			{<br />
				File.SetAttributes( sFilePathToUnLock, FileAttributes.Normal );<br />
<br />
				bFileUnLocked = true;<br />
<br />
			}<br />
<br />
			return bFileUnLocked;<br />
		}

Hope this helps.

Wink | ;)

astanley12-Mar-04 2:06

astanley

12-Mar-04 2:06

Although I'm a C# newbie, I can see Manster's solution will not work. See my (AS) comments below:

if( File.Exists( sFilePathToLock ) && ( File.GetAttributes( sFilePathToLock ) != FileAttributes.ReadOnly ) )<br />
{<br />
// AS Another thread/process could lock the file here, before this thread gets a chance<br />
// to lock it. Therefore the SetAttributes call will fail (throw an exception?).<br />
File.SetAttributes( sFilePathToLock, FileAttributes.ReadOnly );<br />
// Use the FileAttributes.Archive to mark a file for deletion.<br />
<br />
bFileLocked = true;<br />
}<br />
<br />
return bFileLocked;<br />
}

The original reply (to use FileStream) seems more like it, but you still need to trap the error when it fails to open the file because it is already locked.

Heath Stewart12-Mar-04 3:11

LicenseManager, LicenseProvider

12-Mar-04 3:11

This is not a correct solution. This only makes the file read-only to programs that check it. See my post for the correct solution, a solution that has been used for as long as filesystems have been around. This is the way it's supposed to be done and truly locks it while it's open from reading or writing by other processes.

Microsoft MVP, Visual C#
My Articles

claude12345678911-Mar-04 3:11

claude123456789

11-Mar-04 3:11

Hi,
I want to protect my component so i followed the sample from Microsoft but i get always the LicenseException. I have to say that i don't know how to implement the part in the host application. That a part of the code of my component :
[LicenseProviderAttribute(typeof(LicFileLicenseProvider))]

public class Info: Component
{
private License license = null;
public Info()
{
license = LicenseManager.Validate(typeof(Info), this);
}
Thanks in advance

Re: LicenseManager, LicenseProvider

Heath Stewart11-Mar-04 4:47

How to use SetForegroundWindow in C#...??

11-Mar-04 4:47

Read the documentation for LicFileLicenseProvider.GetLicense. The default LicFileLicenseProvider imlpementation looks for a file named myClass.lic, where myClass is the full name of the class. So, if you have a namespace like MyNamespace.MyClass, you must have a file in the same directory as your assembly that contains the component called MyNamespace.MyClass.lic. Inside that file you must include "MyNamespace.MyClass is a licensed component.".

Note, this LicenseProvider is meant only as an example. This is by no means secure and you should derive your own LicenseProvider to provide a more secure means of licensing your control.

Microsoft MVP, Visual C#
My Articles

Member 94012510-Mar-04 23:55

Member 940125

10-Mar-04 23:55

I want my program to open a postscript file and send Ctrl+C to ghostview,
this is part of my code:

Process.Start("gsview32.exe", openFileDialog.FileName);
SendKeys.Send("^c");

but I found ^c was sent to my own program not to ghostview, Confused | :confused:

someone told me I should use SetForegroundWindow to activate ghostview,
(like AppActivate in VB)
but I don't know how to give the parameter to SetForegroundWindow,
Can anyone give an simple example to activate my ghostview...?? Cry | :((

Thanks a lot !! Wink | ;)

Re: How to use SetForegroundWindow in C#...??

Syed Abdul Khader11-Mar-04 2:05

Syed Abdul Khader

11-Mar-04 2:05

You need window handle to use SetForeGroundWindow method.
You can the window handle using the FindWindow method.

HWND FindWindow(LPCTSTR lpClassName, LPCTSTR lpWindowName);

you can give null to the lpClassName and give the Windows title to the
lpWindowName to find the Window handle.

BOOL SetForegroundWindow(HWND hWnd);

Re: How to use SetForegroundWindow in C#...??

Heath Stewart11-Mar-04 4:42