adding data from textbox in to a datagrid? - C# Discussion Boards

Gareth H19-Jan-08 9:57

19-Jan-08 9:57

kingletas,

Final project?, as in University?

Regards,
Gareth.

Paul Conrad19-Jan-08 11:41

19-Jan-08 11:41

kingletas wrote:
I have a friend who needs my help doing his final project

Your friend is best asking his instructor for guidance. That is what they are supposed to be there for.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

kingletas19-Jan-08 15:28

kingletas

19-Jan-08 15:28

Paul Conrad wrote:

Your friend is best asking his instructor for guidance. That is what they are supposed to be there for.

I agree on that. I asked my friend to find out what kind of project or field his professor wanted but all my friend got from him was a "Think what you would like to do and we talk on Tuesday."

This is very important because this is like one big step to graduate from University.

Another thing is that my friend doesn't really know a thing about programming or hardware, so basically i will be tutoring/helping him build the project from the beginning to the end. I know there are a lot of "ethic/moral" principles involve and it might be wrong to do it. But as long as i don't cross the line between helping him to do it and do it myself i think it will be ok.

I thought of a: "Vehicle with a camera and fingerprint reader to ID the driver and the passengers" good for companies with no passengers policies. This is project is more suited for my country Dominican Republic where people tends to give a ride to anyone.

Also i thought of Mobile/smartphone application that constantly send a message where the owner is located, but the fact of violating the principle of privacy makes me uncomfortable; so i am about to discard that idea.

I have this tools, maybe it will help to know i have them:

* Microsoft Visual Studio 2005
* Microsoft Sql Server 2005
* Microsoft Finger Print Reader & the GrFinger SDK
* An extra low resolution small camera
* If it is needed i can get a GPS receiver.
* 2 PDA with WM 5
* Belkin Bluetooth adapter
* a few Atmega 8 with the "programmer"

Again Thanks for the help,

Best regards.

Luis E Tineo S

Gareth H20-Jan-08 0:22

20-Jan-08 0:22

kingletas,

If your friend is not a programmer, do you think he will be able to do your idea of a camera and finger print reader?, with that idea, you will be writing it your self. I think you should go for something FAR simpler: a CRM app (SalesForce.com) or a content management website like Blackboard.com.

Think SIMPLE.

Regards,
Gareth.

Paul Conrad20-Jan-08 9:05

adding data from textbox in to a datagrid?

20-Jan-08 9:05

kingletas wrote:
my friend doesn't really know a thing about programming or hardware

What is he majoring in?

kingletas wrote:
"Vehicle with a camera and fingerprint reader to ID the driver and the passengers"

For someone who really isn't a programmer, this would be very bad. Try something simple.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer

nigel200019-Jan-08 5:39

nigel2000

19-Jan-08 5:39

hi guys, i am writing a application, i have 3 textboxes which are called "items", "Cost", and "Date". i write text into them click an "add" button then i want this data to go in to the datagrid which as columns named items, cost and date. could someone please tell what code to put in the add_click event? thanks

Paul Conrad19-Jan-08 7:20

19-Jan-08 7:20

There should be an Add method for adding new rows to the datagrid.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Muhammad Shahid Farooq19-Jan-08 7:55

Muhammad Shahid Farooq

19-Jan-08 7:55

//Create a new instance of DataSet
DataSet objDataSet = new DataSet("TableName");

//Create a new DataRow in the DataSet
DataRow objDataRow = objDataSet.Tables["TableName"].NewRow();

//Assigning text values to their respective data columns
objDataRow["items"] = txtItems.Text;
objDataRow["cost"] = txtCost.Text;
objDataRow["date"] = txtDate.Text;

//Adding the row in the DataSet
objDataSet.Tables["TableName"].Rows.Add(objDataRow);

Paul Conrad19-Jan-08 11:42

19-Jan-08 11:42

Good job doing his work for him. You didn't add any real learning value for him by doing it for him.

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Displaying the output of one window form in another window form

nigel200019-Jan-08 22:34

nigel2000

19-Jan-08 22:34

this builds fine but there is null exception coming up when i try to input data on the line where the new row is created, am i right in thinking this needs a value? if so what value can i give it?

Ofori Boadu19-Jan-08 4:15

Ofori Boadu

19-Jan-08 4:15

I am developing an application that combines images. I have one form that communicates with a webcam and another that communicates with a signature pad and the main form. My problem is that I want to display the image that my webcamm takes in a picturebox on the main form. Any ideas?

a novice

Re: Displaying the output of one window form in another window form

Paul Conrad19-Jan-08 7:21

Concatting 2 fields in SQL from 2 tables

19-Jan-08 7:21

Ofori Boadu wrote:
Any ideas?

Maybe google...

"I guess it's what separates the professionals from the drag and drop, girly wirly, namby pamby, wishy washy, can't code for crap types." - Pete O'Hanlon

Gareth H19-Jan-08 4:01

19-Jan-08 4:01

Hi,

I am trying to select from two tables and concat two values. Thus, i should get a result of "324324234, gareth111".

SQL is below as well as the error.

SELECT UNet_Engineer.EngineerId + ', ' + UNet_Login.Username FROM UNet_Engineer, UNet_Login WHERE UNet_Engineer.EngineerId=UNet_Login.EngineerId;

