Re: get value from database into a variable - C# Discussion Boards

Re: DataGrid - XML

blue_arc7-Feb-07 0:45

blue_arc

7-Feb-07 0:45

ur question is not very clear ... first describe it..

Ravi Kant Srivastava
(System Analyst)
HandsOn Technology & Engineering
Gurgaon
(India)
e-mail:ravikant@hte.co.in

Re: DataGrid - XML

The Brazilian One7-Feb-07 0:53

The Brazilian One

7-Feb-07 0:53

I want to show only some collumns from a XML file.

I have 3 collums: IDName - Name - Age

I want that the datagrid show only Name

I tried:

dataGrid1.DataSource = ds.Tables[1].Columns["Name"];

but it doesn´t work... can you help me?

ThankS!

Re: DataGrid - XML

Ryno Burger7-Feb-07 1:01

Ryno Burger

7-Feb-07 1:01

Try to use the index value instead?

Like this:

dataGrid1.DataSource = ds.Tables[0].Columns[indexofcolumn];

Re: DataGrid - XML

The Brazilian One7-Feb-07 1:03

The Brazilian One

7-Feb-07 1:03

I already tried it.. but, doens´t work as well..

thanks!

Fill a DataSet from a data source and update another data source

Kamran Zafar7-Feb-07 0:31

Kamran Zafar

7-Feb-07 0:31

My task is to fill a DataSet from a data source and update another data source
in C#.

For example I have two databases in SQL Server (i.e. db1 and db2).
I have table named ProdMkt_Contrib_Link in db1 with following columns:

ProdMkt_Contrib_Link
--------------------
ProdMktContributorID (PK)
ProductMarketID
Priority
Inactive
Contrib_Type_Override
ProdMkt_Contrib_Link_ID

The above columns data should be mapped/sync to the table named
ProdMktContribLink in db2:

ProdMktContribLink
------------------
ProdMktContributorID (PK)
ProductMarketID
Priority
InactiveFG
ContribTypeOverRide
AcumenProdMktContribLinkID

Note: The table name and few column name are different

Suppose few records are added and few are updated in the
db1.ProdMkt_Contrib_Link table.

I have filled the typed DataSet (DS1) with db1.ProdMkt_Contrib_Link (this
contains only added and updated records) ans also filled the another DataSet
(DS2) with db2.ProdMktContribLink (this contains all records).

Now I want that DS1 should be sync with the DS2. That is, the added records
should be added to the DS2 table rows and also updated records should be updated
to the DS2 table rows.

How can I achieve this in c#. Please suggest any good design or sample code.

Thanks,
Kamran

get value from database into a variable

Nekshan7-Feb-07 0:22

Nekshan

7-Feb-07 0:22

Will this get value dashboardid from table into variable 'str'?

int str = "select dashboardid from dashboardlogin where userid=101";

dashboardid is 'int' type in database.
but i have error if i use this:
Cannot implicitly convert type 'string' to 'int'.

do i need to add any other code also for getting its data into variable 'str'?

plz reply
thank you.
nekshan.

Re: get value from database into a variable

blue_arc7-Feb-07 0:43

blue_arc

7-Feb-07 0:43

hey this is wrong , either u write a stored procedured which will return a parameters from stored procedures..
or execute the query.
get the result set in to datatable and get ur value from there.

Ravi Kant Srivastava
(System Analyst)
HandsOn Technology & Engineering
Gurgaon
(India)
e-mail:ravikant@hte.co.in

Re: get value from database into a variable

Corinna John7-Feb-07 0:48

Corinna John

7-Feb-07 0:48

Your statement getsthe query string into the string variable str. The compiler error occurs, because str is declared as an int.

If you want to use LINQ to query the datasource, try this article:
http://www.codeproject.com/useritems/SudokuSolver.asp[^]

Otherwise you have to connect to the database and query it with an SqlCommand:

<br />
using (SqlCommand selectCommand = new SqlCommand("select dashboardid from dashboardlogin where userid=101", connection))<br />
{<br />
object objResult = selectCommand.ExecuteScalar();<br />
if (objResult != null)<br />
{<br />
	int str = (int)objResult;<br />
}<br />
}<br />

____________________________________
There is no proof for this sentence.

Re: get value from database into a variable

aSarafian7-Feb-07 0:52

aSarafian

7-Feb-07 0:52

You got it all wrong.

Please read a database tutorial.

Just a hint. Someone must execute the desired sql command , don't you think?

Its just as you have written
int a="Hello World";

the you just happen to have for text an a sql command.

Read the db tutorial.

Interface Implementation

naveen srirangam7-Feb-07 0:03

naveen srirangam

7-Feb-07 0:03

How to do the implementation of interfaces (written using .Net) between front and Back Office applications.

Kindly assit me ASAP as i have the Client Interview On this.

Thanks and Regards
Naveen Kumar S

Naveen

Re: Interface Implementation

gauthee7-Feb-07 0:12

gauthee

7-Feb-07 0:12

use implements keyword and mention the interface name you name want to implement for that class

class a implements interface a, interface b
...
...

*make sure all the methods of the implemented interfaces have been defined

Gautham

Re: Interface Implementation

Luc Pattyn7-Feb-07 7:59

Luc Pattyn

7-Feb-07 7:59

class a : b { ... }

"implements" is Java !

Smile | :)

Luc Pattyn

get a value from database into a variable

Nekshan7-Feb-07 0:02

Nekshan

7-Feb-07 0:02

Hi Friend!

