|
Waheed Ur Rehman wrote: if in the brackets i have anoter function and so on then what to do
Your expression should be able to look for the text inside the outer brackets.
Waheed Ur Rehman wrote: i think if i make the textbox text execute it can check but how can i make it a code statement which will execute on button click
This is an alternative approach. You can use reflection to invoke the method. This[^] article explains it.
|
|
|
|
|
Hi...
I am developing a project called Info Dial....I got stuck at a place where i have to store an excel sheet into a database that can be displayed in a grid view....thats working fine for a single Excel sheet...but what if i have more than one excel shhets  ??How can i overcome this problem?
I have my code as shown....
if (FileUpload1.PostedFile != null && FileUpload1.PostedFile.ContentLength > 0)
{
string fn = System.IO.Path.GetFileName(FileUpload1.PostedFile.FileName);
string savelocation = @"D:\programs\" + fn;
FileUpload1.PostedFile.SaveAs(savelocation);
string excelConnectionString = ("Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + savelocation + ";" + "Extended Properties=Excel 8.0;");
// Create Connection to Excel Workbook
OleDbConnection connection = new OleDbConnection(excelConnectionString);
OleDbCommand command = new OleDbCommand("Select * FROM [Sheet1$]", connection);
connection.Open();
// Create DbDataReader to Data Worksheet
System.Data.OleDb.OleDbDataReader dr = command.ExecuteReader();
// SQL Server Connection String
string sqlConnectionString = "Database=Infodial;server=s156;uid=sa;pwd=sa";
// Bulk Copy to SQL Server
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlConnectionString);
bulkCopy.DestinationTableName = "companydetails";
bulkCopy.WriteToServer(dr);
connection.Close();
ScriptManager.RegisterStartupScript(Page, this.GetType(), "alert", "<script>alert('Saved in Database Successfully');</script>", false);
}
Any code would be appreciated...
Thanks in Advance
Regards
Abhishek.
|
|
|
|
|
Hi all,
I am gettting the invalid charcter error msg
<button onclick="__doPostBack('btnClear','')" id="btnClear" class="btn" title="Alt-C" accesskey="C" style="width: 56px">Clear</button>
<button id="btnSave" runat="server" class="btn" onclick="btnSave_OnClick" type="button">Save</button><br />
Can some one help ?
Dana
|
|
|
|
|
What is this Button tag ? Do you mean asp:button ?
|
|
|
|
|
It is HTML Button with Runat Attribute set to TRUE
|
|
|
|
|
Well, the examples give by you runs well at my end.
|
|
|
|
|
use html input tag
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns= "http://www.w3.org/1999/xhtml">
<head><title>
Subject Master
</title>
<link href=Spaceinvador.css type="text/css" rel=Stylesheet />
<style type="text/css">
BUTTON.btn
{
border:groove inset 1px #000000;
background:#84B0DC;
filter:progid:DXImageTransform.Microsoft.Gradient(startColorstr='#84B0DC',endColorstr='#ffffff', gradientType='0')
progid:DXImageTransform.Microsoft.dropshadow(OffX=2, OffY=2, Color='#8b9b99', Positive='true');
color:#00000;
font-family: Verdana;
font-size: 8pt;
font-weight:bold;
}
</style>
</head>
<script language ="vbscript" type ="text/vbscript" >
Function Call_Mandatry()
If Len(Trim(document.frmSubjectMaster.txtDescription.value))>0 Then
document.getElementById("imgMandatory").style.width=0
document.getElementById("imgMandatory").style.height=0
document.getElementById("imgMandatory").style.visibility ="hidden"
Else
document.getElementById("imgMandatory").style.width=7
document.getElementById("imgMandatory").style.height=14
document.getElementById("imgMandatory").style.visibility ="visible"
End If
End Function
</script>
<script language ="vbscript" type ="text/vbscript" >
Function BValidateNumber(key)
BValidateNumber = (key >= Asc("0") And key <= Asc("9"))
End Function
Sub ValidateNumber()
window.event.returnValue = BValidateNumber(window.event.keycode)
End Sub
</script>
<script language ="javascript" type ="text/javascript" >
function Delete()
{
if(confirm('Delete Subject?'))
{
return true;
}
else
{
return false;
}
}
function TABLE1_onclick() {
}
function Submit1_onclick() {
}
</script>
<body>
<form name="frmSubjectMaster" method="post" action="SubjectMaster.aspx?Resid=1&css=Spaceinvador.css" id="frmSubjectMaster">
<div>
<input type="hidden" name="__EVENTTARGET" id="__EVENTTARGET" value="" />
<input type="hidden" name="__EVENTARGUMENT" id="__EVENTARGUMENT" value="" />
<input type="hidden" name="__VIEWSTATE" id="__VIEWSTATE" value="/wEPDwULLTEwOTUwOTIzNzMPFgQeCGludGNvdW50BQMxMDgeCHN0cmNvdW50BQZTVUIxMDgWAgIDD2QWBAIZD2QWAgIDDw8WAh4EVGV4dAUGU1VCMTA4ZGQCHQ9kFgICAQ8WAh4LXyFJdGVtQ291bnQCBxYOAgEPZBYEAgEPDxYCHwIFBlNVQjEwN2RkAgMPDxYCHwIFAmMjZGQCAg9kFgQCAQ8PFgIfAgUGU1VCMTA2ZGQCAw8PFgIfAgUEVGVzdGRkAgMPZBYEAgEPDxYCHwIFBlNVQjEwNWRkAgMPDxYCHwIFBlZCLk5FVGRkAgQPZBYEAgEPDxYCHwIFBlNVQjEwNGRkAgMPDxYCHwIFA1NRTGRkAgUPZBYEAgEPDxYCHwIFBlNVQjEwM2RkAgMPDxYCHwIFAlZCZGQCBg9kFgQCAQ8PFgIfAgUGU1VCMTAyZGQCAw8PFgIfAgUHQVNQLk5FVGRkAgcPZBYEAgEPDxYCHwIFBlNVQjEwMGRkAgMPDxYCHwIFA0FTUGRkGAEFHl9fQ29udHJvbHNSZXF1aXJlUG9zdEJhY2tLZXlfXxYVBRBpbWJDb2xsYXBzZUVudHJ5BRNpbWJDb2xsYXBzZUxpc3RWaWV3BSVyZXBTdWJqZWN0JGN0bDAwJGltYkFzY2VuZFN1YmplY3RDb2RlBSZyZXBTdWJqZWN0JGN0bDAwJGltYkRlc2NlbmRTdWJqZWN0Q29kZQUlcmVwU3ViamVjdCRjdGwwMCRpbWJBc2NlbmREZXNjcmlwdGlvbgUmcmVwU3ViamVjdCRjdGwwMCRpbWJEZXNjZW5kRGVzY3JpcHRpb20FGHJlcFN1YmplY3QkY3RsMDEkYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwMSRidG5EZWxldGUFGHJlcFN1YmplY3QkY3RsMDIkYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwMiRidG5EZWxldGUFGHJlcFN1YmplY3QkY3RsMDMkYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwMyRidG5EZWxldGUFGHJlcFN1YmplY3QkY3RsMDQkYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwNCRidG5EZWxldGUFGHJlcFN1YmplY3QkY3RsMDUkYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwNSRidG5EZWxldGUFGHJlcFN1YmplY3QkY3RsMDYkYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwNiRidG5EZWxldGUFGHJlcFN1YmplY3QkY3RsMDckYnRuRWRpdAUacmVwU3ViamVjdCRjdGwwNyRidG5EZWxldGUFBmltZ1Jvd83lyJj4Fv2X+w+jjQyoyzasMVW/" />
</div>
<script type="text/javascript">
var theForm = document.forms['frmSubjectMaster'];
if (!theForm) {
theForm = document.frmSubjectMaster;
}
function __doPostBack(eventTarget, eventArgument) {
if (!theForm.onsubmit || (theForm.onsubmit() != false)) {
theForm.__EVENTTARGET.value = eventTarget;
theForm.__EVENTARGUMENT.value = eventArgument;
theForm.submit();
}
}
</script>
<div class ="HdrTitle">
<table id ="tblTitle" cellspacing ="0" cellpadding ="0" width ="100%" border ="0">
<tr>
<td align ="left" width ="14px">
<img id="imgQuestion" src="../Images/icon.png" style="border-width:0px;" />
</td>
<td align="left">
<span id ="sTitle" style ="FONT-WEIGHT:bold; FONT-SIZE:large">
Question Bank - Subject Master
</span>
</td>
</tr>
</table>
</div>
<div>
<table width="100%">
<tr>
<td align ="right">
<a id="lbtnHome" href="javascript:__doPostBack('lbtnHome','')">Home</a>
<span id="lblPipe">|</span>
<a id="lbtnSubjectMaster" disabled="disabled">Subject Master</a>
<span id="lblPipe2">|</span>
<a id="lbtnQuestionSetter" href="javascript:__doPostBack('lbtnQuestionSetter','')">Question Setter</a>
<span id="lblPipe3">|</span>
<a id="lbtnQuestionViewer" href="javascript:__doPostBack('lbtnQuestionViewer','')">Question Viewer</a>
</td>
</tr>
</table>
</div>
<table width ="100%">
<tr>
<td style="height: 71px">
<div id="pnlErrorMessage" style="width:500px;">
<span id="lblmessage" style="display:inline-block;color:Red;font-weight:bold;height:15px;width:568px;"></span>
</div>
</td>
</tr>
</table>
<button id="btnSave" class="btn" onclick="btnSave_OnClick" type="button">Save</button>
<input onclick="__doPostBack('Button1','')" name="Button1" type="button" id="Button1" value="button" class="btn" /><br />
<div class ="HdrTitle">
<table cellspacing ="0" cellpadding ="0" width ="100%" border ="0" id="TABLE1" onclick="return TABLE1_onclick()">
<tr class ="Section">
<th align ="left" width="98%">
<b style ="FONT-WEIGHT:bolder; COLOR:Black; font-size:small">
<span id ="SpanEntry">
Subject Entry
</span>
</b>
</th>
<th align ="right" style="height: 20px">
<input type="image" name="imbCollapseEntry" id="imbCollapseEntry" src="../Images/icon-leveldown.gif" style="border-width:0px;" />
</th>
</tr>
</table>
</div>
<div>
<div id="pnlEntry" style="width:100%;">
<table id ="tblEntry" class ="form" cellspacing ="0" cellpadding ="0" style="width: 100%">
<tr>
<td>
<span id="lblSubjectCode" style="display:inline-block;height:14px;width:120px;">
Code
</span>
</td>
<td class ="Field">
<input name="txtSubjectCode" type="text" value="SUB108" id="txtSubjectCode" disabled="disabled" class="SaveHistory" style="height:15px;width:120px;" />
</td>
</tr>
<tr>
<td>
<span id="lblDescription" style="display:inline-block;height:15px;width:120px;">
Subject
</span>
</td>
<td class ="Field">
<input name="txtDescription" type="text" id="txtDescription" onchange="vbscript:Call_Mandatry()" class="SaveHistory" style="height:15px;width:320px;" />
<img id="imgMandatory" src="../Images/BacoError.gif" style="height:13px;border-width:0px;" />
</td>
</tr>
</table>
</div>
</div>
<br />
<br />
<div class ="HdrTitle">
<table cellspacing ="0" cellpadding ="0" width ="100%" border ="0">
<tr class ="Section">
<th align ="left" width="98%">
<b style ="FONT-WEIGHT:bolder; COLOR:Black; font-size:small">
<span id ="sView">
Subject List View
</span>
</b>
</th>
<th align ="right">
<input type="image" name="imbCollapseListView" id="imbCollapseListView" src="../Images/icon-leveldown.gif" style="border-width:0px;" />
</th>
</tr>
</table>
</div>
<div id="pnlRows" style="height:13px;width:100%;">
<table class="ListShort" cellspacing ="0" border ="1" style="WIDTH:100%;BORDER-COLLAPSE:collapse">
<tr class ="Header">
<td>
<span id="repSubject_ctl00_lblCode" style="font-weight:bold;">Code</span>
<input type="image" name="repSubject$ctl00$imbAscendSubjectCode" id="repSubject_ctl00_imbAscendSubjectCode" src="../Images/icon-levelup.gif" style="border-width:0px;" />
<input type="image" name="repSubject$ctl00$imbDescendSubjectCode" id="repSubject_ctl00_imbDescendSubjectCode" src="../Images/icon-leveldown.gif" style="border-width:0px;" />
</td>
<td>
<span id="repSubject_ctl00_lblDescription" style="font-weight:bold;">Subject</span>
<input type="image" name="repSubject$ctl00$imbAscendDescription" id="repSubject_ctl00_imbAscendDescription" src="../Images/icon-levelup.gif" style="border-width:0px;" />
<input type="image" name="repSubject$ctl00$imbDescendDescriptiom" id="repSubject_ctl00_imbDescendDescriptiom" src="../Images/icon-leveldown.gif" style="border-width:0px;" />
</td>
<td>
<span id="repSubject_ctl00_lblEdit" style="font-weight:bold;">Edit</span>
</td>
<td>
<span id="repSubject_ctl00_lblDelete" style="font-weight:bold;">Delete</span>
</td>
</tr>
<tr class ="DataLight">
<td>
<span id="repSubject_ctl01_lblSubjectCode">SUB107</span>
</td>
<td>
<span id="repSubject_ctl01_lblSubjectDescription">c#</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl01$btnEdit" id="repSubject_ctl01_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl01$btnDelete" id="repSubject_ctl01_btnDelete" src="../Images/btnDelete_hdr.gif" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
<tr class ="DataDark">
<td>
<span id="repSubject_ctl02_lblSubjectCode">SUB106</span>
</td>
<td>
<span id="repSubject_ctl02_lblSubjectDescription">Test</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl02$btnEdit" id="repSubject_ctl02_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl02$btnDelete" id="repSubject_ctl02_btnDelete" src="../Images/btnDelete_hdr.gif" align="absmiddle" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
<tr class ="DataLight">
<td>
<span id="repSubject_ctl03_lblSubjectCode">SUB105</span>
</td>
<td>
<span id="repSubject_ctl03_lblSubjectDescription">VB.NET</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl03$btnEdit" id="repSubject_ctl03_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl03$btnDelete" id="repSubject_ctl03_btnDelete" src="../Images/btnDelete_hdr.gif" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
<tr class ="DataDark">
<td>
<span id="repSubject_ctl04_lblSubjectCode">SUB104</span>
</td>
<td>
<span id="repSubject_ctl04_lblSubjectDescription">SQL</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl04$btnEdit" id="repSubject_ctl04_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl04$btnDelete" id="repSubject_ctl04_btnDelete" src="../Images/btnDelete_hdr.gif" align="absmiddle" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
<tr class ="DataLight">
<td>
<span id="repSubject_ctl05_lblSubjectCode">SUB103</span>
</td>
<td>
<span id="repSubject_ctl05_lblSubjectDescription">VB</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl05$btnEdit" id="repSubject_ctl05_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl05$btnDelete" id="repSubject_ctl05_btnDelete" src="../Images/btnDelete_hdr.gif" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
<tr class ="DataDark">
<td>
<span id="repSubject_ctl06_lblSubjectCode">SUB102</span>
</td>
<td>
<span id="repSubject_ctl06_lblSubjectDescription">ASP.NET</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl06$btnEdit" id="repSubject_ctl06_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl06$btnDelete" id="repSubject_ctl06_btnDelete" src="../Images/btnDelete_hdr.gif" align="absmiddle" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
<tr class ="DataLight">
<td>
<span id="repSubject_ctl07_lblSubjectCode">SUB100</span>
</td>
<td>
<span id="repSubject_ctl07_lblSubjectDescription">ASP</span>
</td>
<td align ="left">
<input type="image" name="repSubject$ctl07$btnEdit" id="repSubject_ctl07_btnEdit" src="../Images/btnEdit_hdr.gif" align="absmiddle" style="border-width:0px;" />
</td>
<td align ="left">
<input type="image" name="repSubject$ctl07$btnDelete" id="repSubject_ctl07_btnDelete" src="../Images/btnDelete_hdr.gif" onclick="javascript:return confirm('Do you want to delete this?');" style="border-width:0px;" />
</td>
</tr>
</table>
<div>
<table width ="100%">
<tr class ="DataDark" >
<td align ="right" >
<span id="lblRow" style="display:inline-block;height:15px;width:200px;">Number of rows</span>
<input name="txtRow" type="text" id="txtRow" onkeypress="vbscript:ValidateNumber" style="width:23px;" />
<input type="image" name="imgRow" id="imgRow" accesskey="W" title="Alt-W" src="../Images/forward.gif" style="border-width:0px;" />
</td>
</tr>
</table>
</div>
</div>
<table width ="100%">
<tr>
<td align ="right">
<b>Version: 1.0.0.0</b>
</td>
</tr>
</table>
<div>
<input type="hidden" name="__EVENTVALIDATION" id="__EVENTVALIDATION" value="/wEWHQL75qKdAgK9zLaDDALuy465AQKSxsW6BQKM54rGBgKxlL3GCwL0lKzlBgKE3ev/AwLw7veFDwLQ4KnaBQLatbm4BALGk7CUBQKTxtfTAwLOp4ymBwKH+rPmCALOp/C5DgKH+u/DDgLOp4T1DQKH+qu1DwLOp6jWCQKH+qfgCQLOp9ySDwKH+oNTAs6ngPQKAof6//0KAs6nlK8KAof6u+8LAoX7zuYMAqvJ2ecNUIq5ZDmvFIMpkwdiOBl6HG2OT+Y=" />
</div></form>
</body>
</html>
Error at
Line 161 Charcter 2, Invalid Charcter
|
|
|
|
|
please select line where your error occure
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
This one
<button id="btnSave" class="btn" onclick="btnSave_OnClick" type="button">Save</button> <input onclick="__doPostBack('Button1','')" name="Button1" type="button" id="Button1" value="button" class="btn" /><br />
|
|
|
|
|
Save
solution :
Save
If you are using button tag then it not allow to use type="button"
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
Hi all,
I have style as
<style type="text/css">
BUTTON.btn
{
border:groove inset 1px #000000;
background:#84B0DC;
filter:progid:DXImageTransform.Microsoft.Gradient(startColorstr='#84B0DC',endColorstr='#ffffff', gradientType='0')
progid:DXImageTransform.Microsoft.dropshadow(OffX=2, OffY=2, Color='#8b9b99', Positive='true');
color:#00000;
font-family: Verdana;
font-size: 8pt;
font-weight:bold;
}
</style>
I tried apply this to asp:button. But it works well with the Html Button. What could be the issue ?
Thanks in Advance
Dana
|
|
|
|
|
for asp button use the
<asp:button cssclass="stylename">
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
Hi Trishul ,
What I have to use ?
|
|
|
|
|
hi...
i don't understand what u say
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
In your previous post you have said this only
for asp button use the
|
|
|
|
|
use cssclass="cssclassname" property of asp:button
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
|
Hi Everybody,
I want to learn about Design patterns in .net. But i dont know anything regarding this. I search for this in google. But they are not much understandble to me. Can any one give the source for this to learn easily.
Where can i found the information from basics regarding design patterns.
OR
Can any one explain briefly here itself only.
Thanks
G. Satish
|
|
|
|
|
Satish - Developer wrote: Can any one explain briefly here itself only.
It's tough to explain all design patterns here. Look at Microsoft's patterns and practices page. There are many examples. Workout the examples and come up with doubts.
|
|
|
|
|
Hi,
I have a problem with me in my project i want to show country and it's corresponding states in a dropdownlist..i want to show each country name in bold and italics..i applied the styles but didn't work in internet explorer..andit's workin mozilla...
Can anybodyhelp me tosolve this issue ..
regards
alex.
|
|
|
|
|
Hi!
I have a dynamic gridview which is populated based on treeview node selection. I need to hightlight the row of gridview if user selects it. i did it by doing
Session("myID") = CType(gvBuildingComponent.SelectedDataKey.Item("bcTemplateId"), Integer)
now if i change the treenode to another and if the gridview returns matching value with
Session("myID"), I need to hightlight it could someone help me please.
|
|
|
|
|
is my question not clear or the solution isnt easy? could someone at least please tell me if its possible or not
|
|
|
|
|
Hi friends
I am creating a connection object in master page I want use it in my content page how I can access the same connection object which is in master page in all my content pages
Prasanna Kumar.B
|
|
|
|
|
You need to create a public property in the master page which exposes the required object to content pages. Then use Page.Master.YourProperty to access it.
Your design is broken I think. Accessing connection objects from the master page to all content pages are not a good design. Consider splitting the data access part to other classes.
|
|
|
|
|
ERROR : URI formats are not supported
Best Regards,
Trishul Tandel
Software Developer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
