|
well, sounds like your good at this! All my project had to do was wait until shutdown, then display a form to the user, accept some input, then they click submit or cancel shutdown, and it either shutdowns or hides the program again for later. Could have been done in a couple hours by a pro, just I wasted time trying service with interface, also wasted time using listview with checkboxes (because i wanted some colour text) but had problems disable checking on click which was easier with checkedlistbox.
Hopefully I can be of some use for your next post.
Brian
|
|
|
|
|
|
Don't spam the forum.
Also, if you make an effort to write proper english, you have a better chance of getting an answer. Many people here doesn't have english as their first language, or even second.
"do u c wat i m getn at?" 
---
b { font-weight: normal; }
|
|
|
|
|
If someone could/would help you would have received an answer by now. Re-posting your question to the board (spamming) is not considered considerate behaviour.
...Steve
"Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once 
|
|
|
|
|
Consider this table format(Id, KK, Value, Period). I have got a datatable named abc in a dataset loaded with this huge data spanning over 24 months(yyyymm period format). I want to search for a particular field (KK) from this datatable and get the data for KK in descending order of period. Note that the value is 0 for certain period. i.e.I want to obtain the value (value <> 0) for the most recent period for KK from the datatable.
Any help will be useful.
With Best Regards,
Mayur
-- modified at 7:24 Monday 16th January, 2006
|
|
|
|
|
You could use the DataView functionality.
You can get one via myTable.CurrentView (you could also create a new one). The view has a property sort which you can set to "Period DESC" and a property Rowfilter which you could set to "Value <> 0" (probably its "!= 0 - im not sure). Now you can iterate over the DataView
foreach (DataRowView drv in myDataView){
drv.Row;
object kkVal = drv["KK"];
}
or just take the first element
object firstVal = myDataView[0]["KK"];
|
|
|
|
|
Robert, thnx for your help. Since I am a fresher in .Net, could you plz explain how data can be filled in the dataview and then searched.
With Best Regards,
Mayur
|
|
|
|
|
The DataView for itself doesn't contain any data. It's (as it name says) only a different view on the data.
Assuming you have a DataTable myDataTable with your specified columns:
DataTable myDataTable;
DataView dataView = new DataView(myDataTable);
dataView.Sort = "Period DESC";
dataView.Filter = "Value <> 0";
object firstKK = dataView[0]["KK"];
foreach (DataRowView drv in dataView) {
DataRow dr = drv.Row;
}
|
|
|
|
|
Hi Robert,
I have created a dataview of the entire dataset and sorted it as per PERIOD DESC.
str2 = "select pfc,price,period from price where price <> 0 "
con.Open()
DA2 = New OleDbDataAdapter(str2, pcon)
DS2 = New DataSet
DA2.Fill(DS2, "price")
con.Close()
DV = New DataView(DS2.Tables("price"))
DV.Sort = "Period Desc"
''' I have not applied any filter since the the data does not contain any zero prices (see str2).
//Get the first KK value
object firstKK = dataView[0]["KK"];
//Iterate over all values
foreach (DataRowView drv in dataView) {
//get original row
DataRow dr = drv.Row;
//do anything you want
}
'''Robert, I am not able to understand the above code. I will explain my requirement.
*The dataset which I fetch above contains data over 24 months.
*pfc is a unique id.
*When I get the data into the dataset, it contains all the records for each pfc where price <> 0.
*I am getting another set of pfc's from a different table into a new dataset. I want to obtain the price for each pfc from this dataset for the latest period (yyyymm).
Robert, Can you tell me how this can be done. I do not want ot query the database for each pfc as it is taking a lot of time.
Thnx for your help.
With Best Regards,
Mayur
|
|
|
|
|
As you don't seem to have a problem with C# examples I'll just continue it that way :
For this requirement you won't even need a DataView. Assuming you have a DataTable dt and Period is a formatted string column:
DataTable dt;
string maxPeriod = dt.Compute("MAX(Period)");
DataRow[] rowsWithMaxPeriod = dt.Select("Period = '" + maxPeriod + "'");
Now you have an array with all rows which match the criteria.
|
|
|
|
|
Thnx Robert, Though I am a VB Guy, the C# code is fine with me. I have gone through your code. From what I understand, maxPeriod gets the maximum period of all the rows. However I fail to understand the second line that you have mentioned. to filter the records. Could you plz explain it to me. Also, as I had mentioned in my previous reply, I need to obtain the price for the maximum period. However, consider that there is no price for a particular record for the maximum period, then I need to find the previous price (previous month and son on...). I hope you get what I want to say.
With Best Regards,
Mayur
|
|
|
|
|
I thought I understood you but now I'm not totally sure anymore
The Select function returns all rows of a table as an array who fullfill a given criteria. Thus the given statement returns all rows which have the maximum period set.
To avoid further misunderstanding could you post a snippet of the data you have and tell me what the result should be for this? And please clarify me on the price. In a previous post you said that the data is already filtered with <> 0 but now you say I have to take it into account here. I'm a bit irritated.
|
|
|
|
|
Hey Robert, I am extremely sorry for the trouble. Since I am quite new to .Net, I could not explain the exact issue that I am having and the steps that I have followed. However, the good news is that I have found a way, thanks to the steps you have provided.
I am using a dataview to store the entire 24 months data. Then I am getting the records for which I need to obtain the price in another dataset. Then I loop this dataset and in this loop I run another loop on the dataview. Since I have sorted the data in the dataview as per PERIOD DESC, the first occurrence of the data is the price that is needed. When the price is obtained, it is updated in the database and exit loop.
This is actually saving a lot of time that my earlier procedure was taking. Since The Data goes into lakhs, the processing time consumed is very crutial.
Finally, I want ot thank you once again for helping me out and bearing with me for the last few days. Next time if I have a problem, I surely know whom I need to turn to...
With Best Regards,
Mayur
|
|
|
|
|
Who can tell me how to declare a string with double-quotation mark ?
I have total lost.
Thanks
|
|
|
|
|
Use double quoutes:
myString = "This is a string with ""quote"" in it."
---
b { font-weight: normal; }
|
|
|
|
|
cylix2000 wrote: Who can tell me how to declare a string with double-quotation mark ?
What? Didn't the Visual Studio help files contain this information ?!
cylix2000 wrote: I have total lost.
Yep.
...Steve
"Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once
|
|
|
|
|
I have been using the interop word 11 object to build link fields in word so
I can include word excel and powerpoint documents inside a Word document.
The links build fine and when I open the document I cna highlight the link
fields and hit F9 to update them and pull in the target document.
The problem is that I would really like to be able to this from
inside vb.net so the end users doesnt have to do it manually.
The following code should do exactly this but it just doesnt work.
Can anyone explain why this is? thanks.
Dim wordApp As New Word.ApplicationClass
Dim wordDoc As New Word.DocumentClass
Dim fenum As IEnumerator
Dim field As Word.Field
wordApp.Visible = True
wordDoc = wordApp.Documents.Open(filename)
fenum = wordDoc.Fields.GetEnumerator
Do While fenum.MoveNext = True
field = fenum.Current
field.Select()
field.Update()
Loop
wordDoc.Save()
CType(wordApp, Word._Application).Quit()
wordApp = Nothing
thanks again Michael
|
|
|
|
|
HELLO FRIENDS
HOW CAN I ADD REFRENCE OF EXCEL IN .NET
PLEASE TELL ME STEP BY STEP
asdf
|
|
|
|
|
What version of Excel ? Either way, the answer is just a google away, but it does depend on the version.
Christian Graus - Microsoft MVP - C++
|
|
|
|
|
|
I am having trouble when converting the following code from my original VB to VB.NET code. I wish someone can help me on this code,I keep on trying but it doesn't really runs. How should I change for it to run in VB.NET? Please give me some solution,I'm really new to this. Thank you so much~!
Private Sub TT_Engine_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
Service_Name = "TT"
Label1.Text = Service_Name & "_Reminder"
If Dir(App.Path & "\Logs", vbDirectory) = "" Then
MkDir(App.Path & "\Logs")
End If
'############## Used For Log File ###########################################
Log_File_Name = Service_Name & "_Reminder.log"
Dim file_exist As Boolean
file_exist = mFileSysObj.FileExists(App.Path & "\Logs\" & Log_File_Name)
If (file_exist) Then
logFile = mFileSysObj.GetFile(App.Path & "\Logs\" & Log_File_Name)
Else
mFileSysObj.CreateTextFile(App.Path & "\Logs\" & Log_File_Name, True)
logFile = mFileSysObj.GetFile(App.Path & "\Logs\" & Log_File_Name)
End If
'################ Database Setting ######################################
MaxServerIP = "local"
MaxServerPass = "local"
DiServerIP = "local"
DiServerPass = "local"
MaxServerGatewayIP = "local"
MaxServerGatewayPass = "local"
DellServerIP = "local"
DellServerPass = "local"
End Sub
|
|
|
|
|
Use the File and Directory classes in System.IO namespace, like Directory.Exists(), Directory.CreateDirectory(), File.Exist(), File.OpenRead(), File.Create() et.c.
---
b { font-weight: normal; }
|
|
|
|
|
I'm sorry to disturb you again. I'm really new to this VB.NET. Can you give me more detail solution for this code? Or you may give me some example which is very similar to this?
Hope someone can give me a help here. Thanks~!
|
|
|
|
|
Look up the methods I mentioned in the documentation, and you will find examples on how to use them.
---
b { font-weight: normal; }
|
|
|
|
|
Have you tried using the code conversion add-in supplied in VS.NET ?
...Steve
"Give a man a fish and you've fed him for a day. Teach him how to fish and you've fed him for life." (Translation: I'll show you the way, but not write the code for you.) I read that somewhere once
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
