Posts

Showing posts from 2017

How to create android app easily?

-
Hello, Today i explain How to create android app. If you have a website then just follow below steps: 1. Go to http://web2apk.com/create.aspx 2. Enter your website name in url field. 3. And then enter your apps name in Apps title. 4. At last choose app logo (png)  and click "create my app" button. 5. After processing apk, you can download it from here.
Read More »

mvc jquery save

-
<form action =" /Plugin/Ajax/ContactUs " class =" form-horizontal " id =" contact-form " method =" post " name =" contact-form "> <div class =" col-sm-6 "> <div class =" form-group "> <div class =" col-sm-12 "> <input class =" validate[required] form-control " id =" FullName " name =" FullName " placeholder =" Name " size =" 30 " type =" text " value ="" /> <label id =" lblName " name =" lblName " class =" errorlbl "> </label> </div> </div> <div class =" form-group "> <...
Read More »

Code first mvc

-
https://www.codeproject.com/Articles/826571/Code-First-Approach-with-ASP-NET-MVC-Framework
Read More »

jquery save & fetch asp.net

-
Default.aspx: <%@ Page Language="C#" AutoEventWireup="true" CodeFile="Default.aspx.cs" Inherits="_Default" %> <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml"> <head runat="server">     <script type="text/javascript" src="http://code.jquery.com/jquery-1.10.2.min.js"></script>     <style type="text/css">         <style type="text/css">         body         {             font-family: Verdana;             font-size: 11px;         }             .errMsg         {             width: 200px;             text-align: left;             color: yellow;             font: 12px arial; ...
Read More »

desktop application connection string

-
namespace Payroll {     class Connection     {         private  static SqlConnection SqlCon;         //private readonly static SqlConnection SqlCon = new SqlConnection("Server=petunia.arvixe.com; database=visiondb; uid=vision1; password=vision2;");         public static SqlConnection CON         {             get             {               return   SqlCon = new SqlConnection("Server=WIN-PC\\SQLEXPRESS; database=Payroll;integrated Security=SSPI");             }         }     } }
Read More »

Mail Send With Pdf

-
protected void MailSendWithCoponPdf(string Email,string Coupon)     {         using (StringWriter sw = new StringWriter())         {             using (HtmlTextWriter hw = new HtmlTextWriter(sw))             {                 string companyName = "xxxxxxxx";                 string orderNo = "#2303";                 StringBuilder sb = new StringBuilder();                 sb.Append("<table width='100%' cellspacing='0' cellpadding='2'>");                 sb.Append("<tr><td align='center' style='background-color: #18B5F0' colspan = '2'><b>Coupon</b></td></tr>");                 sb.Append("<t...
Read More »

Connection string web.config asp.net

-
<?xml version="1.0"?> <!--   For more information on how to configure your ASP.NET application, please visit   http://go.microsoft.com/fwlink/?LinkId=169433   --> <configuration>     <system.web>       <compilation debug="true" targetFramework="4.5" />       <httpRuntime targetFramework="4.5" />     </system.web>   <connectionStrings>     <add name="conn" connectionString="Data Source=WIN-PC\SQLEXPRESS;Initial Catalog=st_SubiTechnologies;Integrated Security=True;" providerName="System.Data.SqlClient"/>     <!--<add name="conn" connectionString="Data Source=.\SQLServer2012;Initial Catalog=st_SubiTechnologies;User Id=subi;Password=ysN9o2^6;Connect Timeout=120;" providerName="System.Data.SqlClient" />-->   </connectionStrings> </configuration>
Read More »

save class

-
public static int Save(string Name, string Emailid, string PhoneNo, string LaptopBrand, string Model, string SerialNo, string Description, DateTime DOE, string Coupon)     {         int n;         SqlCommand cmd = new SqlCommand();         try         {             cmd.Connection = DataConnection.Con;             cmd.CommandText = "Sp_Register_Save";             cmd.CommandType = CommandType.StoredProcedure;             cmd.Parameters.AddWithValue("@rowId", 0);             cmd.Parameters.AddWithValue("@Name", Name);             cmd.Parameters.AddWithValue("@Emailid", Emailid);             cmd.Parameters.AddWithValue("@PhoneNo", PhoneNo);            ...
Read More »

Fetch Store Procedure

-
USE [st_SubiTechnologies] GO /****** Object:  StoredProcedure [dbo].[Sp_Register_GetLastCoupon]    Script Date: 2/10/2017 10:56:47 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Sp_Register_GetLastCoupon] --@flag int output AS BEGIN begin transaction select top(1) Coupon from tbl_registration order by rowId desc --if @@ERROR=0 --begin -- set @flag=1 -- commit transaction --end --else --begin -- set @flag=0 -- rollback transaction --end END
Read More »

Save storeprocedure

-
USE [st_SubiTechnologies] GO /****** Object:  StoredProcedure [dbo].[Sp_Register_Save]    Script Date: 2/10/2017 10:46:56 PM ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [dbo].[Sp_Register_Save] @rowId int, @Name varchar(300), @Emailid varchar(300), @PhoneNo varchar(20), @LaptopBrand varchar(50), @Model varchar(50), @SerialNo varchar(200), @Description varchar(700), @DOE datetime, @Coupon varchar(10), @flag int output AS BEGIN begin transaction insert into [dbo].[tbl_registration](Name,Emailid,PhoneNo,LaptopBrand,Model,SerialNo,Description,DOE,Coupon) values(@Name,@Emailid,@PhoneNo,@LaptopBrand,@Model,@SerialNo,@Description,@DOE,@Coupon) if @@ERROR=0 begin set @flag=1 commit transaction end else begin set @flag=0 rollback transaction end END
Read More »