|
How to Find last Sundays Date using VB.net Code ?
Sagar J
|
|
|
|
|
First find the Sunday using Weekdayname and then if it is TRUE,then Stored the date nad minus 7 from it then you will get the date and using that day in the Weekdayname you can verify that whether it was sunday or not.
|
|
|
|
|
Uhm, I'm not exactly sure what Zafeer is saying, but here's some code that works:
Dim lastSunday As Date
lastSunday = DateAdd("d", -Weekday(Now), Now)
|
|
|
|
|
Hi Ppl
I am trying to create a service in ASP.net. This service would be called from command line and passed parameters (like the at service (MsTask)).
For example on the command prompt if I write 'myService param1'. Then the service should do something (like opening apps, sending logs, mails etc. in background)depending upon the value of param1.
I have been able to write, compile, build and deploy a basic service that logs some stuff. Thanx to the simple service wizard and even simpler tutorials on the net.
I have not been able to implement a mechanism where in I could accept stuff from command line and then open simple win32 apps based on the parameters.
Please help. Links to tutorials on this will also be of great help.
TIA
|
|
|
|
|
To Debug ur service , got0 project properties---Configuration Properties---debugging ==input ur parameters in the command line argument ...or after making build ..make a bat file conating the exe name & parametres . And Windows services has facility to run this service Automatically. But for this u have to shedule ur job which is to be run..I hope u can get idea to solve this problem.
Sagar
|
|
|
|
|
ASP.NET?? I doubt it...
You'll need to write a second application (Console App it you want) that can talk to your service. You can use .NET Remoting for this. This second app will just provide the interface for you to send your commands to the service, and maybe some return data.
In order for your service to be able to launch an application so you can SEE it, you're service has to be tagged "Allow interaction with desktop". You can do this in the Services control panel. If this is not done, the service will launch applications on a desktop that you cannot see.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
I ahve a textbox control array. i am able to loop through each textbox but i am not able to get the value written in the textbox.
Dim o As Object
Dim ctrl As New System.Windows.Forms.TextBox
For Each o In Me.Controls
If o.GetType Is ctrl.GetType Then
s = ctrl.Text
End If
Next
|
|
|
|
|
may be this will work.
create another sub for textchanged for your text box and dim somthing as a string
dim modtext as string
modtext = ctrl.text
you could then move it anywhere through your program
1. Out of clutter, find simplicity.
2. From discord, find harmony.
3. In the middle of difficulty lies opportunity.
Albert Einstein
three rules of work
|
|
|
|
|
Thanx, but i have used an array and put the textboxes in the array. and now i am getting the text
|
|
|
|
|
a textbox contains strings, so you'll have to cast the values using Cxxx() for example, where xxx is the type you'd like to cast to (CInt() for example)
TOXCCT >>> GEII power
[toxcct][VisualCalc]
|
|
|
|
|
Actaully i need to print my Bill in on the top of A4 papaer size, but every time i press the button print, the printer will print my bill in middle and only printing half only. I try to print again, but my printer will continued print again the half bill for my 1st printing.
how can i reset again for printing code?
Steve
|
|
|
|
|
Hi,
i just want to know the procedure for creating an excel sheet using vb.net where data is to be retrived from database
|
|
|
|
|
Hi Nidhishri
I guess this code snippet shoulld solve your problem.
Dim ExcelApp As New Excel.Application
Dim ExcelWorkBook As Excel.Workbook
ExcelWorkBook = ExcelApp.Workbooks.Add
Dim TemplateSheet As New Excel.Worksheet
TemplateSheet = ExcelWorkBook.Sheets.Add
TemplateSheet.Name="SQLDATA"
Dim SQLData As New SqlDataAdapter("YOUR QUERY FOR GETTING DATA",DatabaseConnection)
SQLDATA.SelectCommand.Parameters.Add("PARAMETERS IF REQUIRED)
SQLDATA.SelectCommand.Parameters(0).Value = "VALUES FOR PARAMETERS"
Dim Myrow As DataRow
Dim SQLdatatable As New DataTable
Try
SQLDATA.Fill(EquationNormDataTable)
Catch ex As Exception
End Try
Dim StartRowForFile As Integer = 1
StartRowForFile += 1
For Each Myrow In EquationNormDataTable.Rows
'Now u can iterate through each rows of the table and populate data in an excel sheet
Dim ColCount As Integer = 1
For ColCount = 1 To 3
TemplateSheet.Cells(StartRowForFile, ColCount).Value = Myrow(ColCount - 1)
Next
StartRowForFile += 1
Next
'now u can save the excel file
ExcelWorkBook.SaveAs(""FILENAME WITH COMPLETE PATH")
Mandar Patankar
Microsoft Certified professional
|
|
|
|
|
Can we use more than one dataset on one crystal report.
A sample code will be more useful.
|
|
|
|
|
You mean more than one database or more than one database table? The answer to these I know is yes
1. Out of clutter, find simplicity.
2. From discord, find harmony.
3. In the middle of difficulty lies opportunity.
Albert Einstein
three rules of work
|
|
|
|
|
I m using only one database.
I m using two datasets contained two tables.
Now i want to fetch data from these two datasets in crystal report.
The exception i get is : Unknown query engine
|
|
|
|
|
I have a tab control on the form.
I want to navigate one one tabpage to anoher tabpage.
on tabpage2
on button click event
tabpage(0).show
tabpage(0).focus
It will display the tabpage 1 but not focus it .. means the tab not comes in front.
Any help will be appreciated.
|
|
|
|
|
Try this: tabControl.SelectedIndex = 0;
|
|
|
|
|
Hi, I have two form in vb.net. Each form has one text box and one button. What i want is when i click the button one form one, both text box on the both form display "Hello world". But the code just work for the first line:
text1.text = "Hello world"<br />
form2.text1.text = "Hello world"
The error appear at the line number 2: form2.text1.text = "Hello world"
It seem that text1 is not the control or member of form. I used to use this method in vb6 and it is working, but when I move to vb.net i faced this problem... Does any one has the solution???
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Forms in VB6 work differently than they do in VB.NET. In VB6, all forms were already instantiated where as in VB.NET, they don't exist untilo your code instantiates them.
You didn't give any details of the errors your getting or the code you used, so about the only thing we can do is point you to an article describing some of the techniques. I'll start with this[^] one on DevCity...
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
Dear Dave, Thank you very much for your answer. Now I could solve the problem via your supported article.
A thousand mile of journey, begin with the first step.
APO-CEDC
Save Children Norway-Cambodia Office
|
|
|
|
|
Hey I am creating an employee database and I need some code help  My project needs to have this criteria...if anyone could help me it would be greatly appreciated!!!! Thanx
• Each employee has the following information: Employee ID number, name, hour wage, number of dependents.
• The record for each employee will be kept in a separate file on the file system. (Note, you will need to understand Chapter 9a to create and manipulate files). Each file will have a name like <employee id="">.txt. For instance, if Fred Jones Employee ID is 198, then his filename will be 198.txt
• The record in each file will have the format:
Employee ID
Name
Hourly Wage
Number of Dependents
o For instance, for Fred Jones:
198
Fred Jones
10.15
1
• The Add Employee button will create a new file with the name <employee id="">.txt and add the information from the form in the appropriate format as discussed above if there is an employee ID filled in the employee ID text box. If there is no ID filled in, it should pop up a messagebox with an appropriate error message.
• The ‘Find Employee’ Button will look on the file system for a file named <employee id="">.txt (as desribed above).
o If it finds the file, it will open it and put the information into the appropriate text boxes on the form.
o If it does not find it, it will pop up a messagebox with an appropriate error message.
• The ‘Update Employee’ button will basically resave the employee information in the form back into the appropriate file, including any changes that have been made.
• The Print Employee Button will print the employee’s information in the following format:
Employee Record
---------------------
Employee Name: Fred Jones
Employee ID: 198
Hourly Wage: 10.15
Number of Dependents: 1
• Notice on the printed form that I have used padding to create the column format.
• You are REQUIRED to use Option Explicit On and Option Strict On.
• Use try/catch blocks as is appropriate • Check for the existence of files before you open them.
THANKYOU SOOOO MUCH
|
|
|
|
|
First, it's obvious this is homework. You have to write the code. We won't do it for you. You won't learn much if you don't at least attempt to write the yourself. Everything you need to know you've already covered in class.
Now, when you run into a specific problem, we can help with that.
RageInTheMachine9532
"...a pungent, ghastly, stinky piece of cheese!" -- The Roaming Gnome
|
|
|
|
|
This is cross posted in the Visual Basic / VB.NET and SQL / ADO / ADO.NET since I am not sure exactly where it goes. So... lets give this a shot. Background: I am using Access 2000 with extensive Visual Basic coding to handle much of the legwork and raw data manipulation. In the project I have a table with several columns (Say [Info1], [Info2], [Amount1], and [Amount2]). When I open the form it selects all the entries from the table where [Amount1] is less than [Amount2] (I call this a sub set of the table but I am sure there is some big word or funny acronym that is normally used). In the VB code for the form I use Form_FormName.RecordSet.Movefirst / Movenext / Movelast to move around the subset of data and modify it as needed based on what is in [Info1] and [Info2]. This all works fine, but I would like to take all of this data from the subset and put it into a new table in the same database. The new table already exist and has data in it, what I can’t figure out is how to open two different tables in a single form and place data from one table into the other table. It sounds simple, and probably is, but I just can’t seem to figure it out. If anyone could give me a hand or at least get me pointed in the right direction I would greatly appreciate it.
Thanks,
Mark
|
|
|
|
|
First of all, it sounds like you had a similar experience as I did - I entered the DB world after years of programming, and tried to do everything in Access using VBA. It worked, but not always efficiently. Eventually, I ran into problems where I was forced to learn about SQL and DBs. (If this isn't the case for you, excuse me.)
The point of all that is that what you are describing can easily be done with SQL.
First off, if you're looking to select all the records from Table1 where [Amount1] is less than [Amount2], and you don't need to display all the records from Table1, things will run much faster if you write a query in Access for this. If you use SQL view (the easiest for me to duplicate here), the SQL should look like this:
SELECT * FROM Table1 WHERE [Table1.Amount1] < [Table1.Amount2]
For this explanation, save this as DifferenceQuery.
If you only have a few records, you might not notice the speed difference. I am working in a medium sized database (30,000 records or so in the largest table, with 20+ fields in the table), and I quickly noticed the difference when creating my queries in Access rather than using ADO.
Then, in your program, to get the records you want from Table1, use ADO with SQL like:
SELECT [Info1], [Info2], [Amount1], [Amount2] FROM [DifferenceQuery]
This will return the same subset you currently acheive, only you don't have to programatically cycle through the records and select the ones where [Info1] < [Info2].
To place data from this subset into Table2, use ADO & SQL again:
dim info1 as string = "info1"
dim info2 as string = "info2"
dim amount1 as double = 1.1
dim amount2 as double = 2.0
dim sql as string
sql = "INSERT INTO [Table2] ([Info1], [Info2], [Amount1], [Amount2]) VALUES ('" & info1 & "', '" & info2 & "', " & amount1 & ", " & amount2 & ")"
The string concatenation can start to get confusing, but the above would (if I typed it right) produce the sql statement:
INSERT INTO [Table2] ([Info1], [Info2], [Amount1], [Amount2]) VALUES ('info1', 'info2', 1.1, 2.0)
Step through your subset and execute this SQL statement (substituting the appropriate values for your fields) and all your records will be added to table 2.
Hope this helps.
P.S.
I find w3school's SQL tutorials good reference, since I don't use all the SQL commands all the time: Link[^]
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
