Comments by SujataJK (Top 133 by date)

I got mail including this warning message
http://localhost/JKWorkBewnch/frmLogin.aspx

Source:
System.WebMessage:
Exception of type 'System.Web.HttpUnhandledException' was thrown.Stack Trace:
at System.Web.UI.Page.HandleError(Exception e)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
at System.Web.UI.Page.ProcessRequest()
at System.Web.UI.Page.ProcessRequest(HttpContext context)
at ASP.frmlogin_aspx.ProcessRequest(HttpContext context) in c:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\jkworkbewnch\673b1ad7\11d2590e\App_Web_ykh4oa1j.2.cs:line 0
at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)

Refresh Refresh
Compose Compose
Print
Move selected item(s) to Trash

I did this in global.aspx

void Application_Error(object sender, EventArgs e)
{
// Code that runs when an unhandled error occurs
MailMessage msg = new MailMessage();
HttpContext ctx = HttpContext.Current;

msg.To.Add(new MailAddress("sujata.shinde@jkumar.com"));
msg.From = new MailAddress("sujata.shinde@jkumar.com");
msg.Subject = "My app had an issue...";
msg.Priority = MailPriority.High;

StringBuilder sb = new StringBuilder();
sb.Append(ctx.Request.Url.ToString() + System.Environment.NewLine);
sb.Append("Source:" + System.Environment.NewLine + ctx.Server.GetLastError().Source.ToString());
sb.Append("Message:" + System.Environment.NewLine + ctx.Server.GetLastError().Message.ToString());
sb.Append("Stack Trace:" + System.Environment.NewLine + ctx.Server.GetLastError().StackTrace.ToString());
msg.Body = sb.ToString();
Response.Write(sb.ToString());
// msg.Body = sb.ToString();

//CONFIGURE SMTP OBJECT
System.Net.Mail.SmtpClient smtCliend = new System.Net.Mail.SmtpClient();
smtCliend.Host = "smtp.logix.in"; //Or Your SMTP Server Address
smtCliend.Port = 587;
smtCliend.UseDefaultCredentials = false;
smtCliend.Credentials = new NetworkCredential("sujata.shinde@jkumar.com", "S@ujata321");

//SEND EMAIL
smtCliend.Send(msg);

}

Above error message also shows following details

Most likely causes:
1. No authentication protocol (including anonymous) is selected in IIS.
2 Only integrated authentication is enabled, and a client browser was used
that does not support integrated authentication.
3 .Integrated authentication is enabled and the request was sent through a proxy that changed the authentication headers before they reach the Web server.
4. The Web server is not configured for anonymous access and a required authorization header was not received.
5. The "configuration/system.webServer/authorization" configuration section may be explicitly denying the user access.

in iis ,inside authorization rules section i allow all user and entry type is local

Forms Authentication

Thanks Sir,
I solved this by re-install of visual studio.

after deleting pdb file or cleaning solution it also doesn't work.

Inside release, there also doesn't exist .exe and .msi files.
and one more thing that i had observed that when i am going to build setup then it doesn't show build successed messsge,instead of that my solution exlore windows with visual studio restart automatically

tHIS IS WHAT I HAVE TRIED NOW

SELECT DOC_ID,DOC_DT,QTY,
CASE WHEN QTY > 0 THEN QTY
ELSE '' END AS RECEIPT,
CASE WHEN QTY < 0 THEN QTY
ELSE '' END AS ISSUE
FROM tbl_StockMaster

AND OUTPUT OF THIS SOMETHING LIKE THIS
DOC_ID DOC_DT QTY RECEIPT ISSUE
MRNGD/0001/18-19 2018-04-17 10:22:12.000 24 24 0
MRNGD/0001/18-19 2018-04-17 10:22:12.000 38 38 0
MRNGD/0001/18-19 2018-04-17 10:22:12.000 45 45 0
MRNGD/0002/18-19 2018-04-17 10:23:58.000 25 25 0
MRNGD/0002/18-19 2018-04-17 10:23:58.000 35 35 0
MRNGD/0002/18-19 2018-04-17 10:23:58.000 25 25 0
MRNGD/0003/18-19 2018-04-17 10:25:07.000 50 50 0
MRNGD/0003/18-19 2018-04-17 10:25:07.000 25 25 0
MRNGD/0003/18-19 2018-04-17 10:25:07.000 33 33 0
PRDGD/0001/18-19 2018-04-17 10:26:51.000 45 45 0
PRDGD/0001/18-19 2018-04-17 10:26:51.000 -24 0 -24
PRDGD/0001/18-19 2018-04-17 10:26:51.000 -21 0 -21
PRDGD/0001/18-19 2018-04-17 10:26:51.000 21 21 0
PRDGD/0002/18-19 2018-04-17 10:36:50.000 35 35 0
PRDGD/0002/18-19 2018-04-17 10:36:50.000 -35 0 -35
TRNGD/0001/18-19 2018-04-17 00:00:00.000 -45 0 -45


