|
I Execute "select * from dbo.Employees for xml auto" in sqlServer.
C# Develope:
SqlConnection sqlCon = new SqlConnection(@"server=JASON-FREE\SQL2K;database=Northwind;uid=sa;pwd=**");
SqlCommand sqlComm = new SqlCommand();
sqlComm.CommandType = CommandType.Text;
sqlComm.CommandText = "SELECT * FROM Employees for xml auto";
sqlComm.Connection = sqlCon;
sqlCon.Open();
//then how to write?
XmlReader xr = sqlComm.ExecuteXmlReader();//Is right?
|
|
|
|
|
You can fill a DataSet and use WriteXML() method.
|
|
|
|
|
Hi friend,
I have one datagridview.
-----------------------------------------------------
DataGridView dataGridView1 = new DataGridView();
dataGridView1.Size = new System.Drawing.Size(220, 150);
dataGridView1.TabIndex = 0;
DataGridViewCheckBoxColumn checkboxColumn = new DataGridViewCheckBoxColumn();
checkboxColumn.Name = "CheckBox";
checkboxColumn.Width = 60;
dataGridView1.Columns.Insert(0, checkboxColumn);
dtaGridView1.DataSource = dt; // dt is a datatable ref which have some data from database
----------------------------------
now i want one more column be there for true false value;
for example if datatable return 5 values to datagridview1 it shows all values
but if user check on any of checkbox of any row i want true/false (0,1) value in corresponding third column. whose name would be "TrueFalse".
so how to add another column..
Hope you understand my problem.
Thanks lot.
|
|
|
|
|
add column in DataTable then bind...
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hi,
I want to communicate to a modem from c# code. If any of you have idea about implementing this please share with me.
Thanks in advance
Prajin
|
|
|
|
|
|
Hello Friends,
I want to create the multilevel tree view in windows application using c#2.0.
I want to add the nodes in tree view form .
If one node has its child then that should be added under that parent node.
Which I am not able to do.
Regards,
rahul saini
|
|
|
|
|
use
TV.Nodes.Add();
to add a node in treeview,
and google, for more info
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
hi,
Thanks for your rply.
Actually I added the nodes in TV but not able to add child node under its parent node.
I am not able to find its parent node. To find I am using this :
treeNode findNode = new treeNode();
findNode = myNode.Nodes.Find(objReader["catId"].ToString(), true);
but giving the following error :
Cannot implicitly convert type 'System.Windows.Forms.TreeNode[]' to 'System.Windows.Forms.TreeNode'
Regards,
rahul saini
|
|
|
|
|
Find() return type is TreeNode[] so how can you assign TreeNode[] to TreeNode
The code will be :
TreeNode[] TN = myNode.Nodes.Find(objReader["catId"].ToString(), true);
to add node as child node, here is a sample
TV.Nodes[<Index Of Parent Node>].Nodes.Add()
hope this will help
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Thanks for this.
The error does't come again.
But not sure whether it finds the search node in treeNode.
Actually I m using the following code for populating the tree.
But not able to do as all the nodes are comming on same level.
If any node has child then its chils will be added under that.Not successed in doing this.
private void createTreeView2(string id)
{
TreeNode myNode = new TreeNode();
TreeNode findNode = new TreeNode();
string connStr = connString;
SqlConnection myConn = new SqlConnection(connStr);
string sqlQuery = "SELECT * from article where parentId='" + id + "'";
myConn.Open();
SqlCommand myCommand = new SqlCommand(sqlQuery, myConn);
SqlDataReader objReader = myCommand.ExecuteReader();
while (objReader.Read())
{
myNode = new TreeNode();
myNode = myNode.Nodes.Add(objReader["articleId"].ToString(), objReader["articleName"].ToString());
TreeNode[] findNode = myNode.Nodes.Find(objReader["articleId"].ToString(), true);
tvArticle.Nodes.Add(myNode);
if (isChild(objReader["articleId"].ToString()))
{
createTreeView2(objReader["articleId"].ToString());
}
}
}
This is my requirement.
rahul saini
|
|
|
|
|
ah, can you explain in details what exactly you want...as without knowing exactly, i cannot tell where is the problems
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
-Electronics
-TV
-Screen
58 CM
62 CM
68 CM
-Stereo
-withFm
-Washing
-washingMachine
-drymachine
Here are 4 levels but this could be any number of levels. What we want is to display this in tree view (+, -).
Following is the sample database.
articleID(auto incrementID) parentArticleId articleName status
1 0 Electronics A
2 0 Washing A
3 1 TV A
4 1 Stereo A
5 2 washingMachine A
6 2 dryMaching A
7 3 Screen A
8 7 58 cm A
9 7 62 Cm A
10 7 68cm A
11 4 With Fm A
This is the explanation of the requirement.
Regards,
rahul saini
|
|
|
|
|
here is simple code :
if (objReader["parentArticleId"] == 0)
TV.Nodes.Add(objReader["articleId"].ToString(), objReader["articleName"].ToString());
else
{
TreeNode[] findNode = TV.Nodes.Find(objReader["articleId"].ToString(), true);
findNode[0].Nodes.Add(objReader["articleId"].ToString(), objReader["articleName"].ToString());
}
hope it will work
TVMU^P[[IGIOQHG^JSH`A#@`RFJ\c^JPL>;"[,*/|+&WLEZGc`AFXc!L
%^]*IRXD#@GKCQ`R\^SF_WcHbORY87??6?N8?BcRAV\Z^&SU~%CSWQ@#2
W_AD`EPABIKRDFVS)EVLQK)JKSQXUFYK[M`UKs*$GwU#(QDXBER@CBN%
Rs0~53%eYrd8mt^7Z6]iTF+(EWfJ9zaK-i?TV.C\y<p?jxsg-b$f4ia>
--------------------------------------------------------
128 bit encrypted signature, crack if you can
|
|
|
|
|
Hi,
I wanted to find out the user name of the application.
Example: user name: rozhanin
I looked up on the net and i find answers which return the login name (dz2344).
I used the Active Directory and was able to find out the name (rozhanin), but this does not work on some computers.
Is there any other method to find the user name.
your help will be greatly appreciated.
Thanks!!
|
|
|
|
|
Hello,
If u r using Window Application than u may use SystemInformation. Like --
SystemInformation.UserName
Please reply.
Best of Luck.
Dipak
|
|
|
|
|
Hi Dipak,
Like i told you by using SystemInformation.UserName gives me the login id(example: dz1234) on the network. I wanted to find the name of the person with this login id (example: rozhanin).
I could achieve this by using InterOp.ActiveDs.dll, but this does not work on some computers. Is there any other method to find the Name of the user given the login id??
Thanks for your reply ,
rozhanin.
|
|
|
|
|
Hi! all.Right now m making a win Email application.I need to create a user interface and so users can select the recipients from Exchange Server Address Book, so user can send e-mail with attachment to the recipients in web application. so, anybody have any idea about that.i need a sample so i can use it in my project.
thanks..
|
|
|
|
|
Hi all,
I already convert a C++ project to C# project. It's fine and working ok.
On C++ I use DWORD data type. But in C# for that I used just a int value. Is that ok. Is there compatible data type which I can use for my project.
Thanks.
I appreciate your help all the time...
Eranga
|
|
|
|
|
Are you having an issue, or are you just worried in general ? long is bigger than int in C#.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Actually I worried this because it related with registry. So new value type should be compatible with registry data type REG_DWORD
I appreciate your help all the time...
Eranga
|
|
|
|
|
UInt32 or Int32 are equivalent to DWORD in c#.
|
|
|
|
|
Seems it is fine. Thanks a lot.
At the same time I found one thing. bool type variable gives the same output as DWORD. Do you guys know about it?
I appreciate your help all the time...
Eranga
|
|
|
|
|
I have a panel control contain 3 label on these labels i am using barcode font Code 39 now i want to print these barcode but i am unable to do so..
Can any one give me a code to print these barcodes.
|
|
|
|
|
Use DrawToBitmap method of control to draw image of control on a bitmap object.
After this you may use a PrintDocument and PrintPreviewControl and you may draw this bitmap image on PrintDocument using PrintPage event.
-Dave.
Dave Traister,
ComponentOne LLC.
www.componentone.com
|
|
|
|