Comments by Aboobakkar Siddeq D U (Top 75 by date)

My aim is to make a file as copyright file format, so that nobody can copy my file.

It showing error like "no suitable method found to override", what is this error? please tell me how to fix this error?

It means that file should not able to copy.

No I don't want to delete, that file should be there, and by clicking on another button that file should be accessible.

I want to do same actions from the code behind, using C#, asp.net. By using code I want to change access denied of files.

No I dont want to delete it and I want make it as Access denied to all users. So could you please help me.

Yes I did many research from last week, and I didn't get any solution to make access denied folder.

earlier it was working, i did many small projects, but in that project it was working....and now it is not working.

I didn't get any solution from your solutions, I didn't understand that

using Microsoft.Reporting.WebForms; is getting error

Here in your code i can't see DataTable, In my case I have values in DataTable and now I want to get DataTable values in PDF report, It should download automatically when button is clicked.

Here I want to get DataTable values in PDF file

No....still its getting same error

Which namespace should I add to this?

NOW I AM GETTING THIS ERROR

Server Error in '/report' Application.

Security Exception

Description: The application attempted to perform an operation not allowed by the security policy. To grant this application the required permission please contact your system administrator or change the application's trust level in the configuration file.

Exception Details: System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.

Source Error:


[No relevant source lines]

Source File: App_Web_ame2uqid.0.cs Line: 0

Stack Trace:


[SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.]
System.Security.CodeAccessSecurityEngine.Check(Object demand, StackCrawlMark& stackMark, Boolean isPermSet) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap, StackCrawlMark& stackMark) +31
System.Security.CodeAccessPermission.Demand() +46
System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) +654
System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy) +60
System.IO.FileStream..ctor(String path, FileMode mode) +55
System.Web.HttpPostedFile.SaveAs(String filename) +94
System.Web.UI.WebControls.FileUpload.SaveAs(String filename) +23
ADMIXS.AdminPanel.AddFranchisee.btnSubmit_Click(Object sender, EventArgs e) in AddFranchisee.aspx.cs:134
System.EventHandler.Invoke(Object sender, EventArgs e) +0
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +9556538
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +103
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +10
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +35
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +6704
System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +245
System.Web.UI.Page.ProcessRequest() +72
System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context) +21
System.Web.UI.Page.ProcessRequest(HttpContext context) +58
ASP.adminpanel_addfranchisee_aspx.ProcessRequest(HttpContext context) in App_Web_ame2uqid.0.cs:0
System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.18067

Let me check for that........

How to check for folder permission? I went through FileZilla and right button clicked on images folder, then clicked on Properties then I saw
1. Owner Permissions
2. Group Permissions
3. Public Permissions
I checked all options but still getting same problem.

Is there other changes to do in that?

How to check for folder permission? I went through FileZilla and right button clicked on images folder, then clicked on Properties then I saw
1. Owner Permissions
2. Group Permissions
3. Public Permissions
I checked all options but still getting same problem.

Is there other changes to do in that?

Wow Thanks a lot......I got this now. Again Thanks for your answer.

Sorry!!! This query is not returning any values. Then I did some changes in this query, but no values returned.

Sorry!!! I tried this, but this query is returning totally One record only. But here I want to return one record per each user.

No I tried this, but this query is returning same two records for one users. Is there any other way???

Ok I added there but I can't see now, because now USA date is same as Indian Date.

I don't how to use? where to use? please help me

No I didn't use anything.

Now I'm Using like this

txtRegDate.Text = DateTime.Now.ToShortDateString();

How Can I change this line to solve my problem please?

I tried many times, where should I change date format? In frontend or backend? How to change format of DateTime?

No I don't think so, because i've tried this and i'm getting in this

select a.userid as [UserID],b.fullname as [Full Name],CONVERT(date,a.regdate,112) as [Joined Date],a.period as
[Month Period],a.unitno as [UnitNo],b.address as [Address] from users a join profiles b on a.accountid=b.accountid
where (1=1) And a.regdate >= '08/01/2013' And a.regdate <= '08/25/2013' And a.membertype =3

Thanks a lot. Wish you all the best

Thanks a lot

ok thanks a lot for your information, i'm a fresher so i don't know much about development. Please tell me how to Export data from 2 table into a single excel sheet at a time?

I want to set it in SQL Server itself. How can I?

I tried this

