So I know how to store and retrieve data in a local database (Chrome). My function to retrieve data is
function SelectHandler(transaction, results) {
for (var i = 0; i < results.rows.length; i++) {
var row = results.rows.item(i);
[code]...
How to check browser support html5?
View 2 RepliesSuppose in .aspx page their is dropdown in which i want to bind two coloumn in that dropdown.for example :-
in database their two column of First_name ,Last_name .I want these two columns value come in a single dropdown using C#.
I am using jquery fullcalender..
I want to bind Events to each days of the calender dynamically from the json return by the ajax method..
I have a small issue binding the values into a dropdown using LINQ in ASP.NET code-behind.
var clientquer = from i in Entity.New_Bank select i;
//var q = (from s in names
// select s).Distinct();
// var getlendername = (from db in mortgageentity.New_Lender group db by db.Bank_Name into t select t.Key).ToList();
if (clientquer.Count() > 0)
{
ddlbankname.DataSource = clientquer.ToList();
ddlbankname.DataValueField = "Bank_ID2";
ddlbankname.DataTextField = "Bank_Name";
ddlbankname.DataBind();
}
It is binding with duplicate values, but I don't want bind duplicate values. I'm trying to solve this by using a group by clause, but it is not working.
I am trying to bind a record to a textbox using a Dropdown selected index change. I get the error.
Conversion failed when converting the nvarchar value 'DrFirstName DrLastName,Ph.D.' to data type int. is it because I concatenate the name and prefix of the DR into the Dropdown list like this,
Code:
SELECT ID,EmailAddress, DrName + ',' + PreFix AS DrName FROM DrNames
Here is the dropdownlist code that I want to populate the textbox with the emailaddress in the table associated with Dr name and ID.
Code:
Private Sub DropDownList1_SelectedIndexChanged(sender As Object, e As EventArgs) Handles DropDownList1.SelectedIndexChanged
Dim dt As New DataTable()
If DropDownList1.SelectedItem.Text = "OTHER,..." Then
txtRx1.Visible = True
DropDownList1.Visible = False
End If
[Code] .....
I have created an asp.net customizable gridview where user will be able to add and delete data. Now I face some proplem with this gridview. now I want to add a dropdown list (which is dynamically bind with database) inside the grid. I created code and it bind well. when the page is post back previous selected dropdown list value lose and set to selectedIndex=0; For this reason I used if(!page.Ispostback) and put the dropdown binding code inside this. Here I faced a problem. The problem is when I want to add data inside grid the dropdownlist missin bind. How can I overcome this problem? For your kind observation I given entire code below:
<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False"
CellPadding="4" ForeColor="#333333" GridLines="None"
onrowdeleting="GridView1_RowDeleting"
onrowdatabound="GridView1_RowDataBound">
<RowStyle BackColor="#EFF3FB" />
<Columns>
<asp:TemplateField HeaderText="SL">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("RowNumber") %>'></asp:Label>
</ItemTemplate>
<EditItemTemplate>
<asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("RowNumber") %>'></asp:TextBox>
</EditItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Material">
<ItemTemplate>
<asp:DropDownList ID="drpMaterial" runat="server">
</asp:DropDownList>
</ItemTemplate>
</asp:TemplateField>
<asp:TemplateField HeaderText="Quantity">
<ItemTemplate>
<asp:TextBox ID="txtQuantity" runat="server"></asp:TextBox>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server"
ControlToValidate="txtQuantity" ErrorMessage="Required Field Missing">*</asp:RequiredFieldValidator>
</ItemTemplate>
</asp:TemplateField>...............................
How to bind records in charts through jquery in asp.net
cone, pie and bar
foreach (HttpPostedFile file in FileUpload1.PostedFile) {
string filename = Path.GetFileName(file.FileName);
string foldername = DateTime.Now.ToString();
Directory.CreateDirectory("../Webimage/"+foldername);
file.SaveAs(Server.MapPath("../Webimage/" + foldername + filename));
[Code] ....
I am getting this error under foreach
foreach statement cannot operate on variables of type 'system.web.httppostedfile'
I am refering below url:
[URL]
how to select items in dropdownlist if i bind it from database.
Once i select some items and save in database , after that i want items selected when page reloads that items bind in dropdown.
I need to capture and save user signature to database on asp.net webform.
I found this plug-in: [URL]
I downloaded the example project and it is very simple, it has only fews file but I could not understand.
demo here: [URL]
How do I use this on a web-form page, let say on "save" button click postback event, it will save the imageurl of the signature under this format:
data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAApIAAAE+CAYAAAA+
vvBuAAAgAElEQVR4Xu3de6w1XV0f8K8WvIEiFTAKXhBrab0AxUraaFET0xYxSGrrpSb
UahsjbcUoXhKtIiaaSFSSojHRUP7w0rQGKbZJ00ahN.........
to a string variable so I can save this string to database?
Also how do I use 2 signature fileds in a same page, because I want to capture signature of 2 users.
this is code for taken data from database appear in bootstrap accordion panel by using jquery ajax.
<script src="Scripts/jquery.js"></script>
<script src="Scripts/jquery-ui.js"></script>
<link href="Scripts/jquery-ui.css" rel="stylesheet" />
[Code].....
i have saved a copy of jquery-1.4.2.js in my local project folder also have jquery-1.4.1-vsdoc.js
I have added comment like /// <reference path="jquery-1.4.2.js" /> in my custome javascript file
Also in another project in the same system i can uise jquery well
but in one of my project i show Microsoft javascript.... errror
what can i do? a line like $("#K").val(); gives error
I want local/Client machine ip address, for that i have written below code. but this code gives me Application server address where my web site is hosted. where as i wanted client machine IP from where my web site is getting accessed. so if my website accessed from 10 different machine in that case i want 10 different IP address of those machines.
Code:
using System.Net;
private string GetIP()
{
string strHostName = "";
strHostName = System.Net.Dns.GetHostName();
IPHostEntry ipEntry = System.Net.Dns.GetHostEntry(strHostName);
IPAddress[] addr = ipEntry.AddressList;
return addr[addr.Length - 1].ToString();
}
Also the below server variable return global ip address.
Code:
HttpContext.Current.Request.ServerVariables["REMOTE_ADDR"];
What is the correct code.
I am trying to run a report in local mode and bind it at runtime to a simple List<string>; I have searched for a sample with no success so far, so could anyone give some hints? I know that a ReportDataSource can be a type that implements IEnumerable but I cannot figure out what field name should be used in the rdlc file? Suppose I bind the datasource at runtme (something like ReportViewer1.LocalReport.DataSources(Add new ReportDataSource("dsname", new List<string> { "John Smith", "Jane Smith" }))
can I still define my report definition file at design time, and bind a text box control to something like Fields[0] or the like? And on a different note, I also defined a static method without parameters that returns a generic list of some type; Yet if a go to Report - Data Sources menu option, I cannot see the method in the list of Project Data Sources.
When i run the site in local host the site map menu headers are appearing, but on mouseover the dropdown items are not appearing.
View 4 RepliesI have a BLL where in I am getting all the values from a table. Now I want to populate a dropdown with one of the field from a BLL.
ddlstatus1.SelectedValue = dt.Rows(0).Item("StatusCode")
But the above code is not working.
I tried ddlstatus1.selectedindex = dt.Rows(0).Item("StatusCode") but it says that it cannot convert string to integer.
I have this XML file:
<questions>
<question id="title">
<option>[code]....
How do I bind each question to a specific drop-down in c#?
I'm trying to figure out if it's possible to transfer records from SQL central database (who has a public IP address) into SQL local database (who doesn't have a public IP)?
or if it's not possible can I use a centralized website instead to pass some data into the local website? (but i'm not sure if it will have some security concerns)..
I want to display the selected value from gridview in a dropdownlist.Here I am not getting the Dropdown from Database as it contains two values.After getting the data user can modify the DDL and change the selection.The data type where the values are saved is declared as Bit.
<asp:Label ID="lblQuery" CssClass="labelbold" runat="server" Text="Query"></asp:Label>
<asp:TextBox ID="txtQuery" runat="server"></asp:TextBox>
<asp:Label ID="lblStatus" CssClass="labelbold" runat="server" Text="Active Status"></asp:Label>
<asp:DropDownList ID="ddlStatus" runat="server">
<asp:ListItem>--Select--</asp:ListItem>
[code]....
Till here it works fine how do I fill the dropdown from database.Eg Active text is coming from Database,so DDL should show Active along with Inactive value.
i m having a bit of trouble here with .. i am changing the text from a dropdown inside the gridview to a cell inside that perticular row.... the code for the jquery i hav used to alter the text is :
[Code]....
the corresponding gridview is :
[Code]....
now after the text is changed into the corresponding cell ... i m trying to access it as per normal server side code as :
[Code]....
I'm trying to bind a selected user's role to a dropdown-list. The purpose of this is to be able to change said user's role.
I'm attempting this inside a formview hooked up to a linqdatasource which contains a row from the aspnet_User table.
The dropdown list is hooked up to a linqdatasource of all the roles in the aspnet_Roles table (with DataValueField="RoleID", DataTextField="RoleName").
I figured it would be possible with something like:
SelectedValue='<%# Bind("aspnet_UsersInRole[0].aspnet_Role.RoleID") %>'
But this throws a parser exception, about the bind call not being correctly formatted.
The roles are there, they show up when I remove the "SelectedValue"
I declared my template as follows
<EditItemTemplate>
<asp:DropDownList ID="ddlYear" runat="server" DataSource='<%#GetYears() %>' DataTextField="year" DataValueField="year"></asp:DropDownList>
</EditItemTemplate>
I need to bind the data from the function i used GetYears()
I need the data for example name to be loaded in dropdown when i click on Edit of gridview is it the correct way or is there any best way to do this
I have a BLL where in I am getting all the data from a table. Now I want to populate a dropdown with one of the field in this BLL.
ddlstatus1.SelectedValue = dt.Rows(0).Item("StatusCode") and this is not working.
I tried ddlstatus1.SelectedIndex = dt.Rows(0).Item("StatusCode") too but this is throwing an error that string cannot be converted to Integer.
I have production server on our intranet and we have website on remote server with its own database. Now we want to sync some tables from our local database to remote database at some interval of time. I have own idea that if data sync is fail than we should get email about that from remote database.
For above scenario I was looking some ideas from you guys and different method to do it. I know about replication of database how to do that. Can we do it by asp.net, SSIS package which will be easy.