|
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.
|
|
|
|
|
Hi Mubashir,
Thanks for the suggestions. I sort of got it working and the database is being updated as I want it to be.
The thing is when I run two SQL command in the same page, it will not work, so I separated both the SQL command into different page (it's not an issue for my case whether where the command is), so it check the email and password and login to the main page then only it updates the date time.
Still wondering why it doesn't work at first, but anyway, I shall find out myself.
Thanks.
J Liang
|
|
|
|
|
Strange issue, but good that its working.
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
