Comments by 2012programmer (Top 38 by date)

thank you...I got it, but how do I check this..(I want to give the permission to two different users in some pages and three users in some pages)?

I need the all the studentids sorted by maximumu avergestudents....
1. Professor=101 has 4 lectureids=401,411,412,415, and each lectureid has various no. of students(25,26,20,19)..
The averagecount=Totalno.ofstudents(25+26+20+19)/no.of distinct lectureids(4)=23
2. Professor=102 has 3 lectureids=416,417,419 and each lectureid has various no. of students(20,19,21)..
The averagecount=Totalno.ofstudents(20+19+21)/no.of distinct lectureids(3)=20
....
Like this there will be 60 professors, with different averagecount...My table should be sorted in a way that, If professor=119 has averagecount=24(for ex: highest)..then all the students of this professor should appear first..

After filtering how to get the value from dataview..?
dv1.Table.Rows[k]["roomno"]);
When I use this statement I am getting all the records of dataview..But My requirement is, The value must be from the filtered data..

but this procedure I want to do it from ASP.net interface using c#.net...

Yeah, I have tried with General datatype and Text data type also...

Thanks alot for your help..appreciated your help...

yes I have defined as "Text"...still it is not working..

the table is already exist, and I am using Import wizard of SQL server management studio, I am able to import it, but If the "roomno." column data is not starting with "G" then it is taking "NULL"(instead of no.1234)..

the table is already exist, and I am using Import wizard of SQL server management studio, I am able to import it, but If the "roomno." column data is not starting with "G" then it is taking "NULL"(instead of no.1234)..

But, the problem here is, I am importing data from an MS-Excel file. I am able to insert the data from sql server mangement studio, but I am unable to import it from excel, bcoz of this data typ issue..

Thank you very for your great support.

Is there any option for random generation in C# or SQL server

Thank you Mr. Sandip, It is working very fine. The hyperlink you have provided is very useful for me.
I have 2 more queries, kindly help me in this regard. 1. How to publish this asp.net application. (Is there any step by step article is available ?). 2. After publishing this application If I want to change my connection string in web.config file, How Can I do this (There is no visual studio in Host system).

I have an application form, in this form there is some static content and dynamic content available. This dynamic content will be changed based on database records. For each row of a table in database one page should be published. " Print 20 pages means If there are 20 rows in that table then 20 pages should be printed. Like Mail merge feature in MS-Word, some content is static and some content is dynamic but when we publish this static content is repeated for each record. Thank you.

Using ajax is looking difficult for me, is there any way to do this. another requirement is stop submitting if there 20 records per a course each day.

I am inserting the record when a user click on button. But Iam checking the userid is correct or not in text change event. In text change event only can I check the user is already registered or not.

I am planning a training program for employees, for that employees will register on a asp.net web page. If there 1500(for example), but the training program is designed for 50 employs only.
My requirement: Somebody can fill my database with garbage values. To avoid this, I have EIDS table in which all employ ids are stored, If a user try to enter gargabe value, then it will check with EIDS table then it will allow you to enter other details. This is working fine. But another requirement if an employ try to re-register it is giving "Server Error", Instead of server error can we provide an alert box with "already registered"

First of all I thank you for your help.
For example, there is 1500 employees. These employee id's are stored in a table(EIDS), But My requirement is to register only 50 employes(EmpRegister table) from those 1500 employees. I need two types of validations, 1. The user entered id must be present in EIDS table, 2. EmpRegister table should not include duplicate records(For this purpose "EID" column of EmpRegister table has a primary key- this is working fine, but if there is duplicate value try to insert into database table- it is giving Server Error in the browser, this is not looking good in the browser, what I need is just give an alert message that "Already Registered".

Thank You 'Naman'. I dont have much idea about DB and foriegn keys. Can you give me detail code. One more problem is, Initially if there is no records in my database table- then it should show all the list(Monday,Tuesday,....Sunday).

References: d1=dropdownlist1
r1=radiobutton1
r2=radiobutton2


Code:


protected void Page_Load(object sender, EventArgs e)
{
DataTable records = new DataTable();
string myConnection = "Data Source=server;Initial Catalog=college;User ID=sa;Password=123";
SqlConnection con = new SqlConnection(myConnection);
con.Open();
SqlCommand sqlCommand = new SqlCommand();
sqlCommand.CommandType = CommandType.StoredProcedure;
sqlCommand.CommandText = "GetListRecordNotHavingTenCount";
sqlCommand.Connection = con;
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand); sqlDataAdapter.Fill(records);
// d1.DataSource = records;
// d1.DataValueField = "Id";
// d1.DataTextField = "Lecturetimings";
//this.d1.DataBind();