NOW I WANT ANOTHER COLUMN AFTER ISSUE COLUMN i.e BALANCE(STOCK) COLUMN WHICH SOMETHING LIKE THIS

DOC_ID DOC_DT QTY RECEIPT ISSUE BALANCE
MRNGD/0001/18-19 2018-04-17 24 24 0 24.00
MRNGD/0001/18-19 2018-04-17 38 38 0 62.00
MRNGD/0001/18-19 2018-04-17 45 45 0 107.00
MRNGD/0002/18-19 2018-04-17 25 25 0 132.00
MRNGD/0002/18-19 2018-04-17 35 35 0 167.00
MRNGD/0002/18-19 2018-04-17 25 25 0 192.00
MRNGD/0003/18-19 2018-04-17 50 50 0 245.00
MRNGD/0003/18-19 2018-04-17 25 25 0 270.00
MRNGD/0003/18-19 2018-04-17 33 33 0 303.00
PRDGD/0001/18-19 2018-04-17 45 45 0 348.00
PRDGD/0001/18-19 2018-04-17 -24 0 -24 324.00
PRDGD/0001/18-19 2018-04-17 -21 0 -21 303.00
PRDGD/0001/18-19 2018-04-17 21 21 0 324.00
PRDGD/0002/18-19 2018-04-17 35 35 0 359.00
PRDGD/0002/18-19 2018-04-17 -35 0 -35 324.00
TRNGD/0001/18-19 2018-04-17 -45 0 -45 279.00


Please quide me

one more thing when i insert null values for var binary field then its works fine
i.e
string qry = "insert into tblComplaintMaster values('" + complNo + "','" + finyr + "',Convert(Date,'" + complDt + "'),'" + complNature + "','" + product + "','" + srno + "'," + issueid + ",'" + descr + "','" + assignto + "','" + reqBy + "','" + contact + "','" + email + "','" + loc + "','" + priority + "','" + txtStatus.Text + "','" + fromTime + "','" + toTime + "',null,null,null,null,null)";
cmd = new SqlCommand(qry);
con.Open();
cmd.Connection = con;

int result = cmd.ExecuteNonQuery();
Response.Write("Result=" + result);
Then gives result=1 as output that means values inserted to database sucessfully

@john Simmons

In my application when i am checking whether file is attached or not using this

if (callReportFileUpload.HasFile)
{
Response.Write("has file");
}
and to checking data in bytes array using Response.Write as follows

string filename = Path.GetFileName(callReportFileUpload.PostedFile.FileName);
Stream str = callReportFileUpload.PostedFile.InputStream;
BinaryReader br = new BinaryReader(str);
Byte[] bytes = br.ReadBytes((int)str.Length);
Response.Write(bytes.Length);

and your 3 rd point record being inserted or not ? I am checking this is using
int result = cmd.ExecuteNonQuery();
Response.Write("Result=" + result);
Then it doesn't gives any result either 0 or 1.
Ant your 4th point it doesn't gives any exception also

yes,just i add this line in y application but it doesn't show any output.

Response.Write("Result=" + result); it doesn't show any output.I am not understand where is the problem.

yes you are right.I got my mistake thanks a lot.

no .
datatype of fromTime and totime is Time

In my table this is record set

Id complNo complDate complNature assignto priorit status fromtime totime

1. B0001/17-18 2018-03-1 Bugs HEMANT High Active 12:15 02:15
2. B0001/17-18 2018-03-21 Bugs HEMANT High Active 12:15 01:15

According to my query result will be

2. B0001/17-18 2018-03-21 Bugs HEMANT High Active 12:15 01:15
but it does not show any record.

I solved above issue using
ClientScript.RegisterStartupScript(GetType(), "closePage", "<script type=\"text/JavaScript\">window.opener.location.href='RedirectAnotherPage.aspx'; window.close();");

THANKS Sir.

what is use of this https://plnkr.co/edit/?p=catalogue link?

when i replace above code then also it gives same error - JavaScript runtime error: Object doesn't support property or method 'getElementsByClassName' AT
var lbl = selectedRow.getElementsByClassName('clsRemarksGrid')[0]

This is my code for that

