window.screen.width
Friday, September 27, 2013
Thursday, September 19, 2013
Telerik: Why the $find Method is Not Working for RadGrid
The reason the $find method is not working for you is because the RadGrid loads on late binding. You need to get the RadGrid client object in the pageLoad() function like in the code below. After you get it you can set the global variables in the your Javascript so the other function will have access to the RadGrid object.
<telerik:RadCodeBlock ID="RadCodeBlock2" runat="server"> <script type="text/javascript"> var radGrid = null; var masterTableView = null; var rgDataItems = null; function pageLoad() { radGrid = $find("<%= RadGrid1.ClientID %>"); masterTableView = grid.get_masterTableView(); rgDataItems = masterTable.get_dataItems(); } </script> </telerik:RadCodeBlock>
Tuesday, September 17, 2013
ASP.NET: Simulate a Button Click in Code Behind
In this blog, I will go over how you can simulate a button click postback. By using the RaisePostBackEvent() method. Many of you probably want to do this because you wanted to refresh your GridView by faking a postback. As you will see the two methods presented on this blog does not perform an actual postback, even though it behaves like it does.
Mark Up
Code Behind
After you run the code you will find out that both ways of doing this does not cause a post back event.
Mark Up
<form id="form1" runat="server"> <div> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /> </div> </form>
Code Behind
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; namespace WebApplication2 { public partial class _Default : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { this.RaiseEvent(this, new EventArgs()); if (!Page.IsPostBack) { this.Button1_Click(this, new EventArgs()); } } protected void RaiseEvent(object sender, EventArgs e) { this.RaisePostBackEvent(Button1, " "); } protected void Button1_Click(object sender, EventArgs e) { Response.Write("You've clicked " + Button1.Text + " "); if (Page.IsPostBack) { Response.Write("this is a post back"); } else if (!Page.IsPostBack) { Response.Write("this is not a post back"); Response.Write("<br/>"); } } } }
After you run the code you will find out that both ways of doing this does not cause a post back event.
JQuery: Infinite Loop Button Click
<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" EnableEventValidation="false" Inherits="WebApplication2._Default" %> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server"> <title></title> <script src="Scripts/jquery-1.7.1.min.js"></script> </head> <script type="text/javascript"> $(document).ready(function () { $("#Button1").click(); }); </script> <body> <form id="form1" runat="server"> <div> <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="Button" /> </div> </form> </body> </html>
Friday, September 13, 2013
SQL Server : Database Reference For ADO.NET
Microsoft has some great references on ADO.NET, however finding everything you need quickly is another story. This a quick reference of when you need to find information quickly when working with ADO.NET.
ADO.NET Data Mappings:
Oracle Data Type Mappings: http://msdn.microsoft.com/en-us/library/cc716726.aspx
SQL Server Data Type Mappings : http://msdn.microsoft.com/en-us/library/cc716729.aspx
OLE DB Data Type Mappings : https://msdn.microsoft.com/en-us/library/cc668759(v=vs.110).aspx
ODBC Data Type Mappings: https://msdn.microsoft.com/en-us/library/cc668763(v=vs.110).aspx
LINQ References:
LINQ To SQL : https://msdn.microsoft.com/en-us/library/bb386934%28v=vs.110%29.aspx
LINQ To Entity: https://msdn.microsoft.com/en-us/library/vstudio/bb386964(v=vs.100).aspx
LINQ To XML: https://msdn.microsoft.com/en-us/library/system.xml.linq.aspx
LINQ To Objects: https://msdn.microsoft.com/en-us/library/bb397919.aspx
ADO.NET Data Mappings:
Oracle Data Type Mappings: http://msdn.microsoft.com/en-us/library/cc716726.aspx
SQL Server Data Type Mappings : http://msdn.microsoft.com/en-us/library/cc716729.aspx
OLE DB Data Type Mappings : https://msdn.microsoft.com/en-us/library/cc668759(v=vs.110).aspx
ODBC Data Type Mappings: https://msdn.microsoft.com/en-us/library/cc668763(v=vs.110).aspx
LINQ References:
LINQ To SQL : https://msdn.microsoft.com/en-us/library/bb386934%28v=vs.110%29.aspx
LINQ To Entity: https://msdn.microsoft.com/en-us/library/vstudio/bb386964(v=vs.100).aspx
LINQ To XML: https://msdn.microsoft.com/en-us/library/system.xml.linq.aspx
LINQ To Objects: https://msdn.microsoft.com/en-us/library/bb397919.aspx
Thursday, September 5, 2013
C# Querying From An Oracle Database
In this blog we will go over how to query an Oracle database in ASP.NET using the System.Data.OracleClient data provider in C#.
Namespaces:
using System.Web.Configuration;
using System.Data.OracleClient;
using System.Data;
Namespaces:
using System.Web.Configuration;
using System.Data.OracleClient;
using System.Data;
string cs = WebConfigurationManager.ConnectionStrings["SomeConnectionString"].ConnectionString; using (OracleConnection oc = new OracleConnection(cs)) { oc.Open(); DataTable dt = new DataTable(); OracleCommand ocmd = new OracleCommand("SELECT * FROM SOMETABLE", oc); OracleDataAdapter oda = new OracleDataAdapter(ocmd); oda.Fill(dt); GridView1.DataSource = dt; GridView1.DataBind(); }Previous: Oracle Date Format And Compare
Wednesday, September 4, 2013
Oracle Date Format And Compare
Oracle dates have a different format than SQL Server dates. So to select a date for the Oracle database you have to have the date in the following format.
Next: C# Querying From An Oracle Database
string myDate = "10/9/2012 2:55:25 PM"; string sql = "SELET * FROM SomeTable WHERE SomeDateField=" + "to_date('" + myDate + "','" + "MM/DD/YYYY HH:MI:SS " + myDate.Substring(myDate.Length - 2) + "');";
Next: C# Querying From An Oracle Database