|
|
I think you should forget what I told you and follow the advice posted by Heath Stewart. His solution is a "More Managed Solution"
Anyway...
Forever Developing
|
|
|
|
|
hi,
I am executing a select() method agnest a data table. I got result as DataRow[]. Here i got collection of datarow.
My question is how can i create a table from this DataRow[] without executing all unwanted iteration(iterating through individual datarow or something).
Specifically : How can i create a table from a DataRow collection. 
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Hi
If the result is the type of 'DataRowsCollection' then you can directly assign it to DataTable's Rows property.
If it is a collection of DataRows then you have to iterate one by one
M.Sendilkumar
TVS Infotech Ltd
Chennai
|
|
|
|
|
hi,
I think you didn't understood my question. See i don't want to iterate through any row hell. Do you have any other solution for this ?
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Hi Sreejith
There is no other way.But we can minimize the work in iteration.
SqlConnection con=new SqlConnection(@"Data Source=YOURSERVER\INSTANCENAME;Initial Catalog=Northwind;UID=sa; PWD=sa;");
con.Open();
SqlDataAdapter adpt=new SqlDataAdapter("select OrderID,CustomerID,EmployeeID from orders",con);
DataTable dt1=new DataTable();
adpt.Fill(dt1);
DataRow[] dr=dt1.Select("customerid='vinet'");
DataTable dt2=new DataTable();
for(int i=0;i<dr.GetLength(0);i++)
{
dt2.ImportRow(dr[i]);
}
int a=dt2.Rows.Count;
------------------------------------
try this.
---------------------------
M.Sendilkumar
TVS Infotech Ltd
Chennai
|
|
|
|
|
Right now I am working with DataGrid.CurrentRowIndex
how to do if I have to select multiple rows.
Thank you,
======
Yo need a brain to code.
|
|
|
|
|
hi,
What is your real requirement ?. We can select more than one record in a datagrid. Select() method is used to select a perticular row. And Unselect() method doing the reverse of Select(). you can check whether a perticular row is selected or not by using IsSelected() method. I recommand you to read the DataGrid Class description in MSDN.;)
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Hello Sreejit,
I have used DataGrid_MouseUp() event and then used DataGrid.CurrentRowIndex to get the current row.
private void DataGrid_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)<br />
{<br />
int i = DataGrid.CurrentRowIndex;<br />
}
But how can I get multiple rows index if I have selected multiple rows.
like this>>
private void DataGrid_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)<br />
{<br />
for (int i = 0; i <= DataGrid.CurrentRowIndexes:confused:; i++)<br />
{<br />
int j = DataGrid.CurrentRowIndexes[i];<br />
}<br />
}
======
Yo need a brain to code.
|
|
|
|
|
//For collecting the index of selected records
ArrayList Ar=new ArrayList();
private void DataGrid_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
{
for (int i = 0; i <= DataGrid.CurrentRowIndexes; i++)
{
/*this line will help you to deside whether row is selected or not. If yes then it will return a bool value. Else will return a false value.*/
if(DataGrid.IsSelected(i)
Ar.Add(DataGrid.CurrentRowIndexes[i].ToString());
else
continue;
}
}
So finally you will get all index of selected row in your ArrayList.
Remaing is upto you to design based on your requirement.;)
**************************
S r e e j i t h N a i r
**************************
|
|
|
|
|
Sreeji, Thank you very much. I appreciate your help.
======
code proj. rocks!
|
|
|
|
|
Hi, I wonder if it is possible to detect somehow (from C# app) when the Windows plays some specific .wav file?
What I wanna do is to "subscribe" for that event and do my job when some specific .wav file gets played.
Any ideas?
thanks!
|
|
|
|
|
You're most likely going to be able to do this simply by a mechanism that watches if a file is read, as opposed to played specifically.
Christian
I have drunk the cool-aid and found it wan and bitter. - Chris Maunder
|
|
|
|
|
|
How to I paste text to and from clipboard while preserving the formating. Because when I paste from the clipboar, the text that use to be bol is not, etc...
Say from 1 textbox into another. Or from a textbox into a word document.
Thanks
|
|
|
|
|
|
I got it to copy, my question is that why it still looses format.
Storing Info:
IDataObject d = Clipboard.GetDataObject();
//d.SetData(DataFormats.Rtf, true, richTextBox1.Text);
// d.SetData(DataFormats.Rtf, richTextBox1.Rtf);
Clipboard.SetText(richTextBox1.Text, TextDataFormat.Rtf);
Retriving info:
foreach (Word.Shape bkMark in aDoc.Shapes)
{
if (bkMark.TextFrame.TextRange.Text.Contains("heading"))
{
// bkMark.TextFrame.TextRange.Paste();
bkMark.TextFrame.TextRange.Text = Clipboard.GetText(TextDataFormat.Rtf).ToString();
//Clipboard.GetDataObject().GetData(DataFormats.Text).ToString();
//
//
}
}
|
|
|
|
|
bkMark.TextFrame.TextRange.Text contains plain text by definition, if you want formatted text you'll have to use clipboard pasting.
To have control over what will actually get pasted you'll have to specify that you want RTF. IIRC there's a PasteSpecial (or something similar) where you can tell Word what format to paste.
Regards,
mav
|
|
|
|
|
Hi
I try to use GetPrivateProfileResString to quickly retrive .ini file information but I dont know how to make a declaration....
Does someone know?
busio
|
|
|
|
|
read this article.
http://www.codeproject.com/csharp/cs_ini.asp
Sanjay Sansanwal
www.sansanwal.com
|
|
|
|
|
S Sansanwal wrote:
http://www.codeproject.com/csharp/cs_ini.asp
http://www.codeproject.com/csharp/cs_ini.asp
[^]
This message brought to you by the click-it cops
Best,
Jerry
Contrary to the cliche, genuinely nice guys most often finish first or very near it.--Malcolm Forbes Toasty0.com
|
|
|
|
|
|
Hi,
I have a list view control with Label Edit Style.
When the user presses a key while an item is selected, Editing should start immediately.
I catch the KeyPress notification and enter edit mode, but I also have to set the edit's contents (or send the simulate the key event).
For that, I think I need the Edit control itself. Is this possible?
we are here to help each other get through this thing, whatever it is Vonnegut jr.
sighist Fold With Us! || Agile Programming | doxygen
|
|
|
|
|
Hi,
I am attempting to connect with MSDE for the first time with V# .NET, so this is probably a simply questions but I would appreciate help.
I have downloaded an SQL frontend called Teratrax which seems to be great?
My problem is getting full access to the SQL tables I have created, I have difficulty understanding the difference between: Database users and Server logins?
The command SqlConnection is giving me problems, what is 'dbo' user and whats the password for it, my tables appear to be owned by this user?
Any help would be greatly appreciated!
Many thanks for your time and may the force be with you! (you'll need it!)
|
|
|
|
|
Dam.NET wrote:
Database users and Server logins?
A server login is anyone that is permitted to log in to the SQL Server. Each server can host multiple databases, so the Database Users are the users permitted to access a particular database. When a database user is created it must know which login the user is accessing the database with.
To create a login in T-SQL use the command sp_addlogin[^]. And to create a database user use sp_grantdbaccess[^]. These links should give you more information.
Dam.NET wrote:
what is 'dbo' user and whats the password for it
The "dbo" is the DataBase Owner. There is no password for it. The "sa" account (System Administrator) is automatically the dbo, as it any user that has the sysadmin role.
As a general rule all objects (tables, views, stored procedures etc.) in the database should be created by a sysadmin user. Users with the db_owner role are permitted also to create objects but they are owned specifically by that user. At the moment I don't want to overload you will lots of information, suffice to say that is is better to have a sysadmin user create all the database object as it can be a real pain in the neck sorting out the security within a database if you allow joe-user to start creating tables, views, stored procedures etc.
"If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell
Not getting the response you want from a question asked in an online forum: How to Ask Questions the Smart Way!
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