<asp:TemplateField HeaderText="">
<itemtemplate>
<asp:LinkButton ID="lnkRemark" Text="Add Remark" OnClientClick="showpopup(this); return false" runat="server">

in google chrome popup window disappears within second so i am not able to test

is there any problem because of internet explorer version?

<asp:GridView runat="server" ID="gridView1" DataKeyNames="ENTRYNO"
AutoGenerateColumns="false">
<columns>
<asp:BoundField DataField="ENTRYNO" HeaderText="ENTRYNO" />
<asp:TemplateField HeaderText="A">
<itemtemplate>
<asp:CheckBox ID="ChkApproved" runat="server">
<asp:TemplateField HeaderText="Remarks">
<itemtemplate>
<asp:Label ID="lblRemarksGrid" CssClass="clsRemarksGrid" runat="server" Text="" Width="200Px">
<asp:TemplateField HeaderText="">
<itemtemplate>
<asp:LinkButton ID="lnkRemark" Text="Add Remark" OnClientClick="showpopup(this); return false" runat="server">

if (!Page.IsPostBack)
{

DataTable dt = new DataTable();
dt.Columns.Add("ENTRYNO");
for (int i = 0; i < 5; i++)
dt.Rows.Add(i);
gridView1.DataSource = dt;
gridView1.DataBind();

}

Check this,
var selectedRow = undefined;
function showpopup(obj) {
var modal = document.getElementById('myModal');
modal.style.display = "block";
selectedRow = obj.parentElement.parentElement;
if (selectedRow) {
var lbl = selectedRow.getElementsByClassName('clsRemarksGrid')[0]
var value = lbl.toString;

document.getElementById('txtRemarks').value = value;
}
}
function closepopup() {
var modal = document.getElementById('myModal');
modal.style.display = "none";
}
function okpopup() {
debugger
var modal = document.getElementById('myModal');
modal.style.display = "none";
if (selectedRow) {
var lbl = selectedRow.getElementsByClassName('clsRemarksGrid')[0]
var value = document.getElementById('txtRemarks').value;
lbl.textContent = value;
}
}



/* The Modal (background) */
.modal {
display: none; /* Hidden by default */
position: fixed; /* Stay in place */
z-index: 1; /* Sit on top */
padding-top: 100px; /* Location of the box */
left: 0;
top: 0;
width: 100%; /* Full width */
height: 100%; /* Full height */
overflow: auto; /* Enable scroll if needed */
background-color: rgb(0,0,0); /* Fallback color */
background-color: rgba(0,0,0,0.4); /* Black w/ opacity */
}

/* Modal Content */
.modal-content {
position: relative;
background-color: #fefefe;
margin: auto;
padding: 0;
border: 1px solid #888;
width: 400px;
box-shadow: 0 4px 8px 0 rgba(0,0,0,0.2),0 6px 20px 0 rgba(0,0,0,0.19);
-webkit-animation-name: animatetop;
-webkit-animation-duration: 0.4s;
animation-name: animatetop;
animation-duration: 0.4s;
}

/* Add Animation */
@-webkit-keyframes animatetop {
from {
top: -300px;
opacity: 0;
}

to {
top: 0;
opacity: 1;
}
}

@keyframes animatetop {
from {
top: -300px;
opacity: 0;
}

to {
top: 0;
opacity: 1;
}
}

/* The Close Button */
.close {
color: white;
float: right;
font-size: 28px;
font-weight: bold;
}

.close:hover,
.close:focus {
color: #000;
text-decoration: none;
cursor: pointer;
}

.modal-header {
padding: 5px;
background-color: #5cb85c;
color: white;
}

.modal-body {
padding: 5px;
height: 100px;
}

.modal-footer {
padding: 2px 16px;
background-color: #5cb85c;
color: white;
}
<asp:GridView runat="server" ID="gridView1" DataKeyNames="ENTRYNO"
AutoGenerateColumns="false">
<columns>
<asp:BoundField DataField="ENTRYNO" HeaderText="ENTRYNO" />
<asp:TemplateField HeaderText="A">
<itemtemplate>
<asp:CheckBox ID="ChkApproved" runat="server">


<asp:TemplateField HeaderText="Remarks">
<itemtemplate>
<itemt

Again it gives same exception - JavaScript runtime error: Object doesn't support property or method 'getElementsByClassName' AT

var lbl = selectedRow.getElementsByClassName('clsRemarksGrid')[0]

yes.when i type selectedRow. then it doesnot show such method ;i.e getElementByclassName()

@karthik
I have tried your solution but shows me this error
JavaScript runtime error: Object doesn't support property or method 'getElementsByClassName' at
var lbl = selectedRow.getElementsByClassName('clsRemarksGrid')[0]

