Comments by Rajiv.net40

Rajiv.net40 1-Sep-17 7:09am View

not worked your query.

Rajiv.net40 30-Aug-17 7:16am View

Deleted

.

Rajiv.net40 30-Aug-17 6:34am View

finally i have updated my quey and for result i was looking for but there is a problem only it null in req_from_id.

select distinct
tb1.UserID,tb1.f_name,tb1.Designationnm,tb1.Comapny_name,tb2.req_from_id
from Tbl_register tb1
left join
tbl_friend_and_match_request tb2
on
tb1.UserID = tb2.req_from_id
where
Comapny_name like '%a%' or Designationnm like '%Manager%'

Rajiv.net40 30-Aug-17 5:16am View

i need all users with friend request id in search result from both table.

Rajiv.net40 30-Aug-17 4:35am View

i dont know how to decide to select one.if u know then tell me or any idea

Rajiv.net40 30-Aug-17 4:27am View

I changed it to req_to_id but it still shows all the entries

aaa CEO Apple 1 1
Rajeev General manager Dell 2 NULL
Suneal Managing director Apple 9 9
Suneal Managing director Apple 9 9
Suneal Managing director Apple 9 9
asa CEO Apple 8 8

Rajiv.net40 30-Aug-17 3:57am View

have u any solution for my question ?

Rajiv.net40 30-Aug-17 2:16am View

it works but gives duplicate records

Rajiv.net40 19-Jan-17 5:11am View

it's not giving any output..

Rajiv.net40 18-Jan-17 23:27pm View

then can u give me code for this

Rajiv.net40 18-Jan-17 10:55am View

can u plz give me code for this

Rajiv.net40 22-Aug-16 7:02am View

i need it in every 15 minute a new random no by default

Rajiv.net40 22-Aug-16 6:34am View

i think u did't understand my qry ?

Rajiv.net40 22-Aug-16 5:55am View

how to run timer 24/7 when browser window is closed or opend in asp.nety with C#

Rajiv.net40 25-Jul-16 7:20am View

hhhmmm...that's exelant.......thx

Rajiv.net40 25-Jul-16 7:02am View

sir how i use ! Operator give me a example

Rajiv.net40 25-Jul-16 6:50am View

sir there is problem with this. it shows false on top but i need true on top. how to do ?

Rajiv.net40 25-Jul-16 5:30am View

thank u very much......this is right answar

Rajiv.net40 25-Jul-16 4:59am View

i need set for n user

Rajiv.net40 25-Jul-16 4:51am View

if i have 1000 user then ?

Rajiv.net40 25-Jul-16 4:36am View

can you give some example

Rajiv.net40 20-Jul-16 10:52am View

i mean for that module

Rajiv.net40 20-Jul-16 10:50am View

sir actually i want to perform above task but i don't have idea about that how to do it.
i want complit sql script and c# code as demo

Rajiv.net40 20-Jul-16 9:41am View

I want to add a new record to a table (from fields in a FormView) and add further records to a related table using the [identity] column from the first table as a foreign key in the second table.

Rajiv.net40 14-Jun-16 9:57am View

i want to show all details of row on model popup wheen i double click on table row

Rajiv.net40 12-Jun-16 4:24am View

Order

</div>
<div id="orderDetails" class="modal-body"></div>
<div id="orderItems" class="modal-body"></div>
<div class="modal-footer">
<button class="btn" data-dismiss="modal" aria-hidden="true">Close</button>
</div>
</div>

Rajiv.net40 12-Jun-16 2:06am View

i want to show colunm name also dynamicly..not static becose i will use single table for multipupose

Rajiv.net40 12-Jun-16 1:55am View

how can i also select column name in table ?

Rajiv.net40 12-Jun-16 1:53am View

thank you very much sir

Rajiv.net40 12-Jun-16 1:45am View

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

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<%@ Register Src="~/UserControls/ucTabeltest.ascx" TagName="uct" TagPrefix="uctbl" %>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<script src="script/jquery-3.0.0.js" type="text/javascript"></script>
<script src="script/bootstrap.js" type="text/javascript"></script>
<script src="script/bootstrap.min.js" type="text/javascript"></script>
<script src="script/jquery-1.11.2.min.js" type="text/javascript"></script>
<script src="script/npm.js" type="text/javascript"></script>

