Comments by SukirtiShetty (Top 87 by date)

It has been solved thank you all for your help

We recommend to remove DynamicCompressionModule from IIS. Follow the steps as shown below to remove the module from IIS -

Open up the IIS Manager
Click on your Server Node (top level). In the right-pane, look for Modules and double-click Modules
Within Modules, look for DynamicCompressionModule. Select the module, and in the upper-right pane (Actions), choose Unlock
Fall back to the left Pane (Connections), expand the Server Node and then expand Sites. Go ahead and click on BizTalk360
Within BizTalk360 Home in the right pane, locate Modules and double-click Modules. This will display all of the propagated Modules from top level (Server Node)
You will notice DynamicCompressionModule in the list of Modules. Right-click and select Remove DynamicCompressionModule
Reset IIS by using iisreset in Admin command prompt


I have checked the above solution
but it showed me same error

Yes I have checked in Google the Error Code but nothing seems to be works for me

I have checked the above but still i am facing the same problem

Still I m facing the same Error
Please anybody help me.

I have checked in Javascript debugger and it throws 1 error "Uncaught TypeError: oCtrlTable.getAttribute is not a function"

var oRow,oCtrlTable,iFieldID,oPromptCell;
oRow=oTable.rows[i];
oCtrlTable=oRow.cells[1].childNodes[0].childNodes[0];
iFieldID=oCtrlTable.getAttribute('FieldID');//error throws here

I have checked return SaveData(); and still its not working for me

I am able to get the particular months report.
but anyone please help me to transpose the Date column

I am trying to display monthwise report for the particular resource but it displays all the dates in database so please help me in this.

I have updated database data in my question

Thank you it worked for me

Thank you sir but can you pls guide how to pass merged values to string builder(Text file using delimiters)

Previously i used code like below

totalRowsCount = dtPatterns.Rows.Count;
totalColumnsCount = dtPatterns.Columns.Count;

this.lblRowsCount.Invoke((MethodInvoker)delegate { this.lblRowsCount.Text = totalRowsCount.ToString(); });

for (int c = 0; c < dtPatterns.Columns.Count; c++)
{
if (c == dtPatterns.Columns.Count - 1)
{
SB1.Append(cValue.ToString() + dtPatterns.Columns[c].ToString() + cValue.ToString());
}
else
{
SB1.Append(cValue.ToString() + dtPatterns.Columns[c].ToString() + cValue.ToString() + sValue.ToString());
}
}
SB1.Append("\r\n");
for (int d = 0; d < dtPatterns.Rows.Count; d++)
{
this.toolStripStatusLabel1.Text = string.Format("Processing Please Wait ...{0} of {1}", (count + 1), totalRowsCount);
for (int c = 0; c < dtPatterns.Columns.Count; c++)
{
int g = dtPatterns.Columns.Count - 1;
if (c == g)
{
SB1.Append(cValue.ToString() + dtPatterns.Rows[d][c].ToString() + cValue.ToString());
}
else
{
SB1.Append(cValue.ToString() + dtPatterns.Rows[d][c].ToString() + cValue.ToString() + sValue.ToString());
}
}
SB1.Append("\r\n");
count++;
}

System.Data.DataTable dtPatterns = new System.Data.DataTable();

excelCommand = new OleDbCommand("SELECT * FROM [Sheet1$A:Z]", excelConn);
excelDataAdapter.SelectCommand = excelCommand;
excelDataAdapter.Fill(dtPatterns);

List<string> xcelData = new List<string>();
List<string> ColumnNames = new List<string>();
ds.Tables.Add(dtPatterns);



System.Data.DataTable dtPatterns1 = new System.Data.DataTable();

excelCommand = new OleDbCommand("SELECT * FROM [Sheet1$AA:KZ]", excelConn);
excelDataAdapter.SelectCommand = excelCommand;
excelDataAdapter.Fill(dtPatterns1);

List<string> xcelData1 = new List<string>();
List<string> ColumnNames1 = new List<string>();
ds1.Tables.Add(dtPatterns1);
dtPatterns.Merge(dtPatterns1);

Yes I have tried to merge two datasets but its merging not as columns.

For Ex:
MY DS1:
1 2
3 4

