A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_URI::$config is deprecated
Filename: core/URI.php
Line Number: 101
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Router::$uri is deprecated
Filename: core/Router.php
Line Number: 127
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$benchmark is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$hooks is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$config is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$log is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$utf8 is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$uri is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$exceptions is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$router is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$output is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$security is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$input is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$lang is deprecated
Filename: core/Controller.php
Line Number: 82
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$db is deprecated
Filename: core/Loader.php
Line Number: 396
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_DB_mysqli_driver::$failover is deprecated
Filename: database/DB_driver.php
Line Number: 371
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: Trying to access array offset on true
Filename: libraries/Email.php
Line Number: 978
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$email is deprecated
Filename: core/Loader.php
Line Number: 1283
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::close() should either be compatible with SessionHandlerInterface::close(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 295
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::read($session_id) should either be compatible with SessionHandlerInterface::read(string $id): string|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 169
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::write($session_id, $session_data) should either be compatible with SessionHandlerInterface::write(string $id, string $data): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 238
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::destroy($session_id) should either be compatible with SessionHandlerInterface::destroy(string $id): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 318
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Return type of CI_Session_files_driver::gc($maxlifetime) should either be compatible with SessionHandlerInterface::gc(int $max_lifetime): int|false, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice
Filename: drivers/Session_files_driver.php
Line Number: 359
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 282
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_set_cookie_params(): Session cookie parameters cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 289
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 304
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 314
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 315
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 316
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 317
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: ini_set(): Session ini settings cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 375
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_set_save_handler(): Session save handler cannot be changed after headers have already been sent
Filename: Session/Session.php
Line Number: 110
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: Warning
Message: session_start(): Session cannot be started after headers have already been sent
Filename: Session/Session.php
Line Number: 143
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$session is deprecated
Filename: core/Loader.php
Line Number: 1283
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property Forums::$user_model is deprecated
Filename: core/Loader.php
Line Number: 358
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/User.php
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$load is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$benchmark is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$hooks is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$config is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$log is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$utf8 is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$uri is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$exceptions is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$router is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$output is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$security is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$input is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$lang is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$db is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$email is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$session is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
A PHP Error was encountered
Severity: 8192
Message: Creation of dynamic property CI_Loader::$user_model is deprecated
Filename: core/Loader.php
Line Number: 931
Backtrace:
File: /home1/biognosy/skmlhometuitions.in/application/controllers/Forums.php
File: /home1/biognosy/skmlhometuitions.in/index.php
How to display image from database in ModalPopup on ListView LinkButton Click using jQuery Ajax in ASP.Net | Forum Topic - SKML Home Tuitions
I have this listview and a linkbutton, i want on linkbutton to pass the label1 id to and show the popup to display category name
i want to do it through jQuery
User click on linkbutton, since its listview so there are multiple records so on click get the label1 category id 3.
Show popup pass the id to category table and through jQuery it returns the categorname and image and show in popup
1
2
3
4
5
6
<asp:ListView ID="ListView1" runat="server">
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%#Eval("category_id") %>' >asp:Label>
<asp:LinkButton ID="LinkButton1" runat="server">View Detailasp:LinkButton>
ItemTemplate>
asp:ListView>
Not sure whare to join tuition right for you?
Choose the right one for you.
Let`s Connect
ARUNA
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
View Detail
×
Category Details
$(function () {
$('[id*=LinkButton1]').on('click', function () {
$('#MyPopup').find('[id*=lblName]').html('');
$('#MyPopup').find('[id*=imgCategory]').attr('src', '');
var categoryId = $(this).prev('[id*=Label1]').html();
$.ajax({
type: "POST",
url: "Default.aspx/GetDetails",
data: '{id: ' + categoryId + ' }',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
$('#MyPopup').find('[id*=lblName]').html(response.d[1]);
$('#MyPopup').find('[id*=imgCategory]').attr('src', response.d[0]);
$('#MyPopup').modal('show');
},
error: function (response) { alert(response.responseText); }
});
return false;
});
});
Namespaces
C#
1
2
3 using System.Configuration;
using System.Data.SqlClient;
using System.Web.Services;
VB.Net
1
2
3 Imports System.Configuration
Imports System.Data.SqlClient
Imports System.Web.Services
Code
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn("category_id"));
dt.Rows.Add(1);
dt.Rows.Add(2);
dt.Rows.Add(3);
ListView1.DataSource = dt;
ListView1.DataBind();
}
}
[WebMethod]
public static object[] GetDetails(int id)
{
object[] details = null;
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM tblFiles WHERE Id = @Id"))
{
cmd.Parameters.AddWithValue("@Id", id);
cmd.Connection = con;
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
byte[] bytes = (byte[])sdr["Data"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
string imageUrl = "data:image/png;base64," + base64String;
string name = sdr["Name"].ToString();
details = new object[] { imageUrl, name };
}
con.Close();
}
}
return details;
}
VB.Net
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim dt As System.Data.DataTable = New System.Data.DataTable()
dt.Columns.Add(New System.Data.DataColumn("category_id"))
dt.Rows.Add(1)
dt.Rows.Add(2)
dt.Rows.Add(3)
ListView1.DataSource = dt
ListView1.DataBind()
End If
End Sub
Public Shared Function GetDetails(ByVal id As Integer) As Object()
Dim details As Object() = Nothing
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand("SELECT Name,Data FROM tblFiles WHERE Id = @Id")
cmd.Parameters.AddWithValue("@Id", id)
cmd.Connection = con
con.Open()
Dim sdr As SqlDataReader = cmd.ExecuteReader()
If sdr.Read() Then
Dim bytes As Byte() = CType(sdr("Data"), Byte())
Dim base64String As String = Convert.ToBase64String(bytes, 0, bytes.Length)
Dim imageUrl As String = "data:image/png;base64," & base64String
Dim name As String = sdr("Name").ToString()
details = New Object() {imageUrl, name}
End If
con.Close()
End Using
PARTH
Check this example. Now please take its reference and correct your code.
HTML
View Detail
×
Category Details
$(function () {
$('[id*=LinkButton1]').on('click', function () {
$('#MyPopup').find('[id*=lblName]').html('');
$('#MyPopup').find('[id*=imgCategory]').attr('src', '');
var categoryId = $(this).prev('[id*=Label1]').html();
$.ajax({
type: "POST",
url: "Default.aspx/GetDetails",
data: '{id: ' + categoryId + ' }',
contentType: "application/json; charset=utf-8",
dataType: "json",
success: function (response) {
$('#MyPopup').find('[id*=lblName]').html(response.d[1]);
$('#MyPopup').find('[id*=imgCategory]').attr('src', response.d[0]);
$('#MyPopup').modal('show');
},
error: function (response) { alert(response.responseText); }
});
return false;
});
});
C#
using System.Configuration;
using System.Data.SqlClient;
using System.Web.Services;
VB.Net
Imports System.Configuration
Imports System.Data.SqlClient
Imports System.Web.Services
C#
protected void Page_Load(object sender, EventArgs e)
{
if (!this.IsPostBack)
{
System.Data.DataTable dt = new System.Data.DataTable();
dt.Columns.Add(new System.Data.DataColumn("category_id"));
dt.Rows.Add(1);
dt.Rows.Add(2);
dt.Rows.Add(3);
ListView1.DataSource = dt;
ListView1.DataBind();
}
}
[WebMethod]
public static object[] GetDetails(int id)
{
object[] details = null;
string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("SELECT Name,Data FROM tblFiles WHERE Id = @Id"))
{
cmd.Parameters.AddWithValue("@Id", id);
cmd.Connection = con;
con.Open();
SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.Read())
{
byte[] bytes = (byte[])sdr["Data"];
string base64String = Convert.ToBase64String(bytes, 0, bytes.Length);
string imageUrl = "data:image/png;base64," + base64String;
string name = sdr["Name"].ToString();
details = new object[] { imageUrl, name };
}
con.Close();
}
}
return details;
}
VB.NET
Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
If Not Me.IsPostBack Then
Dim dt As System.Data.DataTable = New System.Data.DataTable()
dt.Columns.Add(New System.Data.DataColumn("category_id"))
dt.Rows.Add(1)
dt.Rows.Add(2)
dt.Rows.Add(3)
ListView1.DataSource = dt
ListView1.DataBind()
End If
End Sub
Public Shared Function GetDetails(ByVal id As Integer) As Object()
Dim details As Object() = Nothing
Dim constr As String = ConfigurationManager.ConnectionStrings("constr").ConnectionString
Using con As SqlConnection = New SqlConnection(constr)
Using cmd As SqlCommand = New SqlCommand("SELECT Name,Data FROM tblFiles WHERE Id = @Id")
cmd.Parameters.AddWithValue("@Id", id)
cmd.Connection = con
con.Open()
Dim sdr As SqlDataReader = cmd.ExecuteReader()
If sdr.Read() Then
Dim bytes As Byte() = CType(sdr("Data"), Byte())
Dim base64String As String = Convert.ToBase64String(bytes, 0, bytes.Length)
Dim imageUrl As String = "data:image/png;base64," & base64String
Dim name As String = sdr("Name").ToString()
details = New Object() {imageUrl, name}
End If
con.Close()
End Using
End Using
Return details
End Function