|
Hi,
I am a newbie in asp.net. I am trying to connect a sql database with my web page. I have got a checkbox and a button on the page, once the check box is checked and the button is clicked the page should show the data that I want from the database table. I have written so far the following codes.
<
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
if (CheckBox1.Checked)
{
SqlConnection conn = new SqlConnection("user id = user;" +
"password = pass;" +
"Data Source = local host"); //making the connection string
conn.Open(); //opne the connection
SqlCommand cmd = new SqlCommand("SELECT (id, name) FROM customer", conn);//sql query
conn.Close();//close the connection
}
}
}
>
It doesn't work. I get the following error msg.
<
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
>
The datasouce is not right !  . I would really be appriciated if some can give an idea how can I fix it or the way I am trying to do it if it's right. Many thanks in advance.
|
|
|
|
|
Take a look at this page http://www.connectionstrings.com/
|
|
|
|
|
hi
in a page when i click on a button then a pop-up page is shown to the user
now what is the problem is if when user blocks the pop-up page for my website then he cant able to see the pop-up page.
i saw that by default the pop-up blocker is set to turn off for internet explorer
how can this problem is solved
|
|
|
|
|
Nothing much. Apart from checking that the window you had popped up, opened or not. You can check this through window.open("popup").closed property.
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
Check, if you can try with <a href with target as _blank in your scenario.
|
|
|
|
|
I m done a web page in ASP.NET. The Web page is finished. know I m facing a problem.
When i execute my web page in different system web page is will not coming in middle or it is not expand to screen size.
and Zooming process also same problem is coming.
I tried following thing.
1. Set margin: Auto; and margin: 0px auto;
2. text-align as center in div, p, span tag. aslo I tried Center tag.
How to solve this problem.
modified on Wednesday, October 21, 2009 7:53 AM
|
|
|
|
|
How did you fixed the widths of the controls in your page?
It's not necessary to be so stupid, either, but people manage it. - Christian Graus, 2009 AD
|
|
|
|
|
I m using DIV tag and set margin, Padding, Width, Height etc..
|
|
|
|
|
|
What u given suggestion is working improperly in IE but in Mozialla not working for my code is any other solutions?
|
|
|
|
|
hi all,
I have to find control id from java script in my master page
var test = document.getElementById('<%=hiddenvalue.ClientID%>');
I am using this code but its not working in my master page.
plz help.....
modified on Thursday, October 22, 2009 1:41 AM
|
|
|
|
|
bhavnvyas wrote: var test = document.getElementById('<%=hiddenvalue.ClientID%>');
Where is your hiddenvalue field ? It is master page or in any content page?
bhavnvyas wrote: I am using this code but its not working in my master page.
What error are you getting ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
hidden field is in master page only...
ERROR:
System.Web.HttpException: The Controls collection cannot be modified because the control contains code blocks (i.e. <% ... %>).
|
|
|
|
|
What is the best practice to stop a web application to stop from working on IIS in a marketing image. I am distributing an image that has a published web application to customers and i need this applciation too stop from working after a month from that first login.
Any ideas and thanks in advance!!!!!
|
|
|
|
|
Write Business logic on Login of application or Page Load of your application.
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Hi
Guys
Using .net 2.0 i build a web site in which there are some java script which will open a new popup window
that code is working in IE all version & Mozila 3.5 but when i am checking in mozila 2.0 that popup window is not opning
So what are issue Plz help me
Java script Code
<script type="text/javascript" language="javascript">
function OpenChildWindowEmail()
{
var sFeatures="dialogHeight: 200px;";
sFeatures += "dialogWidth: 500px;";
sFeatures += "center: no;";
sFeatures += "edge: sunken;";
sFeatures += "scroll: no;";
sFeatures += "status: yes;";
sFeatures += "resizeable: no;";
var url = 'my_share_emailfile.aspx?somevalue=12345';
var entryWindow = window.showModalDialog(url, 'ChildForm', sFeatures);
window.document.getElementById('HiddenField7').value = entryWindow;
// alert(entryWindow+window.document.getElementById('HiddenField7').value+" "+entryWindow+window.document.getElementById('HiddenField7'));
// alert(entryWindow);
if(entryWindow =="true")
{
//alert("Watch for CurrTime & ChildWin labels, its going to update since the new child window saved something");
//this would trigger the update panels update as the button is part of the UP
window.document.getElementById('btnImgEmail').click();
}
else
{
//No change will happen to the parent page as child page did nothing
//alert("Nothing on the page will change as the new child window was cancelled");
//window.document.getElementById('btnImgEmail').click();
}
}
</script>
On Button Click
<asp:ImageButton ID="btnImgEmail" runat="server" ImageUrl="images/email_bt1.jpg"
OnClientClick="OpenChildWindowEmail();" OnClick="btnImgEmail_Click" ToolTip="Email files to friends"
Enabled="False" />
krishna veer singh
|
|
|
|
|
use
window.open
rather than
window.showModalDialog to work on every browser.
|
|
|
|
|
I did the same but its not working
Any other solution
krishna veer singh
|
|
|
|
|
krishnaveer wrote: I did the same but its not working
What do you mean by not working ? aren't you able to open the popup using window.open() ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Are you sure that window.open doesnt opens a new window ??
or you mean the window is not modal...
I think modal window is not standard option, so many browser will not support this feature. 
|
|
|
|
|
Hi ,
There is an issue of ie8 on JavaScript.When I call a button click on ie8 , postback is occuring.It is working fine with ie7.How to prevent it from happening a postback
With Warm regards.
|
|
|
|
|
Perhaps you need to explain what you mean. A button click is SUPPOSED to generate a postback.
Christian Graus
Driven to the arms of OSX by Vista.
Read my blog to find out how I've worked around bugs in Microsoft tools and frameworks.
|
|
|
|
|
if you write like
<input type="button" value="mybutton" onclick="javascript:func();return false;" />
here if onclick returns false, the event bubbling will not occur and thus the form will not be posted back.
|
|
|
|
|
Why do we need to return false if it is client side button ?
Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.
|
|
|
|
|
Yes bro... you are right... 
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
