Asp.Net – Mehta Websolution's Blog

Must-Know Visual Studio Keyboard Shortcuts

29 February 2016 / By Ravi Vaghela

Here, I will give you a short list of keyboard short-cuts for things you probably do often in Visual Studio. Visual Studio Keyboard Shortcuts Project Related Keyboard Shortcuts Ctrl + Shift + B = Build your project Ctrl + Alt + L = Shows Solution Explorer Shift + Alt + C = Add new class Shift + Alt + A = Add

Asp.net Difference between Website and Web Application

12 September 2015 / By Ravi Vaghela

Generally whenever we are trying to create new web project in visual studio we will found two options ASP.NET Web Application and Web Site. What is the difference between these two which one we need to select to create project in asp.net? It’s choice of the people can go for web application or website we cannot

Display Image Preview Without Saving File to Folder – ASP.Net

18 January 2015 / By Ravi Vaghela

Hiii, It is easy to upload and save an image to folder and display the uploaded file in Image Control in ASP.Net. But what to do when we want to display an image preview to Image Control of ASP.Net without/before saving to folder ??? So here is the solution for this problem…Check this…. Design Code :

Could not load file or assembly ‘CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304’ or one of its dependencies

9 January 2015 / By Ravi Vaghela

In this post I will explain how to solve problem of “Could not load file or assembly “CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken= 692fbea5521e1304′ or one of its dependencies. The system cannot find the file specified.” during deploy crystal reports in servers. Generally we will get this problem because of missing crystal report runtime component in server.

jQuery Display Progress Bar on Button Click in Asp.net

13 October 2014 / By Dhwani Rathod

Default.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
<title>jQuery show progress bar on button click asp.net</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<style type="text/css">
.sample
{
background-color:#DC5807;
border:1px solid black;
border-collapse:collapse;
color:White;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<div id="DisableDiv"> </div>
<input type="button" id="btnClick" value="Get Data" />
<div id="testdiv"></div>
</form>
<script type="text/javascript">
$(function() {
$('#btnClick').click(function() {
$('#DisableDiv').fadeTo('slow', .6);
$('#DisableDiv').append('<div style="background-color:#E6E6E6;position: absolute;top:0;left:0;width: 100%;height:300%;z-index:1001;-moz-opacity: 0.8;opacity:.80;filter: alpha(opacity=80);"><img src="loading.gif" style="background-color:Aqua;position:fixed; top:40%; left:46%;"/></div>');
setTimeout(function() { GetData() }, 1000)
})
});
function GetData()
{
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "ShowLoadingImageonButtonClick.aspx/BindDatatable",
data: "{}",
dataType: "json",
success: function(data) {
var theHtml = data.d;
$('#testdiv').html(theHtml)
$('#DisableDiv').html("");
},
error: function(result) {
alert("Error");
}
});
}
</script>
</body>
</html>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

<title>jQuery show progress bar on button click asp.net</title>

.sample

{

background-color:#DC5807;

border:1px solid black;

border-collapse:collapse;

color:White;

}

</style>

</head>

<body>

</form>

$(function() {

$('#btnClick').click(function() {

$('#DisableDiv').fadeTo('slow', .6);

$('#DisableDiv').append('<div style="background-color:#E6E6E6;position: absolute;top:0;left:0;width: 100%;height:300%;z-index:1001;-moz-opacity: 0.8;opacity:.80;filter: alpha(opacity=80);"><img src="loading.gif" style="background-color:Aqua;position:fixed; top:40%; left:46%;"/></div>');

setTimeout(function() { GetData() }, 1000)

})

});

function GetData()

{

$.ajax({

type: "POST",

contentType: "application/json; charset=utf-8",

url: "ShowLoadingImageonButtonClick.aspx/BindDatatable",

data: "{}",

dataType: "json",

success: function(data) {

var theHtml = data.d;

$('#testdiv').html(theHtml)

$('#DisableDiv').html("");

},

error: function(result) {

alert("Error");

}

});

}

</script>

</body>

</html>

Default.aspx.cs

using System;
using System.Data;
using System.Data.SqlClient;
using System.Web.Services;
using System.Web.UI;
using System.Web.UI.WebControls;

