Comments by baskaran chellasamy (Top 145 by date)

anything friend

I have created the gridview columns dynamically in the subjectdropdown_selectedIndexChanged event not in the page_load event. and my gridiew has editable textbox control. in that i enter mark then only i pass this grid in the another button click event.

protected void Page_Load(object sender, EventArgs e)
{
Button1.Visible = false;
Button2.Visible = false;
if (!IsPostBack)
{
int year = DateTime.Now.Year;
int month = DateTime.Now.Month;
DataTable acyear = inter.bindacademicyears(year,month);
// acyeardropdown.Items.Insert(0, "Select Year");
for (int i = 0; i < acyear.Rows.Count; i++)
{
acyeardropdown.Items.Add(acyear.Rows[i]["FromYear"].ToString() + "-" + acyear.Rows[i]["ToYear"].ToString());

}
bindmedium();
bindclass();
studmarkgrid.DataBind();

}

anything friend.

This is my Insertumark method.
public bool inserstumark(Commonpropertis comp, System.Web.UI.WebControls.GridView grid)
{
bool result = false;
if (comp.EXAMNAMES != "Annual Exam" || comp.EXAMNAMES!="Half yearly Exam"|| comp.EXAMNAMES!="Quartely Exam" )
{

int rows = grid.Rows.Count;
for (int i = 0; i < rows; i++)
{
comp.ROLLNUMBER = (grid.Rows[i].Cells[1].Text);
// comp.ADMISSIONNUMBER = Convert.ToInt32(grid.Rows[i].Cells[0].Text);
// System.Web.UI.WebControls.Label lbl = grid.Rows[i].FindControl("lblrollno") as System.Web.UI.WebControls.Label;
// comp.ROLLNUMBER = lbl.Text;
// comp.NAME = grid.Rows[i].Cells[2].Text;
System.Web.UI.WebControls.TextBox txt = grid.Rows[i].FindControl("mark2txt") as System.Web.UI.WebControls.TextBox;
comp.EXTERNALMARK =Convert.ToInt32(txt.Text);
result= userdao.inserstumark1(comp);
}
return result;

In bool studm = inter.inserstumark(comp,studmarkgrid) i send the gridview to read data from gridview and stored to database. but this method is in the "button1_click" event. and i bind the gridview in the "subjectdropdown_SelectedIndexChanged". so in "inserstumark" i got the null value for all data that bind in the gridview

through c#.

c#

In a second parameter subjectlist will be changing dynamically. so i need the add the subjectlist for the column header dynamically. for that i need to refresh the datatable based on the situation. i think it is better every time when i execute method i want to refresh datatable and also delete the column name is also.

then how do i skip the loop after first time. i dont know how to skip, because it is the column header name.

because whenever execute this method i add extra column based on the dynamic situation. but this three column are fixed. in a second time i execute the this method it return an error that specify Above three column is added already.so that i need to refresh this table in every execution.

gridview is bind dynamically with different columns based on the condition. so i cannot add the column in aspx page.

because in mark entry we dont like go with click every row for new mark entry.because for 40 student we need to click 40 rows.That is possible in windows datagridview.

no. In a cell[3] I want to bind two column value.so i cannot bind it datasource.

I cannot able to get value from gridview using Text property.because first four columns are read only column.

yes i read that one also. my problem after register user details, i dont have the aspnetdb.mdb file in app_data folder.

Yes. changes are not seen in the designer. why it is not happen? please explain me

I have installed accessdatabase engine 64 bit after uninstall all the 32 bit msoffice. now i check the query based on this
<pr>
SELECT * FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0', 'Excel 12.0;Database=c:\generalholiday.xls','select * from [sheet1$]')
</pre>
I provide the network service to this excel file.but this error still occur
<pre>
OLE DB provider "Microsoft.ACE.OLEDB.12.0" for linked server "(null)" returned message "The Microsoft Access database engine could not find the object 'sheet1$'. Make sure the object exists and that you spell its name and the path name correctly. If 'sheet1$' is not a local object, check your network connection or contact the server administrator.".
</pre>

sorry i dont have the office 64 bit. so please tell any other way. my primary goal is upload the excel file to sql server using c# application

i cant install 64 bit databaseaccessengin 64 bit

I try to install 64 bit but i cannot able to install 64 bit. it expose the warning that said "please unistall all the 32 bit ms office file. I uninstalled ms office 2007 (32 bit). but still that problem occures.what can i do.

I Configured ad-hoc distributed quires to true.but still same problem is occur.

Configuration option 'Ad Hoc Distributed Queries' changed from 1 to 1. Run the RECONFIGURE statement to install.

it did not open.for second i try with full path also. same error occur

i created designer page. but i have some problem with controls.I have dragged the textbox into aspx file but when i enter the name of the textbox in the aspx.cs file, it shows the TextBox1 not available in the current context. what is the problem?

my question is which one is first need assign whether roll number or section.

how can use in combobox windows application

yes i posted the same question sorry for that. but i tried with my best to get result. but not able to find solution.so that once again post that question

yes that table contain 4 days "monday,'tuesday' wednesday' thursday.

sorry i stuck with this problem from yesterday.
when i go through the code in for loop, it set the row[i].headercell.value to the particular string.but when datagridview shows, row header text not appear. i check all the properties and i confused why in this gridview only not showing text in row header

before this for loop i set the datasource to datagridview. full code is
DataTable result= userdao.getdateanddayfortimetable1(comp);
DataTable period = userdao.getperiodfortimetable();
int periodcount = period.Rows.Count;
int daycount = result.Rows.Count;
DataTable dt = new DataTable();
for (int i = 0; i < periodcount; i++)
{
dt.Columns.Add();
}
for (int j = 0; j < daycount; j++)
{
dt.Rows.Add();
}
//System.Windows.Forms.DataGridView grid = new System.Windows.Forms.DataGridView();
PLayer.GenerateTimetable gt = new PLayer.GenerateTimetable();
// gt.dataGridView1.DataSource = dt;

for (int k = 0; k < periodcount; k++)
{
//gt.dataGridView1.Columns[k].HeaderText
dt.Columns[k].ColumnName= period.Rows[k]["PeriodNo"].ToString()+"(" + period.Rows[k]["StartTime"].ToString() +"-"+ period.Rows[k]["EndTime"].ToString() + ")";
}
PLayer.TimeTable timetable = new PLayer.TimeTable();
timetable.timetablegrid.DataSource = dt;
//for (int m = 0; m < daycount; m++)
//{
// string rowheader = result.Rows[m]["Working_day"].ToString();
// timetable.timetablegrid.Rows[m].HeaderCell.Value = rowheader;

//}
for (int i = 0; i < daycount; i++)
{
//System.Windows.Forms.DataGridViewRow row = new System.Windows.Forms.DataGridViewRow();
//row.HeaderCell.Value = result.Rows[i]["Working_day"].ToString();
timetable.timetablegrid.Rows[i].HeaderCell.Value = result.Rows[i]["Working_day"].ToString();
}


timetable.Show();

in this first two datatable contains data for setting columnname and rowheader and how many row and column need to be create. here i already set column name but i cannot able to set rowheader. even i try the following code for checking
timetable.timetablegrid.Rows[i].HeaderCell.Value=(i+1).ToString(), still it does not work. but the same code working in another gridview for rowheader text. thats why i am stuck here.

i am new for wcf.so please tell me how to connect and browse the service

actually i found smtp address by typing ping smtp.server.com. that adddress is 216.69.186.201. and my code for sending email is
MailMessage Msg = new MailMessage();
// Sender e-mail address.
Msg.From = txtFrom.Text;
// Recipient e-mail address.
Msg.To = txtTo.Text;
Msg.Subject = txtSubject.Text;
Msg.Body = txtBody.Text;
// your remote SMTP server IP.
SmtpMail.SmtpServer = "216.69.186.201";
SmtpMail.Send(Msg);
Msg = null;
Page.RegisterStartupScript("UserMsg", "<script>alert('Mail sent thank you...');if(alert){ window.location='SendMail.aspx';}</script>");


and the error is
The message could not be sent to the SMTP server. The transport error code was 0x800ccc6f. The server response was 554 Your access to this mail system has been rejected due to the sending MTA's poor reputation. If you believe that this failure is in error, please contact the intended recipient via alternate means.

How can solve this problem.

thank you its working fine.

yes the problem in DbType = 'param[1].DbType' threw an exception of type 'System.ArgumentException'.sorry not in executescaler().it accept proper.admissionnumber,but error in the second parameter.

in executescaler(),the error occured.if apply data in storedprocedure alone its working fine. but the same value throw error in this executescaler() method.

No,still same error occured

Thanks OrginalGriff. But one thing when first click on the cell, it is not selected,but after a second click on any cell, the row fully selected. what happen

if it is non numeric then how can it accept numeric value in comboboxleave event

sorry man
what you are giving is same as my query. here my problem is on join query. but i ran your method also.still i am not getting result

subject code is not static for all class. it is different for each class

thank you friends. but still it is static. because some time for classes no of subject to be change and name of the subject also will change.so that i want to get subjectname for a particular class from sql server table. In there I set how many subject for per class and subject name also. so i want to get subjectname at run time

actually subject name could be changed dynamically for classwise. so i cannot set this one as a static.

yes

varchar(30) and when i make a cursor on error it display expected ID or quoated ID or '.'.

I tried the above you said,but still error near in ('23011'

sorry my question is wrong typed.
for example
mark _details table contain
markid examid subjectid admissionumber mark classid
1 2 23011 100 89 12
2 2 23012 100 87 12
3 2 23013 100 77 12
4 2 23011 101 98 12
5 2 23012 101 78 12
6 2 23013 101 78 12

I want like this
Rollnumber admissionumber name subject1(23011) subject(23012) subject(23013)
1001 100 XXXX 89 87 77

for classid 12.

Is pivot operator for this desired result? if the no of subjects for all class same mean we can use pivot. but here how can solve this?

ok.
I have already created the following table

1 Student table contains student personal data including his admission number
2.class table contain class details
2.section table contains section details for particular class
4.student academic table contain student for section and class
5.student roll number allocation table contain student and his roll number with admission number.
subject table contain subject details
examname table contain examname details
examclass table contain examname and classname and what are the subject for exam for a particular class.
now i want to enter mark for student for particular exam mean i want to create table for mark entry. subject column for each class will vary,so how can create mark table for particular calss and particular exam .

sorry. i tried the way that you speicfy.but i didnt get result. and also change the query like this
ALTER procedure [dbo].[sp_bindexamclass](@classid int,@examid int)
as
begin
select en.ExamName,St.Standered_name,Sr.SubjectName,ec.Maximummark,ec.Minimummark from ExamClasssetting_details ec inner join Standered_details St on ec.Classid=St.Standered_id inner join SubjectRegistration_details Sr on ec.subjectid=Sr.SubjectCode inner join ExamNameSetting_details en on en.ExamId=ec.ExamId where ec.Classid=@classid and ec.ExamId=@examid

end

but still it does not giving a result.

This is the windows application. so we cannot use databind.but we can use datasource method. but i want manually bind data to girdview,because i from datatable i just bind three column and add two column from other nature. inside the forloop we can bind datasource.If my openion is wrong,then tell me how can i do this.

this is the output of my join query

100 Chandru FirstClass A
100 Chandru FirstClass B
100 Chandru FirstClass A
100 Chandru FirstClass B

But in studentAcadamic table
AdmissionNumber sectionid standereid
100 51 12

Here 51 for section A
and 12 for firstclass
so I want to return
as

Admissionnumber studentname classname sectionname
100 chandru firstclass A

DataBind() method not available for gridview in windows application

Thank you. i solved the problem.

Msg 156, Level 15, State 1, Procedure sp_insertregistrationnumber, Line 12
Incorrect syntax near the keyword 'set'.

today some hours before data actually successfully inserted for same query.but now only it doesnt insert data.

The Query is
ALTER procedure [dbo].[sp_studadmissioninsert](@admissionnumber int,@admissiondate datetime,@fromyear smallint,@toyear smallint,@classname varchar(30),@studname varchar(50),@dob datetime,@gender char(1),@age smallint,@fathername varchar(50),@fatheroccupation varchar(50),@mothername varchar(50),@motheroccupation varchar(50),@medium varchar(25),@studenttype varchar(25),@identimark1 varchar(300),@identimark2 varchar(300),@religion varchar(15),@cast varchar(50),@castcategory varchar(10),@phonenumber varchar(20),@email varchar(80),@previousschool varchar(max),@needtransport char(1), @street varchar(200),@city varchar(50),@state varchar(50),@country varchar(50),@zipcode varchar(50),@street1 varchar(200),@city1 varchar(50),@state1 varchar(50),@country1 varchar(50),@zipcode1 varchar(15),@datetime datetime,@adminid int,@applicationnumber int )
as
set nocount on
begin
declare @cassid int,@academicid int
select @academicid=Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear
select @cassid=Standered_id from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)and Standered_name=@classname

if exists (select StudentName from StudentApplication_details where ApplicationNumber=@applicationnumber)
begin
update StudentAdmission_details set Admissiondate=@admissiondate,Academic_year_id=@academicid,ClassId=@cassid,StudentName=@studname,Age=@age,FatherOccupation=@fatheroccupation,MotherName=@mothername,MotherOccupation=@motheroccupation,Medium=@medium,StudentType=@studenttype,IdentificationMark1=@identimark1,IdentificationMark2=@identimark2,Religion=@religion,Caste=@cast,CastCategory=@castcategory,Phone_number=@phonenumber,EmailId=@email,Previous_School=@previousschool,Transport_status=@needtransport,Updateddatetime=@datetime,adminid=@adminid where AdmissionNumber=@admissionnumber and ApplicationNumber=@applicationnumber
end
else
begin
--declare @cassid int,@academicid int
--select @academicid=Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear
--select @cassid=Standered_id from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)and Standered_name=@classname
insert into StudentAdmission_details(AdmissionNumber ,ApplicationNumber ,Admissiondate,Academic_year_id,ClassId,StudentName,DOB,Gender,Age,FatherName,FatherOccupation,MotherName,MotherOccupation,Medium,StudentType,IdentificationMark1,IdentificationMark2,Religion,Caste,CastCategory,Phone_number,EmailId,Previous_School,Transport_status,Createddatetime,adminid)values(@admissionnumber, @applicationnumber,@admissiondate,@academicid,@cassid,@studname,@dob,@gender,@age,@fathername,@fatheroccupation,@mothername,@motheroccupation,@medium,@studenttype,@identimark1,@identimark2,@religion,@cast,@castcategory,@phonenumber,@email,@previousschool,@needtransport,@datetime,@adminid)
end
if exists(select Street,City,State,Country,Zipcode from TemporaryAddress_details where AdmissionNumber=@admissionnumber and ApplicationNumber=@applicationnumber)
begin
update TemporaryAddress_details set Street=@street,City=@city,State=@state,Country=@country,Zipcode=@zipcode,Updateddatetime=@datetime,adminid=@adminid where AdmissionNumber=@admissionnumber and ApplicationNumber=@applicationnumber
end
else
begin
insert into TemporaryAddress_details(Street,City,State,Country,Zipcode,Createddatetime,adminid,ApplicationNumber,AdmissionNumber)values(@street,@city,@state,@country,@zipcode,@datetime,@adminid,@applicationnumber,@admissionnumber)
end
if exists(select Street,City,State,Country,Zipcode from PermenentAddress_details where StudentApplicationNumber=@applicationnumber and StudentAdmissionNumber=@admissionnumber )
begin
update PermenentAddress_details set Street=@street,City=@city,State=@state,Country=@country,Zipcode=@zipcod

The Query is
ALTER procedure [dbo].[sp_studadmissioninsert](@admissionnumber int,@admissiondate datetime,@fromyear smallint,@toyear smallint,@classname varchar(30),@studname varchar(50),@dob datetime,@gender char(1),@age smallint,@fathername varchar(50),@fatheroccupation varchar(50),@mothername varchar(50),@motheroccupation varchar(50),@medium varchar(25),@studenttype varchar(25),@identimark1 varchar(300),@identimark2 varchar(300),@religion varchar(15),@cast varchar(50),@castcategory varchar(10),@phonenumber varchar(20),@email varchar(80),@previousschool varchar(max),@needtransport char(1), @street varchar(200),@city varchar(50),@state varchar(50),@country varchar(50),@zipcode varchar(50),@street1 varchar(200),@city1 varchar(50),@state1 varchar(50),@country1 varchar(50),@zipcode1 varchar(15),@datetime datetime,@adminid int,@applicationnumber int )
as
set nocount on
begin
declare @cassid int,@academicid int
select @academicid=Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear
select @cassid=Standered_id from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)and Standered_name=@classname

if exists (select StudentName from StudentApplication_details where ApplicationNumber=@applicationnumber)
begin
update StudentAdmission_details set Admissiondate=@admissiondate,Academic_year_id=@academicid,ClassId=@cassid,StudentName=@studname,Age=@age,FatherOccupation=@fatheroccupation,MotherName=@mothername,MotherOccupation=@motheroccupation,Medium=@medium,StudentType=@studenttype,IdentificationMark1=@identimark1,IdentificationMark2=@identimark2,Religion=@religion,Caste=@cast,CastCategory=@castcategory,Phone_number=@phonenumber,EmailId=@email,Previous_School=@previousschool,Transport_status=@needtransport,Updateddatetime=@datetime,adminid=@adminid where AdmissionNumber=@admissionnumber and ApplicationNumber=@applicationnumber
end
else
begin
--declare @cassid int,@academicid int
--select @academicid=Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear
--select @cassid=Standered_id from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)and Standered_name=@classname
insert into StudentAdmission_details(AdmissionNumber ,ApplicationNumber ,Admissiondate,Academic_year_id,ClassId,StudentName,DOB,Gender,Age,FatherName,FatherOccupation,MotherName,MotherOccupation,Medium,StudentType,IdentificationMark1,IdentificationMark2,Religion,Caste,CastCategory,Phone_number,EmailId,Previous_School,Transport_status,Createddatetime,adminid)values(@admissionnumber, @applicationnumber,@admissiondate,@academicid,@cassid,@studname,@dob,@gender,@age,@fathername,@fatheroccupation,@mothername,@motheroccupation,@medium,@studenttype,@identimark1,@identimark2,@religion,@cast,@castcategory,@phonenumber,@email,@previousschool,@needtransport,@datetime,@adminid)
end
if exists(select Street,City,State,Country,Zipcode from TemporaryAddress_details where AdmissionNumber=@admissionnumber and ApplicationNumber=@applicationnumber)
begin
update TemporaryAddress_details set Street=@street,City=@city,State=@state,Country=@country,Zipcode=@zipcode,Updateddatetime=@datetime,adminid=@adminid where AdmissionNumber=@admissionnumber and ApplicationNumber=@applicationnumber
end
else
begin
insert into TemporaryAddress_details(Street,City,State,Country,Zipcode,Createddatetime,adminid,ApplicationNumber,AdmissionNumber)values(@street,@city,@state,@country,@zipcode,@datetime,@adminid,@applicationnumber,@admissionnumber)
end
if exists(select Street,City,State,Country,Zipcode from PermenentAddress_details where StudentApplicationNumber=@applicationnumber and StudentAdmissionNumber=@admissionnumber )
begin
update PermenentAddress_details set Street=@street,City=@city,State=@state,Country=@country,Zipcode=@zipcode

