Click here to Skip to main content
15,314,688 members

Comments by Priyanka7777 (Top 36 by date)

Priyanka7777 11-Sep-13 3:34am View
   
This gives me an error that the "Resource cannot be found".
Priyanka7777 6-Sep-13 8:28am View
   
Great this works.But the problem is i need to save some information on OK button click.
I want to write this code:
cmd = objDb.GetStoredProcCommand("SetSurveyInfoDetails");
//temporary set dropdown value to xyz.to run the SP.
Session["DropDownListSurvey"] = "XYZ";
objDb.AddInParameter(cmd, "@ServeyName ", DbType.String, Session["DropDownListSurvey"]);
objDb.AddInParameter(cmd, "@Name ", DbType.String, txtName.Text);
objDb.AddInParameter(cmd, "@Mobile ", DbType.String, txtMobile.Text);
objDb.AddInParameter(cmd, "@Email_Id ", DbType.String, txtEmail.Text);
result = objDb.ExecuteNonQuery(cmd);

Is it possible?
Priyanka7777 6-Sep-13 8:03am View
   
I am not getting any error.Nut the confirmation box is not shown.
Priyanka7777 6-Sep-13 8:02am View
   
Yes.I want to save the information entered once the user clicks on OK button.
Priyanka7777 6-Sep-13 7:50am View
   
Sorry i added your code,but it is not working.Confirmation box is not opening.
Priyanka7777 22-Aug-13 7:28am View
   
I did in the design but still i am not able to change it.
Priyanka7777 18-Jul-13 4:25am View
   
I know i have reposted the answer,but the only purpose was to make things simpler for 12345_abcde.
Priyanka7777 18-Jul-13 3:28am View
   
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
Priyanka7777 18-Jul-13 2:36am View
   
Post the table structure along with data and let me know what are the common columns for both the tables.
Priyanka7777 18-Jul-13 1:36am View
   
Were you able to solve your problem?
Priyanka7777 17-Jul-13 8:32am View
   
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?
Priyanka7777 17-Jul-13 7:01am View
   
Join the two tables 'paperslist' and 'ModuleStudents' with the help of inner join.
Priyanka7777 17-Jul-13 3:34am View
   
Try defining the parameters outside and before the for loop.
Priyanka7777 17-Jul-13 1:38am View
   
Why are you comparing the values in the datasets,instead you can join the two tables in the SQL query.
Priyanka7777 15-Jul-13 7:10am View
   
textBox2.Text = new DateTime(precti.GetOrdinal("odjezd").Ticks).ToString("HH:mm:ss");
Priyanka7777 12-Jul-13 5:51am View
   
Object????
Priyanka7777 12-Jul-13 5:40am View
   
Please be more specific!!!
Priyanka7777 12-Jul-13 5:12am View
   
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.
Priyanka7777 12-Jul-13 4:53am View
   
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.
Priyanka7777 12-Jul-13 3:47am View
   
Thnx.
Priyanka7777 12-Jul-13 3:35am View
   
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
Priyanka7777 12-Jul-13 1:55am View
   
Which solution did work for you?

Please mark the solution as answer which worked for you.
Priyanka7777 11-Jul-13 8:16am View
   
This works!!!
Priyanka7777 11-Jul-13 6:25am View
   
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?
Priyanka7777 11-Jul-13 6:02am View
   
Add after this line:
FullsortDataGridView.DataSource = ds.Tables(0)

FullsortDataGridView.DataBind();
Priyanka7777 11-Jul-13 5:22am View
   
Have you missed this line in your code or not added it?

FullsortDataGridView.DataBind();
Priyanka7777 11-Jul-13 3:35am View
   
Glad that it helped you... :)
Priyanka7777 11-Jul-13 3:30am View
   
You can now bind the result that you got in 'distinctTable' to your gridview's DataSource event.
Priyanka7777 11-Jul-13 3:22am View
   
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.
Priyanka7777 11-Jul-13 3:11am View
   
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);
Priyanka7777 11-Jul-13 2:28am View
   
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;
Priyanka7777 11-Jul-13 1:10am View
   
What do you mean by Next Previous Functionality without Repeated hits on DataBase.
Can u be a little brief?
Priyanka7777 10-Jul-13 7:30am View
   
Im glad that it helped you!!!
Priyanka7777 10-Jul-13 5:28am View
   
Put a break point for second buttons click event.Does the control go there?
Priyanka7777 10-Jul-13 2:22am View
   
Perfect!!!
Priyanka7777 9-Jul-13 7:33am View
   
Did this solution work for you?

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