ASP.NET

Re: how to export gridview data to new pdf file without using third party tool / library in ASP.net 2.0

24-Aug-07 1:02

incase if u can modify these exisitng codes
take a look
http://www.codeproject.com/cs/library/giospdfnetlibrary.asp

winnie

here2learn24-Aug-07 3:06

here2learn

24-Aug-07 3:06

Thanks winnie. i am trying with this but till now not got it working, once it works normaly, then i will try to change it based on my needs.

presently it's throwing lots of error, so i need to correct those errors. hope soon it should work.

People often say that motivation doesn't last. Well, neither does bathing - that's why we recommend it daily
Akhilesh Singh

Re: how to export gridview data to new pdf file without using third party tool / library in ASP.net 2.0

Dhyanga31-Aug-10 6:35

Dhyanga

31-Aug-10 6:35

Did you get it work ?? i am trying the same thing..

suchita

isdate()

mohant$.net23-Aug-07 23:25

23-Aug-07 23:25

hello
java script have the isdate() function ?.

Mohan t working for N.I.C

codelinks24-Aug-07 0:09

24-Aug-07 0:09

there are numerous custom built functions...
i got these from other forums, try it out
*****************************************************
function isDate(dtStr){
var daysInMonth = DaysArray(12)
var pos1=dtStr.indexOf(dtCh)
var pos2=dtStr.indexOf(dtCh,pos1+1)
var strMonth=dtStr.substring(0,pos1)
var strDay=dtStr.substring(pos1+1,pos2)
var strYear=dtStr.substring(pos2+1)
strYr=strYear
if (strDay.charAt(0)=="0" && strDay.length>1) strDay=strDay.substring(1)
if (strMonth.charAt(0)=="0" && strMonth.length>1) strMonth=strMonth.substring(1)
for (var i = 1; i <= 3; i++) {
if (strYr.charAt(0)=="0" && strYr.length>1) strYr=strYr.substring(1)
}
month=parseInt(strMonth)
day=parseInt(strDay)
year=parseInt(strYr)
if (pos1==-1 || pos2==-1){
alert("The date format should be : mm/dd/yyyy")
return false
}
if (strMonth.length<1 || month<1 || month>12){
alert("Please enter a valid month")
return false
}
if (strDay.length<1 || day<1 || day>31 || (month==2 && day>daysInFebruary(year)) || day > daysInMonth[month]){
alert("Please enter a valid day")
return false
}
if (strYear.length != 4 || year==0 || year<minyear ||="" year="">maxYear){
alert("Please enter a valid 4 digit year between "+minYear+" and "+maxYear)
return false
}
if (dtStr.indexOf(dtCh,pos2+1)!=-1 || isInteger(stripCharsInBag(dtStr, dtCh))==false){
alert("Please enter a valid date")
return false
}
return true
}
**************************************************
regards

winnie

mohant$.net24-Aug-07 0:13

24-Aug-07 0:13

thank u.but its a custom function.there is any inbuild function

Mohan t working for N.I.C

codelinks24-Aug-07 0:19

24-Aug-07 0:19

in vbscript the isDate built function is there, but in JS have no idea bout that....

winnie

mohant$.net24-Aug-07 0:21

24-Aug-07 0:21

yes exactly.u r correct java script doesn't hav that function.thank u

Mohan t working for N.I.C

Vasudevan Deepak Kumar24-Aug-07 0:23

24-Aug-07 0:23

Date.Parse

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

mohant$.net24-Aug-07 0:26

24-Aug-07 0:26

hi
in javascript.isdate() function

Mohan t working for N.I.C

GMDatePicker

kiran.puchakayala23-Aug-07 22:46

kiran.puchakayala

23-Aug-07 22:46

How iam using GMDatePicker for entering the

date time .now my problem is

if i selct that as null its sotored in to data base

as 01-01-1900 instead of that ineed to

store

null value how can i do that

Kiran Kumar.P

Vasudevan Deepak Kumar23-Aug-07 23:04

23-Aug-07 23:04

I don't think even you assign Null to a DateTime variable since it will elicit a compile time error. Thatz why perhaps, we have a DateTime.MinValue in existence.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

