|
Take a deep breath, say 'woosa' sevreal times, take caps lock off and try again.
|
|
|
|
|
Hi,
I have a grid i which i have two labels i.e. label1 and label2, now the dataset which is the source for the grid has two tables table1 and table2.
Now when binding(databinder...eval...) date to the labels label1 should get the data from the column in table1 and the label2 should get the data from the cloumn in table!!!
How could this be done?
Thanks!
Gautham
|
|
|
|
|
Make an Inner Join between two tables then bind it in datagrid
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
Score it if you like my post
|
|
|
|
|
I want to merge PDF files into one single PDF Files using asp.net
I got source code window based. But i could not convert it. If any body know this please let me know.
Thanks in advance.
Raja
|
|
|
|
|
|
Hi,
I am getting the following error: Line 1: Incorrect syntax near ','.
conn.Execute = "UPDATE JOB SET " &_
"TITLE='" & cleanText(sTitle) & "', " &_
"CATEGORY=" & cleanText(sCategory) & ", " &_
"DEPARTMENT='" & cleanText(sDepartment) & "', " &_
"DESCRIPTION='" & cleanText(sDescription) & "', " &_
"RESPONSIBILITIES='" & cleanText(sResponsibility) & "', " &_
"REQ='" & cleanText(sRequirements) & "', " &_
"COMPENSATION='" & cleanText(sCompensation) & "', " &_
"CONTACT_PERSON='" & cleanText(sContactPerson) & "', " &_
"CLOSINGDATE='" & cleanText(sClosingDate) & "', " &_
"CONTACT_EMAIL='" & cleanText(sContactEmail) & "', " &_
"StatusId='" & 0 & "' WHERE ID=" & jobID
|
|
|
|
|
.execute is a function not a property whihc can be assinged a values...
it should be conn.Execute("your query");
and i guess the ";" is also missing
Deepak Surana
|
|
|
|
|
deepaks3 wrote: and i guess the ";" is also missing
It's VB code.
---
single minded; short sighted; long gone;
|
|
|
|
|
What kind of object is conn ? There is no built-in class that has a property named Execute, is it a class of your own? Does setting the property execute the query?
What data type is the field CATEGORY? Shouldn't there be apostrophes around the value?
What does the cleanText method do? Does it encode the strings properly to be inserted as string literals in an SQL query? What kind of database are you using?
---
single minded; short sighted; long gone;
|
|
|
|
|
here the syntax is correct but when you inject the values there migt be some special characters , or '..So sql injection is little dangerous in codeing any time it will break...Better write stored procedure and call it in the front end.
All the best
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
Score it if you like my post
|
|
|
|
|
i have a gridview in which i had appplied paging. Now first column is not visible which has the id .on every page i want to get this value . how can i get this.
|
|
|
|
|
GridView1.Rows[index].Cells[0].Text;
Cells[0] refers to the column number from whihc u need the value.
deepak surana
|
|
|
|
|
i want only the first row first column value. I am not getting the first row.
|
|
|
|
|
GridView1.Rows[0].Cells[0].Text
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
Score it if you like my post
|
|
|
|
|
in the gridview i have applied paging. Now on PageIndexChanging i get the newpageindex .But i want to know the new page index on page load also . How can i get it .
|
|
|
|
|
Declare a variable on the page level and assign th current page index to it...
like
newindex =e.NewPageIndex;
deepak surana.
|
|
|
|
|
Dear All,
i am making web application using asp.net ,C# (Visual studio 2005).
i have dropdownlist with first listitem "Select one" and rest of the item comes form database I want to user should not select "Select one " option that is how can i validate dropdowmlist so that user should not select "Select one" Option.
please Provide me some idea.
Please help
thanks
regards
imran khan
|
|
|
|
|
OK there are many ways to do it
most of go with javascript
Write javascript code for that Check the dropdownlist selected index should not 0 if it then return false if not then return true very simple
<l>Thanks and Regards
Sandeep
|
|
|
|
|
Hi,
Just grab the onchange event of the dropdown in Javascript and validate. See the code below,
<br />
function validate()<br />
{<br />
var e = document.getElementById("myDropDown"); <br />
if (e.selectedIndex == 0)
{Alert('some msg');<br />
return false;<br />
} <br />
I assume 'Select One' is the first item on the drop down
Thanks,
Mubashir
Every job is a self portrait of the person who did it.
|
|
|
|
|
You can place a required filed validator.
and after binding the drop down list,
add the two lines:
DropDownList1.Items.Insert(0,"Select One");
DropDownList1.Items[0].Value = "";
If you fail for the first time , call it version 1.0.
|
|
|
|
|
I would like to fill the textbox "on the fly" while typing by suggesting "Like" words from SQL table in a div underneath.
Appreciate any help and thanks in advance...
|
|
|
|
|
|
This is exactly what i wanted.
Thanks alot and happy coding
|
|
|
|
|
You are welcome. all the best. Happy coding
Regards,
Sylvester G
Senior Software Engineer
Xoriant Solutions
sylvester_g_m@yahoo.com
|
|
|
|
|
Hi everyone
I have some audio and video files on my sever,
can any one help me how to play them on client machine .
Help me just for secure streaming
thanks
guru
|
|
|
|