Comments by Member 11819086

Member 11819086 29-Oct-15 2:19am View

here exactly the control jumps....

xlWorkBook = xlApp.Workbooks.Open(fname, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

Member 11819086 29-Oct-15 2:18am View

here i am attaching my code please correct me.....

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Reflection;
//using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using System.IO;
namespace ASPNetFileUpDownLoad
{
public partial class exceltest : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}

protected void Button1_Click(object sender, EventArgs e)
{

Microsoft.Office.Interop.Excel.Application xlApp;
Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;

string fileName = this.FileUpload1.FileName;

FileInfo ff = new FileInfo(fileName);
if (ff.Exists)
{

switch (System.IO.Path.GetExtension(this.FileUpload1.PostedFile.FileName))
{
case ".xlsx":
case ".xls":
case ".csv":
{

// this.InsertAssayOutputFileData();
//objHTSBO.InsertAssayOutputFileData();

//objHTSBO.InsertAssayOutputFileData();
string str3 = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"App_Data\UploadFiles\" + fileName);

// string cmpexelfname = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"App_Data\CMPDATAFILES\" + filenamecmp);
// this.GetExcel(str3);
// this.getcmpexcel(cmpexelfname);
string fname = str3;

xlApp = new Microsoft.Office.Interop.Excel.Application();

//xlWorkBook = xlApp.Workbooks.Open(Server.MapPath("ASPNetFileUpDownLoad.xlsx"), true, true);

xlWorkBook = xlApp.Workbooks.Open(fname, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Microsoft.Office.Interop.Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);

//MessageBox.Show(xlWorkSheet.get_Range("A1", "A1").Value2.ToString());

xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();

releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);

return;
}
}
}

}
private void releaseObject(object obj)
{
try
{
System.Runtime.InteropServices.Marshal.ReleaseComObject(obj);
obj = null;
}
catch (Exception ex)
{
obj = null;
// MessageBox.Show("Unable to release the Object " + ex.ToString());
}
finally
{
GC.Collect();
}
}

}
}

Member 11819086 18-Oct-15 14:57pm View

sg 1033, Level 15, State 1, Line 9
The ORDER BY clause is invalid in views, inline functions, derived tables, subqueries, and common table expressions, unless TOP or FOR XML is also specified.

Member 11819086 18-Oct-15 14:34pm View

Msg 156, Level 15, State 1, Line 15
Incorrect syntax near the keyword 'order'.
i am getting tthe error..

Member 11819086 8-Oct-15 7:05am View

Dear Raju please send me where i have to set above GridView1_RowDataBound() in my code..???please help me

Member 11819086 4-Oct-15 4:50am View

yes @manas_kumar it is working with in the database..
but i dnt know how to resolve it please help ..

Member 11819086 4-Oct-15 4:48am View

dtt.Columns.Add("CompoundCode");
dtt.Columns.Add("WellPosition");
strPlateId = "CB0001";
compoundCode = this.GetCompoundCode(strPlateId);
this.dtt = compoundCode.Tables[0];
this.Session["Plate"] = this.dtt;
dtt = this.dtt;..at thi spoint i am getting the error...
can you please provide me information how can i execute stored procedure..along with NameValue Collections..

Member 11819086 28-Sep-15 8:36am View

i have taken it from view

/****** Script for SelectTopNRows command from SSMS ******/
SELECT [COMPOUND_NAME]
,[500]
,[300]
,[100]
,[30]
,[10]
,[0.1]
,[0.3]
,[0.01]
,[0.03]
FROM [AFileStorageDB].[dbo].[COMP_CONVALUE]

Member 11819086 28-Sep-15 3:00am View

hi here i am attaching the method and marked as red line is the error where i got the error

