|
I love the ASP.NET 2.0 feature which allows one to put the connectionString nodes in the machine.config, but does anyone know how to get those connection strings to show up in the Visual Studio 2005 IDE similar to the way the ones in the local web.config show up? For example, when dragging a SQLDataSource object into the designer, the first step is to configure the datasource, which of course requires that you specify a connection string. The ones that are inherited from machine.config will work, but they aren't available to choose from in the dropdowns of the IDE.
Thanks for you help!
Anthony
|
|
|
|
|
AFAIK, the SqlDataSourceDesginer object (the designer of the SqlDataSource control) uses the object which implements the IDataEnvironment[^] interface to access the connection list of the application at design time and display in the combobox. And it only gets the connections declared in the web.config file of the application, not from the machine.config file which is shared by all applications on the server. Though it's not easy, you may think of customizing the SqlDataSource designer if you want to.
|
|
|
|
|
Thanks for the reply and suggestion. Not sure I'm up to customizing the SqlDataSourceDesginer just for this, but I'll certainly keep that in mind.
Also, the underlying goal I'm trying to achieve might be solved another way if I could get Visual Source Safe 2005 to ignore files that I've excluded from the project. That is, in web.config, I would reference an external file for the connection string, but exclude that file from the project. The problem is, Visual Source Safe still wants to keep that file under source control, so my fellow developers and I would be overwriting each other's connection string file.
The reason we need this is that occasionally one of us will pull in a local copy of the database for the project and hit the road with our laptop. When we get back, we don't want to worry about checking the project back in with connection strings to the portable copy of the DB.
Thanks again
Anthony
Anthony
|
|
|
|
|
Hi Anthony,
Though you can configure the VSS so that it ignores a specified file type, it may affect the other files. There are two work-around options which you may consider:
+ Make the file hidden, the hidden file is automatically excluded from the web site and it's also ignored by the source control.
+ Check in the file, right click the file to open the Properties dialog box, uncheck the Read-only checkbox, you now can edit the file without checking out the file.
|
|
|
|
|
Sweet! Hiding the file works perfectly. Thanks so much!
Anthony
|
|
|
|
|
i want write a number and with click a button convert it for text
for example:
123 convert to: onehundered twenty two
can any body help me???????????
|
|
|
|
|
Goole[^] could bring up a couple of links.
|
|
|
|
|
i have a problem related to dropdown list...
The texts in the dropdown are too long and the width is not sufficient
to show the entire text. Increasing the width is not an option.Is there
a way to show the list without increasing the width.
thanks in advance
|
|
|
|
|
You may reduce the text length, and only display the full text as the tooltip of the item, the article[^] might give you an idea.
|
|
|
|
|
I have images stored in a folder
I use this path
Server.MapPath("~/Avatars") to find it.
I have a method that grabs all of the file names to display.
It works fine on my machine, and shows them perfectly.
I know I can access it because the code created the image and I have checked the access. Its fine.
I tried typing the URL to the image.
I can see it in IE. So I copy this path to my code. The image is still an X. I have even viewed to source to verify the path. and its correct.
Any ideas?
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
Once I also had a similar problem and then it was caused that my local machine wasn't case sensitive but the server was case sensitive ...
|
|
|
|
|
Yeah. I wish that was the answer.
Maybe the web hoster blocks images not on the root.
1 line of code equals many bugs. So don't write any!!
|
|
|
|
|
Hi
I am using Visual Studio with C# to develope a Web Application. I am using a DataList and binds it to a DataTable. When I run the application and the relevant page loads, the DataList is not displayed. I am using the following code:
private void Page_Load(object sender, System.EventArgs e)
{
string tableName = "Categories";
DataSet ds = categoriesDB.LoadCategories(tableName);
DataList_Categories.DataSource = ds.Tables[tableName];
DataList_Categories.DataBind();
}
The DataSet is holding data because when I bind it to a DataGrid on the same page to test it, the DataGrid displays the data correctly. What am I doing incorrectly or incompletely?
Thanks
Kobus
-- modified at 8:59 Thursday 11th May, 2006
|
|
|
|
|
Hi there. What does the ASP.NET markup of the datalist control look like? Also, you might want to check the Visible property of the control.
|
|
|
|
|
hi minhpc_bk
Thanks. I checked ASP.NET markup and I did not set up the ItemTemplate properly. It displays fine now. I am just struggling to get info out of the DataListItem when I have selected an item in the DataList.
|
|
|
|
|
DepLast = Convert.ToInt32(dt.Compute("SUM(essencbd_amount)","doc_date < '"+DateFormat.strYYYY+"/"+MM+"%' AND totalcode = '"+dsD.Tables[0].Rows[i][0]+"' ")) ;
i write this code but it give a error for this part"totalcode = '"+dsD.Tables[0].Rows[i][0]+"' ")) "
and that error massage is :
Cannot perform '=' operation on System.Decimal and System.String.
|
|
|
|
|
i am not sure but you can check it. normally the below statement returns a string and i think you are trying to add the returned string value to totalcode(probably a decimal).
dsD.Tables[0].Rows[i][0]
so you better to convert the same to decimal as shown below.
Convert.ToDecimal(dsD.Tables[0].Rows[i][0].ToString());
cheers.
Ramesh.Kanjinghat
|
|
|
|
|
You have to show the relevant code.
The = operator is not used in the code that you are showing, it's inside a string. The string is then fed to the dt.Compute method, so either you have to explain what that method does, or show the code for it.
---
b { font-weight: normal; }
|
|
|
|
|
ptvce wrote: DepLast = Convert.ToInt32(dt.Compute("SUM(essencbd_amount)","doc_date < '"+DateFormat.strYYYY+"/"+MM+"%' AND totalcode = '"+dsD.Tables[0].Rows[i][0]+"' ")) ;
This is horrible code. Consider refactoring it over several lines, that way you'll see the error more clearly and the compiler will be more helpful to you.
"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog
|
|
|
|
|
Hello !
I'm in the network, and i done a web application that can be viewed on the network.
The questions that i need to know the IP of each computer on the network use my application, and after i store IP in listbox wherever.
Can someone give me help?
and thanks in advance.
Assaf
-- modified at 9:12 Thursday 11th May, 2006
|
|
|
|
|
|
how to transfer data from excel file to sql server's tables in asp.net programatically
i can't use wizard
can any body will help me regarding the same
thanks in advance
|
|
|
|
|
Hi,
It is big procee
Let give you hint
Use the OleDbProvider and open the file and file in to data set and update to database
ExcelConnectionString = Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties="Excel 8.0;HDR=YES";Data Source = " & ExcelFilePath
strSQL = "select Col1,Col2 from [Sheet1$]"
SomeDataAdapter = New OleDbDataAdapter(strSQL, ExcelConnectionString )
have SomeDataSet declared
daCollateral.Fill(SomeDataSet, <tablename>)
 try this
Chinna Srihari
Tech Lead, Capgemini
|
|
|
|
|
thanks for the help,
that i did but it shows more than 4000 records while my excel file contains only 500
and the problem is that how i will transfer the same into sql tables
|
|
|
|
|
Hey...
Know of a good banner management for asp.net?
I was hoping to change from the 1 had used in all my previous projects...
-- modified at 7:30 Thursday 11th May, 2006
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