Thank you for your comment.i got the solution. Actually I modified the table without delete the foreign key reference that i dont want to go through for my process.now i find solution. Thank you for your valuable solution.

sorry I have designed the student student registration form. It is Ok with all the logical process.but for design I want to improve that form. and I put 4 button for new, save,update,delete and finally one button for search. Is any screenshot available for me?

Ok thanks i will do it and i will update this comment when i need your help.

Yes I got your idea. but please help me for the following situation.
as You mentioned.
The table format could be like this

MCID Medicine_id Componenets id
1 11 101
2 11 102
3 11 103
4 12 101
5 12 104
The situation is (in application design)
TextBox value for One medicine (11) and checkboxlist for components (101,102,103) . How can add same medicine value for single insertion for medicine table and multiple insertion for medicine_component table with many checkboxlist.

But In design

thank you for your valuable suggetion. The table you are given is N:M relationship. Is it correct? what is my doubt is In application design I just given one medicine id and select multiple checkboxlist value for combination to store in this medicine-components-details.In that situation how can store value in database

tables are different

I have one doubt, when many class students take common subject at that time we cannot assign particular class room for many group of student. because the class room already assign to particular class. In that situation what can do?

I just using year to registered a class. so how can differentiate this date differenece.
and modified stored procedure is below.it with error on case statement.and if last year not registered then it could not return any class.
<pre>alter procedure sp_addstandered
as
begin
declare @fromyear int,@toyear int
declare @month varchar(30)
set @fromyear=CONVERT(int,DATEPART(YEAR,GETDATE()))
set @toyear=@fromyear + 1
case set @month= convert(varchar(30),datepart(month,getdate())) when @month='January' or 'Febraruy' or 'March' then @fromyear=@fromyear-1 end

