I have created a view called business this runs sucessfully ,but the problem is how will i use dynamic values in place of 12.925432,77.5940171 ,I want to pass parameter in sql query from c# code behind.
create view [dbo].[business] as
SELECT Id,
Name1,
ZipCode,
StreetName,
StreetNumber,
[Code]...
I am doing loan sysytem where you first select the amount you want to borrow and click apply. the problem im getting is i cant seem to be able to redirect the amount selected to my second view where the client fill up the form.
View 1 RepliesI have 2 views(2 view pages) in first view page I will display some names in this page i will have add button after clicking on add button it will redirect to another page (2nd view page) in this i will display multi selected list or listview then i will select multiple items from multi selected list now this selected items has to bind with first view names and display updated list in 1st page?
My question is this selected items in 2nd view page has to bind with 1st view page and display how to do this using mvc razor for mobile application?Â
I have a Datalist Which is Bind with Database..Datalist Displays Image And their Image Name.. Now i Want Details of Selected Image from Database in Next View (View 2).
Also Want to know which control should i use for click event on Image??ImageButton or <a Href="">?My Code is --
<asp:MultiView ID="MultiView1" runat="server" ActiveViewIndex="0" >
<asp:View ID="View1" runat="server">
<asp:DataList ID="DataList1" runat="server" CellPadding="2" CellSpacing="2"
Font-Bold="False" Font-Italic="False" Font-Overline="False"
Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center"
[CODE]
I have an SQL Function with the following SQL within:
SELECT StockID FROM (SELECT DISTINCT StockID,
ROW_NUMBER() OVER(ORDER BY DateAdded DESC) AS RowNum
FROM Stock
WHERE CategoryCode LIKE @CategoryID) AS Info
WHERE RowNum BETWEEN @startRowIndex AND (@startRowIndex + @maximumRows) - 1
I have a Parameter @CategoryID - however I need to take in a category ID such as "BA" and translated this to a list of Category IDs such as "IE","EG" etc so my WHERE clause looks like:
WHERE (CategoryCode LIKE 'IE' OR CategoryCode LIKE 'EG') AS Info
I have a Lookup Table which contains the "BA" code and then all the real category codes this means such as "IE" and "EG".How do I have the CategoryID expand to multiple "OR" statements in my SQL Function?
At the moment the query as shown can cope with one CategoryID such as "IE", this is done as I want a category page such as category.aspx where a parameter "BA" is passed such as category.aspx?category=BA and this page will list all items with the category codes "EG" and "IE".
The reason I need this is there is a "parent" category code which has multiple "children" category codes which are different to the parent code. I am using ASP.NET and .NET 3.5 on the front-end if this helps.
In my application I have 7 listboxes.Each list box has morethan 100 listitems.
the best way to pass the selected listitem values(including text values also) to stored procedure in sql server 2005.
Let's say there is a textbox and a dropdownlist in mainview page, these two values are used by three partial views as well. when I use Html.RenderAction to post action to those three partial views, how to pass these two values to those partial views and in those views how to get these two values as a part of a object to send to database.
View 10 RepliesI would like to add a partial view to my view page
The view page contain a mode name "<IEnumerable<JvTake1.Models.VortN>>
And the partial view contain a model name "<IEnumerable<JvTake1.Models.VideoL>>"
So, theoretically I think they were suppose to work together but no Can any one guide me how to make it happen?
I have a view that is not strongly typed. However I have in this view a partial view that is strongly typed.How do I do I pass the model to this strongly typed view?I tried something like
public ActionResult Test()
{
MyData = new Data();
MyData.One = 1;
return View("Test",MyData)
}
In my TestView
<% Html.RenderPartial("PartialView",Model); %>
This give me a stackoverflow exception. So I am not sure how to pass it on. Of course I don't want to make the test view strongly typed if possible as what happens if I had like 10 strongly typed partial views in that view I would need like some sort of wrapper.
[Code]....
pass values to sproc from sproc?
I have a partial view that is rendered on a view. That partial view has textboxes in it. The user can enter values into them.
I need to put all the values from the textboxes in my partial view into an array, and then give the view (the parent page rendering that partial view) access to that array.
In my page there is a Login form. It looks like
[Code]....
But at the same time in this page I need to render some info from another ViewModel. Is it possible to write in action something like
return View(Model1, Model2); ?And how could I get access to these ViewModels in this case?
I want to create a view that draws from mutiple sources of data and creates a 'summary' view.This would include:An author (data source A) A list of the authors latest writings (data source B) A list of topics the author writes about (data source A)I notice I cannot pass into ...return View(author, articles, topics) from the controller.It seems you have to pick one.I want to construct my View from multiple partial views for each type.Not sure I am trying to do this the correct way.
View 6 RepliesSuppose i have a Product and Category Model, In add new product page i want to list all categories in a listbox. For this purpose i require to have Product and Category model available to Add New Product Page View.
View 4 Repliesi have one scenario in which i have to pass values from one page to another for that currently i am using querystring but now the values are more so i want to remove querystring and i dont want to user session as well and so i have tried using Hiddenfields but after redirecting to another page the values are cleared from all the hidden fields.
View 14 RepliesHow to pass values between ASCX ?/
View 1 RepliesI would like to discuse with u, now i have one problem, ie, how could i pass value from the code behind to the web service, in that ,i have to pass 3 values,1, context key2, prefix text3, dropdown selected text or value, ( Contains Designation Details)how could i pass this 3rd value
View 1 RepliesWhy can I not call the global variables CatCode and CompanyName which are equated in the first procedure GetCompanyCatID And use their new values in the second procedure UpdateCompanyCounts as parameter values. When I hard code them code their values at the end of the GetCompany CatID procedure the following procedure updates properly.
string CatCode; - delcared global
string CompanyName; - delcared global
protected void GetCompanyCatID()
{
LinkID2 = Request.QueryString["linkid"].ToString();
string L_ID = LinkID2;
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString001"].ConnectionString);
SqlCommand cmd = new SqlCommand("GetCID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@L_ID", L_ID);
try
{
con.Open();
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
if (reader["CG_ID"] != System.DBNull.Value)
CatCode = (string)reader["CG_ID"];
CompanyName = (string)reader["CG_Name"];
}
}
}
catch (SqlException exc)
{ }
finally
{ con.Close(); }
// ******* HARD CODED to test below update procedure, it works. When commented out the following update procedure does not update.
CatCode = "55555"
CompanyName = "Test";
UpdateCompanyCounts();
}
protected void UpdateCompanyCounts()
{
LinkID2 = Request.QueryString["linkid"].ToString();
string L_ID = LinkID2;
string CatCode2 = CatCode;
string CompanyName2 = CompanyName;
// string CatCode2 = "23456";
// string CompanyName2 = "TEST";
SqlConnection con2 = new SqlConnection(ConfigurationManager.ConnectionStrings["ConnectionString001"].ConnectionString);
SqlCommand cmd2 = new SqlCommand("UpdateCatCounter", con2);
cmd2.CommandType = CommandType.StoredProcedure;
cmd2.Parameters.AddWithValue("@L_ID", LinkID2);
cmd2.Parameters.AddWithValue("@CG_ID", CatCode2 );
cmd2.Parameters.AddWithValue("@CG_Name", CompanyName2 );
try
{
con2.Open();
cmd2.ExecuteNonQuery();
}
catch (SqlException exc)
{
// ErrorBox.Text += string.Format("Error: {0}<br/>", exc.Message);
}
finally
{
con2.Close();
}
}
i am trying here is to pass values to other pages. When i include the following code
private void Button1_Click(object sender, System.EventArgs e)
{
Response.Redirect("WebForm5.aspx?Name="+txtName.Text);
[code]...
i have a view /categoria/index
[Code]....
i am trying to call the action from /imovel/index
with an id
but the thing is that i am getting null
[Code]....
I´have this situation: I have a Master Page for all my pages.
Inside it I have a Partial Page that render the Main Menu of my site.
My question is how to pass a data from a Controller (For example AboutController) to the Menu so it can "knows" that in the "about" li, render an aditional class in it..
Normally is: <li>About</li>
But the About page: <li class="on">About</li>
I think that controllers must send this aprameter.. or not? how?
I have the following action executed when a user selects an item from the dropdown;
[Code]....
The object paymentApplicationRefund is populated. I want to get the contents of this object to put in a Html.Textbox(). How do I proceed??
Basically I want to display a popup box only at a specific time in asp.net application. so i'm using the following
[code]....
but this code is not working. the alert box is not popping up. is this a correct method to pass values to the script?. or what else to be done to meet the requirement?.
I guarantee the title of my thread does not explain what I am looking for, but I just can't think of a better way to word it. What I have right now is an application that the user can add, search, and update various orders in the System. I've been working on the front end page, and wanted to display a summary of all orders performed this month. Right now the Orders are represented as labels (based on data pulled from the database). What i'd like to do is replace these labels with hyperlinks. I was hoping that by doing that I could somehow write some code so that when an order is clicked that the user is taken directly to the search page and that order is displayed.
View 6 RepliesNow that i learned how to pass values to an SWF object via flashvars, how can i pass values from a querystring to javascript?
What do i mean? In the following example i hard-code the xml file to load in the SWF object.
<script type="text/javascript">
var so = new SWFObject("preview.swf", "", "100%", "100%", "9", "#ffffff");
so.addParam("allowFullScreen", "true");
so.addParam("scale", "noscale");
so.addParam("menu", "false");
so.addVariable("xmlPath", "xml/exampleData.xml");
so.write("flashcontent");
</script>
Since the Xml file is created dynamic, the xml should be loaded from the value of a query-string. (I guess).
Supposing my url is http://www.example.com/load.aspx?XmlFile=SomeData
How can i pass it to the javascript side? Like..
so.addVariable("xmlPath", "xml/<% SomeData %>.xml");
or whatever it needs to make it work.
UPDATE: Besides the above example, is there any way of creating the JavaScript, in server-side?