|
|
SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["sqlcon"].ConnectionString);
//cn.ConnectionString = "Data Source=SVIADV;Initial Catalog=my database;User ID=sa;Password=sqlserver";
SqlCommand cm = new SqlCommand();
cm.Connection = cn;
cm.CommandText = string.Format("select count(*)from myusers where username='{0}'and password='{1}'");
cn.Open();
int i = Convert.ToInt32(cm.ExecuteScalar());
cn.Close();
if (i == 0)
{
Response.Write("<b> invalid username/password</b>");
}
else
{
HttpCookie c = new HttpCookie("n", TextBox1.Text);
Session["n"] = TextBox1.Text;
Response.Redirect("default2.aspx");
}
when iam executing this it shows the following error
index(zerobased) must be greater than or equalto zero and less than the size of the arguement list
|
|
|
|
|
aratireddy wrote: when iam executing this it shows the following error
index(zerobased) must be greater than or equalto zero and less than the size of the arguement list
Did you debug the Application? Try to debug yourself. Check the line where its throwing Exception.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
What, you mean you're mind-reading skills are not working today Abhijit?
Mine are, its this line - can you spot the flaw?
cm.CommandText = string.Format("select count(*)from myusers where username='{0}'and password='{1}'");
|
|
|
|
|
J4amieC wrote: Mine are, its this line - can you spot the flaw?
cm.CommandText = string.Format("select count(*)from myusers where username='{0}'and password='{1}'");
Yes .
J4amieC wrote: What, you mean you're mind-reading skills are not working today Abhijit?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
hello,
i have an application developped under asp.net.
after the deployement of that application, my application run with the first page default.aspx
If i surf to another page and users.aspx, and if i copy the url from the addres bar and i put it in another browser the page appear without passing by the default.aspx.
can someone help me.
regards.
dghdfghdfghdfghdgh
|
|
|
|
|
you have to redirect to default.aspx page when some one enter the url
directly.
put the condition when page load and check it for default.aspx
Regards
Keyur Satyadev
|
|
|
|
|
|
ellllllllie wrote: If i surf to another page and users.aspx, and if i copy the url from the addres bar and i put it in another browser the page appear without passing by the default.aspx.
This is normal behavior.
Could you please what is your actual requirement? means what kind of restriction you want to give?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
ellllllllie wrote: the page appear without passing by the default.aspx.
Of course it will. The answer to your question is in your own statement. Re-read what you wrote and you will figure it out.
You started on one machine with http://yourserver/default.asp then you navigated to users.aspx. Now you took http://yourserver/users.aspx and copied it to a different browser and you expected to go to default.aspx.
If that is what you want then in users.aspx you need to check if default was visted first, if not redirect them to defualt.aspx
Yusuf
|
|
|
|
|
i have javascript file for calendar ..now when i click on link button or a button i want to execute the function from javascript..
how to insert the javascript in asp.net..and am using c#..
thanks..
scarface
|
|
|
|
|
scar_face wrote: click on link button or a button i want to execute the function from javascript..
Have you tried calling the JS function from OnClientClick event of LinkButton?
|
|
|
|
|
i did try the client click but it doesnt display anythin..
scarface
|
|
|
|
|
go to your aspx page and write tag in the head part and put your code in script tag.
alternate you can make .js file and call it externally in your aspx page
Regards
Keyur Satyadev
|
|
|
|
|
i have called the js file from src and from link button tried calling the function but it isnt displaying anythin..
scarface
|
|
|
|
|
scar_face wrote: have called the js file from src and from link button tried calling the function but it isnt displaying anythin..
Are you sure that its calling the JS file. Put a alert and test weather its calling properly or not.
Which Calender control are you using ? Are missing any CSS ?
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
I built a small learning site with a dal,a bll, a stored procedure,
a database ,a detailsview,and a gridview.
I want to be able to insert itemname,description,datelised,emailaddress,phonenumber,category,and
a picture. everything does what it is supposed to do except....the picture wont show in the gridview all i get is a box with a red x
I think i need some item inserted codebehind on the page that has the gridview (the detailsview is on a different page)
I have looked everywhere for a good example scott mitchells data access
seemed good but i cant get the image to show no matter what.....
|
|
|
|
|
learningman wrote: .the picture wont show in the gridview all i get is a box with a red x
Possible reason is that the image path is not correct.
For your ref^[^]
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi All, I am using ajaxToolkit:AnimationExtender, now i want to initialize the TargetControlID property in Javascript .
Does it is possible, if so how to do it....
Expecting your valuable reply
Thanks in Advance..
|
|
|
|
|
Hi
i have one dropdownlist in which no. of themes are thier?
now anyone can select the any one of theme then that theme
will appear in my site. how can i achieve this?
for eg. as might you know in orkut user can select or change the theme
that will appear in the site.
Regards
Keyur Satyadev
|
|
|
|
|
Use
Page.Theme = themename;
on page pre init event.
for details check this...
http://www.codeproject.com/KB/HTML/ThemeChanging.aspx
The miracle is this--the more we share, the more we have.
|
|
|
|
|
I will suggest you to write a HTTPHanlder for that.
cheers,
Abhijit
CodeProject MVP
|
|
|
|
|
Hi all...
In my asp.net page i have used one tabcontainer with 3 tabs....all controls r inside this....i have used upadatepanel also..now i have placed a hiddenfield which is totally outside of tabcontainer,to fetch a value from the textbox on a button click....value is getting to hiddenfield but when am trying to take that value into javascript variable its giving nulll.(am passing that id from external jscript...)
function GetObj(id)
{
var val=this.document.getElementById(id).value;
return val;
}
can anubody tel me to get the value?....
|
|
|
|
|
I'm sure you realize, the tabcontainer adds stuff to the id of its child controls.
Like if you have a Panel1 inside a TabPanel2 in a TabContainer1 it's most likelly gonna be something like: TabContainer1_TabPanel2_Panel1. Debug it and see for yourself. Or look at the source in your browser.
Oh, and obviously, remember, if you're using masterpages, they do that too.
Disregard that, I misread your post.
var question = (_2b || !(_2b));
|
|
|
|
|
hi
I'm trying to execute a stored procedure which returns a datatable
my code is:
try
{
string conStr = WebConfigurationManager.ConnectionStrings[0].ConnectionString;
SqlDataAdapter adapter;
DataTable ans = new DataTable();
SqlConnection connection = new SqlConnection(conStr);
SqlCommand command = new SqlCommand();
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "usp_GetUserDetails";
command.Parameters.Add("@UserName", SqlDbType.VarChar);
command.Parameters.Add("@Password", SqlDbType.VarChar);
command.Parameters["@UserName"].Value = user;
command.Parameters["@UserName"].Direction = ParameterDirection.Input;
command.Parameters["@Password"].Value = pass;
command.Parameters["@Password"].Direction = ParameterDirection.Input;
adapter = new SqlDataAdapter(command.CommandText, connection);
adapter.Fill(ans);
return ans;
}
catch (Exception ex)
{
throw ex;
}
when i execute i get an exception:
An attempt to attach an auto-named database for file C:\Documents and Settings\Administrator\My Documents\Visual Studio 2008\WebSites\WebSite1\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be Opened, or it is located on UNC share.
i tried to look for a solution but didnt find something helpfull.
|
|
|
|