select Standered_name from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)
end</pre>

This is my store procdure but it is an error on case statement.and also if last year not registered then i would not return correct year. please see this stored procedure and let me know to make any changes .
alter procedure sp_addstandered
as
begin
declare @fromyear int,@toyear int
declare @month varchar(30)
set @fromyear=CONVERT(int,DATEPART(YEAR,GETDATE()))
set @toyear=@fromyear + 1
case set @month= convert(varchar(30),datepart(month,getdate())) when @month='January' or 'Febraruy' or 'March' then @fromyear=@fromyear-1 end

select Standered_name from Standered_details where Acadamic_year_id=(select Acadamic_year_id from Acadamic_year where Acadamic_year_from=@fromyear and Acadamic_year_to=@toyear)
end

yes. registered with year

but already i registered class with academic year. so i dont know how datediffer help me to give a last year details for(january to march of current year ) perod.

thanks for this idea.i will try it

sorry friend
I want to add two combobox control in one single cell of gridview.but the above code give us one combobox for single cell.

thanks for reply. I solve the problem myself.i just pass datevalue to input paramters. its work fine now

Ok thanks its working fine. the problem is system default time.

ok.which one is better whether gsm modem, or third party api,sms gateway? suppose i want to use windows application that mean it is not in online.
Thank you

