Re: Web - User Control and Serach Engines - ASP.NET Discussion Boards

Re: SQL 2008 (Web Developer Membership System) - Could not find stored procedure.

Baeltazor4-Feb-10 20:41

4-Feb-10 20:41

Yeah, with your help i managed to sort it out. If it weren't for you, i would've had to pay to get it fixed by somebody. You saved my butt! Big Grin | :-D

No line numbers in release stack trace

Danpeking4-Feb-10 12:49

Danpeking

4-Feb-10 12:49

Hi, I'm looking into a problem on our website but other than the method I have no way of knowing which control/line number the error refers to. I know it is caused by one of 4 controls where we convert the contents to an int. For example, the code is:

private void SomeMethod()
{
int i = Convert.ToInt32(ddl.SelectedValue);
int i2 = Convert.ToInt32(txt.Text);
}

I think it is being caused by a custom textbox's value returning null. It is an intermittent problem and not something we have been able to recreate.
The stack trace is:
Input string was not in a correct format
System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) +119
System.Convert.ToInt32(String value) +63

It would be nice to narrow the search down to a particular control and I would like to understand how exactly I can narrow the stack trace error down to a particular line. Can anybody please tell me how this is possible?
Thanks

Re: No line numbers in release stack trace

Venkatesh Mookkan4-Feb-10 17:35

Venkatesh Mookkan

4-Feb-10 17:35

Check which of the lines is returning String.Empty (i.e empty string) as the parameter to Convert.ToInt32() function.

Convert.ToInt32(null) will return 0 whereas Convert.ToInt32("") - throws the exception is mentioned.

I hope this would help you.

Castle Rider

What if I freeze??? Don't forget to breath...

My: Website | Yahoo Group | Blog Spot

Message Removed

4-Feb-10 11:06

sweety1988

4-Feb-10 11:06

Message Removed

Re: Interview questions for web develoepr

Graham Breach4-Feb-10 11:26

Graham Breach

4-Feb-10 11:26

Have you considered telling the truth?

Cross post

Not Active4-Feb-10 11:27

Not Active

4-Feb-10 11:27

You've already failed the interview because you can't follow directions.

Don't cross post Mad | :mad:

I know the language. I've read a book. - _Madmatt

Web - User Control and Serach Engines

tronix014-Feb-10 6:40

tronix01

4-Feb-10 6:40

hello @ all

i've created a small website for our company with asp.net 2.0.

now i've started to make the website multilingual.
i know there a lot of good and easy solutions to get a website multilingual by using localization.
but...
my boss wants to write the website content by itselfs, so i needed to found a other solution and i found one.

for example, i use a usally aspx website and two ascx usercontrols (they are contains the english and french content).

i added to the aspx-website a contentplaceholder and two buttons (EN and FR).
if one of these buttons becomes clicked, the click-event loads the related ascx-usercontrol to the contentplaceholder at the aspx website.

the website loads by default the english-content.

now the poblem,
if someone search some content from our website by google or bing etc., they only matches the english content. the french content will be never matched by the search engines.
does anyone now why ?
what can i do to solve this problem ?

thanks a lot
tronix

Re: Web - User Control and Serach Engines

Not Active4-Feb-10 19:59

Not Active

4-Feb-10 19:59

Since the English site is the default that is what the search engines will pick up. Search engines don't go around your website clicking buttons to get to content, they follow links.

Localization is done by using resource files, not by creating seperate controls for each language. http://quickstarts.asp.net/QuickStartv20/aspnet/doc/localization/localization.aspx[^]

I know the language. I've read a book. - _Madmatt

Re: Web - User Control and Serach Engines

tronix014-Feb-10 21:03

tronix01

4-Feb-10 21:03

thanks for your reply.

i know localization but in this case i was constrained to find a other way to the developed a multilingual website.

i will see what can i do,
thanks for your help

Re: Web - User Control and Serach Engines

Not Active4-Feb-10 21:16

Not Active

4-Feb-10 21:16

tronix01 wrote:
i know localization

If you know localization then you should realize creating multiple controls/pages is not the answer to allowing one to update content and localize it.

I know the language. I've read a book. - _Madmatt

filtering search result

hi_everybody4-Feb-10 0:01

hi_everybody

4-Feb-10 0:01

hi ,
i am using gridview for displaying search result.
after getting the result i want to filter the result by selecting the value from dropdown list which is at the top of gridview.and one more thing when i am selecting any value from dropdownlist the search result should get changed according to selection without going back to the code behind...

how can do that?

Re: filtering search result

Dinesh Mani4-Feb-10 1:36

Dinesh Mani

4-Feb-10 1:36

Doing this on the client browser would mean using javascript to show and hide the grid rows which is not very easy. Since you are using gridview you cannot get a row id on the client script for each row.

I would suggest you use AJAX to accomplish this. Put the grid inside an update panel and place a dropdown in the header and do the filtering from the serverside using AJAX. I'm not an AJAX expert so you have to dig up the details.

Re: filtering search result

4anusha44-Feb-10 1:41

4anusha4

4-Feb-10 1:41

Find out the dropdown in the header row of the grid view and filter the dataview based on the selected value of the dropdown

storing and retrieving colors from database

sreeraj.a.173-Feb-10 22:30

sreeraj.a.17

3-Feb-10 22:30

I have a doubt.
i have 10 check boxes.i want to check first three check boxes and applying color to the selected check boxes.