Thanks.
Please Share realated link or code

thanks all.
I solved the problem.In above case i just forgot to set autopostback="true" property of checkbox.

i tried using session instead of viewstate but problem remains same.

see the following javascript code for count(selected entries)


function SelectAllCheckboxes(chk) {
$('#&lt;%=gvAppvrDetail.ClientID %>').find("input:checkbox").each(function () {
if (this != chk) {
this.checked = chk.checked;
}
});
CheckBoxCount1();
}
function CheckBoxCount1() {
var gv = document.getElementById("&lt;%= gvAppvrDetail.ClientID %>");
var inputList = gv.getElementsByTagName("input");
var numChecked = -1;

for (var i = 0; i &lt; inputList.length; i++) {
if (inputList[i].type == "checkbox" && inputList[i].checked) {
numChecked = numChecked + 1;
}
}
var label = document.getElementById("&lt;%=lblcntRows.ClientID %>");

label.innerHTML = numChecked;
document.getElementById("&lt;%=lblcntRows.ClientID %>").value = label.innerHTML;

}


function CheckBoxCount() {
var gv = document.getElementById("&lt;%= gvAppvrDetail.ClientID %>");
var inputList = gv.getElementsByTagName("input");
var numChecked = 0;

for (var i = 0; i &lt; inputList.length; i++) {
if (inputList[i].type == "checkbox" && inputList[i].checked) {
numChecked = numChecked + 1;
}
}

var label = document.getElementById("&lt;%=lblcntRows.ClientID %>");

label.innerHTML = numChecked;

document.getElementById("&lt;%=lblcntRows.ClientID %>").value = label.innerHTML;
}

thanks a lot @Peter_in_2780.
It solve my problem.

Its ajax control

as per my knowledge ajax combobox allows user autocomplete textbox using AutoCompleteMode="SuggestAppend" property

actually i am new to this concept.i have not added any user control.Please guide me how to use this.

No

In my code combobox is bind in page_load().

protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
LoadLocationList();
}

}

private void LoadLocationList()
{
SqlConnection con = null;
SqlCommand cmd = null; ;
SqlDataReader dr;
try
{
con = new SqlConnection(ConfigurationManager.ConnectionStrings["CRMConnection"].ConnectionString);

cmd = new SqlCommand("select locationname from dbo.tbl_LocationMaster");
con.Open();
cmd.Connection = con;
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
//dr = cmd.ExecuteReader();
if (ds.Tables[0].Rows.Count > 0)
{

cmbLocationList.DataSource = ds;
cmbLocationList.DataBind();
cmbLocationList.DataTextField = "locationname";
cmbLocationList.DataValueField = "locationname";
cmbLocationList.DataBind();
cmbLocationList.Items.Insert(0, new ListItem(" ", ""));
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", "alert('No Data Found')", true);
}
}
catch (Exception ex)
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Message", "alert('" + ex.Message + "')", true);
}
finally
{
cmd.Dispose();
con.Close();
}

}

but how can encode these values?

yes its working

it means when i am going click on ActiveBugs hyperlink then it will be type=="Bugs" and status="Active".Like that i have several hyperlink as follwoing

1.ActiveBugs here type="Bugs" and status="Active"
2.ResolevdBugs here type="Bugs" and status="Closed"
3.ActiveRequirement here type="Requirement" and status="Active"
4.ResolevdRequirement here type="Requirement" and status="Closed".

I had also tried like this(using Hiddenfield)

<asp:HiddenField ID="hdtype" Value="Bugs" runat="server" />
<asp:HiddenField ID="hdstattus" Value="Active" runat="server" />
<asp:HyperLink id="hyperlink2"

NavigateUrl='<%# string.Format("~/frmCompliantView.aspx?&type={0}&status={1}",Eval("hdtype"),Eval("hdstattus")) %>'
Text="Active Bugs" runat="server"/>
but it's not working.

Ok

Thanks @Thomas
But here i have vertical menu bar(created using ajax) that i want to show in left hand side of each page .

