Pramod Raising: 2016

Tuesday, 29 November 2016

Arry Data DataTable Data Xml data insert into Database

DataTable _dt = new DataTable();
DataColumn col1 = new DataColumn("fkEmployeeid");
col1.DataType = System.Type.GetType("System.String");
_dt.Columns.Add(col1);

if (sel_list.Items.Count > 0)
{
for (int i = 1; i < sel_list.Items.Count; i++)
{
_dt.Rows.Add(sel_list.Items[i].Value);

}
}

public static string GetXMLOfDataTable(DataTable dtToProcess)
{
string strOutput = "";
try
{
dtToProcess.TableName = "Table";
StringWriter sw = new StringWriter();
dtToProcess.WriteXml(sw);
strOutput = sw.ToString();
}
catch (Exception ex)
{
}
return strOutput;
}
ED.strxmlData1 = GetXMLOfDataTable(_dt);

@xmlLanguage2 xml,

IF (@xmlLanguage2 IS NOT NULL)
begin
SELECT ISNULL(cast(Colx.query('data(fkEmployeeid)') as varchar(max)),'0') as fkEmployeeid
INTO #TMPLanguage1 FROM @xmlLanguage2.nodes('DocumentElement/Table') AS Tabx(Colx)
insert into tb_tab_OthereEmployeeInvoled(
Employeeid,
EmployeeReportId
)
select fkEmployeeid,@RID from #TMPLanguage1
end

Monday, 17 October 2016

DDL Drropdown DDLDay DDLMonth DDlYear

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="testc.aspx.cs" Inherits="testc" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script type="text/javascript">
function ValidateDate(sender, args) {
var dateString = document.getElementById("ddlday").value + "/" + document.getElementById("ddlmonth").value +
"/" + document.getElementById("ddlyear").value ;
alert(dateString)
var regex = /(((0|1)[0-9]|2[0-9]|3[0-1])\/(0[1-9]|1[0-2])\/((19|20)\d\d))$/;
if (regex.test(dateString)) {
var parts = dateString.split("/");
var dt = new Date(parts[1] + "/" + parts[0] + "/" + parts[2]);
args.IsValid = (dt.getDate() == parts[0] && dt.getMonth() + 1 == parts[1] && dt.getFullYear() == parts[2]);
} else {
args.IsValid = false;
}
}
</script>
</head>
<body>
<form id="form1" runat="server">
<div class="selectWrapper">
<label>Date of registration</label>
<div class="selectContainer">
<div class="innerContainer">
<div class="selectText" id="selectday" runat="server" >Day</div>
<asp:DropDownList ID="ddlday" runat="server">
<asp:ListItem>Day</asp:ListItem>
</asp:DropDownList>

</div>
</div>
<div class="selectContainer">
<div class="innerContainer">
<div class="selectText">Month</div>
<asp:DropDownList ID="ddlmonth" runat="server">
<asp:ListItem>Month</asp:ListItem>
</asp:DropDownList>
</div>
</div>
<div class="selectContainer">
<div class="innerContainer">
<div class="selectText">Year</div>
<asp:DropDownList ID="ddlyear" runat="server">
<asp:ListItem>Year</asp:ListItem>
</asp:DropDownList>
</div>
</div>
</div>
<asp:CustomValidator runat="server" ClientValidationFunction="ValidateDate"
ErrorMessage="Invalid Date." OnServerValidate="ValidateDate" ValidationGroup="Group2" />
<asp:Button ID="Button1" runat="server" Text="Button" ValidationGroup="Group2" />
</form>
</body>
</html>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Text.RegularExpressions;

using System.Globalization;

public partial class testc : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

if (!IsPostBack)

{

bindddlDayMonthYear();

}

protected void ValidateDate(object sender, ServerValidateEventArgs e)