thank you very much.
it took hours to solve this the problem
now its working.

SELECT * FROM OPENROWSET('Microsoft.jet.OLEDB.4.0','+@datavar+;HDR=YES','SELECT Date,Day,Reason FROM [Sheet1$]')
This is the string.

sorry friends this is working.
<pre>create procedure sp_exceltest
as
set nocount on
declare @sql varchar(2000)
begin
set @sql='select * from OPENROWSET(''Microsoft.jet.OLEDB.4.0'',''Excel 8.0;Database=D:\testing.xls;HDR=YES'',''select * from [Sheet1$]'')'
exec(@sql)
end</pre>
But the above is not working.please find if i made with any syntax error

I check with this tutorial.And i found there is msexcl40.dll on two location.
1.C:\Windows\System32 The exact place to for this dll
2.C:\Windows\winsxs\x86_microsoft-windows-m..components-jetexcel_31bf3856ad364e35_6.1.7600.16385_none_1de500b1a390aab9

Is any problem will occur ragarding with these two location
thanks for advance

i am using ms2007.how can i check whether it is 32 bit or 64 bit.and only 2007 verson is installed in my system and my sistem is 32 bit

now i restart sql server and run the above query it shows the same error with adding some extra information.
the error is
<pre>OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly.".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)".</pre>