DataSet ds = new DataSet();
ds.Tables.Add(ds1.Tables[0]);
ds.Tables.Add(ds2.Tables[0]);
ds.Tables.Add(ds3.Tables[0]);
ds.Tables.Add(ds4.Tables[0]);

but i'm getting error like this "DataTable already belongs to another DataSet."

Yeah I have 4 different tables, each tables contains one columns and I didn't add any column to gridview, I want to bind it directly from tables. How can I?

Your query is gives error like this:

Msg 8127, Level 16, State 1, Line 5
Column "AmountMaster.CustomerId" is invalid in the ORDER BY clause because it is not contained in either an aggregate function or the GROUP BY clause.

No here i'm getting same error, I don't want the sum of TotalAmount, I want only PaidAmount sum here. For Ex. CustomerId = 1 has many values in "AmountMaster" Table, so I don't want sum of TotalAmount, but i want sum of PaidAmount from "PaymentMaster" with same userid

No here i'm getting same error, I don't want the sum of TotalAmount, I want only PaidAmount sum here. For Ex. CustomerId = 1 has many values in "AmountMaster" Table, so I don't want sum of TotalAmount, but i want sum of PaidAmount from "PaymentMaster" with same userid

No here i'm getting same error, I don't want the sum of TotalAmount, I want only PaidAmount sum here. For Ex. CustomerId = 1 has many values in "AmountMaster" Table, so I don't want sum of TotalAmount, but i want sum of PaidAmount from "PaymentMaster" with same userid

I'm using this inside Row_Command

protected void gvBlackAmount_RowCommand(object sender, GridViewCommandEventArgs e)
{
try
{

if (e.CommandName == "Update")
{
int customerId = int.Parse(e.CommandArgument.ToString());

Session["CustomerId"] = customerId;
//BindCustomerDetails(customerId);
//BindBalance(customerId);

string getVal = "select * from CustomerDetails where CustomerId=" + customerId;
DataSet ds = _bindDetails.GetDataSet(getVal);
if (ds.Tables[0].Rows.Count > 0)
{
txtCustomerName.Text = ds.Tables[0].Rows[0]["CustomerName"].ToString();
txtTotalValue.Text = ds.Tables[0].Rows[0]["TotalValue"].ToString();
txtAgreementValue.Text = ds.Tables[0].Rows[0]["AgreementValue"].ToString();
txtBalanceAmount.Text = (decimal.Parse(txtTotalValue.Text.ToString()) - decimal.Parse(txtAgreementValue.Text.ToString())).ToString();
}
}
}
catch (Exception ex)
{
ex.Data.Clear();
}
}

yes it's already there

public DataSet GetDataSet(string a_strDataSource)
{
if (_sConn.State != ConnectionState.Open)
{
_sConn.Open();
}
System.Data.SqlClient.SqlDataAdapter myAdapter;
DataSet DS;
try
{
DS = new DataSet();
myAdapter = new System.Data.SqlClient.SqlDataAdapter(a_strDataSource, _sConn);
myAdapter.SelectCommand.CommandTimeout = _connectionTimeout;
myAdapter.Fill(DS);
myAdapter.Dispose();
myAdapter = null;
return DS;
}
catch (Exception ex)
{
ex.Data.Clear();
return null;
}
finally
{
_sConn.Close();
}
}

Thanks a lot, it works fine now

I used this code

<pre lang="cs">
dt.Columns.Add("TotalProfit");
dt.AcceptChanges();
foreach (DataRow row in dt.Rows)
{
row["TotalProfit"] = Convert.ToDouble(row["PaidAmount"].ToString()) - Convert.ToDouble(row["ActualPaid"].ToString());
}
dt.AcceptChanges();</pre>

Thanks,,,but it showing error like this "the name commandtype does not exist in the current context"

Thanks a lot

I changed query like this

select Convert(varchar, DateOfTerminate ,110) from UserDetails

Now I got answer this, i changed query

Thanks for reply, But actually i'm binding directly from backend, First i'm getting data into DataTable and i'm binding to gridview like this

<pre lang="c#">SqlDataAdapter adp = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adp.Fill(dt);
if (dt.Rows.Count > 0)
{
gvReports.DataSource = dt;
gvReports.DataBind();
}</pre>

For example now I select one DoctorName("Arun Prashad") using Ajax auto complete extender, Now i want to get ("Arun Prashad") DoctorId. So how can I get it?