private void GetExcel(string fileName)
{

// string filenamecmp = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"App_Data\CMPDATAFILES\" + FileUpload1.FileName);
string str = string.Empty;
Application application = null;
Workbook workbook = null;
Worksheet xlWs = null;
Dictionary<string, string=""> dictionarySingleValue = new Dictionary<string, string="">();
try
{
application = (Application)Activator.CreateInstance(Type.GetTypeFromCLSID(new Guid("00024500-0000-0000-C000-000000000046")));
if (application == null)
{
Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct.");
}
else
{
application.Visible = false;
workbook = application.Workbooks.Open(fileName, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
// workbook = application.Workbooks.Open(fileName, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

string str2 = System.IO.Path.GetFileName(this.fileuploader.FileName);
string fileNameWithoutExtension = System.IO.Path.GetFileNameWithoutExtension(this.fileuploader.FileName);
for (int i = 1; i <= workbook.Worksheets.Count; i++)
{
if (!((Worksheet)workbook.Worksheets[i]).Name.StartsWith("Sheet"))
{
string str5;
string str6;
Range range;
int num8;
int num9;
xlWs = (Worksheet)workbook.Worksheets[i];
double mpMax = 0.0;
double mpMin = 0.0;
double sdMax = 0.0;
double sdMin = 0.0;
double dZPrime = 0.0;
if (xlWs == null)
{
Console.WriteLine("Worksheet could not be created. Check that your office installation and project references are correct.");
}
System.Data.DataTable dtData = new System.Data.DataTable();

dtData.Columns.Add("PlateId");
dtData.Columns.Add("WellPosition");
dtData.Columns.Add("DataType");
dtData.Columns.Add("Value");
dtData.Columns.Add("Replicates");
dtData.Columns.Add("Concentration");
dtData.Columns.Add(" Assay_Type");
/************************** Initializing the Values *****************************************************************/
string rep = ddlreplicates.SelectedItem.Value;
string concen = ddlconcentrate.SelectedItem.Value;
string assy_type = ddlassaytype.SelectedItem.Value;

DataView defaultView = ((System.Data.DataTable)this.ViewState["TemplateDetls"]).DefaultView;
defaultView.RowFilter = "TEMP_ID = '" + this.ddlTemplate.SelectedItem.Value + "'";
System.Data.DataTable table2 = defaultView.ToTable();
this.ViewState["dvdt"] = table2;
defaultView.RowFilter = "";
defaultView.RowFilter = "TEMP_ID = '" + this.ddlTemplate.SelectedItem.Value + "' AND START_POINT = END_POINT AND CALCULATION = 'No'";
table2 = defaultView.ToTable();
List<string> list = new List<string>();
ArrayList list2 = new ArrayList();
dictionarySingleValue = new Dictionary<string, string="">();
int num7 = 0;
while (num7 < table2.Rows.Count)
{
str5 = Convert.ToString(table2.Rows[num7]["Start_Point"]);
str6 = Convert.ToString(table2.Rows[num7]["End_Point"]);
range = xlWs.get_Range(str5, str6);
if (range != null)
{
num8 = 1;
while (num8 <= range.Rows.Count)
{
num9 = 1;
while (num9 <= range.Columns.Count)
{
string str8 = ((string)Convert.ToString(((dynamic)range.Cells[num8, num9]).value2)).Split(new string[] { ":", ":" }, StringSplitOptions.None)[1].Trim();
if (string.Equals(Convert.ToString(table2.Rows[num7]["TEMP_DETAILS"]), "Date of Measurement", StringComparison.OrdinalIgnoreCase))
{
dictionarySingleValue.Add(Convert.ToString(table2.Rows[num7]["TEMP_DETAILS"]), str8.Substring(0, 10).Replace("-", "/"));
}
else
{
dictionarySingleValue.Add(Convert.ToString(table2.Rows[num7]["TEMP_DETAILS"]), str8);
}
num9++;
}
num8++;
}
}
num7++;
}
defaultView.RowFilter = "";
DataSet plateLayoutId = new DataSet();
if (this.ddlPlateLayout.Visible)
{
plateLayoutId = this.objHTSBO.GetPlateLayoutId(this.ddlPlateLayout.SelectedItem.Value);
}
else
{
plateLayoutId = this.objHTSBO.GetPlateLayoutId(fileNameWithoutExtension);
}
List

Member 11819086 28-Sep-15 1:45am View

i have just changed the name and make it another file which is working properly.. even though it is not working i,e it gives same error..... what i can do?

Member 11819086 28-Sep-15 1:40am View

hi,thank you for response here i am giving the method as follows

private void GetExcel(string fileName)
{

// string filenamecmp = System.IO.Path.Combine(AppDomain.CurrentDomain.BaseDirectory, @"App_Data\CMPDATAFILES\" + FileUpload1.FileName);

string str = string.Empty;
Application application = null;
Workbook workbook = null;
Worksheet xlWs = null;
Dictionary<string, string=""> dictionarySingleValue = new Dictionary<string, string="">();
try
{
application = (Application)Activator.CreateInstance(Type.GetTypeFromCLSID(new Guid("00024500-0000-0000-C000-000000000046")));
if (application == null)
{
Console.WriteLine("EXCEL could not be started. Check that your office installation and project references are correct.");
}
else
{
application.Visible = false;
workbook = application.Workbooks.Open(fileName, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
// workbook = application.Workbooks.Open(fileName, 0, false, 5, "", "", true, XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);

string str2 = System.IO.Path.GetFileName(this.fileuploader.FileName);
string fileNameWithoutExtension = System.IO.Path.GetFileNameWithoutExtension(this.fileuploader.FileName);
for (int i = 1; i <= workbook.Worksheets.Count; i++)
{
if (!((Worksheet)workbook.Worksheets[i]).Name.StartsWith("Sheet"))
{
string str5;
string str6;
Range range;
int num8;
int num9;
xlWs = (Worksheet)workbook.Worksheets[i];
double mpMax = 0.0;
double mpMin = 0.0;
double sdMax = 0.0;
double sdMin = 0.0;
double dZPrime = 0.0;
if (xlWs == null)
{
Console.WriteLine("Worksheet could not be created. Check that your office installation and project references are correct.");
}
System.Data.DataTable dtData = new System.Data.DataTable();

dtData.Columns.Add("PlateId");
dtData.Columns.Add("WellPosition");
dtData.Columns.Add("DataType");
dtData.Columns.Add("Value");
dtData.Columns.Add("Replicates");
dtData.Columns.Add("Concentration");
dtData.Columns.Add(" Assay_Type");
/************************** Initializing the Values *****************************************************************/

string rep = ddlreplicates.SelectedItem.Value;
string concen = ddlconcentrate.SelectedItem.Value;
string assy_type = ddlassaytype.SelectedItem.Value;

DataView defaultView = ((System.Data.DataTable)this.ViewState["TemplateDetls"]).DefaultView;
defaultView.RowFilter = "TEMP_ID = '" + this.ddlTemplate.SelectedItem.Value + "'";
System.Data.DataTable table2 = defaultView.ToTable();
this.ViewState["dvdt"] = table2;
defaultView.RowFilter = "";
defaultView.RowFilter = "TEMP_ID = '" + this.ddlTemplate.SelectedItem.Value + "' AND START_POINT = END_POINT AND CALCU

Member 11819086 27-Sep-15 10:20am View

Dear Mika wendelius thank you for your suggetions will you please make the COL1 for this following querry

?????

SELECT *
FROM
(
SELECT [COMPOUND_NAME]
,CON_VALUE,
VALUE

FROM [AFileStorageDB].[dbo].[View_1]
)as s
PIVOT
(
MIN(VALUE)
FOR CON_VALUE IN ([500],[300],[100],[30],[10],[3],[1],[0.3],[0.1],[0.03],[0.01])
)AS p
ORDER BY COMPOUND_NAME

Member 11819086 27-Sep-15 9:07am View

my table contains more than one grouping of COMP for the pivoting columns ie for each one comp values have two times values 500,300,100,30..as i specified in my questionn

Member 11819086 27-Sep-15 4:44am View

COMP 500 300 100 30 10 3
7977797 19.67 -3.99 -7.92 -27.3 -145.2 -86.26

7977797 17.68 -7.68 -7.70 -33.07 -40.45 -58.82

the following "
with PivotData as
(SELECT TOP 1000 [WELLPOSITION]
,[COMPOUND_NAME]
,[CON_VALUE]
,[VALUE]
,[DATA_TYPE]
,[REPLICATES]
,[CONCENTRATION]
,[ASSAY_TYPE]
,[PLATE_ID]
,[Expr1]
FROM [AFileStorageDB].[dbo].[View_1] where DATA_TYPE='% Inhibition')

SELECT [COMPOUND_NAME],[500],[300],[100],[30],[10],[3],[1],[0.3],[0.1],[0.03],[0.01] from PivotData
PIVOT
(sum(VALUE)
FOR CON_VALUE IN ([500],[300],[100],[30],[10],[3],[1],[0.3],[0.1],[0.03],[0.01])
)as PivotResult

" it the

Member 11819086 27-Sep-15 4:43am View

thank you for responding i want to display it as folloe

COMP 500 300 100 30 10 3
7977797 19.67 -3.99 -7.92 -27.3 -145.2 -86.26

7977797 17.68 -7.68 -7.70 -33.07 -40.45 -58.82

the following "
with PivotData as
(SELECT TOP 1000 [WELLPOSITION]
,[COMPOUND_NAME]
,[CON_VALUE]
,[VALUE]
,[DATA_TYPE]
,[REPLICATES]
,[CONCENTRATION]
,[ASSAY_TYPE]
,[PLATE_ID]
,[Expr1]
FROM [AFileStorageDB].[dbo].[View_1] where DATA_TYPE='% Inhibition')

SELECT [COMPOUND_NAME],[500],[300],[100],[30],[10],[3],[1],[0.3],[0.1],[0.03],[0.01] from PivotData
PIVOT
(sum(VALUE)
FOR CON_VALUE IN ([500],[300],[100],[30],[10],[3],[1],[0.3],[0.1],[0.03],[0.01])
)as PivotResult

" it the

Member 11819086 25-Sep-15 9:32am View

WELLPOSITION COMPOUND_NAME CON_VALUE VALUE DATA_TYPE REPLICATES CONCENTRATION ASSAY_TYPE PLATE_ID Expr1
A1 7977797 500 19.67334 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A10 7977797 0.03 -93.38832 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A11 7977797 0.01 -184.94661 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A2 7977797 300 -3.99334 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A3 7977797 100 -7.92299 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A4 7977797 30 -27.33510 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A5 7977797 10 -145.27402 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A6 7977797 3 -86.26695 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A7 7977797 1 -39.03680 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A8 7977797 0.3 102.36552 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
A9 7977797 0.1 -39.20167 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B1 7977797 500 17.68691 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B10 7977797 0.03 -65.32619 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B11 7977797 0.01 104.08864 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B2 7977797 300 -7.68289 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B3 7977797 100 -7.70530 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B4 7977797 30 -33.07991 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B5 7977797 10 -40.45419 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B6 7977797 3 -58.82987 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B7 7977797 1 -47.70282 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B8 7977797 0.3 -51.27712 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
B9 7977797 0.1 -50.22628 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C1 Z969076296 500 23.80387 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C10 Z969076296 0.03 -80.12518 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C11 Z969076296 0.01 103.20667 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C2 Z969076296 300 -4.32068 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C3 Z969076296 100 -0.92566 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C4 Z969076296 30 -17.48859 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C5 Z969076296 10 -51.90458 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C6 Z969076296 3 -108.45382 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C7 Z969076296 1 -46.60636 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C8 Z969076296 0.3 -84.65667 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
C9 Z969076296 0.1 -89.29941 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D1 Z969076296 500 11.44110 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D10 Z969076296 0.03 -104.77148 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D11 Z969076296 0.01 -84.13325 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D2 Z969076296 300 -5.70366 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D3 Z969076296 100 -18.11205 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D4 Z969076296 30 -112.88768 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D5 Z969076296 10 -64.70993 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D6 Z969076296 3 -117.24950 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D7 Z969076296 1 -39.55541 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D8 Z969076296 0.3 -59.28526 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
D9 Z969076296 0.1 -70.68123 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
E1 STOCK-1S-21278 500 -705.39462 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
E10 STOCK-1S-21287 0.03 -45.25220 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
E11 STOCK-1S-21288 0.01 -77.64494 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
E2 STOCK-1S-21279 300 -315.64286 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2
E3 STOCK-1S-21280 100 0.89749 % Inhibition 1 3 Alpha_Screen Plate 2 Plate 2

Member 11819086 25-Sep-15 9:23am View

thank,,

Member 11819086 25-Sep-15 9:12am View

i want to remove those null values and make it column by column...
after completing 500 to 0.01 values next it must come next row and again fill the values

Member 11819086 25-Sep-15 9:10am View

COMPOUND_NAME DATA_TYPE PLATE_ID 500 300 100 30
7977797 % Inhibition Plate 2 19.67334 NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL -3.99334 NULL NULL
7977797 % Inhibition Plate 2 NULL NULL -7.92299 NULL
7977797 % Inhibition Plate 2 NULL NULL NULL -27.33510
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 17.68691 NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL -7.68289 NULL NULL
7977797 % Inhibition Plate 2 NULL NULL -7.70530 NULL
7977797 % Inhibition Plate 2 NULL NULL NULL -33.07991
same compound id contains the values for 500,300,100,10 and so on but it displays in another row instead of next column
like
7977797 500value 300 value ,100value and so

Member 11819086 25-Sep-15 8:50am View

i am getting result like this

COMPOUND_NAME DATA_TYPE PLATE_ID 500 300 100 30
7977797 % Inhibition Plate 2 19.67334 NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL -3.99334 NULL NULL
7977797 % Inhibition Plate 2 NULL NULL -7.92299 NULL
7977797 % Inhibition Plate 2 NULL NULL NULL -27.33510
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 17.68691 NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL NULL NULL NULL
7977797 % Inhibition Plate 2 NULL -7.68289 NULL NULL
7977797 % Inhibition Plate 2 NULL NULL -7.70530 NULL
7977797 % Inhibition Plate 2 NULL NULL NULL -33.07991

Member 11819086 25-Sep-15 8:48am View

this is the desired output
COMPOUND_NAME 500 300 100 30 10 3 1 0.3
7977797 0.23 0.23 0254 0.25 0.65 .025 215 0.2
7977797 124 145 425 125 254 225 254 14

in case of compound code column contains pivoting valuesmore than two of each compound....

Member 11819086 25-Sep-15 8:25am View

Thank you for your response..

it is working but not in desired output form...

COMPOUND_NAME contains two times of the CONCENTRATION

7977797 NULL 351761.58499 NULL 508212.27179 457484.90318 384627.26038 212552.08840 387983.57205 474486.28549 377284.14203
STOCK-1S-21278 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL
STOCK-1S-21279 NULL NULL NULL NULL NULL NULL NULL NULL NULL NULL

but i need

7977797 ---->one row all contains pivot
7977797 ------>second row contains all pivot...

Member 11819086 25-Sep-15 7:14am View

varchar or nvarchar

Member 11819086 8-Sep-15 3:29am View

I have't infrigistics.dll files ..
but i can take it from other web application which is in bin folder...

Member 11819086 4-Sep-15 6:11am View

so then how can i handle it..
please help...

Member 11819086 4-Sep-15 6:04am View

Those are the Value of the previous ID....

All the records are belongs to the previous ID until and unless another Id is occurred...

i have uploaded it from the excel and the excel contains like this....
give me some suggestions..please

when i select the row on the basis of the ID value i need to get the following values also from that row...

i know the how many rows belongs to that id..while uploading ...

Member 11819086 21-Aug-15 7:17am View

thank you for your responce @ vayyalaravi i have two dropdownlist and one file uploader to select excel sheet so that how can i do that? please help me

while uploading(sqlbulkcopy) the selected values from dropdownlist must be inserted ...

Comments by Member 11819086 (Top 27 by date)