|
Hi,
I am new web programming , so experts please excuse, I've created a simple web app in asp.net2.0 and sql server2000 .I wish to host this web site, and i payed for the webhosting provider. They send me the credentials like:
1. Host Usr name & passwd
2.Database details(ip address,name,usrname,pwd)
But my problem is , that i dont know how to copy my database scheme and data into the providers remote database server.i.e from a local db to remote db.
Plz help out !!!!!
Thax in Advance ...
|
|
|
|
|
Register the remote SQL server in your local SQl Server 2000 enterprise manager.
Then open your remote database and use DTS export/import wizard to copy data from your local database to remote database.
|
|
|
|
|
Thanks a lot for the replies !!!
But could guide me through the steps to register remote SQL server
Plz help!!
|
|
|
|
|
use this connection string
<appSettings>
<add key="ConnectionStringname" value="Data Source=ip address;Database=databasename;uid=username;pwd=password;"/>
</appSettings>
after that
open Enterprise manager open sql server group and then run new database registraion wizard,put ur ip address at server name then run wizard,after completing this wizard,right click on thatgroup which genrated as ipp name,and export ur database on that group.
before doing this thing u must have to create a database on ur web server and create a database and give uid and pwd.
|
|
|
|
|
I've had some success with this[^] tool from Microsoft. It creates a single script from your database which, when executed on a remote server will recreate your database on the remote machine, schema and data.
"A Journey of a Thousand Rest Stops Begins with a Single Movement"
|
|
|
|
|
iam getting a datatable through webservice..now how can i read the datatable through javascript ...
|
|
|
|
|
You can use JSON to convert the server side DataTable to use in client side.
Check this link[^]
Also you can use asp.net ajax page methods to return and use server side datatabl in client side using javascript.
Check this link[^]
|
|
|
|
|
Hi Friends
I want all the time difference with gmt when a zipcode is entered preferably all the US time differences.Please tell me how can we do it .Is it the same time zone for the selected state or in the same state they are different time zones in US!
Thanks In ADvance For Your Answer!![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
With Regards
sashidhar
Forgive yOuR EnEMIes, but nEVeR FoRget tHeiR NamES!
|
|
|
|
|
Hi all,
I am using .NET 2008 with AJAX. When I drag ajax control on to the Page, its neither getting pasted on the form, nor giving error. When I drag to HTML code back window, it is saying "INVALID FORMATETC Structure".
What exactly does it mean? I can use those controls ?
Ramesh Sambari
Knowledge is like honey.
Collect it, to make life sweet.
|
|
|
|
|
|
i m using javascript function to sto back button.
function logout()
{
Backlen=history.length;
alert('history len ' + Backlen);
history.go(-Backlen);
}
and in code file
FormsAuthentication.SignOut();
Response.ExpiresAbsolute = DateTime.Now.AddDays(-1d);
Response.Expires = -1500;
Response.CacheControl = "no-cache";
Session.Abandon();
Response.Redirect("~/frm_Default.aspx");
back button is disable now but forward button still working its opening the pages .. i dont want to disable back and forward for all the pages i only want at the time of logout.. thnx in advance
|
|
|
|
|
Not sure why people are so much worried on Back/Forward buttons. Anyway, check this[^] thread.
|
|
|
|
|
forward button still not disable it does not open logout page but it opens next to that on click of forward button
|
|
|
|
|
Hi guy,
I am Creating (ActiveX control or win-form libarary) in C# using ASP.Net.
Everything has been done successfully but when I run the web-form
on the browser screen show me prompt dialog "Security-warning" Messages.
with Run or Don't Run two buttons
I want to can’t Show this Dialog, Anyone help me.
web-form expose ActiveX Control Codes.
<object id="myControl1" name="myControl1"
="" classid="ActiveXDotNet.dll#ActiveXDotNet.myControl" width="288" height="72">;
;
|
|
|
|
|
ActiveX controls are external objects and embeeded with browser. It's execution is solely dependant on the browser's security settings. The security warning message can be removed by changing the browser settings but that can be dengerous as far as the security threats are concerned. It can be accepted if the application will run with in the network.
Regards
Saanj
Either you love IT or leave IT...
|
|
|
|
|
Hi,
Thanks for help, but what's alternative way.
We have needed to Client-side ActiveX control without asking Security message in browser.
|
|
|
|
|
Dear all
i want to a label on image control
this label will display a dynamic text about the image
but i should be a image control becose the imageur will be dynamic and the image will change in a timer
so i want to display the label over the image control to display a text about the image
thanks for help
MD_NADA
|
|
|
|
|
I have a tree view in my page. I want to show the name of of selected node
along with it's parent node. I am using the folleing event. I want my text
of lable like follwing when I click child node aaa
AA--> aaa.
Where AA is parent node's text and aaa is child node's text. I don't want
to use Sitemappath.
|
|
|
|
|
when you clicked the Node Get Parent Nodes of Selected Node
and Show it on label.
Example.
TreeNode ParentNode= new TreeNode();
ParentNode=this.treeviewCtrl.SelectedNode.Parent
string strFullNode=ParentNode.Text + ">>"+ this.treeviewCtrl.SelectedNode.Text
|
|
|
|
|
In my site i have a div to represent a blog post like below
<div class="post">
<div class="header">
<h3>Header</h3>
<div class="date">May 18, 2009</div>
</div>
<div class="content">
Some Content
</div>
</div>
Basically, what i'm wanting to do is select the 10 recent posts from a database and build the page with these posts using the div tags above. I can already do the easy things like setting the header, date, and content.
Thanks,
Don't be overcome by evil, but overcome evil with good
|
|
|
|
|
So, what is your question?
|
|
|
|
|
what i can't figure out is how to create dynamically create div's for each post (as opposed to hardcoding them in the aspx file).
Don't be overcome by evil, but overcome evil with good
|
|
|
|
|
I think i figured it out. The solution i found is something like this:
(i know this won't generate the markup in the original post, this is in a seperate test project)
ContentPlaceHolder leftContent = (ContentPlaceHolder)Master.FindControl("leftContent");
HtmlGenericControl div = new HtmlGenericControl("div");
div.Attributes.Add("class", "post");
HtmlGenericControl h2 = new HtmlGenericControl("h2");
h2.InnerText = "My Header";
HtmlGenericControl p = new HtmlGenericControl("p");
p.InnerText = "This is some content.";
div.Controls.Add(h2);
div.Controls.Add(p);
leftContent.Controls.Add(div);
which will then generate this:
<div class="post"><h2>My Header</h2><p>This is some content.</p></div>
Is there a better way to achieve what i'm trying to do? I feel like i'm going against the grain here.
Don't be overcome by evil, but overcome evil with good
|
|
|
|
|
Use asp.net repeater control.
<asp:Repeater id="rPOSTS" runat="server">
<ItemTemplate>
</ItemTemplate>
<asp:Repeater> On ItemTemplate you will put the code you want to repeat X times.
So, in code behind you will do something like this:
rPOSTS.DataSouce = YOUR_DB_DATA;
rPOSTS.DataBind();
See more about repeater control in Google[^].
|
|
|
|
|
Sweet! That was easy enough  For future readers this is the result that paulo helped me come up with
in the aspx file:
<asp:Repeater runat="server" ID="postRepeater">
<HeaderTemplate>
<div class="post">
</HeaderTemplate>
<ItemTemplate>
<h2>
<%#DataBinder.Eval(Container.DataItem, "Header")%></h2>
<p>
<%#DataBinder.Eval(Container.DataItem, "Content")%></p>
</ItemTemplate>
<FooterTemplate>
</div>
</FooterTemplate>
</asp:Repeater>
and in the code behind:
System.Data.DataTable dt = new System.Data.DataTable("Posts");
dt.Columns.Add(new System.Data.DataColumn("Header"));
dt.Columns.Add(new System.Data.DataColumn("Content"));
System.Data.DataRow row = dt.NewRow();
row[0] = "Header 1";
row[1] = "Content 1";
dt.Rows.Add(row);
postRepeater.DataSource = dt;
postRepeater.DataBind();
Thanks again
Don't be overcome by evil, but overcome evil with good
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