kiran.puchakayala23-Aug-07 23:30

kiran.puchakayala

23-Aug-07 23:30

Hai
how can i insert null
if user is not insert any
value that is myquestion

Kiran Kumar.P

Imran Khan Pathan23-Aug-07 23:35

Imran Khan Pathan

23-Aug-07 23:35

U can't insert NULL For Datetime datatype.

Check out if Date is "01-01-1900" then display "" Instead of "01-01-1900"

Best Regard

Pathan

---------------------------------------------------

Vasudevan Deepak Kumar24-Aug-07 0:03

24-Aug-07 0:03

NULL is not an allowed value for DateTime. Your best bet is the predefined constant DateTime.MinValue.

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips

urgent

jai 12323-Aug-07 21:43

jai 123

23-Aug-07 21:43

hi please help me i have designed a form in asp.net with sqlserver.

<asp:dropdownlist id="ddcountry" style="Z-INDEX: 104; LEFT: 320px; POSITION: absolute; TOP: 232px"
="" runat="server" width="160px">
<asp:listitem>India
<asp:listitem>US
<asp:listitem>UK
<asp:listitem>Canada

SqlConnection con=new SqlConnection("database=anand;server=sdiserver;uid=sa;pwd=sa");
con.Open();
SqlCommand cmd=new SqlCommand("Insert into jai(name,age,gender,conntry)values('"+Txtname.Text+"','"+Txtage.Text+"','"+txtgender.Text+"','"+coun+"'",con);
cmd.ExecuteNonQuery();
con.Close();

i am getting this error
Incorrect syntax near 'India'

please help me

jai prakash

Re: urgent [modified]

Imran Khan Pathan23-Aug-07 21:49

Imran Khan Pathan

23-Aug-07 21:49

Missing to enclose query ")" after coun

Best Regard

Pathan

-- modified at 5:30 Friday 24th August, 2007

---------------------------------------------------

codelinks23-Aug-07 22:01

23-Aug-07 22:01

u can take the suggestion given by the previous thread

winnie

\laddie23-Aug-07 22:21

\laddie

23-Aug-07 22:21

Hai,

Just my small suggestion..This is a regular problem when using the SQl query in this way and is considered a bad programming practice.. You can make it better and free from error by doing it like below.

SqlConenction con = new SqlConnection("database=anand;server=sdiserver;uid=sa;pwd=sa");

con.Open();

SqlCommand cmd = new SqlCommand("insert into jai(name,age,genter,country) values(@name,@age,@genter,@country)",con);

cmd.Parameters.Add("@name",SqlDbType.Char).Value = Txtname.Text;
cmd.Parameters.Add("@age",SqlDbType.Int).Value = int.Parse(Txtage.Text);
cmd.Parameters.Add("@genter",SqlDbType.Char).Value = txtgender.Text
cmd.Parameters.Add("@country",SqlDbType.Char).Value = coun;

cmd.ExecuteNonQuery();

This will help you a lot when doing queries with large number of parameters.

Hope this helps

Laddie

N a v a n e e t h23-Aug-07 22:29

N a v a n e e t h

23-Aug-07 22:29

jai aswitha wrote:
SqlCommand cmd=new SqlCommand("Insert into jai(name,age,gender,conntry)values('"+Txtname.Text+"','"+Txtage.Text+"','
"+txtgender.Text+"','"+coun+"'",con);
cmd.ExecuteNonQuery();

If this example is only for some demonstration purpose, then this is ok. You can accept the suggestion given by first poster. But if you are using this in a online server, It looks like you are very closer to SQL Injection Attacks. You should never write queries like this, use parameterized queries or stored procedures. To know regarding the attacks check this[^] excellent article.

My Website | Ask smart questions

Vasudevan Deepak Kumar23-Aug-07 23:06

23-Aug-07 23:06

Amongst all syntax and semantic errors that I would like to guide you in this query, the first and foremost to suggest you is that you should take remedial steps to solve the aggressive SQLInjection vulnerability that is blatantly visible in this code snippet. Smile | :)

Vasudevan Deepak Kumar
Personal Homepage
Tech Gossips