|
destroyer89 wrote: can anyone help me or may be show me the code
You should always share your effort while asking a question. Currently, it's just like a homework question without any effort made so far.
destroyer89 wrote: how to connect and display the database from the MySQL work bench to asp.net.
Start from here: Using MySQL with ASP.NET - Part 1[^]
|
|
|
|
|
There is a project that I want to merge in my project. It has only one default page with several back end files such as .css, .js. Is there a way to add that solution or that page to be specific in a certain div of page of my project, like we do using JQuery? What kind of c# code is required for that?
|
|
|
|
|
[][][][][][][][][][][][][][][][][][][][][][]>><<<>>>><
<big><big><small><small>
|
|
|
|
|
Ron_The_King wrote: Is there a way to add that solution or that page to be specific in a certain div of page of my project
Copy all resource files like CSS, JS and paste in your main project. Copy Default page and add it to main project - modify the references to JS/CSS/etc if needed based on the project hierarchy. If the relative hierarchy is still the same, no change would be needed.
Ron_The_King wrote: What kind of c# code is required for that?
For resource reference to a page, there would be no CS code involved. If you have some specific code to project you might need to make it suitable as per main project.
|
|
|
|
|
Hi,
I have created a windows service for printing PDF's through Adobe reader.
The code is as below.
Process.Start(exe,arg);
The command which executes from the above will be like below
C:\Program Files\Adobe\Reader 9.0\Reader\AcroRd32.exe,/h /t "D:\test.pdf" "\\servername\PrinterName" "" ""
This was working fine in windows 2000 server.
Now we are upgrading to windows 2003 server. In this it is not giving print.
Also I'm not getting any exception or any logs. Logs were created as everything working fine.
Also in 2003 server this is working from command prompt and
from console application also it is working, but when user logged in.
If no one is logged in again the print is not working.
Can please some one help me on this.
Regards
Madhu
|
|
|
|
|
How to add image to the masterpage
|
|
|
|
|
To Master Page? Way to adding picture to master or Web Form, are same. If you want to add image via HTML, write this code:
<img id="pic" runat="server" alt="" />
And to code behind add following code:
...
pic.Src="path to the picture";
...
Of course, you can add image via asp:Image, but adding image by HTML is better solution, because ASP.NET server control add a some value to _VIEWSTATE, add prefix before id...
|
|
|
|
|
Adding image to normal webpage and masterpage are same. At times, you might face issue with image display because of the image relative path issue because of page hierarchies.
For such cases, you would need to make sure that the path is correct such that file is found and used.
I would suggest you to use this Tip and resolve the path correctly before setting the source: Resolving Paths in a Multi-Folder WebSite[^]
|
|
|
|
|
Hi world,
My Code is :
I call this page from another Page :
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
<script type="text/javascript">
function setinformation() {
var oMyObject = window.dialogArguments;
document.getElementById('<%=GridviewTypeT.ClientID%>').value = oMyObject.GridViewType;
}
</script>
</head>
<body onload="setinformation();">
<form id="form1" runat="server" >
<div>
<asp:HiddenField ID="GridviewTypeT" runat="server" />
</div>
</form>
</body>
</html>
My Question is that how can i call function setinformation() before Page_Load so in Page Load i can have value in GridviewTypeT Something Like this :
protected void Page_Load(object sender, EventArgs e)
{
if (GridviewTypeT.Value == "Ghata")
{
}
else if (GridviewTypeT.Value == "Khadamat")
{
}
}
But now it doesnt have any value and after Page_Load finish then it execute the function setinformation() and will get Value.
So i want the value befor Page_Load.
Thanks in advanced!
|
|
|
|
|
You can't.
[explanation]
The javascript will not execute until the DOM is ready, in other words, all the HTML has to download to the browser, before the JavaScript will initialize.
|
|
|
|
|
Thanks for reply.
So what is the solution or Trick!
|
|
|
|
|
|
I think you need to call the window.onload for javascript, like page load, and make it call your function. The post says that it will load a fucntion before the DOM is ready.
I may be wrong on this, I always wait for the DOM, and do stuff like that on the server side using page load.
[^]
|
|
|
|
|
Thanks but not used...
I have tested this before and didnt get any result :
<script language="javascript" type="text/javascript">
window.onload= function c() {
document.getElementById('<%=TextBox1.ClientID%>').value = "Helo";
}
</script>
|
|
|
|
|
I don't know what your trying to do, but the link did offer several suggestions.
If you want to execute some javascript on page load, you use the body tag and enter a javascript function to run on your tag onLoad.
<script>
function initialize() {
}
</script>
<body onload="initialize()">
<div id="map_canvas"></div>
</body>
Google Maps uses this, to initialize the map object, and request map data before the page is drawn in the browser. When the map canvas is available in the DOM, the map object then draws the map in the map canvas.
If you want to execute some javascript when the DOM intializes, usually 2 seconds after the page paints in the browser window,
window.onload = function() {
init();
doSomethingElse();
};
function init() {
var tempValue = document.getElementById(txtHiddenDomain).value;
alert(tempValue);
document.getElementById(txtHiddenDomain).value = "test value"
}
function doSomethingElse() {
}
If you can't get the value, then double check your ID attribute for the control. If you use the controls ID, then perhaps the ID is changing to another value, so you have to hard code the ID using id="_txt_textbox"
you had your id wrapped in <% %>, so do a response.write(<% %>) and double check the value printed.
|
|
|
|
|
Thanks for the ans.
My aim is that when this page loaded it should show a gridview.
now the datasource of gridview depend on what i will send from other pages.(i mean that i just send the type of gridview and in the page_Load it will fill it depending on the type i sent).
So i should know the value of GridviewTypeT.Value in Page_Load for when the page load the gridview will also load automatically.
if (GridviewTypeT.Value == "Ghata")
{
}
else if (GridviewTypeT.Value =="Khadamat")
{
}
|
|
|
|
|
Well if your starting a new page, or redirecting, send a query string over to the page
details.aspx?q=datastring&output=datasource5
Change the words to what you need,
Then make sure the values exist, check the values against fraud, and load the page.
on Page.Init, select the proper gridview, on page.load, load the right datasource
So you can have like 5 gridviews, 1 in each div tag, and just make the div you need visible.
Ok, 5 datasources, choose the correct datasource based on output=datasource1
now i assumed your doing this in code behind, you need to use code behind to select the data source.
That's how I would do it. If it's a new page, you don't need to use javascript, unless you want it on the same page.
I'm done for tonight
|
|
|
|
|
Hello guys,
I have created a web application, where i provide to users to login and log out, register, etc.
I have two databases (i only will use one of them at the end, but now i use them both just to test my application. I use One each time i run the app). I am using the Membership provider on both of those databases. I the Web.config file i point the app to use one of the two databases, by using this connection string:
<connectionStrings>
<clear/>
<add name="MyLocalSqlServer" connectionString="Data Source=THESAINT\SQLEXPRESS;Initial Catalog=UserAuthentication;Integrated Security=SSPI;"/>
</connectionStrings>
I have two problems i can't seem to figure out what is going on and why they happen. I have searched a lot , but didn't any post with similar problem.
I can successfully register and after login the registered user. The problem appears in this two scenarios:
1st. When i change the database name in the connection string, put the second database, run the application, and after put again the first database in the connection string and run again the application.
2nd. When i close the SQL Server Express 2008 R2 and then start it again.
Having done those scenarios above, if i try after to login with a user that is registered in any of the two databases, i keep getting message that the password or username is not correct(that is, the error message of the ASP.NET Login control).
But if i want to register a new user, i still can. I only cannot log in .
It seems like the application doesn validate the credentials when logging in.
Anyone had a similar problem or has an idea of what might be going here ??
I am really frustrated at this point ! I've searched a lot but nothing !
Thank you guys !
|
|
|
|
|
Your question is vague,
Maybe you have a space in the data you wrote in the database
like "john doe "
So when you query the value it doesn't match.
You have to use the trim()
|
|
|
|
|
What you didn't understand mate ? I tried to explain as simple as i could, but let me try to explain it again.
As i told you i have this application. The user can register, login, log out, change password, etc.
I am able to register new users from the registration form(ASP.NET CreateUserWizard). After having registered them, i can also log in successfully if i give the credentials of any of those users i registered.
But If i do one of the two steps below the error appears.
1. If i close the project and the database server(SQL Server Express 2008 R2)and after open it again, i cannot log in anymore with some of the registered users, as i could before closing the project.
2. If i try to:
i)change database(i have two DB, with different names but exactly the same
tables and columns inside)
ii)point my application in the connection string to the second database.
iii)run the application
iv) after put back the first database in the connection string
v) run the application
vi) try to log in with some user that is already registered
vii) Baam !! The user doesn't get authenticated. I get message that the password
and username are not correct, when before changing the database name,i could log in without
any problem.
And here is the strange thing that makes me crazy. After having done one of the two steps above, i still am able to register new users. The only thing i cannot do anymore, is log in with some user that already exists in the database.
I do not thing that it has to do anything with the Trim, because when i registered the users, i used very simple usernames and passwords without any white spaces, just for testing purposes.
I hope i made it more clear here now.
Thank you very much for taking the time to see this !
Regards,
Pier
|
|
|
|
|
That's much clearer than the previous explanation. I understood the first explanation, just sounded to me like the data input was malformed, so there was no match.
Well overall, connecting to a database is pretty straight forward, but does require a series of steps to make sure it works correctly, before writing 10K lines of code.
I just learned how to use Oracle 11.g, and it took me 3 days to figure the whole thing out from start to finish.
I can probably narrow down your problem, and can only condense it into a smaller format. The actual problem can be within a much larger scope of issues, ranging from connecting to actual table permissions.
Now you may think my post here is condescending, but it's designed to teach you how to fix your problem, because your always going to run into this every time you create a new SQL Server, no matter what brand it is.
CONNECT to table in the WebDev - OK
CONNECT to table in IIS - OK
UPDATE table - OK
SELECT from table - Fails
[Possible Solutions]
Double check your connection string
http://www.connectionstrings.com/sql-server-2012[connection string^]
In the WebDev [F5], security is relaxed, so connecting to a SQL Server on your development computer is easier.
Server=.\SQLExpress ;Database=myDataBase ;Trusted_Connection=True;
But in a production enviroment, if your SQL server is remote, and your not running in a windows domain, you should use SQL Authentication, which is a SQL user account just for that tablespace, and secure password. When you ran the setup for SQL Server, you had a choice for Windows Auth or Mixed Mode, you need Mixed Mode for web apps, well it's just easier to start with, and is pretty secure with strong passwords.
Server=myServerName\myInstanceName;Database=myDataBase;User Id=myUsername;
Password=myPassword;
Next, check your tablespace permissions, your SQL user must be able to CONNECT, SELECT, UPDATE at the minimum. A tablespace is the database name in SQL Server.
Use a program like EMS SQL Manager Lite,to open your table, and use the SQL Tool to write a simple query, and execute it. The program will print the actual server response, which is the error message that caused the failure. In asp.net, you have to capture that error using catch.
SELECT COUNT(*) FROM schema.tablename WHERE accountName = 'testName'
Check your results, you should get a value of 1
If that all works, write a function that does the same thing, and walk through it to make sure you get the same value in your project.
Now if that works fine, the error is now isolated down to your login program. You'll need to walk through the program code using F5 and make a break point using F9, and step through the database code using F11, examine the username and password buffers all the way through the journey, and make sure that the values are valid right up to the database execute query, and then check for any error messages.
Basically I think your either writing or reading bad data, or your user does not have permission to read the data.
If you bound the wizard control to a table, There might be a mistake somewhere, so you have to narrow it down.
[edit]
It doesn't matter that you have 2 databases to anyone but you. You have to fix the first database of choice, and when that is fixed, fix the second one, then both will work correctly.
|
|
|
|
|
Hello and thank you again!
Well the problem got fixed somehow, but i didn't change anything regarding the database permissions. What i changed was the below properties of my CreateUserWizard control
From
LoginCreatedUser="true" DisableCreatedUser="false"
To
LoginCreatedUser="false" DisableCreatedUser="true"
That seems to fixed the problem, but not completely. I can log in and authenticate all the registered users that exist in my membership database, except the first user i registered. That one can not be authenticated, and i don't understand why, since all the others can be authenticated just fine.
Thank you again,
TheS@int
|
|
|
|
|
That seems strange
The example code seems to represent that when the create user wizard runs and completes, it will login the user automatically.
So it looks like your problem is that the user is being disabled after creation. So if you login, you get a false flag saying login failed, when login was successful, but the account is disabled, so it's a fail.
You need to edit the table and toggle all the users to non-disabled, I think it should be
LoginCreatedUser="true" DisableCreatedUser="true"
|
|
|
|
|
Dear All, I am having an issue with an aspx where it takes too much (more than 1 min) to execute a page as it only takes 2 second in sql server to execute the same query where i am calling from aspx page.
I didn't understand why the aspx page takes too much time?
Abdul Rahaman Hamidy
Database Developer
Kabul, Afghanistan
|
|
|
|
|
I've heard that before.
In most case, one binds a table to a control, and that table has over 10K records. Of course in SQL, it returns in 2 secs, but the overhead on the server, takes, several minutes to generate the HTML code, and the download time as well.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
