ASP.NET Discussion Boards

minhpc_bk11-May-06 19:43

11-May-06 19:43

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.

Re: connectionString in machine.config

Anthony Ford12-May-06 2:02

Anthony Ford

12-May-06 2:02

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

Re: connectionString in machine.config

minhpc_bk12-May-06 6:27

minhpc_bk

12-May-06 6:27

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.

Re: connectionString in machine.config

Anthony Ford12-May-06 6:56

Anthony Ford

12-May-06 6:56

Sweet! Hiding the file works perfectly. Thanks so much!

Anthony

converting

ptvce11-May-06 6:15

ptvce

11-May-06 6:15

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???????????

Re: converting

minhpc_bk11-May-06 19:44

minhpc_bk

11-May-06 19:44

Goole[^] could bring up a couple of links.

Problem related to dropdown list.

123xyztt11-May-06 5:00

123xyztt

11-May-06 5:00

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

Re: Problem related to dropdown list.

minhpc_bk11-May-06 19:52

minhpc_bk

11-May-06 19:52

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.

Image not showing on Hosting site

Ista11-May-06 4:12

Ista

11-May-06 4:12

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!!

Re: Image not showing on Hosting site

KrIstOfK11-May-06 4:22

KrIstOfK

11-May-06 4:22

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 ...

Re: Image not showing on Hosting site

Ista11-May-06 4:54

Ista

11-May-06 4:54

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!!

DataList not showing

kbalias11-May-06 2:25

kbalias

11-May-06 2:25

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

Re: DataList not showing

minhpc_bk11-May-06 19:55

minhpc_bk

11-May-06 19:55

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.

Re: DataList not showing

kbalias14-May-06 19:34

kbalias

14-May-06 19:34

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.

Error for opration =

ptvce11-May-06 1:52

ptvce

11-May-06 1:52

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.

Re: Error for opration =

Kanjinghat11-May-06 2:38

Kanjinghat

11-May-06 2:38

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

Re: Error for opration =

Guffa11-May-06 9:23

Guffa

11-May-06 9:23

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; }

Re: Error for opration =

Colin Angus Mackay11-May-06 10:30

Colin Angus Mackay

11-May-06 10:30

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

How to Get the IP of a computer on the network?

Assaf8211-May-06 1:23

Assaf82

11-May-06 1:23

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

Re: How to Get the IP of a computer on the network?

minhpc_bk11-May-06 20:04

minhpc_bk

11-May-06 20:04

HttpRequest.UserHostAddress Property [^]

transfer data from excel file to sql server programatically

amit__811-May-06 0:55

amit__8

11-May-06 0:55

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

Re: transfer data from excel file to sql server programatically

chinnasrihari11-May-06 3:16

chinnasrihari

11-May-06 3:16

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>)

Smile | :)

try this

Chinna Srihari
Tech Lead, Capgemini

Re: transfer data from excel file to sql server programatically

amit__811-May-06 18:04

amit__8

11-May-06 18:04

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

Banner management

Anish M11-May-06 0:42

Anish M

11-May-06 0:42

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

iHow can i use macromedia projects in asp.net.

TechnoGrey11-May-06 0:36

TechnoGrey

11-May-06 0:36

Hi,
I designed a menu with macromedia dreamweaver.It created a javascript and a file like *.js by it self.
I wanted to use this menu in my asp.net project therefore i copied the html codes and files from macromedia and pasted into my project.
When i run my asp.net project i can see the menu but the menu is not working properly.
It's colors must change when the mouse is on but not work.
How can i use macromedia projects in asp.net.
I want to include the macromedia codes in my project like this:
""
how can i do it?
Thanks.

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.