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

Heath Stewart

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.