DbConnection.ExecuteSelect; Exception: System.Data.OleDb.OleDbException: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.<br />
Data type mismatch in criteria expression.<br />
   at System.Data.OleDb.OleDbDataReader.ProcessResults(OleDbHResult hr)<br />
   at System.Data.OleDb.OleDbDataReader.GetRowDataFromHandle()<br />
   at System.Data.OleDb.OleDbDataReader.GetValueBinding(MetaData info)<br />
   at System.Data.OleDb.OleDbDataReader.GetValues(Object[] values)<br />
   at System.Data.ProviderBase.DataReaderContainer.CommonLanguageSubsetDataReader.GetValues(Object[] values)<br />
   at System.Data.ProviderBase.SchemaMapping.LoadDataRow()<br />
   at System.Data.Common.DataAdapter.FillLoadDataRow(SchemaMapping mapping)<br />
   at System.Data.Common.DataAdapter.FillFromReader(DataSet dataset, DataTable datatable, String srcTable, DataReaderContainer dataReader, Int32 startRecord, Int32 maxRecords, DataColumn parentChapterColumn, Object parentChapterValue)<br />
   at System.Data.Common.DataAdapter.Fill(DataTable[] dataTables, IDataReader dataReader, Int32 startRecord, Int32 maxRecords)<br />
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br />
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)<br />
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)<br />
   at UNet.Manager.Database.DbConnection.ExecuteSelect(String sql) in D:\UNet.Manager\Database\DbConnection.cs:line 90

Any ideas?

Regards,
Gareth.

pmarfleet19-Jan-08 4:56

19-Jan-08 4:56

What data type is UNet_Engineer.EngineerId? If it is numeric, you need to cast it to a string data type before attempting the concatenation. CAST(UNet_Engineer.EngineerId AS VARCHAR) should do it.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Gareth H19-Jan-08 6:31

19-Jan-08 6:31

Hi,

I changed the SQL as you said, but it produced a new error.

SELECT CAST(UNet_Engineer.EngineerId AS VARCHAR) + ', ' + UNet_Login.Username FROM UNet_Engineer, UNet_Login WHERE UNet_Engineer.EngineerId=UNet_Login.EngineerId;<br />
<br />
DbConnection.ExecuteSelect; Exception: System.Data.OleDb.OleDbException: IErrorInfo.GetDescription failed with E_FAIL(0x80004005).<br />
   at System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS dbParams, Object& executeResult)<br />
   at System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)<br />
   at System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)<br />
   at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)<br />
   at System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)<br />
   at System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)<br />
   at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)<br />
   at System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior)<br />
   at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)<br />
   at UNet.Manager.Database.DbConnection.ExecuteSelect(String sql) in D:\UNet.Manager\Database\DbConnection.cs:line 90

Regards,
Gareth

Gareth H19-Jan-08 6:38

19-Jan-08 6:38

Just thought i'd add. I am using MS Access as my db.

Regards,
Gareth.

pmarfleet19-Jan-08 9:11

19-Jan-08 9:11

gareth111 wrote:
Just thought i'd add. I am using MS Access as my db.

Ah. I'd assumed you were using SQL Server. The syntax I provided is specific to T-SQL and won't work in Access.

My Access knowledge is somewhat lapsed and I don't have it installed on my PC. Have you tried executing your original query directly through the Access IDE? You might get some more meaningful information on the cause of the error.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

Gareth H19-Jan-08 9:59

19-Jan-08 9:59

pmarfleet,

I have not tested that. But, is there a way of making it not database dependent? Because this project is aimed at running on a variety of database systems and i dont want to have to change the SQL every time, and yes, i know i could use stored procs to solve this, but is there another way.

Regards,
Gareth.

pmarfleet19-Jan-08 10:08

how to display percentage of compeletion of bacup sql server in my app ?

19-Jan-08 10:08

gareth111 wrote:
But, is there a way of making it not database dependent?

AFAIK, string concatenation is pretty standard across different database providers. However there are likely to be subtle differences. For instance, in T-SQL you are required to cast non-string values to strings before attempting to concatenate that value with another string. Access is more forgiving, and I believe doesn't require explicit casting. If you want database independence, you should limit yourself to pure ANSI SQL in your queries and perform any data manipulation in your middle tier.

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

hdv21219-Jan-08 3:45

hdv212

19-Jan-08 3:45

hi if u run this tsql command :
backup database northwind to disk='c:\nw.bak' with format,stats=10
it display percentage of compeletion of backing up your database in sql server output window, but i want to display it, in my app, how to do that ?
thanks

Re: how to display percentage of compeletion of bacup sql server in my app ?

pmarfleet19-Jan-08 5:00

Re: how to display percentage of compeletion of bacup sql server in my app ?

19-Jan-08 5:00

I doubt that this information is accessible. Instead, why not consider showing some sort of animated graphic? Something like the progress bar that Windows XP displays upon loading?

Paul Marfleet

"No, his mind is not for rent
To any God or government"
Tom Sawyer - Rush

hdv21219-Jan-08 5:22

hdv212

19-Jan-08 5:22

thanks Paul Marfleet
but i think a way that show it in omy app.
however can u more explain of your suggestion ?
thanks

Re: how to display percentage of compeletion of bacup sql server in my app ?

pmarfleet19-Jan-08 5:53