protected void Page_Load(object sender, EventArgs e)
{
}
[WebMethod]
public static string BindDatatable()
{
GridView gv = new GridView();
System.IO.StringWriter stringWriter = new System.IO.StringWriter();
HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);
DataTable dt = new DataTable();
using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Initial Catalog=MySampleDB;Integrated Security=true"))
{
using (SqlCommand cmd = new SqlCommand("select UserId,UserName,Location from UserInformation", con))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(dt);
}
}
gv.HeaderStyle.CssClass = "sample";
gv.DataSource = dt;
gv.DataBind();
gv.RenderControl(htmlWriter);
return stringWriter.ToString();
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

using System;

using System.Data;

using System.Data.SqlClient;

using System.Web.Services;

using System.Web.UI;

using System.Web.UI.WebControls;

protected void Page_Load(object sender, EventArgs e)

{

}

[WebMethod]

public static string BindDatatable()

{

GridView gv = new GridView();

System.IO.StringWriter stringWriter = new System.IO.StringWriter();

HtmlTextWriter htmlWriter = new HtmlTextWriter(stringWriter);

DataTable dt = new DataTable();

using (SqlConnection con = new SqlConnection("Data Source=SureshDasari;Initial Catalog=MySampleDB;Integrated Security=true"))

{

using (SqlCommand cmd = new SqlCommand("select UserId,UserName,Location from UserInformation", con))

{

con.Open();

SqlDataAdapter da = new SqlDataAdapter(cmd);

da.Fill(dt);

}

gv.HeaderStyle.CssClass = "sample";

gv.DataSource = dt;

gv.DataBind();

gv.RenderControl(htmlWriter);

return stringWriter.ToString();

}

jQuery Higlight Table Row & Column on Mouseover in Asp.net

13 October 2014 / By Dhwani Rathod

Default.aspx

<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1">
<title>Asp.net Bind Data to Datatable using JQuery or JSON</title>
<script type="text/javascript" src="http://code.jquery.com/jquery-1.8.2.js"></script>
<script type="text/javascript">
$(function() {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/BindDatatable",
data: "{}",
dataType: "json",
success: function(data) {
for (var i = 0; i < data.d.length; i++) {
if (i % 2 == 0) {
$("#tbDetails").append("<tr class=tg-even><td>" + data.d[i].Tagid + "</td><td>" + data.d[i].TagName + "</td><td>" + data.d[i].Noofarticles + "</td></tr>");
}
else {
$("#tbDetails").append("<tr><td>" + data.d[i].Tagid + "</td><td>" + data.d[i].TagName + "</td><td>" + data.d[i].Noofarticles + "</td></tr>");
}
}
$('td').mouseover(function() {
$(this).siblings().css('background-color', '#EAD575');
var ind = $(this).index();
$('td:nth-child(' + (ind + 1) + ')').css('background-color', '#EAD575');
});
$('td').mouseleave(function() {
$(this).siblings().css('background-color', '');
var ind = $(this).index();
$('td:nth-child(' + (ind + 1) + ')').css('background-color', '');
});
},
error: function(result) {
alert("Error");
}
});
});
</script>
<style type='text/css'>
.tbl {
border-collapse: collapse;
border-spacing: 0;
}
.tbl td, .tbl th {
background-color: #fff;
border: 1px #bbb solid;
color: #333;
font-family: sans-serif;
font-size: 100%;
padding: 10px;
vertical-align: top;
}
.tbl .tg-even td {
background-color: #eee;
}
.tbl th {
background-color: #ddd;
color: #333;
font-size: 110%;
font-weight: bold;
}
</style>
</head>
<body>
<form id="form1" runat="server">
<table id="tbDetails" class="tbl">
<tr >
<th>UserId</th>
<th>UserName</th>
<th>Location</th>
</tr>
<tbody>
</tbody>
</table>
</form>
</body>
</html>

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

71

72

73

74

75

76

77

<title>Asp.net Bind Data to Datatable using JQuery or JSON</title>

