|
Hi every-one,
Short: My name is Ian, I am actually learning web programming, please if any one can answer me on my burning question - thank you.
1: Is it possible to access another sql server from a website
2: I want to create login and access ie. read and write client specific data to and from the client db.
3: What controls or how do I manipulate .net controls to allow me access on these db's
If any one can assist me please and Thank you
Ian
WOW
|
|
|
|
|
Hi,
I am not sure what you meant by another sql server. Yes you can connect to multiple sql server through your website. Its up to you how you manage your connections. You could use GridView, DataList etch controls to access your Db but not sure what exactly you are trying to achieve.
|
|
|
|
|
Hi Jaffer,
Well sorry for the incomplete description. Ok, I have a client(say Pups) who needs his clients to access their information over the web. This entails that when that client logs in over the web, I must read their login information which is stored in Pups SQL Db on Pups server. Also for new clients of Pups who need to register over the web, to be able to trade with Pups, I need to Update his sql Db.
I am still new to ASP.net and web development and are not familiar with all the controls. I have however tried to adjust or change asp.net configuration and Provider but with no success.
Please if you can help me and put me into the right direction. If the information is still not enough I will elaborate more should you have more questions.
Thank you very much
WOW
|
|
|
|
|
Hi,
Are you using 2 sql servers? Because from the description i am still unable to completely understand your problem.
What i understand from your description is you might be having 2 sql servers one called pups. Okay when pups clients access pups application over web you might say you establish connection to the server using connection string 1 hitting pups database server. And when you need to connect to another database server you should use connection string 2. This logic should be embedded in your program to determine which database it should access at any particular moment.
I am assuming you know about connection string and know how to connect to a sql server in asp.net
|
|
|
|
|
Well thank you very much Jaffer, I did find information assisting me in this regard.
Ianjan
WOW
|
|
|
|
|
Buy a book mate, The MS Press books "xxxxx Step By Step" will get you started. Read articles on SQL Injection attacks as well.
|
|
|
|
|
Hi Frank,
Will definitely get a good book thank you very much
Ianjan
WOW
|
|
|
|
|
Hello all, please forgive my newbie-ness.... (at ASP.NET)
I have a tabcontainer on my masterpage where each time a tab is clicked it actually shows a different .aspx page for each tab. First, I'm not sure if I'm even going about this the right way. It works, but it's kinda slow and a very visible transition.
I just call 'Response.Redirect()' in the 'ActiveTabChanged' event depending on which tab was clicked.
Secondly, even though this works to switch from page1 to page2, it always shows the active tab as the first one after clicking on the second one, even though the second page is now showing. I even tested setting it back explicitly, and it still doesn't work.
protected void TabContainer1_ActiveTabChanged(object sender, EventArgs e)
{
switch (TabContainer1.ActiveTabIndex)
{
case 0:
Response.Redirect("default.aspx");
break;
case 1:
Response.Redirect("default2.aspx");
TabContainer1.TabIndex = 1;
break;
}
}
Thanks in advance
|
|
|
|
|
Hi,
I am relatively new to ASP.NET with AJAX, and have a couple of performance related issues I am experiencing, and was wondering if anyone could offer some pointers.
I have quite a basic page, with 1 ScriptManager, and UpdatePanel, and 4 Collapsible panels on the page. Inside the collapsible panels, there are some labels and textboxes that are databound to various data sources. I have one button that calls an update to the database. This call happens Asynchronously as I expected as all the data controls and button is inside the UpdatePanel.
All works wonderfully locally.
On the production webserver, nonlocal users are complaining of slow performance. I have no narrowed it down to the size of the page.
I am using the WebDeveloper addon in Firefox to look at the resultant page.
Here are the results :
Documents (1 files) 28 KB (86 KB uncompressed)
Images (7 files) 15 KB
Scripts (5 files) 100 KB (540 KB uncompressed)
Style Sheets (2 files) 1 KB (3 KB uncompressed)
I have setup IIS6.0 to compress static content, as well as ASXP , AXD , CSS , JS etc.
I have not added an Javascript myself, so the script files are all compiler/control related.
Is this sort of size normal ? How do people get good performance from pages that download over 100k of scripts, for a few controls.
Any pointers would be greatly appreciated ?
Thanks,
Steve
|
|
|
|
|
You may be able to trim some of the image files down, or you may even be able to use some sprite-based magic to combine them together.
The document size (28KB) is not particularly big, but again you may be able to trim this down by removing unnecessary markup and making better use of CSS classes.
Your big resource hog seems to be the javascript files totalling 100KB, which I imagine must be some kind of javascript framework (prototype, jquery etc? 540KB uncompressed is really quite monstrous!). Most frameworks offer a compressed version which drastically reduces the size of the framework, or you may want to consider javascript compression in addition to server compression - combining your files into one and then JS compressing will have a much greater effect.
On top of that I would just verify that your site is setup to allow correct caching of static files.
|
|
|
|
|
Hi,
Thanks for the feedback.
I found I was using the debug version of the framework, dropped about 200k.
Am working on combining the files as we speak, and will look at the compression and server setup in depth,
Am looking forward to an optimized experience.
Thanks for the help.
|
|
|
|
|
Hi Everyone,
How to check a paypal's email id verified or not programatically? Does paypal give any option for that? Any answers or links welcome.
Thanks
Jegastar D.
|
|
|
|
|
Doesn't it tell you on Paypal FAQ? I would have thought that would be the best bet.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi follow the below link it may be useful for you..
http://paypaldev.org/[^]
|
|
|
|
|
Read up on the paypal faqs/documentation, sure you can find the answer there.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
I am new to administering a domain on plesk. It seems the default virtual directory for a domain is *httpdocs*. I would like to contain the default site content in a separate directory, but have the domain always default to this virtual directory. How can I do this?
|
|
|
|
|
hi,
i want to paste 2 image over and over in ASP page. but i cant do it. please help me.
 i want two hand for this 