DS2:
5 6
7 8

I want output like below
1 2 5 6
3 4 7 8


But i m getting
1 2
3 4
5 6
7 8

can you please give me some idea how can i achieve the same results using my code

I wanted delimiters so i used for loop to get data from excel

Yes. and I have debugged the code. It works fine for 1000 rows in Excel. It throws error when rows more than 1,00,000 in Excel file

yes it is test table only i have updated in question. I am using single table here

I have updated table data in my Question panel.

thank you so much. It worked fine for me...

Hithank you for providing answer
Query worked for me except the Total

If any values is 'NULL' then Total also showing 'NULL' its not clculating other values from different scopes

now it displays results like this it calculates sum only for the entries in all the fields


resources Technical DataEntry Total
John 215 NULL NULL
Mary 40 NULL NULL
Rita NULL 5700 NULL
Sharo 200 1700 1900

i tried using javascript but it simply redirecting to the index page.

As i am new in PHP can you please help me on this

As it doesnot showed me any error and I have configured smtp in Php.ini file

yes i am trying to bind procedure as well as the query

It doesnot work. It showed the same result.
Please help me on this

Its solved thank you..

thank you. i will redesign the table for numeric values

whether i have to remove those characters from query or from database

some quality % is like --- Scope1: 98.73%, Scope2: 100%
so if i run the above query it always shows the error. i tried to convert to numeric as well.

in my quality column some values like "Both 100%" and 95.65% etc..

i have not used single quotation in query.
select distinct b.UserName,SUM (Cast(b.Quality as int)) as Amt from table1 a, table2 b where b.UserName like b.USerName Group BY b.UserName ;

if i use cast(quality) it shows the same error.
Conversion failed when converting the varchar value '100.00' to data type int.

ok thank you.

I am getting correct answer but why did you used x in the query. Please explain the query.

I am getting error as Incorrect syntax near the keyword 'select'. for above query

i am getting values as compressiontag.value ---- byte[2]
[0]=5 and [1]=0 i want here 5 as a result.

I want results as 1, 2, etc like below
1: no compression
2: CCITT Group 3
3: Facsimile-compatible CCITT Group 3
4: CCITT Group 4 (T.6)
5: LZW

but i want that result in int.
I am unable to pass that compressiontag.value to int

1: no compression
2: CCITT Group 3
3: Facsimile-compatible CCITT Group 3
4: CCITT Group 4 (T.6)
5: LZW

public static int GetCompressionType(Image image)
{
int compressionTagIndex = Array.IndexOf(image.PropertyIdList, 0x103);
PropertyItem compressionTag = image.PropertyItems[compressionTagIndex];
return BitConverter.ToInt16(compressionTag.Value, 0);
}


I have used this code to get tiff compression of an image

its showing results in byte array as com[0]=5 and com[1]=0 in (byte[] com = compressionTag.Value;) but how to pass this value to string

it display results as below numbers
1: no compression
2: CCITT Group 3
3: Facsimile-compatible CCITT Group 3
4: CCITT Group 4 (T.6)
5: LZW


but how can i get only value 5 from byte array.
Please help me on this.

I am getting results in byte array. but i am unable to get that value pls help me

thank you it worked fine now i have changed the table3 data.
now its working fine as required.
thanks again for your help

UserName is same in both tables. i tried for full join also

it displays results for test1 but for test2 it shows null values.
Please help me on this

We have tried both. but we are getting query results as required

Hi,
Anybody please help me on this. I am stuck on this.

Hi,

Here <%=userid%>, what userid I have to add? Please tell me.

I got solution for that thanks for your reply

i am getting error when i add <%=textbox1.ClientID %>
Error The name 'textbox1' does not exist in the current context

I have added like this
onclick="javascript:NewCssCal('ctl00_pc_grd1_+_<%=textbox1.ClientID %>', 'MMddyyyy', 'dropdown', 'true', '12', 'true', 'all dates are enabled')"

i need to add control id of eachrow of gridview like this ctl00_pc_grd1_ctl00_textbox1

Help me on this

Thank you so much. It worked for me.

and condition is if(column4==Column5) then Count is 0 (if it is NULL value)
else if(Column4!=column5) the Count=1

