Not Showing Sql Server Name?
Jan 14, 2011i just want know about my sql server name not showing..
View 11 Repliesi just want know about my sql server name not showing..
View 11 RepliesI'm not sure if I can do this, but I've been trying my hardest.
I have a company that catagorizes people under Membership 1 and Membership 2.
It is possible for a person to have 0, 1, or 2 of these memberships.
I have a select statement, that I'm building in a view, that shows if a person has no membership, Membership 1, or Membership 2 along with their name, user id, and company. However, if the person has both Membership 1 and Membership 2 it is showing up as two records.
Can I have it show all of this information in one record per user?
I have implemented this in my website as per my requirement. [URL] It is working fine in local. But i moved that code to dev server today... it is showing all the drives of dev server. (But my fuctionality is it should show all the drives of local computer who is accessing this ste).
View 1 Repliesthis is an issue regarfding the SQL Severe Integration Services
I have installed the Business Intelligence Studio through SQLEXPR_TOOLKIT.EXE
but the problem is when i am trying to create the SSIS Project it is not showing the SSIS Project Templates in BID .
I have try to change the location of Templates in Tools --> Option --> project & Solution but the still the problem is same
I want to show xml which is load from sql server with the following code but I dont know for showing that in web which control is suitable?the code is as follow:
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["WebApplication1.Properties.Settings.mycon"].ConnectionString))
{
con.Open();
SqlCommand cmd = new SqlCommand("select * from ajaxmovie FOR XML AUTO ", con);
XmlReader xr = cmd.ExecuteXmlReader();
xr.Read();
string data;
do{
data=xr.ReadOuterXml();
}
while(!string.IsNullOrEmpty(data));
I was creating my new webforms application and testing it. Now I added a new textbox to the form and when pressing F5 to test, it doesn't show. None of the changes show when I try to test it.
View 1 RepliesMy asp.net application running properly in single machine and even server itself . But when i installed the microsoft vss on server and cline machine and added the application in server vss itself. But that time it self it showing dll error . I am using Windows Xp Os. My vss is microsoft vss 2005
View 1 RepliesALL the server controls are not showing in Visual Studio ASP.net project. It used to be intermittent, I would restart devenv and they would show again(even if the layout was terrible) Anyhow now it's not showing at all. The only change I made to the project was to switch Membership providers to MySql. Even pages that have no reference to Membership don't display.Anything(page wise) that has a server control fails (displayes the message "hresult e_fail when creating com component") even if it's just a label with no programming logic.
View 2 RepliesI have a web server on which I deploy my asp.net project after publishing. However many times I have noticed that when any error occurs on the web server I see that the error location is showing path of my local machine on the webserver and not the path of the web server.
View 2 RepliesThe bar chart report is showing data on x and y axis (y axis has 3 fields - min, max, avg values for time frame) and x axis has task type. For some reason, the chart only shows task types on the x-axis for some apparently interval, even though I have no interval set expressly.
View 1 RepliesHow I will create the scheduling system. I have 3 tables related namely employees, schedule and shift. How will I show the data using the relation shift of the table on gridview by this: It will be filtered by datefrom and dateto: Select via calendar ex Datefrom: August 1 Dateto: August15
Then It will show:
EmployeeID Name
1 2 3 4 5 and up to 15
EP9112 Lastname, firstname, Middlename shift shift shift shift shift
with edit when I press EmployeeID their shift.
How can I also format the shift and date by: ex TimeIn: 7:00:00 AM TimeOut: 3:00:00 PM Date: 8/1/2010
When I add it, it will be TimeIn: 8/1/2010 7:00:00AM TimeOut: 8/1/2010 3:00:00 PM.
Do I need to edit my database.
I am trying to set up a POST from one aspx file to another progromatically. Inside the POST is a String of XML data which i have properly added to Server.HtmlEncode(). For some reason, when I grab it in my logs on the other page, it is showing with 3 question marks. I at first thought it was logging text i left somewhere, but have narrowed it down to a Encoding error of some sort because when i change the encoding it changes the character, and when I just put some text in there, i see it on the other side fine. i have tried UTF 8,UTF32,Unicode,ASCII... Can't seem to find the right combination. Can't find the UTF-16
when I use the Encoding object
Below is my Code:
[Code]....My Sending Debug log has the Extension xml coming out in HTML format correctly before POST. Below is just a piece of it[Code]....
And then on the other side log I get the below
Extensions =??
I defined the property as follow and in the Properties window, it just shows an empty textbox. While the CssClass property shows a list of CSS classes.
[CssClassProperty]
public
string HeaderStyleCssClass
{
get
{
return headerStyle;
{
set
{
this.headerStyle =
value;
}
}
I am downloading file from remote server in page load using content disposition. After downloading the file i am trying show some other controls in the page. But that controls are showing asp.net .
View 1 RepliesI have implemented captcha control in my webpage based on the article How to implement Captcha in ASP.Net.
It is working fine when running through the VS IDE, but when i deployed the website in IIS 8 (Windows 8.1) server the captcha image does not show.
[Code]....
i have successfully showed data using puting directpath in to a textbox(e.g, filename=TextBox1.Text;). but the code above is not working. i dont know why.
I have the following simple linq to sql statement:
[Code]....
Instead of showing me the UserName from the aspnet_Users table, it showed me the SQL select statement.
while i was using sql server authentication, it was running a quite good but suddenly it starts showing an error 'Login Failed for user sa'
Here is my error-Login failed for user 'sa'.
Description:An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Login failed for user 'sa'.
Here is my code-
<add name="MyDB" connectionString="Data Source=ERPTEST;Initial Catalog=LoginDatabase;User ID=sa;Password=sa"
providerName="System.Data.SqlClient" />
I created and populated a database inside Visual Studio 2008 instead of using Management Studio.I need to run the script to create the schema for users and roles.The database does not show up in ASP.NET SQL Server Setup Wizard or in Management StudioThe only databases that do show up are master, model, msdb, and tempdb
Is there anything I can do to fix this or would it be easier for me to just create a new database starting in Management Studio and then connect to it from within Visual Studio?
I had problems showing my .aspx files on my server after "copy website"-ftp, as the server had ASP.NET version 2.0. However, html-files worked like a charm. I got my server-dude to install ASP.NET 4.0 on server, and I can now publish an empty aspx-file only containing text without error. BUT, if I add a standard login-form from ASP.Net and copy the website, it says "Server Error in '/' Application", "Configuration Error" blablabla and "Line 8: roleManager enabled = "true"/>" is highlighted in red..And also some IIS-errors. What is IIS? I thought IIS was for people who ran websites from their computers? Is this an IIS-error? What can I do to fix this?
View 9 RepliesIn the database one number like a 91-9685748596 and, 2nd number like 9122-9685748596 and another one is 9685748596 .when we are try to formate it using substring function it all are may be9685748596,9685748596,9685748596.Mobile number is assigned as a primary key.so its showing error "Primary key violation".We can not the remove primary key also and there are 50 lack data in our database.
View 6 RepliesI have a command button on a page, that when selected will save details to a database and produce a letter in a word document. Using VS2005 and Asp.net 2.0 The problem I have is that when the button is selected, the word document opens fine, the data is saved to the database fine, but certain fields that should be populated after the button click are not.
Code:
protected void cmdGenerateLetter_Click(object sender, EventArgs e)
{
if (ValidateReviewLetter())
{
//Retrieve Application Reference
string strApplicRef = Session["ApplicationDetails"].ToString();
strApplicRef = strApplicRef.Substring(11, 9);
ddlLetterGeneratedBy.SelectedIndex = ddlLetterGeneratedBy.Items.IndexOf(ddlLetterGeneratedBy.Items.FindByText(_userProfile.FullName.ToString()));
txtGeneratedBy.Text = ddlLetterGeneratedBy.SelectedItem.Text;
cldDateGenerated.Value = UtilityFunctions.GetFormattedDate(DateTime.Now.Date.ToString());
objDeclarationLetter.Enabled = true;
Code to save data
ProduceLetter();
}
}
The values at the top of the procedure - txtGeneratedBy and cldDateGenerated are the fields not being populated event though I set values to them.
In one page I have image controls that are showing pics from the web site. This works fine but sometimes, and randomly some pics are not shown. I guess this issue could happen because Im using the IIS 5.1 in my development enviroment and it could be denying some requests. Anyway, I dont know exactly what is happening, so i request help of those who have workaround this fixture.
View 1 RepliesI have a masterpage. And i got 2 pages. Anyhow one is displaying all the contents. Other doesn't. Even though I can do everything in source It really drives me crazy not to see what i'm doing. Website is working as a charm. Everything is cool except development environment of single page.
View 1 RepliesI know browser compatability isn't fun, but this one is odd. I have the following code:
[code].....
When the user clicks on a link in any version of IE, Chrome, or Safari, the scrollbar on the right side is there, no problem. But when they do it in Firefox, the scrollbar is missing. They can hit page down to scroll through the info, but why wouldn't the scrollbar be there as well?