Yes I tried, I got this by adding like this

set @sql = @sql + ' And DoctorName like ''' + @DoctorName + '%'''

I mean i want to use query like this

if @DoctorName is not null
set @sql = @sql + ' And DoctorName like =''' + @DoctorName + '%'''


Can I use use like this?

I want to get records like first letter
Ex: select * from Doctorlist where DoctorName like @Doctorname + %

Can you tell me How Can I Add 'Like' condition to all conditions?

Thanks a lot...........Mr. Maciej Los. I solved this with your solution thanks a lot.

Can you tell me what is the problem in my code here? Also i tried this

@Name Nvarchar(250),
@Country Nvarchar(250),
@State Nvarchar(250),
@Speciality Nvarchar(250),
@Email Nvarchar(250),
@Grade Nvarchar(250)


as

BEGIN

DECLARE @sql AS NVarchar(4000)

SET @sql = 'SELECT * FROM Doctorslist where (1=1)'

if @Name is not null
set @sql = @sql + ' And (DoctorName = @Name)'

if @Country is not null
set @sql = @sql+ ' And (Country = @Country)'

if @State is not null
set @sql = @sql + ' And (State = @State)'

if @Speciality is not null
set @sql = @sql + ' And (Speciality = @Speciality)'

EXEC(@sql)
END

How to write @WhereStatement here?

I tried this but this doesn't work
DECLARE @sql VARCHAR(MAX)
SET @sql = N'SELECT * FROM DoctorsList where'
IF (NOT @Name IS NULL)
SET @sql = @sql + 'DcotorName='+@Name

IF(not @Country is null)
set @sql=@sql+'and Country='+@Country

if(not @State is null)
set @sql=@sql+'and State='+@State

if(not @Speciality is null)
set @sql=@sql+'and Speciality='+@Speciality

EXEC(@sql)
END

Sorry Mr.Raja Sekhar S I want to try many conditions here, i'm getting error on this, my conditiong in like this


@DoctorName varchar(255),
@Degree varchar(255),
@Speciality varchar(255),
@TelNumber varchar(255),
@District varchar(255),
@State varchar(255),
@Country varchar(255),
@Email varchar(255)

AS

BEGIN

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
DoctorName = isnull(@DoctorName,DoctorName)
and TelNumber = isnull(@TelNumber,TelNumber)
and State = isnull(@State,State)
and Country = isnull(@Country,Country)
and Speciality = isnull(@Speciality,Speciality)

and Degree = isnull(@Degree,Degree)
and TelNumber = isnull(@TelNumber,TelNumber)
and District = isnull(@District,District)
and Email = isnull(@Email,Email)

END


Still getting same error
Failed to convert parameter value from a String to a Int32.

Ya my field allows null values, but how can i pass dbnull value? please help me

Thanks a lot

Thanks a lot

Now I have record with doctor name but not with Speciality, I should get doctor name if i enter only doctor names? How can I?

Sorry now i'm not getting, because now i added all the conditions like

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
DoctorName = isnull(@DoctorName,DoctorName)
and Country = isnull(@Country,Country)
and State = isnull(@State,State)
and Degree = isnull(@Degree,Degree)
and Speciality = isnull(@Speciality,Speciality)
and TelNumber = isnull(@TelNumber,TelNumber)
and District = isnull(@District,District)
and Email = isnull(@Email,Email)


but i'm not getting any data now? What is the wrong with this one?

Thanks a lot

Yes, I got this, But Can I use ("like isnull(@Name,DoctorName) '%' ") here?

I'm not asking for handle null value in where clause, i'm asking about condition inside where clause? How to add If condition inside Where clause or How to add ("=" or "like") inside 'then' statement in CASE ?

