|
hi,
when i am running this query from sql server query analyzer it won't return a single record from table.while table has number of records matching this field.
select * from csvdata where [source]='529042010\All Data 4cr\0.66cr_calicut_1401 '
plz suggest me solution.
thanks in advance.
no knowledge in .net
|
|
|
|
|
|
hi,
yes JHizzle table has more than one thousand records matching to the value.
and i don't want to use like keyword
no knowledge in .net
|
|
|
|
|
Touch tricky to nail ti down without being able to see it I'm afraid but;I've just noticed one thing that's a bit odd about your query. There's a space at the right hand side of your search string. What happens when that's removed?
|
|
|
|
|
still no results, on removing space from the the value.
does backslash affect my query or the starting number that is prefix in my query?
no knowledge in .net
|
|
|
|
|
there is one space in end of this '529042010\All Data 4cr\0.66cr_calicut_1401 '
remove space i.e. you use '529042010\All Data 4cr\0.66cr_calicut_1401'
|
|
|
|
|
In case you are not getting any matching rows even after removing the extra space from the end of the string, and you are sure that there are matching values in the table, there must be a small catch somewhere which you/we are not able to understand.
Few questions:
1. Are you getting matching rows with LIKE clause?
select * from csvdata where [source] LIKE '529042010\All Data 4cr\0.66cr_calicut_1401%'
2. What is the datatype of the target column?
3. Can you please paste some values directly from csvdata table which, you think, should match with the condition?
|
|
|
|
|
Write this Question in General database forum........... 
|
|
|
|
|
foreach (GridViewRow rw in this.grdEmpSearch.Rows)
{
ChkBox =(CheckBox(rw.Cells[0].FindControl("chk"));
if (ChkBox.Checked)
{
chkCount++;
}
}
i wrote the above code to check whether the checkbox inside a grid is checked or not but although the checkbox is not checked the above code is returning checked true is all the cases....
|
|
|
|
|
I haven't down-voted you for the one I replied before this because I didn't see the other two posts' content.
Now my 1-vote! 
..Go Green..
|
|
|
|
|
foreach (GridViewRow rw in this.grdEmpSearch.Rows)
{
ChkBox =(CheckBox(rw.Cells[0].FindControl("chk"));
if (ChkBox.Checked)
{
chkCount++;
}
}
i wrote the above code to check whether the checkbox inside a grid is checked or not but although the checkbox is not checked the above code is returning checked true is all the cases....
|
|
|
|
|
Use this
int checkedCount = 0;
foreach (GridViewRow row in gvData.Rows)
{
bool result = ((CheckBox)row.FindControl("CheckBox1")).Checked;
if (result)
{
return true;
}
else
{
return false;
}
}
|
|
|
|
|
foreach (GridViewRow rw in this.grdEmpSearch.Rows)
{
ChkBox =(CheckBox(rw.Cells[0].FindControl("chk"));
if (ChkBox.Checked)
{
chkCount++;
}
}
i wrote the above code to check whether the checkbox inside a grid is checked or not but although the checkbox is not checked the above code is returning checked true is all the cases....
|
|
|
|
|
Already posted in Q&A section.
..Go Green..
|
|
|
|
|
When the code is not separated to index.aspx and index.aspx.vb
but all the code aspx and vb in the same page index.aspx
where I can but the code such as :
Imports system.IO
|
|
|
|
|
<%@ Import Namespace="myNamespace">
Try this..
|
|
|
|
|
Thanks .
But this error is occurred:
Parser Error Message: The server block is not well formed.
|
|
|
|
|
k try this
<%@ Import Namespace="system.IO" %>
|
|
|
|
|
You have missed server side tage closing character "%>" ( you have provided ">" only )
Thanks,
Arindam D Tewary
|
|
|
|
|
i do have 2 gridviews in my page, both of which contains check boxes. i need to uncheck and enable second gridview when any of the checkbox from first gridview is selected and vice versa.
|
|
|
|
|
Here is a demo example, i m takin two grids and than disabling and enabling the second one through checkbox click in first one through javascript.
.aspx code
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField>
<ItemTemplate>
<input type="checkbox" id="chkitemheader" name="chkitemheader" onclick="SelectAll('chkitemheader');" />
<ItemTemplate>
</asp:TemplateField>
<Columns>
</asp:GridView>
<asp:GridView ID="GridView2" runat="server" style="visibility:hidden;">
</asp:GridView>
Javascript:-
function SelectAll(id) {
if(document.getElementById(id).checked)
{
var grid = document.getElementById("<%= GridView2.ClientID %>")
grid.style.visibility = "visible";
}
else {
var grid = document.getElementById("<%= GridView2.ClientID %>")
grid.style.visibility = "hidden";
}
}
</script>
modified on Friday, May 7, 2010 4:00 AM
|
|
|
|
|
thanks , but i need to enable asp.net checkbox inside gridview .
|
|
|
|
|
1. You need to put a javascript function in each checkbox in row in first gridview. in that checkbox you call the javascript function as follows
<asp:checkbox ...... OnClientClick = "return EnableBelowGrid(this.id)" />;
2. Following would be your javascript function defination
function EnableBelowGrid()
{
var chkBoxID = arguments[0];
if(document.getElementByID(chkBoxID).checked)
{
document.getElementById('<%=BelowGridID.ClientID%>').disabled = true
}
return false;
}
Assumed that "BelowGridID" is the ID of your below grid as you have refered.
Thanks,
Arindam D Tewary
|
|
|
|
|
je ss un etudiant comme CDA creation et développement des application intranet Extranet et mon projet de fin d etude et un mélange entre forum de discussion et site des cours numériser et cours video upload et download ben si quilqu un peu m aider si il vous plez
|
|
|
|
|
mouadel wrote: je ss un etudiant comme CDA creation et développement des application intranet Extranet et mon projet de fin d etude et un mélange entre forum de discussion et site des cours numériser et cours video upload et download ben si quilqu un peu m aider si il vous plez
 What is this ? Can you please write it in English ?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
