|
|
Where did an iframe come from, whats the point in that? You want a multiline textbox (TextBox control with MultiLine or something similar set to true). It will get rendered as a tag
|
|
|
|
|
when i click in one button i want to open datetime picker in anotherform and when i select date i want to show the datetime in a textbox near to that button.i think we can write javascript function for that.is anybody know from where i will get the codings for that ?
|
|
|
|
|
anujose wrote: when i click in one button i want to open datetime picker in anotherform
Create one page that holds date time picker and when clicking popup that page. Then datetime picker will be in another page..
anujose wrote: when i select date i want to show the datetime in a textbox near to that button
Where you want to show the date ? In first page or the page where datetime picker resides ? If in first page use parent property of javacript.
parent.opener will give access to the window which opened datetimepicker window. Code could be something like this
function pick(symbol) {
if (window.opener && !window.opener.closed)
window.opener.document.Form.TextBox.value = symbol;
window.close();
}
|
|
|
|
|
How i can popup the page where datetimepicker resides?i want to pop up that page near to my button Control
|
|
|
|
|
Use this script
function launch(newURL, newName, newFeatures, orgName) {
var remote = open(newURL, newName, newFeatures);
if (remote.opener == null)
remote.opener = window;
remote.opener.name = orgName;
return remote;
}
function launchRemote() {
myRemote = launch("http://www.webreference.com/js/column7/demoontop.html", "myRemote", "height=400,width=110,screenX=100,left=100,screenY=100,top=100,channelmode=0,dependent=0,directories=0,fullscreen=0,location=0,menubar=0,resizable=0,scrollbars=0,status=0,toolbar=0", "myWindow");
}
In this code change screenX and screenY related to your buttons position
|
|
|
|
|
HI All ,
I am getting Problem with connection string.I know the syntax and Everything.I am getting problem with Data Source name.I Checked in Service manager in that server name is like this B4B-2F-323-CK26.
But when i try to open Enterprise manager then it is showing (local)windowsNT.
My connection String like this:
------------------------------
conObj = New SqlConnection("Data Source=B4B-2F-323-CK26;user id=sa;pwd=sa;Database=Shopping")
conObj.Open()
i am displaying Login table details in datagrid.i am getting blank aspx page as output.
i tried using B4B-2F-323-CK26 and local.Pls Help me it is very urgent.what i have to give Data source name
|
|
|
|
|
Hi
Try to register again your server using SQL Enterprise Manager on your local machine and check whether it is connecting. If it is still not working, then change the datasource to an Server IP address, or may be network not connected properly... try pinging in the command prompt ..
Harini
|
|
|
|
|
Hi Harini,
I Have given my IP Address still i am not able to connect.Pls tell me the Steps how to Register again my server using SQL Enterprise Manager.
Pls tell me neccessary steps i am new in this one
|
|
|
|
|
Hi
Hope you have installed SQL Enterprise Manager.
Go to SQL Enterprise Manager->Expand Console->Microsoft SQL Servers
Right Click SQL Server Group->Click New SQL Server Registration. You will get wizard popup. Click Next.
Did you get the server names on the left list??
If the server name is on the list, then double click the server name.
If not, type the correct name (as like connecting to other machine \\Server-Name or \\Machine-Name or \\IPAddress).
Before doing the above step, check whether server is available. How?? Go to start -> Run. Type \\server-machine-name. System will open a window mentioning the server path on the address bar means server is available.
One more thing, make sure that SQL Server service is started only then you will be able to get to database.
Now go back to SQL Wizard. Click next, by default Windows Authentication will be selected. If you know the UserId and password, you can change it to SQL Account and type correct userid and password.
Click Next, It will ask for SQL Server Group. Leave this step and click next.
Click Finish, it will be added to the SQL Server Group.
Now expand the SQL Server Group->Instead of local(windows NT)....Your server name will be there. Expand it, you will get Databases ...etc...
Once done. You can run your application with the same datasource.
If you are getting error on registering SQL Server, check the network is there or SQL Server Service is started (not stopped)
Hope this is clear
Harini
|
|
|
|
|
Hi Harini,
Thanks for Quick Reply.I followed all steps that u mentioned above.
1.I didnot get any server names in the left list.
2.i given \\10.185.80.205 then it opened printers and faxes page.same message i got when i gave 'machine-name' in start-->run
3. i have given my system IPAddress in leftlist then it is visible in SqlServer tree.
4.In codebehind when i gave Data Source =ipaddress of my machine then also
i did not display any records from database.
Pls suggest me again ..Thank inAdvance.
|
|
|
|
|
Hi
Then there is some mistake in your code behind ... post your code ...I will check it up.
Harini
|
|
|
|
|
Hi ,I think problem with Data source only .Pls check my code.
Imports System.Data.SqlClient
Public Class DataGrid
Inherits System.Web.UI.Page
Dim conObj As New SqlConnection
Dim adpObj As New SqlDataAdapter
Dim dsObj As DataSet
Page_Load()
-----------
Try
conObj = New SqlConnection("Data Source=10.187.80.208;
user id=sa;password=sa;Database=Shopping")
conObj.Open()
adpObj = New SqlDataAdapter("SELECT * FROM Login", conObj)
adpObj.Fill(dsObj, "Login")
DataGrid1.DataSource = dsObj.Tables("Login")
DataGrid1.DataBind()
Catch ex As Exception
Response.Write(ex.ToString())
End Try
i am getting this following error.i tried Data Source=B4B-2F-323-CK26
" Login failed for user 'B4B-2F-323-CK26\ASPNET'".
imp point is when open servermanager 'B4B-2F-323-CK26' this is showing server name .Pls suggest me
|
|
|
|
|
Hi
So Datasource is correct but what about Login name and password.
Try register again with login name and password (select SQL Account Login from the wizard).
Harini
|
|
|
|
|
Hi Harini,
Fnally , I am getting message that server already Exists.So tell me How to Delete Existing one .Then I will register with SQl Account info afterwards.
Waiting for your Kind and valuable Reply.
Thank you.
|
|
|
|
|
Hi
No need to delete the existing one. Right Click -> Edit SQL Server Registration. Change to SQL Logon instead of Windows Authentication.
Harini
|
|
|
|
|
Yes Harini ,
Finally my problem solved.Thanks for so many replies and keep sending answers for Questions.
Thank you very much....
|
|
|
|
|
That is great ... Sure will do
Harini
|
|
|
|
|
|
is that exe created using .net ? Try registering dll using regsvr32
|
|
|
|
|
when i am binding gird in page load it showing default values for check boxes in templet field means what ever at design time those but if i bind in button click then this is not happpned why is it so..
|
|
|
|
|
nikhil1234 wrote: hat ever at design time those but if i bind in button click then this is not happpned why is it so..
When button is clicked page will post back and will execute all the contents in the page load. So try to call the binding function in pageload like this
if(!isPostBack)
{
}
|
|
|
|
|
Install this software and you got yourself an online shop to sell ANYTHING!
..and run a professional internet business that will work for you 24/7,
so you have the freedom to quit your job and do things you really want to do with your time.
* Tiny size, only 2.0MB
* Automatic shipping fee calculation
* Unlimited number of items and categories
* Order and Accounts Manager
* Customize timeZone Support
* Customize Stock State Support
* Batch update Product price, desc, stock state
* News Manager
* AJAX support
Please Visit http://www.nzmk.com[^] to find out more!
Running on ASP .NET 2.0 & SQL 2000/2005
|
|
|
|
|
hello there,i know its not the righ place to ask some query,im cannot access my database in a query pane..i made a database where the username column has value and the password has none for e.g Username:93838383 and password:?..i just want to update the password column inputed by the user
I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text
i just want someone to check out the query and pls tell me what wrong or incomplete to my query
UPDATE UserTable
SET ((UserTable.[password] = [@password])
WHERE ((UserTable.username = [@username])
another thing is whenever the user visit the site,when the user type the password,it could not be updated anymore..unless i just want to use "select clause" because password column have now values...
here is the query
SELECT COUNT(*) AS Num_of_User
FROM UserTable
WHERE (((UserTable.username)=[@username]) AND ((UserTable.pasword)=[@password]));
error:unable to parse query text
it is correct query for accessing the values from the database?
im using a visual web developer IDE
thanx for helping
|
|
|
|
|
blitz2bleach wrote: I make the query in th stord procedure but th error said: Incomplete SET clause..unable to parse query text
Count your parentheses.
Also, don't you want to specify the parameters @password and @username instead of the fields [@password] and [@username]?
blitz2bleach wrote: error:unable to parse query text
Same here, don't you want to specify the parameters @username and @password instead of the fields [@username] and [@password]?
Check the spelling of the field pasword / password.
---
single minded; short sighted; long gone;
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
