|
very urgent
hello guys,
i iam in great problem please help me
my problem is that i want to fetch record between two date
my date feild is in varchar and i have seprated that date in three fields
dd1,mm1 and yy1 as int .
when the month is same and first date is lower than second date this works ok
but when the month is different or day1 value is greater than second day
this show unnessasary record
my code is this
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Me.WindowState = FormWindowState.Maximized
Me.MinimizeBox = False
Dim strd1 As String = DateTimePicker4.Value.ToShortDateString()
Dim strd2 As String = DateTimePicker3.Value.ToShortDateString()
Dim dd1 As Date = CDate(strd1)
Dim dd2 As Date = CDate(strd2)
day1 = dd1.Day
month1 = dd1.Month
year1 = dd1.Year
day2 = dd2.Day
month2 = dd2.Month
year2 = dd2.Year
If (day1 >= day2 And month1 <= month2) Then
swapday = day2
day2 = day1
day1 = swapday
swapmonth = month2
month2 = month1
month1 = swapmonth
End If
'If (day1 <= day2 And month1 <= month2) Then
str1 = "{ViewPartyOrder.pcode}='" & ComboBox2.Text & "' and {ViewPartyOrder.dd1} >= " & day1 & " and {ViewPartyOrder.dd1} <= " & day2 & " and {ViewPartyOrder.mm1} >= " & month1 & " and {ViewPartyOrder.mm1} <= " & month2 & " and {ViewPartyOrder.yy1} >= " & year1 & " and {ViewPartyOrder.yy1} <= " & year2
'ElseIf (day1 >= day2 And month1 <= month2) Then
' str1 = "{ViewPartyOrder.pcode}='" & ComboBox2.Text & "' and {ViewPartyOrder.dd1} <= " & day1 & " and {ViewPartyOrder.dd1} >= " & day2 & " and {ViewPartyOrder.mm1} <= " & month1 & " and {ViewPartyOrder.mm1} >= " & month2 & " and {ViewPartyOrder.yy1} >= " & year1 & " and {ViewPartyOrder.yy1} <= " & year2
'End If
Dim myTableLogonInfos As New TableLogOnInfos
Dim myTableLogonInfo As New TableLogOnInfo
Dim myConnectionInfo As New ConnectionInfo
With myConnectionInfo
.ServerName = ConfigurationSettings.AppSettings("servername").ToString()
.DatabaseName = ConfigurationSettings.AppSettings("databasename").ToString()
.UserID = ConfigurationSettings.AppSettings("username").ToString()
.Password = ConfigurationSettings.AppSettings("password").ToString()
End With
myTableLogonInfo.ConnectionInfo = myConnectionInfo
myTableLogonInfo.TableName = "ViewPartyOrder"
myTableLogonInfos.Add(myTableLogonInfo)
Dim ir As New Itemwisereport
Dim Help As New Mentor
Dim strorderdate As String = DateTimePicker4.Value.ToShortDateString
Dim strorderdate1 As String = DateTimePicker3.Value.ToShortDateString
If (RadioButton1.Checked) Then
ir.RecordSelectionFormula = "{ViewPartyOrder.partyname}='" & ComboBox2.Text & "' and {ViewPartyOrder.dd1} >= " & day1 & " and {ViewPartyOrder.dd1} <= " & day2 & " and {ViewPartyOrder.mm1} >= " & month1 & " and {ViewPartyOrder.mm1} <= " & month2 & " and {ViewPartyOrder.yy1} >= " & year1 & " and {ViewPartyOrder.yy1} <= " & year2
ElseIf (RadioButton2.Checked) Then
ir.RecordSelectionFormula = str1
ElseIf (RadioButton3.Checked) Then
ir.RecordSelectionFormula = "{ViewPartyOrder.pdesc}='" & ComboBox2.Text & "' and {ViewPartyOrder.dd1} >= " & day1 & " and {ViewPartyOrder.dd1} <= " & day2 & " and {ViewPartyOrder.mm1} >= " & month1 & " and {ViewPartyOrder.mm1} <= " & month2 & " and {ViewPartyOrder.yy1} >= " & year1 & " and {ViewPartyOrder.yy1} <= " & year2
End If
CrystalReportViewer1.LogOnInfo = myTableLogonInfos
CrystalReportViewer1.ReportSource = ir
CrystalReportViewer1.RefreshReport()
End Sub
urgent
|
|
|
|
|
When you posted this and you got the warning that your message was very long and you should consider cutting it down, did you actually pay any attention?
I'd love to help, but I'm not going to read through all that. If you have a specific question then we'd love to help.
What error you got tell it here we are here and we will help you in solving your error.
Regards,
Satips.
|
|
|
|
|
hello sir
my prob is that i m giving input two date from datetimepicker
and i want to fetch all the record between these date where as
orderdate is stored as varchar datatype in the database. and i m
applying this formula on view.(on crystal report in vb.net)
FORMULA::
Dim strorderdate As Date = DateTimePicker4.Value.ToShortDateString
Dim datefrom2 As String = Help.ChangeMMDDYY(strorderdate)
Dim strorderdate1 As Date = DateTimePicker3.Value.ToShortDateString
Dim datefrom3 As String = Help.ChangeMMDDYY(strorderdate1)
If (RadioButton1.Checked) Then
ir.RecordSelectionFormula = "{ViewPartyOrder.partyname}='" & ComboBox2.Text & "' and {ViewPartyOrder.orderdate}>='" & datefrom2 & "'and {ViewPartyOrder.orderdate}<= '" & datefrom3 & "'"
ElseIf (RadioButton2.Checked) Then
ir.RecordSelectionFormula = "{ViewPartyOrder.pcode}='" & ComboBox2.Text & "' and {ViewPartyOrder.orderdate}>='" & datefrom2 & "'and {ViewPartyOrder.orderdate}<= '" & datefrom3 & "'"
ElseIf (RadioButton3.Checked) Then
ir.RecordSelectionFormula = "{ViewPartyOrder.pdesc}='" & ComboBox2.Text & "' and {ViewPartyOrder.orderdate}>='" & datefrom2 & "'and {ViewPartyOrder.orderdate}<= '" & datefrom3 & "'"
End If
CrystalReportViewer1.ReportSource = ir
CrystalReportViewer1.RefreshReport()
monu_khan
|
|
|
|
|
does anybody have any suggestions?
|
|
|
|
|
with javascript you can do it.
string popupScript = "<script language='javascript'>" +<br />
"window.open('PopUp.aspx', 'CustomPopUp', " +<br />
"'width=200, height=200, menubar=yes, resizable=no')" +<br />
"</script>";<br />
<br />
Page.RegisterStartupScript("PopupScript", popupScript);<br />
Regards,
Satips.
|
|
|
|
|
Hello,
VS 2005.
I have to create a setup for web service. Which I don't think will be much of a problem.
However, I have to create a setup that once its installed on the IIS, there is a button that can be pressed that would be on a windows form after the setup has completed. This will inform the user that the setup was completed successfully. Does anyone know of any good method to do this?
I think what I need is some kind of window that will be displayed after the setup is completed. However, how would I test if the setup was completed or not?
Many thanks for any suggestions and examples.
Steve
|
|
|
|
|
Hi,
Is there any way to detect on the server side, when a page changes, like the Page_Load event, or to fire a server side event when a menu item is clicked.
Thanks
Tim
|
|
|
|
|
hi there:
Use this: ddl.options[ddl.selectedIndex].value to get the selected value
<< >>
|
|
|
|
|
Hi,
I want to send bulk emails from my program.
Is it possible to add more than one email address in "MailMessage.To" field.
Thanks.
|
|
|
|
|
Yes.
MailMessage message = new MailMessage();
message.From = new MailAddress("sender@abc.com");
message.To.Add(new MailAddress("recipient1@abc.com"));
message.To.Add(new MailAddress("recipient2@abc.com"));
message.To.Add(new MailAddress("recipient3@abc.com"));
message.CC.Add(new MailAddress("carboncopy@abc.com"));
message.Subject = "This is my subject";
message.Body = "This is the content";
SmtpClient client = new SmtpClient();
client.Send(message);
Hope it will help yoou.
Regards,
Satips.
|
|
|
|
|
Hi Guys
Can any one let me know how can we use web service made in PHP in .Net client , is this possible ? what are the draw backs, please relpy ASAP, thankx in advance,
|
|
|
|
|
|
Thankx man for ur reply , can you please let me know one more thing, is it possible to use digest authentication with PHP webservices, thankx once again,
regards,
|
|
|
|
|
|
Hi All,
Iam new to asp.net2.0, Could u pls give information about Master page concept.
Thanks In Advance for ur replay,
|
|
|
|
|
if your national is persian say me to help you in farsi language
We Can Do Anything, If We Want It
|
|
|
|
|
|
|
|
Hi,
I am having a problem to update a field in the database, my code is
sqlString = "UPDATE [user] SET logindt='10/9/2007 2:39PM' WHERE email='abc@yahoo.com'"
myCommand = New SqlCommand(sqlString, myConnection)
myCommand.ExecuteNonQuery()
Response.Redirect("main.aspx")
The thing is the page just sort of refresh itself after I click 'Log in' and did not show any error message but the logindt is not updated still.
Could it be permission problem or something else?
Please help me out on this, I'd been cracking my head wondering why since no error message shows.
J Liang
|
|
|
|
|
Hi,
Please post the code you wrote when login button is clicked and also the code under page load of login page.
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
Hi Mubashir,
Thanks for the reply, here's the code
Dim myConnection As SqlConnection
Dim myCommand As SqlCommand
Dim dr As SqlDataReader
Dim currdt As DateTime = DateTime.Now
myConnection = New SqlConnection("server=localhost;uid=aa;pwd=abc;database=ww;Data Source=mysource")
myConnection.Open()
Dim sqlString = "SELECT * FROM [dbo].[user] WHERE email='" & Me.txtEmail.Text & "' AND password='" & Me.txtPwd.Text & "'"
If Me.txtEmail.Text = "" Or Me.txtPwd.Text = "" Then
Me.lblmsg.Text = "Please fill in your email and password"
Else
Try
myCommand = New SqlCommand(sqlString, myConnection)
dr = myCommand.ExecuteReader()
dr.Read()
If dr.HasRows Then
'Set session for later use
Session("uid") = dr(0)
Session("name") = dr(1)
Session("deptid") = dr(2)
Session("title") = dr(3)
Session("grpid") = dr(4)
Session("category") = dr(5)
Session("email") = dr(6)
'Update login time
sqlString = "UPDATE [user] SET logindt='10/9/2007 2:39PM' WHERE email='abc@yahoo.com'"
myCommand = New SqlCommand(sqlString, myConnection)
myCommand.ExecuteNonQuery()
Response.Redirect("main.aspx")
Else
Me.lblmsg.Text = "Email and password incorrect"
End If
dr.Close()
myConnection.Close()
Catch e As Exception
Me.MsgBox(e.ToString())
End Try
End If
Hope this is what you need.
J Liang
|
|
|
|
|
HI,
Your code seems to be fine, Try and run the UPDATE sql in the SQL Query Analyzer and see wat it do. May be it is not fulfilling the WHERE criteria so check the aphabet case as well for the email field.
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
Hi,
I'd tried running the SQL script using the Enterprise Manager and it works fine, the database is being updated, that is what makes me so confuse on what is wrong with my site.
|
|
|
|
|
ic..
Use the following suggestions
- Are you able to select records from the DB? the idea is to check whether the code is connected with the DB alright. If NO then use the following connection string
"server=yoursvr;uid=uruser;pwd=urpwd;database=SomeDB"
- Try and debug to see whether the Update cmd is executed/parsed or not.
Best of luck
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
