|
i have found this in some replies but dat was not working.
I always use ISO format when typing SQL in Query Analyzer, but for accessing the application through ADO.NET (ASP.NET is for web applications and has nothing to do with the database). I don't worry about the date format as I use parameters. For example
SqlCommand cmd = new SqlCommand();
cmd.Connection = myConnection;
cmd.CommandText = "SELECT * FROM MyTable "+
"WHERE SomeDate BETWEEN @startDate AND @endDate";
cmd.Parameters.Add("@startDate", theStartDateTimeObject);
cmd.Parameters.Add("@endDate", theEndDateTimeObject);
SqlDataReader reader = cmd.ExecuteDataReader();
theStartDateTimeObject and theEndDateTimeObject are DateTime objects. If you use these then you don't need to know what format to write the dates in to the SQL String - and nor should you need to convert it.
The database should be used for storing information. You shouldn't really be doing any localisation functions with the database as that is all presentation layer stuff.
Maniiiiiiiiiiiiiii
|
|
|
|
|
Hi i am using list view control in my form,
In that itemtemplate i used checkbox...,
Now that check box check change event i have to capture...,
I searched in google but i didnt get ,help me regarding that
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
what i would do is:
add a button after the listview,
and in the button_click event,
go through the list view, row for row,
and then use the : CheckBox box = (CheckBox)Row.FindControl(CheckBoxID)
if (box.checked) { } else { }
|
|
|
|
|
ya thats ok,.
i cant able to get the selected checkbox row cell value...,
This is my code:
string getchoice11 = null;
string chval = null;
int loop11 = 0;
CheckBox chkHeader = sender as CheckBox;
for (int i = 0; i < lvEmployee.Items.Count; i++)
{
CheckBox chk = lvEmployee.Items[i].FindControl("ICheck") as CheckBox;
if (chk.Checked == true)
{
getchoice11 += "'" + lvEmployee.Items[1].ToString().Trim() + "',";
}
}
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
Why not use the following:
foreach( ListViewItem lvi in lvEmployee.Items)
{
CheckBox chk = (CheckBox)lvi.FindControl("ICheck");
if (chk.Checked)
{
getchoice11 += lvi[1].ToString().Trim() + ",";
}
}
|
|
|
|
|
getting error as this place:
getchoice11 += "'"+ lvi[2].ToString().Trim() + ",";
Cannot apply indexing with [] to an expression of type 'System.Web.UI.WebControls.ListViewItem'
Thanks & Regards,
NeW OnE,
please don't forget to vote on the post
|
|
|
|
|
is it not possible to get the full path using FileUpload control FileName property? I am asking this because when selected a file for uploading in C drive (C:\filename.ext) and when I click on send mail it shows an error saying that the file is not available in the path "C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\WebSites\...".
may please help out me.
Kovuru Sreedhar
|
|
|
|
|
Hi there.
Just want to know, what i have to do to my asp.net site, so that google will display my site and the main headings in my site in one section.
Eg. if you search for Asus, you will find ASUS international, and the headings (Products, United kingdom,Autralia, Repairs... etc.)
Thanks.
modified on Friday, August 29, 2008 6:34 AM
|
|
|
|
|
Icarus123 wrote: what i have to do to my asp site
What are you doing ASP.Net forum thn?
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
I think this belongs in a google forum
|
|
|
|
|
Why?
Is it because you dont understand the question, or is it because there is no way to do this in asp.net?
|
|
|
|
|
Icarus123 wrote: no way to do this in asp.net
bingo!
What made you think that a method for dynamically outputting HTML (ASP.NET) could have any control whatsoever of how google decides to layout their search results.
|
|
|
|
|
well... do you mean how to include your website to google...
Try
www.google.com/addurl
you will get the option to store your site to google search engine.. so that it would be listed when search occurs...
The position of ur site link depends on search criteria and site popularity as per I know..
more you click on the site from search.. more will be the probability to get your site listed early...
Hope you will like my reply... ![Rose | [Rose]](https://codeproject.freetls.fastly.net/script/Forums/Images/rose.gif)
Abhishek Sur
|
|
|
|
|
Thanks you very much for the reply, it is what i wanted to know..
So as per building a site in a specific structure, makes no difference to the way it would appear in google?
|
|
|
|
|
Icarus123 wrote: Thanks you very much for the reply, it is what i wanted to know..
So as per building a site in a specific structure, makes no difference to the way it would appear in google?
no... it only depends on the way you add your site...
well, if you are using Google Analytics to your site, this would not apply... google analytics can modify search catalog....
Abhishek Sur
|
|
|
|
|
Thank you Abhishek for all the information. you have been most helpfull!
|
|
|
|
|
how to create tally9.0 -leader xml tags in c#asp.net
|
|
|
|
|
source code of email validation in one of the articles is not working in my asp.net page plz help me
the code i m using is
using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Text;
using System.IO;
using System.Net.Sockets;
using System.Net;
using System.Web.Mail;
public partial class HR_module_mn_testing_Emailvalidation : System.Web.UI.Page
{
string ss = "";
protected void Page_Load(object sender, EventArgs e)
{
}
private enum SMTPResponse : int
{
CONNECT_SUCCESS = 220,
GENERIC_SUCCESS = 250,
DATA_SUCCESS = 354,
QUIT_SUCCESS = 221
}
//---------------javaScript Alert-------------------------
public void CreateMessageAlert(System.Web.UI.Page senderpage, string alertMsg)
{
string alertKey = "alertKey";
string strScript;
strScript = "alert('" + alertMsg + "')";
if (!senderpage.IsStartupScriptRegistered(alertKey))
{
senderpage.RegisterStartupScript(alertKey, strScript);
}
}
//--------------------------------------------------------
protected void bttn_valid_Click(object sender, EventArgs e)
{
try
{
Send(txt_email.Text);
}
catch
{
ss = "Email id not correct";
CreateMessageAlert(this, ss);
}
}
public static bool Send(string aa)
{
string[] host = (aa.Split('@'));
string hostname = host[1];
IPHostEntry IPhst = Dns.GetHostEntry(hostname);
IPEndPoint endPt = new IPEndPoint(IPhst.AddressList[0], 25);
Socket s = new Socket(endPt.AddressFamily,
SocketType.Stream, ProtocolType.Tcp);
s.Connect(endPt);
//Attempting to connect
if (!Check_Response(s, SMTPResponse.CONNECT_SUCCESS))
{
s.Close();
return false;
}
//HELO server
Senddata(s, string.Format("HELO {0}\r\n", Dns.GetHostName()));
if (!Check_Response(s, SMTPResponse.GENERIC_SUCCESS))
{
s.Close();
return false;
}
//Identify yourself
//Servers may resolve your domain and check whether
//you are listed in BlackLists etc.
Senddata(s, string.Format("MAIL From: {0}\r\n",
"testexample@deepak.portland.co.uk"));
if (!Check_Response(s, SMTPResponse.GENERIC_SUCCESS))
{
s.Close();
return false;
}
//Attempt Delivery (I can use VRFY, but most
//SMTP servers only disable it for security reasons)
Senddata(s, aa);
if (!Check_Response(s, SMTPResponse.GENERIC_SUCCESS))
{
s.Close();
return false;
}
return (true);
}
private static void Senddata(Socket s, string msg)
{
byte[] _msg = Encoding.ASCII.GetBytes(msg);
s.Send(_msg, 0, _msg.Length, SocketFlags.None);
}
private static bool Check_Response(Socket s, SMTPResponse response_expected)
{
string sResponse;
int response;
byte[] bytes = new byte[1024];
while (s.Available == 0)
{
System.Threading.Thread.Sleep(100);
}
s.Receive(bytes, 0, s.Available, SocketFlags.None);
sResponse = Encoding.ASCII.GetString(bytes);
response = Convert.ToInt32(sResponse.Substring(0, 3));
if (response != (int)response_expected)
return false;
return true;
}
}
|
|
|
|
|
This checks the Email id Format
function echeck(str) {
var at="@"
var dot="."
var lat=str.indexOf(at)
var lstr=str.length
var ldot=str.indexOf(dot)
if (str.indexOf(at)==-1){
return "Invalid E-mail ID"
}
if (str.indexOf(at)==-1 || str.indexOf(at)==0 || str.indexOf(at)==lstr){
return "Invalid E-mail ID"
}
if (str.indexOf(dot)==-1 || str.indexOf(dot)==0 || str.indexOf(dot)==lstr){
return "Invalid E-mail ID"
}
if (str.indexOf(at,(lat+1))!=-1){
return "Invalid E-mail ID"
}
if (str.substring(lat-1,lat)==dot || str.substring(lat+1,lat+2)==dot){
return "Invalid E-mail ID"
}
if (str.indexOf(dot,(lat+2))==-1){
return "Invalid E-mail ID"
}
if (str.indexOf(" ")!=-1){
return "Invalid E-mail ID"
}
return "";
}
and to check the existence of mail .. send a mail . keep try catch block .. i am not sure whether it will solve ur problem but syntax validation can be done by the above one
If You win You need not Explain............
But If You Loose You Should not be there to Explain......
|
|
|
|
|
Krazy Programmer wrote: and to check the existence of mail .. send a mail
In short...this is called spamming. 
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
email validation should be done without sending mail
Maniiiiiiiiiiiiiii
|
|
|
|
|
i have to validate email domain without sending mail to that id,do anybody have the ans.
Maniiiiiiiiiiiiiii
|
|
|
|
|
Dont post your complete code...Pin point your problem....
For validation, have you ever heard of regular expression validators?
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
|
regular expression only validates syntax not domain of email id.
Maniiiiiiiiiiiiiii
|
|
|
|
|
mnkh wrote: regular expression only validates syntax not domain of email id.
That is what called validation...rite?
And there is no way to know weather domain/email id exists, without sending the email...
Please remember to rate helpful or unhelpful answers, it lets us and people reading the forums know if our answers are any good.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