Yes when i did that
select @cols = STUFF((SELECT distinct ',' + QUOTENAME(STATENAME)
from (
(select CODE from FARVISIONDB..M_STATEWISEGSTINACTAG) e inner join
(select CODE,STATENAME from FARVISIONDB..M_STATEMASTER) f on e.code=f.code
)
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')
print @cols;
i am not able to write @dbnm(Variable) instead of FARVISIONDB .

yes Richard u are correct

I also tried this it gives mi same error.
For further clearance Please check my stored procedure..

create procedure [dbo].[GSTIN_Update]
AS
BEGIN

DECLARE @cols AS NVARCHAR(MAX),
@query AS NVARCHAR(MAX)

select @cols = STUFF((SELECT distinct ',' + QUOTENAME(STATENAME)
from (
(select CODE from FARVISIONDB..M_STATEWISEGSTINACTAG) e inner join
(select CODE,STATENAME from FARVISIONDB..M_STATEMASTER) f on e.code=f.code
)
FOR XML PATH(''), TYPE).value('.', 'NVARCHAR(MAX)') ,1,1,'')
print @cols;

set @query = 'SELECT CtrlAc, DESCR,' + @cols + ' from
(select c.CtrlAc,a.DESCR,s.GSTIN,stcd.statename from
(select accd,descr,MAINACCD from FARVISIONDB..M_LEDGER) as a inner join
(select code,Gstin,accd from FARVISIONDB..M_STATEWISEGSTINACTAG) as s on a.ACCD = s.ACCD inner join
(SELECT CODE,STATENAME,UT FROM FARVISIONDB..M_STATEMASTER) as STCD on s.CODE=stcd.CODE INNER JOIN
(SELECT ACCD,DESCR AS CtrlAc from FARVISIONDB..M_LEDGER) as C on c.ACCD=a.MAINACCD
) x
pivot
(
MAX(GSTIN)
for statename in (' + @cols + ')
) p '
execute(@query)
PRINT @query;
END;

This is MY static procedure i just want replace FARVISIONDB by @dbnm parametere.
here @Cols contains state name which i have used in @query.
i.e @Cols contains

[BIHAR],[DADRA AND NAGAR HAVELI],[DAMAN & DIU],[DELHI],[GOA],[GUJARAT],[HARYANA],[JHARKHAND],[KARNATAKA],[MADHYA PRADESH],[MAHARASHTRA],[RAJASTHAN],[TAMILNADU],[TELANGANA],[UTTAR PRADESH]

yes i had tried .Is working when i provide manual database name

no.I mean in 1 st query .I have print command so its results my second query which i shown above.That means my query executed up to print statement but when i am going to execute @cols then it shows error like

Msg 156, Level 15, State 1, Line 6
Incorrect syntax near the keyword 'FOR'.

yes

I could not use a separate query like you above shown.Here i have dropdownlist with values Pending ,Certified, All .Where My table has WDNO column with NULL means PENDING AND Some value like 'WDNLAK/00008/17-18' means CERITIFIED .
When i choose All option from dropdownlist then result contain pending records + certified records.For that purpose i have use Case statement in above my query.

thanks @RickZeeland but @status='' here '' it used for pending + certified value.
i.e it should display both pending and certified values.

thanks..

Done..

when i added existing report respectively original in report header and duplicate added in page header.Then it works perfect but when i am going to add triplicate report then it not works.I am now confused ,where to add sub report in section.

yes. i have added one subreport in report header and one added in page header section .Am i Correct?

you mean i have to design separate copy for original,duplicate and triplicate and all those sub report in original report.

OK

yes i am using store procedure to show invoice details.

then what operation will be performed on logout link click?

Ok.

you mean like this
var nodes = (xmlDoc.GetElementsByTagName("UserName")[0]);

Error 1 'System.Xml.XmlNode' does not contain a definition for 'GetElementsByTagName' and no extension method 'GetElementsByTagName' accepting a first argument of type 'System.Xml.XmlNode' could be found (are you missing a using directive or an assembly reference?) D:\SujataShare\JKViasion17042017\JKVision\JKVision\Site.Master.cs 65 68 JKVision

Now it shows error at
var nodes = (xmlDoc.GetElementsByTagName("Rights")[0]).GetElementsByTagName("Right");

i can't understand what you are asking.

thanks @Wessel

but following line shows errors
//i think deceleration error in var userlist
var userList = new list(of string, string)

var nodes = (xmlDoc.GetElementsByTagName("Rights")[0]).GetElementsByTagName("Right");

Somebody please help me...

hey i solve my issue just little change in above code i.e
List<listitem> files = new List<listitem>();
f (!this.IsPostBack)
{
string[] filePaths = Directory.GetFiles(Server.MapPath("~/Files/"));

foreach (string filePath in filePaths)
{
files.Add(new ListItem(Path.GetFileName(filePath), filePath));
}
}

it works for me

i just use
response.write("alert('"+file.FullName+"')")

i tried but not working for me
when print file.FullName in looks like
D:SujataWebApplicationZipFileDemoZipFileDemoDownloadLibraryPBLWRM0000116-17.pdf
instead of
D:\Sujata\WebApplication\ZipFileDemo\ZipFileDemo\DownloadLibrary\PBLWRM0000116-17.pdf

yes yes u are correct.I will check your above solution

Thanks @Karthik
but iterate foreach like this
DirectoryInfo dir = new DirectoryInfo(@"D:/PDFFiles/");

FileInfo[] files = dir.GetFiles();

foreach (FileInfo file in files)
{
string fileName = Path.GetFileName(file.ToString());
ListItem item = new ListItem(fileName);
cblFiles.Items.Add(item);
}

Here files is FileInfo[] type array ND I have added directory files to files .So i have path na

thanks @Richard

is there any other way

ok.I in my task i have to provide folder selection for user where user can download all files

but file upload does not provide folder selection functionality.We can just select file i want folder selection.

exactly.. but how to do that?

thanks sir for reply

but In my web application user has browse and download Button when it click on browse button then it requires folder selection for download all files in same folder.

PrincipalContext ctx = new PrincipalContext(ContextType.Domain);

// define a "query-by-example" principal - here, we search for all users
UserPrincipal qbeUser = new UserPrincipal(ctx);

// create your principal searcher passing in the QBE principal
PrincipalSearcher srch = new PrincipalSearcher(qbeUser);

// find all matches
foreach (var found in srch.FindAll())
{
//Label1.Text = found.Name;
// do whatever here - "found" is of type "Principal" - it could be user, group, computer.....
DropDownList1.Items.Add(found.Name);
DropDownList2.Items.Add(found.UserPrincipalName);
}

i got solution...

Ye..i got solution

Please give mi solution for above post..

Thanks Karthik sir,
I got solution .
Follwoing code downloads multiple files from database and save on disc.It works perfectly in my case.

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{


// DialogResult result = this.folderBrowserDialog1.ShowDialog();
con.Open();
using (SqlCommand cmd = new SqlCommand("select Name, ContentType, Data from ImageTable"))
{
cmd.Connection = con;
DataTable objTable = new DataTable();
SqlDataAdapter objAdapter = new SqlDataAdapter(cmd);
// objAdapter.MissingSchemaAction = MissingSchemaAction.AddWithKey;
SqlCommandBuilder sqlCmdBuilder = new SqlCommandBuilder(objAdapter);
objAdapter.Fill(objTable);
foreach (DataRow objRow in objTable.Rows)
{
byte[] objData = (byte[])objRow["Data"];
var firstNBytes = objData.Take(4);
Byte[] threeBytes = new Byte[] { objData[0], objData[1], objData[2], objData[3] };
var bytesToCompare = Encoding.Unicode.GetBytes("0x25");
bool equal = firstNBytes.SequenceEqual(bytesToCompare);
string hex = BitConverter.ToString(threeBytes);
hex.Replace("-", "");



string strFileToSave = "D:\\PDFFiles\\" + Guid.NewGuid();
if (hex == "25-50-44-46")
{
strFileToSave += ".pdf";
}
else
{
strFileToSave += ".jpg";
}


FileStream objFileStream = new FileStream(strFileToSave, FileMode.Create, FileAccess.Write);
objFileStream.Write(objData, 0, objData.Length);
objFileStream.Close();
}

}
}

Ok..
i will try

Following code i used for download PDF when download linkButton of gridview click.
i.e by passing particular id

protected void lnkDownload_Click(object sender, EventArgs e)
{
LinkButton lnkbtn = sender as LinkButton;
GridViewRow gvrow = lnkbtn.NamingContainer as GridViewRow;
int fileid = Convert.ToInt32(gvDetails.DataKeys[gvrow.RowIndex].Value.ToString());

using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand())
{
cmd.CommandText = "select Name, ContentType, Data from ImageTable where id=@Id";
cmd.Parameters.AddWithValue("@Id", fileid);
cmd.Connection = con;
con.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{
Response.ContentType = dr["ContentType"].ToString();
Response.AddHeader("Content-Disposition", "attachment;filename=\"" + dr["Name"] + "\"");
Response.BinaryWrite((byte[])dr["Data"]);
Response.End();
byteArray = (byte[])dr["Data"];
string result = System.Text.Encoding.UTF8.GetString(byteArray);
list.Add(result);

}
}
}

ok..
but how can do that? as per ur above link..
string sPathToSaveFileTo = @"C:\SelectedFile.pdf";
// on this path i will create selected PDF File Data open pdf for checking

this only for selected file but i want to perform download action on btnDownloadAll_Click().i.e.Download all file in single select query.

thanks,Karthik sir.
As per understanding above link save individual pdf to the disc.but i want simultaneously download or create zip folder of all pdf stoared in database

yeeeh,
I solved the problem
here i replace <asp:hyperlink> by <asp:linkbutton>
as follows
<asp:LinkButton ID="LinkButton1" onclick="LinkButton1_Click" runat="server">Logout

and c# function as
protected void LinkButton1_Click(object sender, EventArgs e)
{

string unm = this.Context.Request.LogonUserIdentity.Name;

string clientMachineName;
clientMachineName = (Dns.GetHostEntry(Request.ServerVariables["remote_addr"]).HostName);


string ip = (Request.ServerVariables["HTTP_X_FORWARDED_FOR"] ??
Request.ServerVariables["REMOTE_ADDR"]).Split(',')[0].Trim();

string lmdt = DateTime.Now.ToString();
LogActivity log = new LogActivity();
log.CreateLogFile(unm, clientMachineName, ip, lmdt, "Log-out");


ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "text", "Logout()", true);

}