no.when i was creating the procedure at first time, query is working. but now even i create new query with new excel table it doesnt working. the procedure is successfully compiled but when the excecution it doesnt working.

yes i am sure first time its working. then after i shut down and restart the system and then only its not working.

Now i created another one excel file to execute. but this time the new excel file is also not executed. the same error occurs.

I studied the above articles and check the permission on temp folder.all the user in my system has permission to write and read and everything. but still the error occurs.if the excel file is locked mean how can i unlocked

sql server2008

I want to right in coding. and please tell me what the error in my query that was updated from above.
<pre>
alter procedure sp_excelforgeneralholidays(@filname nvarchar(max))
as
declare @datavar varchar(200)
declare @sql varchar(500)
set @datavar = 'Excel 8.0;DATABASE=' + @filname

set nocount on
begin
--create table #temptable (Date date ,Day varchar(30),Reason varchar(100))
set @sql = INSERT INTO Genaral_holydays_details(Date,Day,Reason) SELECT Date,Day,Reason FROM OPENROWSET('Microsoft.jet.OLEDB.4.0','+@datavar +;HDR=YES','SELECT Data,Day,Reason FROM [Sheet1$]')

exec (@sql)
end
</pre>
and the error is 'incorrect syntax near insert'

Is this my query is right.
<pre>create procedure sp_excelforgeneralholidays(@filname nvarchar(max))
as
declare @datavar varchar(200)
declare @sql varchar(500)
set @datavar = 'Excel 8.0;DATABASE=' + @filname

