Comments by Dolly Nimavat (Top 55 by date)

To use sp_executesql, you gave me a link, in that solution it says to add database reference in solution explorer. When I right click in my solution explorer reference folder, there is no option like - add database reference. Only add reference and add service reference is there. But, with exec, the stored procedure works fine. The error is in the IF statement. Let me try to use stored procedure without if statement.

Thanks for your reply. You are right but in my VS2013, using sp_executesql gives error -
'the procedure has unresolved reference to the object [dbo].[sp_executesql]'

Is it because i am not working on database project? If so, then what is the alternative?

In my VS when I right click to reference folder, there is no - Add database reference - option.

But i can't understand why there is problem with if statement?

Thank you very much. I solved it. I spend my whole day in this one statement. Thank you.

Yes. I am using VS2013 and sqlserver 2012

I am not using database project.So now what can I do instead of using if statement?

I tried it. Still the same error.

Writing the statement - EXEC sp_executesql @sql - gives the error - 'the procedure has an unresolved reference to object [dbo].[sp_executesql]'

I have already gone through this link. I don't find anything helpful to my problem because I am not adding script as add new item to the project. I am creaing stored procedure in server explorer.

I also found the answer that change build action property of the stored procedure. But in properties window there is no such property exists.

I did it. Still the same error.

I tried to create a procedure as per your suggestion. But in if statement there is error - This statement is not recognized in this context.

Thank you for your reply. You are right that database management will be difficult. But the dedicated database server we are going to use for this.
1. Here you have written - authorization [dbo] - does it mean that new schema will be created under the schema [dbo]?
2. IF EXISTS(SELECT * FROM sys.objects WHERE name = 'BuildCustomerSchema' AND [schema_id] = SCHEMA_ID('dbo')) in this line what does - [schema_id] = SCHEMA_ID('dbo') - it mean? I can't understand because I have used stored procedure only for tables.

Yes, I update the question

There is one table in which i will store details of each user. But under each user there are various tables as per user's requirements. Like for automobiles' business and for restaurant there will be different products and all other things. So, I want to diffrentiate tables under each schema. This is multitenant application.

I solved my problem by installing sqlserver 2012. In vs2013 some components of sql server were not installed.

I remove the update panel and changed following line in code behind. TabContainer1.ActiveTab = TabContainer1.Tabs[TabContainer1.ActiveTabIndex+1];

On google I found the answer that says to do appropriate settings in sql server configuration manager. But i didn't find the Microsoft SQL server 2012 option in my start menu. Does it mean that sql server is not installed in my PC?

Will it be installation problem? I have installed VS 2013. So all sql server commponents are those installed automatically in this setup. There was no error in installation.

I have updated the question. Hope it will help you to understand better.

I don't know the server name. So I add new database using add connection instead of using 'create new sql server database'. In 'ADD CONNECTOIN' server name is not asked. As I add new databse instead of existing one, I can't test connection.

Thanks. I solved my problem. Still I'll check this example for more knowledge.

I have copied connection string from properties panel.

I have done this. I have copied connection string from properties panel.

I tried it. Now it is not refreshing the page and not navigating to the next tab. Remains as it is.

Thanks.

My problem solved. It was due to fewer space on hard disk than required.Thak you for your attention.

Will it solve my problem by installing sqlserver 2012 saperately?

I have tried repair. It says that - 'The timestamp signature and/or certificate could not be verified or is malformed'

But I don't know how to do that using jquery and web service? Can you please help me?

The problem is how to redirect to the another view with the data? Or I should first redirect to another view and then from there Retrieve the data?

I have updated my code as per your suggestions. Still the same error is there.

Can you please me why it shows the location of the error in jquery file?

Still the same error is there.

My problem solved. It was onther error. But alert(location.pathname) returns only '/'. So I don't require to prepend '/' before home

in mvc "Home/Allcities" means - localhost:1040/Home/AllCities
where Home is controller(Class inherited from Controller class) and Allcities is the method of home controller.

I am using MVC structure. AllCities is the web method written in HomeController

I solved this error by writing this code -
<% Html.DropDownList("CityName");
Now there is no error and no otput. Any html helpers are not displayed in the browser.

How does db.cities fetches data from database? I have used stored procedure to fetch the data and it returns datatable.
Following is the code I am selecting data from that datatable :
public ActionResult Index()
{
DbConnect objdb = new DbConnect();//connection to database
DataTable dt= objdb.ExecuteDataset("usp_allCities"); // call to the function that calls the stored procedure


List<SelectListItem> cityList=new List<SelectListItem>();

var mylist = new SelectList(dt.);
for (int i = 0; i < dt.Rows.Count; i++)
{
cityList.Add(new SelectListItem { Text = dt.Rows[i]["CityName"].ToString(), Value = dt.Rows[i]["CityId"].ToString() });
}

ViewData["CityName"] = (IEnumerable<SelectListItem>)cityList;
return View(ViewData);
}

<%Html.DropDownListFor("ddlCity",new SelectList(ViewData["City"].ToString(),"CityId","CityName"));%>

still same error

It works. but now helpers are not displayed in the browser

Thanks. I have solved my problem using this solution.

If you don't know the answer then don't improve the qustion