ASP.NET

Re: How to validate user input with SQL database using asp.net C#?

5-Jul-08 4:03

I think you're asking how to call a SQL database. You could only find VB examples ? They are easy to convert, and there's web sites that do it for free. Also, the code is the same if it's ASP.NEt or not, you just need to get some C# ADO.NET examples. Plenty on this site and elsewhere.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

katelva6-Jul-08 23:31

katelva

6-Jul-08 23:31

Hi Christian,

Can you give me the recommended website of learning asp.net using language C#, I am newbie to asp.net C#, so I am not sure how to read the data from SQL Express database and validate the user input from the database using asp.net C#. Mostly from book and internet are in VB language.

The bottom is my source code where I have tried to use SQLdataReader:

protected void btnSubmit_Click(object sender, EventArgs e)
{
string uname = txtUserName.Text;
string pwd = txtPassword.Text;

string connectionString = "Data Source= .\\SQLEXPRESS;"
+ "AttachDbFilename=\"C:\\Documents and Settings\\kathy\\My Documents\\Visual Studio 2008\\WebSites\\WebSite1\\App_Data\\salon.mdf\";"
+ "Integrated Security=True;"
+ "User Instance=True";
SqlConnection myConnection = new SqlConnection(connectionString);
SqlCommand cmd = myConnection.CreateCommand();

cmd.CommandText = "SELECT * FROM [Customer]";
myConnection.Open();

SqlDataReader dr = cmd.ExecuteReader();

while (dr.Read())
{
if (dr.GetOrdinal("UserName").ToString() == txtUserName.Text)
{
Response.Write("Heelo");
//dr.Close();
}
//dr.Close();
myConnection.Close();
}
}

Thanks.

Regards,
Katelva

Re: How to validate user input with SQL database using asp.net C#?

Herman<T>.Instance8-Jul-08 4:06

Herman<T>.Instance

8-Jul-08 4:06

you should do a Binary_checksum in your SQL:

Example of a Stored Procedure with Binary_Checksum:
CREATE procedure [dbo].[SE_SelSecUserCredentials]
@UserName NVARCHAR(45),
@PassWord NVARCHAR(45)
AS
begin
SELECT
......., ............., ........
FROM
UserTable
WHERE
active = 1
AND BINARY_CHECKSUM(loginName) = BINARY_CHECKSUM(@UserName)
AND BINARY_CHECKSUM(password) = BINARY_CHECKSUM(@PassWord)
end

RSS in ASP.NET

.NET- India 5-Jul-08 2:47

.NET- India

5-Jul-08 2:47

Hello,

I'm showing property news in my website throught RSS. And it's working fine in localhost but as i upload it over server then it's raising Runtime Error

my site url is:- http://www.investbackhome.com

and there is a link News it has further two sub-links like Property News-India and Property News- Overseas which are throwing the Runtime errors

N a v a n e e t h5-Jul-08 2:53

5-Jul-08 2:53

Turn custom errors off. You will get the error message then.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

.NET- India 5-Jul-08 3:04

.NET- India

5-Jul-08 3:04

It's raising Security Exception error
as shown in below url
http://www.investbackhome.com/Property_India.aspx[^]

N a v a n e e t h5-Jul-08 3:13

5-Jul-08 3:13

Looks like you need to contact your server provider.

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

.NET- India 5-Jul-08 3:17

.NET- India

5-Jul-08 3:17

what should i ask him

N a v a n e e t h5-Jul-08 3:46

How to make Wikipedia in asp.net

5-Jul-08 3:46

You can show the error message to them. They will have idea on that

All C# applications should call Application.Quit(); in the beginning to avoid any .NET problems.- Unclyclopedia

How to use google | Ask smart questions

VivekNema5-Jul-08 2:01

VivekNema

5-Jul-08 2:01

Dear All

I want to construct a website like wikipedia using asp.net 2.0. Please guide me briefly how to build this type of website and what would be the Database design for it.

With Regards

Vivek

Re: How to make Wikipedia in asp.net

Christian Graus5-Jul-08 2:03

How to divide time span value to integer number ?

5-Jul-08 2:03

I guess you'd have a db that's designed to take a page, I would presume as HTML, and index it's html against search terms. So you do the search, grab the result, and display it.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Sub Domain Rewriting