{

string txtDate3 = ddlday.SelectedValue + "/" + ddlmonth.SelectedValue + "/" + ddlyear;

if (Regex.IsMatch(txtDate3, "(((0|1)[0-9]|2[0-9]|3[0-1])\\/(0[1-9]|1[0-2])\\/((19|20)\\d\\d))$"))

{

DateTime dt;

e.IsValid = DateTime.TryParseExact(e.Value, "dd/MM/yyyy", new CultureInfo("en-GB"), DateTimeStyles.None, out dt);

if (e.IsValid)

{

ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('Valid Date.');", true);

}

else

{

e.IsValid = false;

}

protected void bindddlDayMonthYear()

{

ddlday.Items.Clear();

for (int i = 1; i <= 31; i++)

{

if (i < 10)

{ ddlday.Items.Add(new ListItem("0" + i.ToString())); }

else

{ ddlday.Items.Add(new ListItem(i.ToString())); }

}

ddlday.Items.Insert(0, "Day");

ddlmonth.Items.Clear();

for (int i = 1; i <= 12; i++)

{

if (i < 10)

{ ddlmonth.Items.Add(new ListItem("0" + i.ToString())); }

else

{

ddlmonth.Items.Add(new ListItem(i.ToString()));

}

ddlmonth.Items.Insert(0, "Month");

ddlyear.Items.Clear();

for (int i = 1980; i <= DateTime.Now.Year; i++)

{

ddlyear.Items.Add(new ListItem(i.ToString()));

}

ddlyear.Items.Insert(0, "Year");

}

Wednesday, 13 July 2016

Client site validation in MVC and Umbraco

Monday, 20 June 2016

one field text box and multiple validator

Monday, 13 June 2016

post request

using (WebClient client = new WebClient())
{

byte[] response =
client.UploadValues("http://dork.com/service", new NameValueCollection()
{
{ "home", "Cosby" },
{ "favorite+flavor", "flies" }
});

string result = System.Text.Encoding.UTF8.GetString(response);
string addResult = "{\"d\":" + result + "}";

XmlDocument xml = (XmlDocument)JsonConvert.DeserializeXmlNode(addResult);
XmlNodeList xnList = xml.SelectNodes("/d/transaction_details");
string statusr = "";
string transactionId = "", PG_TYPE = "", Bank_Ref_Num = "", BankCode = "", CardNum = "", Card_Type = "" ;
foreach (XmlNode anode in xnList)
{
if (anode != null)
{
foreach (XmlNode a in anode.FirstChild)
{
if (a != null)
{
if (a.Name == "status")
{
statusr = a.InnerText.ToLower().Trim();

}
else
if (a.Name == "txnid")
{
transactionId = a.InnerText.ToLower().Trim();

} else
if (a.Name == "PG_TYPE")
{
PG_TYPE = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "bank_ref_num")
{
Bank_Ref_Num = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "bankcode")
{
BankCode = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "card_no")
{
CardNum = a.InnerText.ToLower().Trim();
}
else
if (a.Name == "card_type")
{
Card_Type = a.InnerText.ToLower().Trim();
}
}
}
}

}

Monday, 2 May 2016

Check box Validation

Thursday, 28 April 2016

No Back page

Thursday, 7 April 2016

301 Url Redirect

http://www.iis.net/learn/extensions/url-rewrite-module/setting-http-request-headers-and-iis-server-variables

http://www.iis.net/learn/extensions/url-rewrite-module/using-the-url-rewrite-module

This file added your left side, select and click on Http Redirect Icon

Write your where you want to redirect file

Tuesday, 29 March 2016

Excel Integer value upload time going wrong like 10000000..1e+9 or exponential format --Vasu

private void Uploaddata(string strConn, string[] columnNames, string strProcedure)
{
try
{
DataTable dataTableForTheAdapter = new DataTable();

DataTable dtNew = new DataTable();
string commaSepColumns = string.Empty;
foreach (string strColumn in columnNames)
{
commaSepColumns = commaSepColumns + "," + strColumn;
dtNew.Columns.Add(strColumn, typeof(String));
}
commaSepColumns = commaSepColumns.Substring(1, commaSepColumns.Length - 1);
DataSet myDataSet = new DataSet();
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT " + commaSepColumns + " FROM [Sheet1$]", strConn);
myCommand.Fill(dtNew);

int j = 0;
if (dtNew.Rows.Count > 0)
{
string consString = getSqlConnectionstring();
using (SqlConnection con = new SqlConnection(consString))
{
using (SqlCommand cmd = new SqlCommand(strProcedure))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = con;
cmd.Parameters.AddWithValue("@tblCustomers", dtNew);
con.Open();
cmd.ExecuteNonQuery();
con.Close();

lblDispMsg.Text = "Master data uploaded successfully.";
}
}
}
else
{
lblDispMsg.Text = "Master data not uploaded as Data is not proper in Excel.";
}

}
catch (Exception ex)
{

lblDispMsg.Text = "Error in File Upload.<br/>" + Convert.ToString(ex.Message);

}
}

Monday, 7 March 2016

Find Query string value by Name

Friday, 5 February 2016

Select Date, DDL Date, Custome Validation in Csharp .net

Wednesday, 3 February 2016

WCF Test Without Project

C:\Program Files (x86)\Microsoft Visual Studio 10.0\Common7\IDE
WcfTestClient.exe