set nocount on
begin
create table #temptable (Date date ,Day varchar(30),Reason varchar(100))
set @sql = 'SELECT * into #temptable FROM OPENROWSET(''Microsoft.jet.OLEDB.4.0'','''+@datavar +''',''SELECT Data,Day,Reason FROM [Sheet1$]'')'
exec (@sql)
end</pre>


Excution part is
exec sp_excelforgeneralholidays'D:\baskaran\baskarbook1'
This baskarbook1 contain single excel sheet.

the error is syntax error near +.

Mr wes aday sorry for my incomplete questions. I have tried with best then only i post this question.but now I solve my problem myself. and i would like to say to you i wont post any question without my effort.

sorry, section__name contain two A and two B. But in combobox i want to bind only one A and one B.

ok.please tell me how can i call this value to windows form in front end.

why ask this question is In my windowsform i want to bind above two table values.ok sorry for my posting query. the query would like this
<pre>create procedure [dbo].[temptable]
as
begin
set nocount on
declare @standeredname varchar(50)
declare @acfy int ;
declare @acty int
select @standeredname=Standered_name from Standered_details
select @acfy=Acadamic_year_from,@acty=Acadamic_year_to from Acadamic_year where Acadamic_year_id=@academicyearid
create table #temptable2(Standered_name varchar(50),Acadamic_year_from smallint,Acadamic_year_to smallint)
insert into #temptable2(Standered_name,Acadamic_year_from,Acadamic_year_to)values(@standeredname,@acfy,@acty)
select * from #temptable2;
end</pre>

all are different forms.

Thank for help

Thanks.this is ok for one main form and more sub form.In my task there is two main forms like MainAdmin and SecondaryAdmin. these two contain some same sub forms. at this situation how can i do it?

This event also not working.please give me any sample code in window application for binding country,state,city based on the combobox selected value.

How can we call this stored procedure in c sharp by coding for delete query.because @id parameter is enough for deleting the row.but when calling this through this stored procedure we must enter all parameter to deleting process.if we enter the @id and statementType two parameters for delete,is this executed?

Thank you very much.its working fine now

sorry records available in the database for the corresponding parameter.in sql its working fine. but when i calling to the application then only it return null value.but i correctly pass the brachid and academicyearid to the store procedure. is the temporary table available for dataset when using temporary table to application?

same problem for my application.did you able solve the problem? if so please let me know.

i check parameter value at debug mode.all values are set to parameter.but in excutenonquery it produce -1;

it doesnt show any error.but when trace the value cmd.ExecuteNonQuery() return
-1.

its working in when excuting the storeprocdure.i got correct value in the table .when executing through visualstudio(front end)it is not working.the code for c# is
SqlCommand cmd = new SqlCommand("sp_insertclass1", Dob.con);
Dob.con.Open();
/// cmd.Connection=Dob.con;
cmd.CommandType = CommandType.StoredProcedure;
// cmd.CommandText="dbo.sp_addschool";
cmd.Parameters.Add(new SqlParameter("@standeredid",sc11.STANDEREDID));
cmd.Parameters.Add(new SqlParameter("@standeredname",sc11.STANDEREDNAME));
cmd.Parameters.Add(new SqlParameter("@branchname", sc11.BRANCHNAME));
cmd.Parameters.Add(new SqlParameter("@yearfrom", sc11.YEARFROM));
cmd.Parameters.Add(new SqlParameter("@yearto",sc11.TOYEAR));
cmd.Parameters.Add(new SqlParameter("@createddatetime", sc11.CREATEDDATETIME));
int affectedrows = cmd.ExecuteNonQuery();
return affectedrows;
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (Dob.con != null)
{
Dob.close();
}
}

no.which value neeed to pass to datetime variable at executing the storeprocedure

yes i inserted tran and commit. how can track the value from c# class about this store procedure operation

year from is 2012 and yearto is 2013 and acadamic yearid=112 and one thing i left to mentions is in db yearfrom and yearto is smallint. but in c# class i declared as a int value.if this would be problem mean which datatype need to specify in c#.

yes data present in the table

i want to bind single column values into combobox using sqldatareader in three tier architecture.please help me

thanks for your help.this will help me in future task definetly.but in my current task is i have webform that is used to add standered details.this form contain textboxes for entering standered id and standered name. three combo boxes one for entering branch name which is already created in the table of Branch,another two for entering from year,and toyear which are already created int the tale name of academic_year. now what i want is just binding these date to these combobox values on the page_load event.how to do that.

explaination of my task
table 1:brach
column1:branchname
table 2: academic_year
column1:yearfrom
column 2;yearto
I want to combind these two table value and to view on the windows form page.

The table doesnt have any relationship at all. so i couldnt able to using join method.is any other way to this problem?

i want ignore the click.please tell me how to do it

yes i have already added insert data and time column.and insert a value. but now i want add update date and time. how to do it.

thank you now its working fine

i leave the textbox as an empty but when i trace the code if condition is executed and it went to else condition.i dont know why.please help me.

thanks. keyword means how to find related example articles

sorry for this silly question.how can search it by keyword

I am very thankful for this reasonable reply.As i am a fresher i want to study about this through some article.please help me

admin pages are only in winform and this data should be available for student,parent and teachers as a report page of web application project.i am still confuse how can i set database available for local windows application and also to web application .please clear this doubt. is it possible to centeralize database for all branches(windows application) and web applicaiton (report pages)?.

i just hear about popup window in web application few minutes ago. what is role for this and at which situation we can chiled pop up window

sorry for my another question regarding with this.
The style is appeared in the menu control at designing time but it disappear at when running the application. please let me know what would be the problem for this issue.
thanks

yes.i have applied.but it does not work fine.
what i have done is
css file name:content.css
i have applied this to the derived webpage(like main.aspx)at contentplaceholder which id=head.
<link rel="stylesheet" type="text/css" href="~/content.css" />
but still it doesnt work

thanks for reply.how can i could able to send sms automatically when student enter their attendance using fingerprint device and please give sample database tables for sending sms to parents

sorry for the above question method.my question is
I want to find out how object class is coded and also other built-in classes,enumerations,interface,structure are coded.because i want to learn from root level.please help me

i just go with object class by using go definition from my class to know how base class is formed. In that it just has been written as a one line word(public virtual bool Equal(Object obj)).But i dont know where this bitwise process have been written?

symbol like a square with filled any color and find pixel value of middle point of square.for example in my neck (both side) i placed square symbol from this i need to find pixel value of both square point.

myself solve the problem and detected face.the problem is lightining and scene.thank you for posting and giving some idea.

sorry for the above post.
i have been tried with external image(jpeg) for face detection its okey.what my problem is i have an image which is taken from webcam using aforge.net.i cannot able to detect face from this image.but i convert this bitmap image to opencv image and it is converted but not detected and also there is no error detected in my code

is there any way to find neck point of human body? please tell me.

i think u are misunderstand my question or otherwise my question might with wrong meaning.what is my objective is only detect neck point rather than finding human using neck point.

thanks for reply

fixed shape

thanks for reply ..

ok thanks but i tried this aforge.net for my project.but in my project i am using webcam image in that i cannot extract human body and i should locate two points in neck of human body what can do?

ok.,first i need to extract human body from webcam image.which algorithm will help me.
thank you

thanks for reply.
no,jewel is fixed with neck on the human body. on sight we could not find difference between two images.ok what is the method to simple overlay on webcam image