$(function() {

$.ajax({

type: "POST",

contentType: "application/json; charset=utf-8",

url: "Default.aspx/BindDatatable",

data: "{}",

dataType: "json",

success: function(data) {

for (var i = 0; i < data.d.length; i++) {

if (i % 2 == 0) {

$("#tbDetails").append("<tr class=tg-even><td>" + data.d[i].Tagid + "</td><td>" + data.d[i].TagName + "</td><td>" + data.d[i].Noofarticles + "</td></tr>");

}

else {

$("#tbDetails").append("<tr><td>" + data.d[i].Tagid + "</td><td>" + data.d[i].TagName + "</td><td>" + data.d[i].Noofarticles + "</td></tr>");

}

$('td').mouseover(function() {

$(this).siblings().css('background-color', '#EAD575');

var ind = $(this).index();

$('td:nth-child(' + (ind + 1) + ')').css('background-color', '#EAD575');

});

$('td').mouseleave(function() {

$(this).siblings().css('background-color', '');

var ind = $(this).index();

$('td:nth-child(' + (ind + 1) + ')').css('background-color', '');

});

},

error: function(result) {

alert("Error");

}

});

</script>

.tbl {

border-collapse: collapse;

border-spacing: 0;

}

.tbl td, .tbl th {

background-color: #fff;

border: 1px #bbb solid;

color: #333;

font-family: sans-serif;

font-size: 100%;

padding: 10px;

vertical-align: top;

}

.tbl .tg-even td {

background-color: #eee;

}

.tbl th {

background-color: #ddd;

color: #333;

font-size: 110%;

font-weight: bold;

}

</style>

</head>

<body>

<tr >

<th>UserId</th>

<th>UserName</th>

<th>Location</th>

</tr>

<tbody>

</tbody>

</table>

</form>

</body>

</html>

Default.aspx.cs

using System;
using System.Collections.Generic;
using System.Data;
using System.Web.Services;

public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{

}
[WebMethod]
public static UserDetails[] BindDatatable()
{
List<UserDetails> details = new List<UserDetails>();
DataTable dt = new DataTable();
dt.Columns.Add("Tagid", typeof(Int32));
dt.Columns.Add("TagName", typeof(string));
dt.Columns.Add("Noofarticles", typeof(string));
dt.Rows.Add(1, "Asp.Net", 100);
dt.Rows.Add(2, "C#.Net", 10);
dt.Rows.Add(3, "SQL Server", 30);
dt.Rows.Add(4, "jQuery", 20);
dt.Rows.Add(6, "javascript", 15);
dt.Rows.Add(7, "XSLT", 50);
foreach (DataRow dtrow in dt.Rows)
{
UserDetails user = new UserDetails();
user.Tagid = dtrow["Tagid"].ToString();
user.TagName = dtrow["TagName"].ToString();
user.Noofarticles = dtrow["Noofarticles"].ToString();
details.Add(user);
}
return details.ToArray();
}
public class UserDetails
{
public string Tagid { get; set; }
public string TagName { get; set; }
public string Noofarticles { get; set; }
}
}

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

using System;

using System.Collections.Generic;

using System.Data;

using System.Web.Services;

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

{

protected void Page_Load(object sender, EventArgs e)

{

}

[WebMethod]

public static UserDetails[] BindDatatable()

{

List<UserDetails> details = new List<UserDetails>();

DataTable dt = new DataTable();

dt.Columns.Add("Tagid", typeof(Int32));

dt.Columns.Add("TagName", typeof(string));

dt.Columns.Add("Noofarticles", typeof(string));

dt.Rows.Add(1, "Asp.Net", 100);

dt.Rows.Add(2, "C#.Net", 10);

dt.Rows.Add(3, "SQL Server", 30);

dt.Rows.Add(4, "jQuery", 20);

dt.Rows.Add(6, "javascript", 15);

dt.Rows.Add(7, "XSLT", 50);

foreach (DataRow dtrow in dt.Rows)

{

UserDetails user = new UserDetails();

user.Tagid = dtrow["Tagid"].ToString();

user.TagName = dtrow["TagName"].ToString();

user.Noofarticles = dtrow["Noofarticles"].ToString();

details.Add(user);

}

return details.ToArray();

}

public class UserDetails

{

public string Tagid { get; set; }

public string TagName { get; set; }

public string Noofarticles { get; set; }

}

From around the world

What is Ransomware? What is WannaCry Ransomware? How it spreads? What can you do to prevent infection?

Simple PHP anti-brute-force login

How to install NginX on cPanel/WHM Server

Convert PDF Documents with Able2Extract Professional 11

One Click Extension Manager: Manage Chrome extensions

Must-Know Visual Studio Keyboard Shortcuts

Asp.net Difference between Website and Web Application

Display Image Preview Without Saving File to Folder – ASP.Net

Could not load file or assembly ‘CrystalDecisions.Web, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304’ or one of its dependencies

jQuery Display Progress Bar on Button Click in Asp.net

jQuery Higlight Table Row & Column on Mouseover in Asp.net

Categories

Mehta Websolution Since 2007