trilokharry5-Jul-08 1:46

trilokharry

5-Jul-08 1:46

in search for resolution i came to url rewriting.
Among other problems like postbacks ther is another one
Subdomain rewriting...

I was trying to make rewriting of subdomain url rewriting using HTTP module but with no success. (eg. http://subdomain.domain.com/default.aspx rewrite to http://www.domain.com/default.aspx?id=subdomain)

Whenever I try to rewrite full URL I get error telling me it’s not supported J. As Url rewriting is doing internal address rewriting it is normal to get that kind of error but how to accomplish that kind of thing in ASP.NET?

P.S. my dev machine is WinXP Pro (one possible and default web site) no DNS.
So I use hosts. file for host heading that site in combination with setting IIS web site host header names

You get the best out of others when you give the best of yourself.

Re: Sub Domain Rewriting

Steve Westbrook6-Jul-08 16:19

Steve Westbrook

6-Jul-08 16:19

Could you use Server.Transfer or Response.Redirect?

Rameez Raja5-Jul-08 0:54

Rameez Raja

5-Jul-08 0:54

hi,

may i divide timespan object to any integer number like

2:00:00/3 is it possible ?

help in this regard

becuase i have to divide timesapn object result to any integer value

regards

Rameez

Re: How to divide time span value to integer number ?

Christian Graus5-Jul-08 1:19

Re: How to divide time span value to integer number ?

5-Jul-08 1:19

I guess you've found that it's not. You'd have to build a new timespan object, dividing every individual part by 3.

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Steve Westbrook6-Jul-08 16:27

Steve Westbrook

6-Jul-08 16:27

Use the timespan's TotalSeconds property, or a related one, to get the number of time units, divide that by three.

problem in sending mails thru asp.net 2.0

vijaylumar5-Jul-08 0:41

vijaylumar

5-Jul-08 0:41

i m sending mails to client thru code
oke its fine working .mail successfully sent to client

but the mails are not storing in sentmail folder of my mail
i m maintaing a mail server
and i have a company mail id like info@compnayname.com

i m sending mails to client thru this mail id
but i cant view sent mails in the sentfolder

plz help me

thanks in advance
vijay

Re: problem in sending mails thru asp.net 2.0

Abhijit Jana5-Jul-08 1:14

Abhijit Jana

5-Jul-08 1:14

you are using SMTP Server to send mail using asp.Net not Exchange Server.
Your send item is the part of ExchangeMailBox . If it's a .pst file then also its alos takes data from Exchange only.

while sending mail using asp.net, data never pass to your Exchange server, that's why you did'nt get in your sent item.

Hope this clears you !!!

cheers,
Abhijit

Re: problem in sending mails thru asp.net 2.0

Christian Graus5-Jul-08 1:20

Compilation Error at Run time ?

5-Jul-08 1:20

If you send mail using MAPI, it will go through your mail program,

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

Muhammad Gouda5-Jul-08 0:23

Muhammad Gouda

5-Jul-08 0:23

I have a form with a crystal report
when I compile, I get ZERO compile errors
But when I run, I get the following error

Compilation Error 
 CS1525: Invalid expression term ')'
Line 17: 			<cr:crystalreportviewer id=rpViewer runat="server"  
ReportSource="<%# D:\Inetpub\wwwroot\MersaalStaff\Administrator\StmtRprt.rpt %>">
Line 18: 			</cr:crystalreportviewer></form>

Error in Line 17

So,
1- How to catch compile time error at un time
2- And does the incorrect HTML generates runtime errors
3- Also, I did not write the html code, it was generated automatically
Ho COME !!!!!!! Mad | :mad:

Mohammed Gouda
foreach(Minute m in MyLife)
myExperience++;

Re: Compilation Error at Run time ?

Christian Graus5-Jul-08 1:22

Re: Compilation Error at Run time ?

5-Jul-08 1:22

1 - with a try/catch block, I guess
2 - because it's presumably sending a query to CR that is invalid.
3 - because using auto generated stuff always sucks

Christian Graus

Please read this if you don't understand the answer I've given you. If you're still stuck, ask me for more information.

N a v a n e e t h5-Jul-08 2:14