and same javascript:Logout() function

problem is that how can i call both java-script function and c# function on same <asp:hyperlink> control.
here java-script function for logout i.e for window.close and c# function for save logout detail.

yeehh,
I solved problem.
thanks @Richard and F-ES Sitecore

@Richard

sir i did that like,
cmd.Parameters.Add("@Data", SqlDbType.VarBinary,8000).Value=bytes;

but still its not working

but sir,
in my case varbinary(MAX) working for some pdf file like
New Doc 10.pdf - application/pdf
Formwork Checklist.pdf - application/pdf
RFI.pdf - application/pdf
PBILLJG0050715-16.pdf - application/pdf
PBILLJG0051315-16.pdf - application/pdf

and for some pdf file its not working.
Is there any version issue?

thanks Richard.
but i can not find BLOB datatype in sql server 2008 R2

thanks for quick reply.
Here i have 4 columns for my ImageTable as
id int not nill,
Name varchar(25)null,
ContentType varchar(25)null,
and
Data varBinary(MAX)

Still I haven't solve this issue.Please help me

I am New to MVC concept thats why have begun from MVC2 .If i start directly from higher version then i never understand drowbacks of MVC2.I will do Some practice on MVC2 then i will move to higher version.


thanks for your advise.
As per your solution I did that but it gives another error like that...