if(@DoctorName is not NULL and @Speciality is not NULL and @State is not NULL and @Country is not NULL and @TelNumber is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
DoctorName like @DoctorName + '%' and Speciality like @Speciality + '%' and State like @State + '%' and Country like @Country + '%'


else if(@DoctorName is not null and @Speciality is not null and @State is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
DoctorName like @DoctorName + '%' and Speciality like @Speciality + '%' and State like @State + '%'


else if(@DoctorName is not null and @Speciality is not null and @Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
DoctorName like @DoctorName + '%' and Speciality like @Speciality + '%' and Country like @Country + '%'


else if(@DoctorName is not null and @State is not null and @Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
DoctorName like @DoctorName + '%' and State like @State + '%' and Country like @Country + '%'


else if(@Speciality is not null and @State is not null and @Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where
Speciality like @Speciality + '%' and State like @State + '%' and Country like @Country + '%'


else if(@DoctorName is not null and @Speciality is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where DoctorName like @DoctorName + '%' and Speciality like @Speciality + '%'



else if(@DoctorName is not null and @State is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where DoctorName like @DoctorName + '%' and State like @State + '%'



else if(@DoctorName is not null and @Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where DoctorName like @DoctorName + '%' and Country like @Country + '%'


else if(@Speciality is not null and @State is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where Speciality like @Speciality + '%' and State like @State + '%'


else if(@Speciality is not null and @Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where Speciality like @Speciality + '%' and Country like @Country + '%'


else if(@State is not null and @Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where State like @State + '%' and Country like @Country + '%'


else if(@DoctorName is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where DoctorName like @DoctorName + '%'


else if(@Speciality is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where Speciality like @Speciality + '%'


else if(@State is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where State like @State + '%'


else if(@Country is not null)

select DoctorName,Degree,Speciality,TelNumber,Taluk,District,State,Country from Doctorslist where Country like @Country + '%'


THIS IS THE QUERY I USED TO GET DETAILS, HERE I USED ONLY 4 CONDITIONS (STATE, COUNTRY, SPECIALTY AND DOCTORNAME) SO I GOT 15 MORE QUERIES, BUT IF I WRITE ALL CONDITIONS IT WILL BECOME 255 MORE QUERIES, SO IS THERE ANY OTHER WAY TO GET IT?

Now how can I remove that error?

I'm not able use doc.Root["Body"]["Monday"]["FiveToNine"] = "Something"; System is throwing error like "Cannot apply indexing with [] to an expression of type 'System.Xml.Linq.XElement'",
What is the solution for that?

THIS IS MY CODE HERE I CAN PLAY SONG DIRECTLY BUT IT WILL PLAY ONLY ONE SONG AND STOP THERE I WANT TO PLAY 2ND SONG WITHOUT PRESSING ANY BUTTON OR FILES


using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;

namespace Mp3Player
{
public partial class frmMp3Player : Form
{
bool _IsAddFiles = false;
string[] files, paths;

public frmMp3Player()
{
InitializeComponent();
}

private void btnPlay_Click(object sender, EventArgs e)
{
_IsAddFiles = false;
OpenFileDialog opd = new OpenFileDialog();
opd.Multiselect = true;

if (opd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
files = opd.SafeFileNames;
paths = opd.FileNames;
for (int i = 0; i < files.Length; i++)
{
listBox1.Items.Add(files[i]);
}
}
}

private void listBox1_SelectedIndexChanged(object sender, EventArgs e)
{
if (_IsAddFiles.Equals(false))
{
int index = int.Parse(listBox1.SelectedIndex.ToString());
axWindowsMediaPlayer1.URL = paths[index];
}
else
{
string fileName = listBox1.SelectedItem.ToString();
axWindowsMediaPlayer1.URL = @"D:\Mp3Files\" + fileName;
}
}

private void btnAdd_Click(object sender, EventArgs e)
{
_IsAddFiles = true;
string file1=string.Empty;
DirectoryInfo directory = new DirectoryInfo(@"D:\Mp3Files");
FileInfo[] files = directory.GetFiles("*.mp3");
foreach (FileInfo file in files)
{
file1 = file.Name;
listBox1.Items.Add(file1);
}
}

private void frmMp3Player_Load(object sender, EventArgs e)
{
//if (axWindowsMediaPlayer1.playState != WMPLib.WMPPlayState.wmppsPlaying)

LoadSongs();
if (listBox1.Items.Count != 0)
{
for (int i = 0; i < listBox1.Items.Count; i++)
{
listBox1.SelectedIndex = i;
break;
}
}
}

public void LoadSongs()
{
_IsAddFiles = true;
string file1 = string.Empty;
DirectoryInfo directory = new DirectoryInfo(@"D:\Mp3Files");
FileInfo[] files = directory.GetFiles("*.mp3");

foreach (FileInfo file in files)
{
file1 = file.Name;
listBox1.Items.Add(file1);
}
}
}
}

Yeah I tried many times. Still i'm trying that one. But i'm not getting anything about that. Actually I want to play song continuously one by one, without stop, without pressing any button or any files. So can you help me?