protected void DropDownList1_SelectedIndexChanged(object sender, EventArgs e)
{


switch (d1.SelectedIndex)
{
case 0:
r1.Visible = false;
r2.Visible = false;
break;
case 1:
r1.Visible = false;
r2.Visible = false;
r1.Text = "C Language";
r2.Text = "C ++";
r1.Visible = true;
r2.Visible = true;
break;
case 2:
r1.Visible = false;
r2.Visible = false;
r1.Text = "Basic Hardware";
r1.Visible = true;
break;
case 3:
r1.Visible = false;
r2.Visible = false;
r1.Text = "Networking";
r1.Visible = true;
break;
case 4:
r1.Visible = false;
r2.Visible = false;
r1.Text = "Adobe Flash";
r2.Text = "Adobe Photoshop";

r1.Visible = true;
r2.Visible = true;
break;
case 5:
r1.Visible = false;
r2.Visible = false;
r1.Text = "C#.Net";
r1.Visible = true;
break;
case 6:
r1.Visible = false;
r2.Visible = false;
r1.Text = "Basic Hardware";
r1.Visible = true;
break;
case 7:

r1.Text = "Adobe Flash";
r2.Text = "Networking";
r1.Visible = true;
r2.Visible = true;
break;

}

}


protected void Button1_Click1(object sender, EventArgs e)
{
String myConnection = " Data Source=server;Initial Catalog=college;User ID=sa;Password=123";
SqlConnection con = new SqlConnection(myConnection);
SqlCommand cmd;

con.Open();
cmd = new SqlCommand(@"INSERT INTO [dbo].[Register]([Sname],[Email]
,[ContactNo],[Activity],[Lecturetimings])
VALUES('" + name.Text + "','" + email.Text + "','" + contact.Text + "','" + r1.Text + "','"+d1.SelectedValue+"')", con);
cmd.ExecuteNonQuery();
con.Close();
ScriptManager.RegisterStartupScript(this, GetType(), "alert", "alert('SuccessFully Submitted');", true);
d1.SelectedIndex = 0;
name.Text = "";
email.Text = "";
contact.Text = "";
CheckBox1.Checked = false;
r1.Visible = false;
r2.Visible = false;

}

Thank you Naman Kumar.

what is "tt" here.

What is "ii" here in the above code.

There is one more question, If I create LectureTimings table,then on one-day(ex:Saturday) there are 2 courses(ex:VB,ASP).How can I enter this type of situation in table.

Thanks "Kishor". As I am new to programming can you let me know with the code to generate radio buttons dynamically.

Ok.This is working well.It showing 2 items in dropdown list as there entries with Saturday and Sunday.Intially if there are no records in the table then it should show all the items in the list like (Monday,.....Saturday).
And One more problem is its not showing the radio buttons when I select any list item(after applying this code)

I am creating a web based application (Student Registration Form). In this Web Page I have 1 dropdown list (which shows the lecturetimings like Saturday, Sunday, Monday, Tuesday,........etc). After selecting a list item(ex: Saturday It will show availble courses as Radio buttons (Example:MS-Office,C#.Net). In the selected index change event of drop down list-I have written a switch case: for every different casecase 0:
r1.Visible = false;
r2.Visible = false;
break;
case 1:
r1.Visible = false;
r2.Visible = false;
r1.Text = "MS-Office";
r1.Visible = true;
break;
case 2:
r1.Visible = false;
r2.Visible = false;
r1.Text = "Hardware & Networking";
r2.Text="C#.net";
r1.Visible = true;
r2.Visible = true;
break;
...........
Upto case7 written.
Then I have some text boxes for (StudentName, EmailId, ContactNo.& address0
I have checkbox(I agree terms & Conditions)
There is a submit button( on clicking this, the information wil be saved in data base table registration(StudentName,EmailId,ContactNo.,Address, Lecturetimings, Course)Ex:(John, john@john.com, 9999999999, India, Saturday,MS-Office).
Now My requirement is if there 10 records with Saturday then in the dropdown list saturday should not be shown. Thanks in advance for taking pains for me.

What is "Id" here in thi code?. I am getting this error "DataBinding: 'System.Data.DataRowView' does not contain a property with the name 'Id'."

Hi, Thank you once again for your great support. Kindly let me know how to append these "records" table values as dropdown list item. Initially if there are no records in the database, then what values it will append to the dropdown list.

Kindly let me know the code for stored procedure and C# code. My table name is "Register", Column Name is "Lecturetime", List Items are(1.Monday,2.Tuesday, 3.Wednesday, 4.Thursday, 5.Friday, 6.Saturday, 7.Sunday). Thanks in advance "Faisaladians".

Yes Exactly. Kindly let me know the code for stored procedure and C# code. My table name is "Register", Column Name is "Lecturetime", List Items are(1.Monday,2.Tuesday, 3.Wednesday, 4.Thursday, 5.Friday, 6.Saturday, 7.Sunday). Thanks in advance "Faisaladians".

Thank you very much Every body.This code is working.I need some more help. I was saving the selected list items of a dropdown list into column of a database table.My requirement is to count the records with each "list item". If there are 10 records with one "listitem" then that listitem should be removed from the dropdown list.
The above code is working fine for one list item, But I need for 7 list items. Do I need to write the stored procedure or I need to write select statements 7 times.

Thanks Vani Kulkarni for early response.Kindly let me know how to write a stored procedure. I am new to programming. Can any body tell complete code. Thanks in advance.