how can i apply color to the selected check boxes ?how to store and retrieve the check box value and color to the database?

Pls help me....

Re: storing and retrieving colors from database

sashidhar3-Feb-10 22:46

sashidhar

3-Feb-10 22:46

Take the color in the form of string format and change it into color format..!

You mean to say caonverting text to color i think
if yes follow the below code

System.Drawing.ColorConverter colConvert = new ColorConverter();
lblSample.BackColor = (System.Drawing.Color)colConvert.ConvertFromString("Your Color");

If No
please eloborate..!

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Re: storing and retrieving colors from database

Dinesh Mani4-Feb-10 1:25

Dinesh Mani

4-Feb-10 1:25

I'm not sure if I understand the question right, but based on what I understand, you wish to set the back color for checkboxes that are checked to say "Blue" and the unchecked check boxes are to be left as is. You also wish to persist the details on which check boxes are checked and which are not and if and when needed want to recreate the checkboxes with the same status. Am I correct?

If yes, then
1. To set the color of checkboxes - set the back color of the check box oncheckedchange event. Wire-up all the checkboxes to the same event and use the event source to identify the checkbox
2. To persist the state - there are many way how you can save the state, if the no of checkboxes is a constant and less than 5 you can have individual binary columns in db and save the status directly. If otherwise, I prefer form a Binary string of 1s and 0s representing the state of the checkboxes and then convert it to integer and would store it in the DB. When it is time to re-create the checkboxes, retrieve the int value, convert it to binary and use it to set the status. Remember to persist the number of checkboxes along with the status integer. This is just my way and there may be many different and efficient ways to do the same.

HTH!

data is not saving in (inbuilt)database(WIndows Application)(Dotnet)

kalyansantosh3-Feb-10 18:45

kalyansantosh

3-Feb-10 18:45

i developed a Windows apllication (Payroll). Intially i created External database.But i have to install in systems. Now im creating in built database already queries are executed. After closing the closing the application the data is not saving
Wt is the problem.
i tried so many times.
Please help me out in this situation
Thanks in Advance,
KS
This is the code
con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
cmd = new SqlCommand("insert into TDept values('" + TXT_TDName.Text + "')", con);
//cmd.CommandText = q;
//cmd.CommandType = CommandType.Text;
//cmd.Parameters.AddWithValue("@TDName", TXT_TDName.Text);
con.Open();
int r = (int)cmd.ExecuteNonQuery();

Re: data is not saving in (inbuilt)database(WIndows Application)(Dotnet)

Abhijit Jana3-Feb-10 19:50

Abhijit Jana

3-Feb-10 19:50

kalyansantosh wrote:
i developed a Windows apllication (Payroll)

This is ASP.NET Forum. Smile | :)

kalyansantosh wrote:
After closing the closing the application the data is not saving

I didn't get your point. Frown | :(

kalyansantosh wrote:
con = new SqlConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["con"].ToString();
cmd = new SqlCommand("insert into TDept values('" + TXT_TDName.Text + "')", con);
//cmd.CommandText = q;
//cmd.CommandType = CommandType.Text;
//cmd.Parameters.AddWithValue("@TDName", TXT_TDName.Text);
con.Open();
int r = (int)cmd.ExecuteNonQuery();
Quote Selected Text

Did you tried to debug your code by putting breakpoint ? What is vlaue of cmd after execution of that line ?

cmd = new SqlCommand("insert into TDept values('" + TXT_TDName.Text + "')", con);

Why you are opening Connection after initilizing the Cmd ?

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

See Trace.axd for all asp.net pages

Majid khosravi3-Feb-10 5:28

Majid khosravi

3-Feb-10 5:28

Is it anybody know why I can only see just trace for some of my asp.net pages in trace.axd?

Re: See Trace.axd for all asp.net pages

m@dhu3-Feb-10 18:22

m@dhu

3-Feb-10 18:22

Trace of the accessed(opened) .net pages of an application only will be found in trace.axd

Download multiple Xml file

<<Tash18>>3-Feb-10 2:13

<<Tash18>>

3-Feb-10 2:13

Hi guyzz.. Im developing a web application here i get datas from the user and on a button click these datas get stored in my data base now i have another button on clicking it,it retrieves all the data from the database and gets saved in my system as an XML file... the code is as follows for the button that creates an xml file...

private void Button1_Click(object sender, System.EventArgs e)
		{
			SqlDataAdapter da = null;
			try
			{
				con = new SqlConnection();
				con.ConnectionString = ConfigurationSettings.AppSettings["DSN"];
				da = new SqlDataAdapter("select * from card_details",con);
				DataSet ds = new DataSet();
				da.Fill(ds,"card_details");
				ds.WriteXml("D:\ADIB\OutputXML.xml");
			}
			catch(SqlException ex)
			{
				throw new System.Exception ("Error -- " +ex.Message);
			}
			catch(Exception exp)
			{
				throw new System.Exception ("Error -- " +exp.Message);
			}
			finally
			{
				con.Close();
				da.Dispose();
			}
		}

Now my issue is i need my application to create the xml file,before saving it into my system it should ask me whether to open the file or save the file so that i can specify the file name (something similar to a download window in our web browser)... please advice me...
Thanx in advance..
Regards,
Tash

Re: Download multiple Xml file

Not Active3-Feb-10 2:22

Not Active

3-Feb-10 2:22