|
In Visual Web Developer Express 08, in the Solution Explorer pane, if I expand the ASPNETDB and click Procedures, it contains a stored procedure that the above error claims it cannot find. ... Could you kindly suggest which commands I'd need to use in aspnet_regsql.exe?
|
|
|
|
|
In case only this particular stored procedure is missing then you can use this one...
CREATE PROCEDURE [dbo].[aspnet_CheckSchemaVersion]
@Feature nvarchar(128),
@CompatibleSchemaVersion nvarchar(128)
AS
BEGIN
IF (EXISTS( SELECT *
FROM dbo.aspnet_SchemaVersions
WHERE Feature = LOWER( @Feature ) AND
CompatibleSchemaVersion = @CompatibleSchemaVersion ))
RETURN 0
RETURN 1
END
|
|
|
|
|
If you want to do this using apnet_regsql.exe, use the following steps:
1. Open visual studio command prompt
2. type aspnet_regsql and press enter
3. Click next on the window just appeared
4. select "configure sql server for application services", click on next
5. enter server name, username & password
6. choose databse from drop down
7. click on NEXT & NEXT
This will repair your database.
|
|
|
|
|
Thank you for your help and the code. It appears that there is no Command Prompt in Visual Web Developer Express 08. Can I just use the MS-DOS Command Prompt?
|
|
|
|
|
|
Thank you for your help arun$aini 
|
|
|
|
|
My Pleasure
Hope you have solved the issue.
|
|
|
|
|
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! 
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
|
Have you considered telling the truth?
|
|
|
|
|
You've already failed the interview because you can't follow directions.
Don't cross post 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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?
|
|
|
|
|
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.
|
|
|
|
|
Find out the dropdown in the header row of the grid view and filter the dataview based on the selected value of the dropdown
|
|
|
|
|
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....
|
|
|
|
|
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.
|
|
|
|
|
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!
|
|
|
|
|
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();
|
|
|
|
|
kalyansantosh wrote: i developed a Windows apllication (Payroll)
This is ASP.NET Forum.
kalyansantosh wrote: After closing the closing the application the data is not saving
I didn't get your point. 
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.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