From table 'dashboardlogin', i want an int type value : 'dashboardid' of a particlar row(suppose where userid =101), into a variable suppose 'str', so that i can display that variable in a function :
funEntrylogin(str, tb_id.Text, tb_pswd.Text, DateTime.Now, DateTime.Now);

Is this possible?
Can some1 plz help on it.
Thank you.
nekshan.

Re: get a value from database into a variable

gauthee7-Feb-07 0:10

gauthee

7-Feb-07 0:10

select @str=dashboardid from dashboardlogin where userid=101

Gautham

Re: get a value from database into a variable

Nekshan7-Feb-07 0:20

Nekshan

7-Feb-07 0:20

Will this get value dashboardid into variable 'str'?

int str = "select dashboardid from dashboardlogin where userid=101";

dashboardid is 'int' type in database.
but i have error if i use this:
Cannot implicitly convert type 'string' to 'int'.

do i need to add any other code also for getting its data into variable 'str'?

plz reply
thank you.
nekshan.

Re: get a value from database into a variable

gauthee7-Feb-07 0:38

gauthee

7-Feb-07 0:38

nekshan,

your variable str should also be the same type of the column, here your coulmn datatype is int, so declare @str int and try.

Check whether the dashboardid datatype in your table!!!

Gautham

Compactframe work(2.0) can support treeview.backcolour?

Sri harini6-Feb-07 23:50

Sri harini

6-Feb-07 23:50

Hi,

In am developing windows mobile 5.0 application using VS2005 C#.NET Compact framework(2.0).Is it support to treeview.Backcolour or not?..If not supporting any other alternate source?..Please tell me..

Thanks in Advance

Bye

using TreeView as a menu

Rocky#6-Feb-07 23:42

Rocky#

6-Feb-07 23:42

can u plz tell me how to make the treenodes collapse on a single click. I want to make a menu based on a tree view in a C# 2.0 windows Application. so the problem is that it need double click to collapse a tree node. In the after select event I tried to puit the statement e.Node.Collapse(); but it doesnt seem to be giving the result I want so can u help me?
thanks alot

Rocky

Re: using TreeView as a menu

VirtualVoid.NET7-Feb-07 1:35

VirtualVoid.NET

7-Feb-07 1:35

maybe Expand() or ExpandAll() ?! Smile | :)

VirtualVoid.NET

Re: using TreeView as a menu

Rizawn7-Feb-07 5:38

Rizawn

7-Feb-07 5:38

Hmm try this... For collapse use CollapseAll() And for expand use
ExpandAll() method e.g TreeView1.CollapseAll()

Q@!$3r

Re: using TreeView as a menu

Rocky#7-Feb-07 19:06

Rocky#

7-Feb-07 19:06

hmm alright.. I'll chk out what that does, just wondering whats the difference b/w collapse and expand Smile | :)

thanks alot

Rocky

remote

mihksoft6-Feb-07 23:01

mihksoft

6-Feb-07 23:01

Hy I have a remote application and I need to send to server an object who is a window control, and I can't do that.
If i send to server a string, it's works
Can tell how can I send an object like a window control to a server for my application?
The server know to serialize and deserialize.

10x

Collection Editor

bobsugar2226-Feb-07 22:32

bobsugar222

6-Feb-07 22:32

My object has a List<Color> property that I want the user to be able to edit. I was presenting all the object's properties in a PropertyGrid and this was working fine. I've since decided that I no longer need the user to see the other properties; only the List<Color>. So there's no longer a need for a propertygrid.

Anyone have any ideas how I could perhaps use the Collection Editor at runtime, outside of the propertygrid, or some other method of presenting the color collection to the user for editing without having to implement my own dialog.

Thanks

Re: Collection Editor

JoeSharp6-Feb-07 23:15

JoeSharp

6-Feb-07 23:15

hi
you can hide properties in the propertygrid with the Browsable attribute set tu false.

example:
[System.ComponentModel.Browsable(false)]
public int MyProperty
{
get {return myProperty;}
set {myProperty = value;}
}

akkram6-Feb-07 22:32

akkram

6-Feb-07 22:32

Hello,

I have a problem when using MS Visual Studios 2005 build in DataSet Designer. In my App I want to work with two related tables, one Parent and one Child table.

ParentTable
-----------
ParentID (pk)
ParentName

ChildTable
-----------
ChildID (pk)
ChildName
ParentID (fk)

When I do this the old fashion way (not using the designer), I have no problem accessing the Child records related to the Parent record im working with. Here's the working code:

DataRelation parentChildRelation;
DataColumn colMaster;
DataColumn colDetail;
colMaster = parentChildDataSet.Tables["Parent"].Columns["ParentID"];
colDetail = parentChildDataSet.Tables["Child"].Columns["ParentID"];
parentChildRelation = new DataRelation("parentChildRelation", colMaster, colDetail);
parentChildDataSet.Relations.Add(parentChildRelation);

Now i can access the relation using
parentRow.GetChildRows(relation, DataRowVersion.Default);

But when I do the same thing but using the DataSet designer (adding the two tableadapters for the Parent and Child table and adding a relation between them from the DataSet Toolbox) I can't access the relation in my code.
I have looked in the Designer.cs and it adds the code for the relation:

this.relationParent_Child = new System.Data.DataRelation("Parent_Child", new System.Data.DataColumn[] {
this.tableParent.ParentIDColumn}, new System.Data.DataColumn[] {
this.tableChild.ParentIDColumn}, false);
this.Relations.Add(this.relationParent_Child);

But still a call like this: parentTable.ChildRelations; ends up empty..

Anyone have any idea why?

/Thanks - Martin

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.