|
Hi!
I have a project made up of asp.net website (2008) and a class library project.
my class library project is a DAL which is accessed via BLL that is in asp.net website.
DAL is made up of several tableadapters in a dataset.
I need to dynamically change connection properties of tableadapters in DAL if change is made in web.config file in asp.net website. I am just not sure how could i achieve this.
my BLL (which is not working currently)
------
using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using myDAL.DAL;
[System.ComponentModel.DataObject]
public class EmployeesBLL
{
private myDAL.DAL.dsEmployeeTableAdapters.getEmployeeTableAdapter empTableAdapter = null;
private string ConnString
{
get
{
string conn=null;
return conn = System.Web.Configuration.WebConfigurationManager.ConnectionStrings["db1ConnectionString"].ConnectionString;
Console.WriteLine(conn);
}
}
protected myDAL.DAL.dsEmployeeTableAdapters.getEmployeeTableAdapter Adapter
{
get
{
if (empTableAdapter == null)
empTableAdapter = new myDAL.DAL.dsEmployeeTableAdapters.getEmployeeTableAdapter();
return empTableAdapter;
}
}
[System.ComponentModel.DataObjectMethodAttribute
(System.ComponentModel.DataObjectMethodType.Select, true)]
public dsEmployee.getEmployeeDataTable GetEmployees()
{
return Adapter.GetEmployee ();
}
}
------
my DAL ( not sure if i am doing this correctly)
----
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
namespace myDAL
{
public partial class Employee
{
public DataTable getEmp(string ConnectionString)
{
SqlConnection conn =null ;
try
{
conn = new SqlConnection(ConnectionString);
DataTable dt = new DataTable();
DAL.dsEmployeeTableAdapters.getEmployeeTableAdapter eta = new myDAL.DAL.dsEmployeeTableAdapters.getEmployeeTableAdapter();
eta.Connection.ConnectionString = conn.ToString();
dt = eta.GetEmployee();
return dt;
}
catch (Exception ex)
{
Console.Write("Error in connection : " + ex.Message);
return new DataTable();
}
finally
{
conn.Close();
}
}
}
}
asp.net website aspx page
<asp:GridView ID="gvEmployee" runat="server" AutoGenerateColumns="False"
DataSourceID="ObjectDataSource1">
<Columns>
<asp:BoundField DataField="employeeid" HeaderText="employeeid"
InsertVisible="False" ReadOnly="True" SortExpression="employeeid" />
<asp:BoundField DataField="loginid" HeaderText="loginid"
SortExpression="loginid" />
<asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
</Columns>
</asp:GridView>
<asp:ObjectDataSource ID="ObjectDataSource1" runat="server"
OldValuesParameterFormatString="original_{0}" SelectMethod="GetEmployees"
TypeName="EmployeesBLL"></asp:ObjectDataSource>
please help
|
|
|
|
|
When you make changes in the web.config, your application will restart. Next time when you access the connection string, you will get the updated one.
|
|
|
|
|
hi all
i need some help about how to make a msg box in a web applications while using ajax controle (update panel) when i write a java script (responce.write) in the server side of the code on a control action that is in an update panel it gives me an error
thanks for any help
|
|
|
|
|
You need to tell us what the error is and show us some code, but it sounds like you don't understand what ASP.NET is, and does. A msgbox runs on the server, so it won't show on the client. Use javascript and alert, on the client side.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
i need to show the msgbox after an action or a result in the server side and as we know the excuation of the client side is done befor the server side will if any other suggestion about how to use alerts but after a result in the server side
thenks any way
|
|
|
|
|
Well, the only way to get a message box to show after a server side call, is to use AJAX, or if you're doing a postback, to write javascript into the returned page to show the popup. If you're not using AJAX, I see no point in a popup over a message on the page, but either way, MsgBox runs on the server, you need to use javascript. End of story.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
You may probaby try using the modalpopup extender that comes with Ajax Control Toolkit
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
hi
i am trying to use the ajax ModalPopupExtender it worked but i need to display a result after an action on the server side
thanks for your help
|
|
|
|
|
|
hi anybody have the solution how to check the other sesion or how to check which one is online using session.
|
|
|
|
|
VISUAL STUDIO 2005
I HAD ADDED THE XML FILE & IMAGES INTO THE PROJECT BUT WHEN THE IMAGES WERE CHANGING ONLY WHEN I WAS CLICKING REFRESH BUTTON... WHAT CAN I DO FOR CHANGING IMAGES FREQUENTLY.. PLS HELP ME
|
|
|
|
|
Thats how that control works. You need to roll your own and use AJAX
don't shout.
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hi,
Use Ajax controls, put your adrotator controls in those Ajax containers and remainig is same. Probably you can get what you want.
Thanks,
Aleem Mohammad.
S/W Engineer
Akebono Soft Technologies
aleem_abdul@akebonosoft.com.
|
|
|
|
|
i upload the default.aspx file along with web.config and default.cs files after uploading ......default.aspx page show the below error
Server Error in '/' Application.<br />
--------------------------------------------------------------------------------<br />
<br />
Runtime Error <br />
Description: An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine. <br />
<br />
Details: To enable the details of this specific error message to be viewable on remote machines, please create a <customErrors> tag within a "web.config" configuration file located in the root directory of the current web application. This <customErrors> tag should then have its "mode" attribute set to "Off".<br />
<br />
<br />
<!-- Web.Config Configuration File --><br />
<br />
<configuration><br />
<system.web><br />
<customErrors mode="Off"/><br />
</system.web><br />
</configuration><br />
<br />
<br />
Notes: The current error page you are seeing can be replaced by a custom error page by modifying the "defaultRedirect" attribute of the application's <customErrors> configuration tag to point to a custom error page URL.<br />
<br />
<br />
<!-- Web.Config Configuration File --><br />
<br />
<configuration><br />
<system.web><br />
<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/><br />
</system.web><br />
</configuration><br />
-----------------------------------
how i launch the .aspx files on my webpage without any error
|
|
|
|
|
Turn CustomErrors off. You will get the error message.
|
|
|
|
|
hi,
but.....where and how can i turn CustomErrors off.....
may you explain me........THANKS 
|
|
|
|
|
The error message you got is very friendly. Don't you able to understand from that ?
|
|
|
|
|
yes........i don't know that what happened ....therefore i
ask....please give some hints ...so that i able to understand the problem
|
|
|
|
|
zeeShan anSari wrote: please give some hints ...so that i able to understand the problem
Strange ! This <customErrors> tag should then have its "mode" attribute set to "Off".. Are you able to see the above in your error message ?
|
|
|
|
|
You may try running the application form local host. This will give you the exact error and the stach trace.
Thanks
Laddie
Kindly rate if the answer was helpful
|
|
|
|
|
Hello to all..............
actually i want to show data in datalist in table...
i have not predefined table row in Datalist... its also create in runtime. and you can check
http://www.magicbricks.com/property/faces/jsp/indexc.jsp[^][^] in featured project...
In this article they show City name on runtime and then city's Content.it's not predefined how much City can have and how much content of city can add.
and i havenot predefined city. and city's content.
so how can i display this type of data in datalist at runtime..
|
|
|
|
|
|
The fact that so many people ask this question here is the reason I wrote this[^].
Christian Graus - Microsoft MVP - C++
"also I don't think "TranslateOneToTwoBillion OneHundredAndFortySevenMillion FourHundredAndEightyThreeThousand SixHundredAndFortySeven()" is a very good choice for a function name" - SpacixOne ( offering help to someone who really needed it ) ( spaces added for the benefit of people running at < 1280x1024 )
|
|
|
|
|
Hey People how are you?
I've got an ASP.NET (Built in VB.NET) web system and I need to talk to a program called IBM MQ. IBM MQ is sort of like BizTalk but I've been unable to find anyone that has been able to find out how to talk to MQ directly. To talk to MQ in general you can do it through the DOS Command Prompt by typing in commands and that works really well.
My problem is that I don't know how to get my VB.NET web system to talk to Command Prompt and pass it arguments that I'll use to talk to MQ.
If anyone has any code for opening and passing arguments into a command prompt that would be very much appreciated.
Thank you very much in advance.
Michael
|
|
|
|
|
Michael101 wrote: My problem is that I don't know how to get my VB.NET web system to talk to Command Prompt and pass it arguments that I'll use to talk to MQ.
Write a .bat file which contains all your command to be executed. Use Process.Start() to execute this .bat file. But doing this through ASP.NET doesn't make any sense, also bat file will be executing on server, not client machine.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