foreach statement cannot operate on variables of type 'MvcCRUDApplication.Models.CRUDModel' because 'MvcCRUDApplication.Models.CRUDModel' does not contain a public definition for 'GetEnumerator'

Thanks Sinisa .
I solved my problem when i put my Index View under Views/Shared Folder.
thanks again for your early response.

No my Index is as Views/Index.aspx .

@Richard
I used debugger and also rewrite code then also same issue.
Also I used smtp.rediffmail.com in separate program still same issue.

thanks for your early reply

already changed still not working i gives following exception
InvalidOperationException ....The SMTP Host is not specified

how to use web service within my web application for such task?

I want GrandTotal at Maximum of SRNO

Thanks,
It's Still fine than my output.But now i want how to put GrandTotal Row at Bottom.

Here I have used with rollup for calculating sum of perticular column at bottom ,I got result but grand total row should be at bottom of query result Instead my result it display at top.

Thanks @Andy Lanng.
It Really helpful for me.I Solved my problem by changing DefaultAppPool setting of .net framework version to 4.0 in in Application pool.It Work.....

Here I got the following Script ,Which gives me all Backup file within particular Folder.Its correct but i want only 3 Latest File .So If anyone have idea ,then give me.



IF OBJECT_ID('tempdb..#DirectoryTree') IS NOT NULL
DROP TABLE #DirectoryTree;

CREATE TABLE #DirectoryTree (
id int IDENTITY(1,1)
,subdirectory nvarchar(512)
,depth int
,isfile bit);

INSERT #DirectoryTree (subdirectory,depth,isfile)
EXEC master.sys.xp_dirtree 'D:\Sujata\SALESDBBackup',1,1;

SELECT *--,ROW_NUMBER()over (order by id desc)
FROM #DirectoryTree
WHERE isfile = 1 AND RIGHT(subdirectory,4) = '.BAK'
ORDER BY id desc;
ELSE

GO

C#

I want stored procedure for retrieve list of files (*.BAK) from particular folder.

Thanx @Maciej Los It's Really helpful for me.

but here i decalred list of class type means List<> itemDetails=new list<>()
Here List is of RepeaterData Class Type

thanx

List is declared like that
List<repeaterdata> itemDetails=new List<repeaterdata>();

In Default.aspx.cs
like
List<repeaterdata> itemDetails = new List<repeaterdata>();