i need it as a distinct value of mary which gives me 3 times in the output.
below is the output what i get while executing below query.

select distinct(UserName), case when (column4 <> column5
OR (column4 IS NULL AND column5 IS NOT NULL)
OR (column4 IS NOT NULL AND column5 IS NULL)) then
Count(column2) else '0' end as Count
from table1 where column1='test' Group BY column1 , column2, column3

UserName Count
John 0
Sam 3
Mary 1
Mary 0
Mary 0

Column1 Column2 Column3 Column4 Column5
test sample001 Mary NULL NULL
test sample002 Mary NULL NULL
test sample003 Mary NULL NULL
test sample004 Mary NULL NULL
test sample005 Mary A NULL
test sample006 Mary A A
test sample007 Mary NULL NULL
test sample008 John NULL NULL
test sample009 John NULL NULL
test sample010 John NULL NULL
test sample011 John NULL NULL
test sample012 John NULL NULL
test sample013 John NULL NULL
test sample014 John NULL NULL
test sample015 John NULL NULL
test sample016 Sam A NULL
test sample017 Sam NULL NULL
test sample018 Sam NULL NULL
test sample019 Sam NULL NULL
test sample020 Sam A NULL
test sample021 Sam NULL NULL
test sample022 Sam NULL NULL
test sample023 Sam NULL NULL
test sample024 Sam A NULL



Output will be:
UserName Count
Mary 1
John 0
Sam 3

No i have tried but same results. i want results of count as 0 for other usernames but for mary i want 21 as count. Please help me on this

I have added crystal report aspx page and it works correctly in localhost but after published and hosted in server table will be displayed but graph image is not displaying in the report. I am using IIS version 7 ,Visual Studio 2005 , .Net Framework2.0

Hi, It worked fine. thank you for the solution.
But now the problem is in crystal report graph image is not displaying in client machine after published in server.
Thanks

Thank You so much it worked perfectly.

thank you for your reply.
I have tried your solution, but it works same as before.
I added picturebox inside the panel. Please help me in this.

Yes thanks for your quick reply. I already checked that.

But it should be similar to this link:

http://www.hafele.com/in/en/external/blaetterkataloge/AH_2014_feb/

I used Canvas to load image. It worked well. Now i want to save that image with drawing so please give me idea how to save image.



Thanks

Will you Please give me idea how can I achieve this without using Picturebox.

thanks in advance

Here I need to redact some portion of image by drawing multiple rectangles. I tried above code, but its not working.

Here I am loading image in a picturebox and drawing multiple rectangles in the image and save that image in the virtual folder.

Another pain point is that, when I set picturebox size mode to zoom and if I draw rectangle it will not be in the selected position. It will be in the top right corner position.

FilePath = TextBox1.Text;
DataTable dt = new DataTable();
dt.Columns.Add("ImageName", typeof(System.String));
DataRow dr = null;
DirectoryInfo dir = new DirectoryInfo(FilePath);
foreach (FileInfo fi in dir.GetFiles())
{
dr = dt.NewRow();
dr[0] = fi.Name.ToString();
dt.Rows.Add(dr);

}

ImageGridView.DataSource = dt;
ImageGridView.DataBind();

I want to hide file names from gridview and I will save only file names into database.

Here now I do not need file names which is already in database, when I select same folder for the next time.

thank you sir it works fine now. Its firewall issue.

yes i have tried all those options. and i have restarted server also but it is not connecting to remote server database. Please help me. I dont no where it went wrong.

Please help me on this.

I am trying to connect database from remote server in c# windows application for authentication but it is not connecting to database..
If i try to connect database from server in my sql server by providing ip address it shows me the below error message.

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

I have tried all these steps but still its not working.

Yes I have tried even that.

this query is working in Sql server but i want query in c#

here is my c# code

DataTable dt = new Select(Test1.Resource.WorkAreaIDColumn, Test2.User.UserIDColumn, Test2.User.DisplayNameColumn).From(Test1.Resource.Schema).InnerJoin(Test2.User.Schema).ExecuteDataSet().Tables[0];

DataView dv = new DataView(dt);


I m getting this error: Invalid object name 'dbo.User'.