Comments by Priyanka7777 (Top 36 by date)

I did in the design but still i am not able to change it.

I know i have reposted the answer,but the only purpose was to make things simpler for 12345_abcde.

I did not get the purpose of 2nd table(paperlist),but still i have written a query for
your first table(SEGDATA) to get conflicting records.See if it helps you.


SELECT ADMINNO,
SUBSTRING(
(SELECT (':' + MODULECODE)
FROM SEGDATA1 S2
WHERE S1.ADMINNO=S2.ADMINNO
ORDER BY
ADMINNO,
MODULECODE
FOR XML PATH( '' ) ),3,1000) AS CONFLICTING_PAPERS
FROM SEGDATA1 S1
GROUP BY ADMINNO

Post the table structure along with data and let me know what are the common columns for both the tables.

Were you able to solve your problem?

You want to search for common students within exampapers,right?
You can do that using inner join.
What is the problem that you are facing?

Join the two tables 'paperslist' and 'ModuleStudents' with the help of inner join.

Try defining the parameters outside and before the for loop.

Why are you comparing the values in the datasets,instead you can join the two tables in the SQL query.

textBox2.Text = new DateTime(precti.GetOrdinal("odjezd").Ticks).ToString("HH:mm:ss");

Object????

Please be more specific!!!

This is the only field that you have added in your query:
rule1.fnlwgt = probablity.fnlwgt.

Check for similar links that you can make between rule1 table and probablity.

what chimcham said is right.There is still another field that you have to link for you to get the distinct data.Check for more linking between the two tables.

Thnx.

Check out this link which shows how to Retrieve Values of Cached Items.

http://msdn.microsoft.com/en-IN/library/xhy3h9f9(v=vs.100).aspx

Which solution did work for you?

Please mark the solution as answer which worked for you.

This works!!!

Actually it should work.

Check this link if you find something useful.

http://www.codeproject.com/Questions/293066/asp-net-grid-view-data-binding

What are the namespaces that you have added in your code?

Add after this line:
FullsortDataGridView.DataSource = ds.Tables(0)

FullsortDataGridView.DataBind();

Have you missed this line in your code or not added it?

FullsortDataGridView.DataBind();

Glad that it helped you... :)

You can now bind the result that you got in 'distinctTable' to your gridview's DataSource event.

This was just a sample code to let you know how you get distinct records.

As per your code provided above you can change it to:

da = new SqlDataAdapter("select DISTINCT Date,Humidity,Temprature,light,Voltage,outp from Dataset", cn.con);
dt = new DataTable();
da.Fill(dt);

//dt will contain the data from your query.

DataTable distinctTable = dt.DefaultView.ToTable( /*distinct*/ true);

See if it works.

The solution does work.I have checked it.

Try this piece of code and check what result you get in 'distinctTable' DatatTable:


DataTable table2 = new DataTable("articletable");
table2.Columns.Add("articleID");
table2.Columns.Add("title");
table2.Columns.Add("content");

DataRow row2 = table2.NewRow();
row2[0] = "1";
row2[1] = "article name";
row2[2] = "article contents go here";
table2.Rows.Add(row2);

DataRow row1 = table2.NewRow();
row1[0] = "1";
row1[1] = "article name";
row1[2] = "article contents go here";
table2.Rows.Add(row1);

DataTable distinctTable = table2.DefaultView.ToTable( /*distinct*/ true);

My mistake.

Instead of using a DataTable dt in this line use a DataView

DataView dv= dt(/*default*/true).DefaultView;

Correct this line to :

DataView dv1 = new DataView();
DataView dv= dv1.ToTable(/*default*/true).DefaultView;

What do you mean by Next Previous Functionality without Repeated hits on DataBase.
Can u be a little brief?

Im glad that it helped you!!!

Put a break point for second buttons click event.Does the control go there?

Perfect!!!

Did this solution work for you?

Mark as answer if it worked for you.....