<link href="css/bootstrap-theme.css" rel="stylesheet" type="text/css" />
<link href="css/bootstrap-theme.min.css" rel="stylesheet" type="text/css" />
<link href="css/bootstrap.css" rel="stylesheet" type="text/css" />
<link href="css/bootstrap.min.css" rel="stylesheet" type="text/css" />

<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<uctbl:uct ID="uct" runat="server" />
</div>
</form>
</body>
</html>

//====== controller

<%@ Control Language="C#" AutoEventWireup="true" CodeFile="ucTabeltest.ascx.cs" Inherits="UserControls_ucTabeltest" %>

<script src="script/userdefiendfees.js" type="text/javascript"></script>
<div>
<input type="button" id="tbl" value="Get Data" class="btn btn-success"/>

<table id="tblselect" runat="server" clientidmode="Static" class="table table-striped">
<thead><tr>
<td></td>
</tr></thead>
<tbody >
<tr>
<td></td>
</tr>
</tbody>
<tfoot><tr>
<td></td>
</tr></tfoot>
</table>

</div>

Rajiv.net40 12-Jun-16 0:33am View

<pre lang="C#">public static DataTable ExecuteselectQry_returns_datatable(string qry)
{
SqlConnection con = new SqlConnection(WebConfigurationManager.ConnectionStrings["con"].ToString());

DataTable dt = new DataTable();
SqlDataAdapter da = new SqlDataAdapter();
SqlCommand cmd = new SqlCommand(qry, con);
da.SelectCommand = cmd;
con.Open();
da.Fill(dt);

con.Close();
return dt;

}</pre>

<pre lang="C#">public string showdata()
{
string qry = "select *from usr";
DataTable dt = dllmain.ExecuteselectQry_returns_datatable(qry);
return getdatatabletojson(dt);

}

public static string getdatatabletojson(DataTable dt)
{
string str = string.Empty;
JavaScriptSerializer serializer = new JavaScriptSerializer();
List<Dictionary<string, object>> rows = new List<Dictionary<string, object>>();
Dictionary<string, object> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary<string, object>();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
str = serializer.Serialize(rows);
return str;

}</pre>

<pre lang="C#">[WebMethod]
[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)]
public string bindtable()
{
dllgetinfo info = new dllgetinfo();
return info.showdata();
}</pre>

Rajiv.net40 12-Jun-16 0:28am View

this is not working sir

Rajiv.net40 12-Jun-16 0:11am View

sir your code works fine but 1 thing is wrong with this. when i click getdata button it repeats complit table.if i click 2 time it repeats tables two times .....plz solve it

Rajiv.net40 11-Jun-16 9:46am View

[WebMethod]
[ScriptMethod(UseHttpGet = false, ResponseFormat = ResponseFormat.Json)]
public string bindtable()
{
dllgetinfo info = new dllgetinfo();
return info.showdata();
}

//=======
public string showdata()
{
string qry = "select *from usr";
DataTable dt = dllmain.ExecuteselectQry_returns_datatable(qry);
return getdatatabletojson(dt);

}

public static string getdatatabletojson(DataTable dt)
{
string str = string.Empty;
JavaScriptSerializer serializer = new JavaScriptSerializer();
List<dictionary<string, object="">> rows = new List<dictionary<string, object="">>();
Dictionary<string, object=""> row;
foreach (DataRow dr in dt.Rows)
{
row = new Dictionary<string, object="">();
foreach (DataColumn col in dt.Columns)
{
row.Add(col.ColumnName, dr[col]);
}
rows.Add(row);
}
str = serializer.Serialize(rows);
return str;

}

Rajiv.net40 21-May-15 7:41am View

not working your code sir

Rajiv.net40 23-Dec-14 6:54am View

sir i have multiple connection string so i had used more than one user id and password. will it create nay problem. it gives error "Invalid object name 'db2.dbo.table2'."

Rajiv.net40 23-Dec-14 5:49am View

not working this code...

Comments by Rajiv.net40 (Top 37 by date)

Order