thanks
modified on Sunday, October 5, 2008 1:32 PM
|
|
|
|
|
Just create new image controls and add them to the page, although it seems a strange thing to do.
Bob
Ashfield Consultants Ltd
|
|
|
|
|
Hi,
I want to know what is the best tag to use when making a piece of text a different color. I always used to use the <font> tag, but Visual Studio said that it is "outdated". So what should I use now? The <span> tag?
Please can someone advise?
Thanks
Brendan
|
|
|
|
|
Use CSS, the idea of which it to separate out your style from your content as much as possible.
|
|
|
|
|
Use CSS?? Of course I will, but you clearly didn't understand the question. I have a style called:
separator
{
color:#999;
}
So I wanted to know what tag must I use to apply this style to have a certain piece of text a different colour? The span tag?
|
|
|
|
|
--- NET Enthusiast wrote:</div>Use CSS?? Of course ---
Then what were you twittering on about using the <font> tag for?
--- NET Enthusiast wrote:</div>what tag must I use ---
well it depends on how you have styled you page. As you have it
separator
{
color:#999;
}
is defined neither as a class which can be applied to any element, whether it be p, td or yes, even span - in which case it should be
.separator
{
color:#999;
}
(and used eg <span class="separator"> )
or as a style applied to a particular element defined by its ID, eg <div id="separator"> in which case you shouold have
#separator
{
color:#999;
}
Generally you would use span for styling elements of [parts of text) that may require multiple uses, whereas applying an ID to an element applies oly to that one element.
|
|
|
|
|
The reason <font> is considered outdated is it tells you what (text is being formatted with a specific font, color...) but not why (text is being emphasized? de-emphasized? used to represent something specific, like a keyword, abbreviation, action...).
Generally, you should use a tag that most closely fits your intentions for the text: <p>, <em>, <strong>, <cite>, <code>, etc. If none of the standard semantic tags come close, use <span> for inline text, <div> for block text. When using span or div, or when you need to differentiate between multiple uses of another tag (different sorts of emphasis, code...), use CSS class names to specify your intentions: <em class="warning">; <div class="note">. Then, in your stylesheet, write rules against these elements and classes to provide the actual formatting:
em.warning { color: yellow; }
div.note { border: 1px solid black; padding: 2em; background-color: yellow; }
---- You're right.
These facts that you've laid out totally contradict the wild ramblings that I pulled off the back of cornflakes packets .
|
|
|
|
|
sir ,
i am a third yesr engineering student and we are developing a web site,basically we are having difficulties in accessing data from our database,if u can give us an insight into thus
|
|
|
|
|
what exactly your problem ??
When you get mad...THINK twice that the only advice
Tamimi - Code
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
