|
Dear All,
I am making small web application using asp.net, C# ,sql2000 using visual studio 2005
I basically want to know how to generate report(do have export and print feature).
I generated report with in local mode using ReportViewer but it was not supported print option.
Please suggest me idea or give me some usefull link to generate report.
Please help
thanks
regards
imran khan
|
|
|
|
|
hi
i want to create a page for send email.
for email body i want to use a control that user can write html tag.
how can do this?
|
|
|
|
|
|
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
|
|
|
|