SQL Server :: Trying To Build Dynamic Statement But Doesnt Work When Put Together?
Jan 3, 2011
If i split the statements up they work fine individually.But what im trying to accomplish is to pass in the column name that i want to select from my table.. ill pass it from the page as well as 1 other parameter.
I was looking and found some queries that will return the column name from the table but figured this may work.when i execute this,it returns the actual value in my SET @column line.so in the below code if i run it, it will just return the value "VideoLevel"
BUT if i change it to the example below that,it works..
i'm trying to select/unselect aspxtreelist nodes that meet the criteria.when user click a row and it fires an event which handled by server side eventhandler.When i debug the code everthing ok.selection works but on the browser side selection remains same as before eventrised.
Last year we created an application that creates folders for the records on our network drive. Everything worked til the new year.. then we had to update the code to create a new parent folder for the year, since then every other month it seems that the month folder gets created, but the individual folders under that month do not.
After a long process of configuring IIS inhttp://forums.asp.net/t/1622627.aspx ...In iis project the jquery doesnt work ...but when i run the same in vs2010...it works
In my local enviroment it just works. Iam no IIS Admin so ....
i try the following
My domain "http://mysite.com/" goes to my url provided by my hosting service (discountasp.net)
I want that this url goes to the root/mysite/ virtual directory but i want that the url stays on "http://mysite.com/". So i defined the following rule, but it doesnt work for me.
here is my web.config that is placed in the root directory (generated by the IIS7 Remote Administration UI)
I am very new to WCF, I have read a lot and seen several presentations about it. I can get the basicHttp endpoint to work on my server but when i wanted to use https, I found that that endpoint binding doesnt work. I think through my research that the wsHttp binding is what i need. I can get the client to work but the service gives me a few different errors when I try to call the ssl endpoint.
Currently i get the following error:
The requested service, 'https://devwcftestsite.crata.ucf.edu/services/Person.svc/Person' could not be activated. See the server's diagnostic trace logs for more information.
Below I have included the web.config for my service project which is hosted at:https://devwcftestsite.crata.ucf.edu/services the service is called:Person.svc
I got a view that uses the ajax.beginform tag.This works great but if I want to do some validation to the data and then return a error message to the page it doesnt work for me.Here my code :
I create a dynamic dropdownlist to select several values, in developer server it's everything ok but in production server, when the postback happens lost the selected value.
i followed this tut http://www.ajaxprojects.com/ajax/tutorialdetails.php?itemid=554 for cascading drop downs, but i changed the sql connections for my linq datasource. VS2010 is showing no errors in my code and the page loads fine too, but the two drop down lists are emptycan anyone scan there eyes over it and see if theres any reason why it shouldnt be working?my code is the same as the tuts apart from it uses LINQ instead of SQL
I'm trying to do something that on the face of it is very simple.
If I have 5 text boxes, and 1 of them is blank, I want to exclude that textbox from the query, rather than searching for where a field is blank.
I've tried to do a bit of research into dynamic linq queries, but have come up empty handed, or what I've found doesn't seem to quite answer my question.
I have a server control which consists of a gridview with custom navigation&information capabilities and with javascript functions to highlight the selected grid items or highlight when mouse over event occurs.. (full tested outside asp:wizard)I'm trying to use that server control inside a template wizard step, when I drop such server control in the first step of the wizard everything goes ok.
When I insert even a blank step previous to the step which contains the server control, the javasript code of the server control is not rendered at all, the page doesn't fail during load but until I go with mouse over an item of the grid for instance.When I check the rendered HTML I can see no HTML, nor javascript events of this server control where rendered, neither the implementation nor calls to javascript, but even rarer what is there visible in the grid for ie, even the other components of the server control, are not in the "view source code" content. I seems it was sent to the client, even showed, but truncated in some phase..
For comparison: something like the shirt builder application at [URL] Say, if I have fabric image and want to generate base, collar, cuff etc. How should I do it on server side in .NET, and generate different components of shirt.
I'm trying to use a server control inside a template wizard step, when I drop such server control in the first step of the wizard everything goes ok. When I insert even a blank step previous to the step which contains the server control, the javasript code of the server control is not rendered at all, the page doesn't fail during load but until I go with mouse over an item of the grid for instance.When I check the rendered HTML I can see no HTML, nor javascript events of this server control where rendered, neither the implementation nor calls to javascript, but even rarer what is there visible in the grid for ie, even the other components of the server control, are not in the "view source code" content. I seems it was sent to the client, even showed, but truncated in some phase..The server control consists of a gridview with custom navigation&information capabilities and javascript functions to highlight the selected grid items or highlight when mouse over event occurs.. (full tested outside asp:wizard)
What is the best way for me to build a control that will kinda work like an Access table in ASP.NET?
That is, I define, say, 3 columns. The user can add/edit/remove rows. It can be one row at a time, that's fine. There are other fields on the form too, not related to this table. When the user is done adding rows of information, then they hit 'submit', and at that point, is when I grab all the data out of the control and save to a database (or xml file or whatever).
I've tried to build something with ListView and/or GridView.
Is it possible to generate dynamic LINQ statements? I need to be able to build conditional "WHERE" clauses for some of my LINQ statements. I don't want to write a giant block of code to hand every possible combination of filters, sorts and groups. I found a article online that outlines how to use string based where clauses here. Does LINQ in framework 4.0 no longer support this? Every example I've found has giant walls of virtually unreadable, must likely unmaintainable code.