protected void BtnAdd_Click(object sender, EventArgs e)
{

itemDetails = GetItemDetails();
GridView1.DataSource = itemDetails;
GridView1.DataBind();

}

protected List<repeaterdata> GetItemDetails()
{
RepeaterData data = new RepeaterData();
data.INo = Convert.ToInt32(ItemNoList.Text);
data.IName = ItemNameList.Text;
data.Val1 = TxtVal1.Text;
data.Val2 = TxtVal2.Text;
data.Val3 = TxtVal3.Text;
data.Val4 = TxtVal4.Text;
data.Total = TxtTotal.Text;

itemDetails.Add(data);
con.Close();
return itemDetails;
}


}

sir,In your code snippet what is items.is it class or xml object

I think this will be helpful for me.Let me try.
thanks

thanx

application exit means browser close.
collect item from several webpages means take example of online shopping like that i have to add several item of different categories in single list.

thanx.
here i want to collect item from several webpages and add in single list.For that i uesd static list in app_code/Class.cs .I got correct list but when my application exit then my list is still as it is.I want to reset my static list.

thanks. The code in ItemSelection.aspx.cs page_load event as

protected void Page_Load(object sender, EventArgs e)
{
Class1 c = new Class1();

if (Request.QueryString["FilePath"] != null)
{
Session["itemcount"] = Convert.ToInt32(Session["itemcount"]) + 1;
int count = Convert.ToInt32(Session["itemcount"].ToString());
//here label2 is used for no.of item selected
label2.Text = count.ToString();
//list2 is used for store selected item
List<string> list2 = new List<string>();

//Response.Write("count=" + count);
//Here we add selected item in list2

list2.Add(Request.QueryString["FilePath"]);

// then i added this list into static list created in class under app_code/class

c.setArr(list2);
Session["itemList"]= c.getArr();

//If item selected then only i have created dynamic div with image control
if (count > 0)
{
for (int i = 0; i < count; i++)
{
HtmlGenericControl div1 = new HtmlGenericControl("div");

string j = (i + 1).ToString();
div1.Attributes.Add("id", "j");
//Response.Write(div1.Attributes.ToString());
div1.Attributes.Add("class", "top_rounded");
Image img = new Image();

//List<string> a = c.listItem;
List<string> a = (List<string>)Session["itemList"]; img.ImageUrl = a[i];
div1.Controls.Add(img);
Panel1.Controls.Add(div1);
}
}

see my newly posted code from details

thanx for ur reply .But I already used this website.It gives same problem.All other information displayed correctly only image shows cross mark.

Here i retrieve image from sql server.

See My newly posted code .

Thanx for ur reply...

My designing page include DataList control like that
<asp:DataList ID="DataList1" runat="server" RepeatColumns="4" RepeatDirection="Horizontal"Width="100%" BorderColor="Blue" BorderStyle="Solid" BorderWidth="3px">

<itemtemplate>

<asp:Label ID="Label2" runat="server" Text='<%# Eval("imagename") %>' Font-Italic="true"/><br />

<asp:Image ID="Image1" runat="server" ImageUrl='<%# "GetImageDatafromDB.aspx?id=" + System.Convert.ToString(Eval("ImageID")) %>'/>

<itemstyle horizontalalign="Center" verticalalign="Top">


//Code in the pageload event
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
string connectionString = ConfigurationManager.ConnectionStrings["MyConnection"].ConnectionString;
DataTable dt = new DataTable();
SqlConnection conn = new SqlConnection(connectionString);
using (conn)
{
SqlDataAdapter ad = new SqlDataAdapter("SELECT * FROM ImageGrid", conn);
ad.Fill(dt);
}
DataList1.DataSource = dt;
DataList1.DataBind();
}
}
// And the code in page load of GetImageDatafromDB.aspx
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
string imageID = Request.QueryString["id"];

string constr = ConfigurationManager.ConnectionStrings["MYConnection"].ConnectionString;
string sQuery = "SELECT image FROM ImageGrid WHERE imageID = @imageID";

SqlConnection con = new SqlConnection(constr);
SqlCommand cmd = new SqlCommand(sQuery, con);

cmd.Parameters.Add("@imageID", SqlDbType.Int).Value = Int32.Parse(imageID);

using (con)
{
con.Open();
SqlDataReader DR = cmd.ExecuteReader();

if (DR.Read())
{
byte[] imgData = (byte[])DR["Image"];
Response.BinaryWrite(imgData);
}
}
}

Thanx .Its really helpful for me.

thanx.I will be helpful for me.

I have used .net framework 4.0