Comments by Member 7909353

Member 7909353 16-Jan-20 22:02pm View

It shows high charts column type ,I want stacked bar chart

Member 7909353 15-Jan-20 23:51pm View

When I have all data to bind then what need to be rebind and get from database

Member 7909353 20-Mar-19 8:13am View

I need to pass parameters to this report when I click on a button in ssrs report(button mean link in parent rport)

Member 7909353 20-Mar-19 7:46am View

I need to pass parameters to this report when I click on a button in ssrs report(button mean link in parent rport)

Member 7909353 14-Feb-17 1:42am View

It is working but when I select BankBranch(means suggestion) then it shows on text box it's value not label.

Member 7909353 14-Feb-17 1:27am View

yes

Member 7909353 31-Jan-17 1:25am View

It is not working after selection

Member 7909353 18-Jul-16 3:31am View

Thanks it is done by pPageIndex and PageCount property

Member 7909353 15-Jul-16 8:23am View

not working

Member 7909353 15-Jul-16 8:08am View

Column "FPSDBT" show datarow record is checked or not.
If "FPSDBT" is "Yes" then checked other wise not checked.
If I have 100 records and page size is 51.
suppose "FPSDBT" is "No" of 52th record then I want check box in header row should be checked in page number 1 and not checked in page number 2

Member 7909353 3-May-16 2:18am View

Panel is always visible=true but table inside panel is visible=false,
When I set table visible=true it is working
but why?

Member 7909353 13-Apr-16 7:19am View

No! I specify in ModalPopUp CancelControlID="btncancel"

Member 7909353 13-Apr-16 6:41am View

when I click Add button first time it shows modalpopup and Bind Items to drop down list and then I hide modalpopup by clicking on cancel button it hide.
After above steps I click on add button it does fire event

Member 7909353 30-Mar-16 7:13am View

Suppose Alphanumeric, hyphen and forward slash are valid

Member 7909353 30-Mar-16 6:36am View

I want to validate Bank Challan number in javascript

Member 7909353 30-Mar-16 5:57am View

Yes I will use textbox value on the server.
And tell pattern now.

Member 7909353 21-Mar-16 6:21am View

It is working but do not call indexchange event

$(document).ready(function () {
try {
$('#<%=d.ClientID%>').on('change', function () {
try {
var StateCode = $('#<%=d.ClientID %> :selected').val();

}
catch (e) {

}
});

}
catch (e) {
alert(e);
}

});

Member 7909353 21-Mar-16 2:56am View

no I want to change index and get selected value on click buton event

Member 7909353 21-Mar-16 2:39am View

I want to change index on button click

Member 7909353 18-Mar-16 5:00am View

Dear How to read and hide errormessage of asp:RequiredFieldValidator

Member 7909353 18-Mar-16 0:25am View

how to hide

Member 7909353 16-Mar-16 1:26am View

ValidatorEnable($get('<%=rfvBankName.ClientID %>'), true); is not working

Member 7909353 15-Mar-16 6:31am View

When I enable error message should not be show. I want this.

Member 7909353 8-Mar-16 5:28am View

yes div has class='horizontal' but horizontal scroll bar does not show

if set $('#dvGridView').addClass("horizontal"); it is working bcoz div(dvGridView) created statically

Member 7909353 8-Mar-16 5:16am View

if
var str="<tr><td><div id=\"grid\"><table><thead class=\"thead-inverse\"><tr><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th><th>aaaaaa</th></tr></thead></table></div></td></tr>";

then div(id=grid) should has horizontal scroll bar.

Member 7909353 8-Mar-16 5:09am View

If table (tbl) has 50 column then div(grid) should has horizontal scroll bar

Member 7909353 8-Mar-16 1:13am View

Not working

Member 7909353 3-Mar-16 5:58am View

$('<%=rfvBankName.ClientID %>').hide(); it does not work

Member 7909353 15-Feb-16 3:38am View

setTimeout function executes one statement or function after some time it does not stop execution of next statement for some time.
I want to execute statement after execution of function().

Member 7909353 1-Feb-16 4:37am View

Actually! I have nested repeater and a gridview inside last repeater.
like repeate1(state) ,repeater2(city) and gridview(village) has information

Member 7909353 1-Feb-16 2:17am View

In my code
I clone the row first and remove that row from jquery. cloned item updated with new value and add to repeater for all the records.

Member 7909353 1-Feb-16 1:57am View

I have only commo seperated string like 'Mathura','Agara','Allahabad'.
not table for xml.

Member 7909353 20-Jan-16 2:13am View

No remove all <li> tag
means remaining tag is only <ul> tag

Member 7909353 20-Jan-16 1:57am View

In Tagit function,
return matcher.test(value.label);//this line is not working

Member 7909353 20-Jan-16 1:42am View

In Tagit funtion,return statement is not working, i think bcoz alert shows <li> tag
response($.grep(mydata, function (value) {
alert(data[0].FPS_ShopName_EN); //for check value, it is fine ,it shows value
return matcher.test(value.label);// I think this line is not working
}));

Member 7909353 20-Jan-16 1:37am View

<ul> tag contains <li>
<div></div><a></a>
</li>
I want to remove all <li> tag from <ul> tag

Member 7909353 20-Jan-16 1:00am View

In li tag ,I have div tag and a tag.
$("#ulelementID").html(""); it is removing div and a tag only

Member 7909353 12-Jan-16 1:24am View

If I remove updatepanel and set dvTag runat="server" then It is not disappear but on selection index change I want to to clear dvTag

Member 7909353 11-Jan-16 4:13am View

Initiallay ul(dvTag) has li tag and li tag has input tag and taster ,input tag has place holder after firing event ul does not have li tag

Member 7909353 11-Jan-16 1:53am View

Yes It is there but does not show place holder i.e. not show li tag

Member 7909353 8-Jan-16 7:04am View

alert(row.id) gives
ContentPlaceHolder1_rptFPS_rptCommodity_0_rptMonth_0_gvPayment_0_txtLiftedQty_0

Member 7909353 8-Jan-16 6:54am View

Actually I do not want to use innerHTML after getting element.

Member 7909353 8-Jan-16 6:44am View

Like this
var row = document.getElementById(rowId + "_txtLiftedQty_" + rowIndex);

alert("abc=" + $('#row').val());
?
It shows abc=undifined

Member 7909353 22-Dec-15 2:18am View

I have many drop down, text box and one button.
If click button it is fired but change selection of drop down does not fired.
If I change selection then i have to click button for selection change

Member 7909353 22-Dec-15 2:10am View

I have server side event for drop down not client side.

Member 7909353 22-Dec-15 2:09am View

I have only server side event for drop down.

Member 7909353 21-Dec-15 23:52pm View

I want to fire onindex change event on server side not on client side

Member 7909353 21-Dec-15 7:41am View

I do not want to fire script on selection change.

Member 7909353 21-Dec-15 6:48am View

Actually I have implement this java script for auto text search. It is working for auto search but index change event does not fire when i change selection.

Member 7909353 21-Dec-15 6:03am View

I do not want to have client side event for drop down

Member 7909353 3-Dec-15 23:48pm View

I want to get control in javascript.

Member 7909353 9-Nov-15 3:57am View

But why it is not call implicitly

Member 7909353 29-Sep-15 2:13am View

gvProducts.AllowPaging = false;
gvProducts.DataBind();
gvProducts.Rows.Count is zero.
gvProducts.Rows[index] index out of range exception is occurred

Member 7909353 23-Sep-15 1:11am View

When I debug this line row = gvProducts.Rows[index];
Index out of range exception is occurred

Member 7909353 16-Sep-15 6:43am View

I want to read only all rows irrespective of what values

Member 7909353 8-May-15 2:05am View

yes it is solved
set @sql='update Table1 set'+' '+ @ColName+'=''P'''+' where UserId='+@userId+' and ContractorName='+''''+@cn+''''

Member 7909353 7-May-15 7:41am View

I have tried but no solution

Member 7909353 7-May-15 4:50am View

declare @ColName varchar(20)
declare @sql nvarchar(1000)
DECLARE @sitename nvarchar(30)
DECLARE @userId nvarchar(10)
DECLARE @cn nvarchar(70)
set @cn=(select ContractorName from Table1);
set @userid=1
set @ColName='Days1'
set @sql='update Table1 set'+' '+ @ColName+'=''P'''+' where UserId='+@userId
It is right
but when I concate

set @sql='update Table1 set'+' '+ @ColName+'=''P'''+' where UserId='+@userId+' and ContractorName='+@cn

print @sql
EXEC sp_executesql @sql

update Table1 set Days1='P' where UserId=1 and ContractorName=a
Msg 207, Level 16, State 1, Line 1
Invalid column name 'a'.

Member 7909353 1-Dec-14 3:38am View

try again please

Member 7909353 28-Nov-14 6:47am View

See again

Member 7909353 28-Nov-14 1:47am View

when report is generating the error is
for security reasons dtd is prohibited

Member 7909353 4-Sep-14 2:55am View

Actually I want to display win form control in web page

Member 7909353 26-Aug-14 3:02am View

insert into Table_1 values(101,convert(datetime,'03/06/2013',103))

select convert(datetime,datevalue,103) from Table_1
where convert(varchar(10),datevalue,103) between convert(varchar(10),'02/11/2014',103)
and convert(varchar(10),'03/11/2014',103)
this gives '03/06/2013' value also why?

Member 7909353 26-Aug-14 2:32am View

But sometimes I need only time sometimes only date,I have to convert

Member 7909353 17-Jun-14 2:59am View

I want to write some text on that file like 092348343403.
But my need is to generate .cap file

Member 7909353 15-May-14 4:44am View

I have gone above link and followed instruction.
I have found two missing dll
IESHIMS.DLL
WER.DLL

Member 7909353 25-Apr-14 8:57am View

Yes I have done it.

Member 7909353 20-Mar-14 2:55am View

I want
string1
string1.string2
string1_string2
string1 string2

Member 7909353 14-Mar-14 15:00pm View

thank you

Member 7909353 14-Mar-14 14:32pm View

I want to save name like above example only

Member 7909353 20-Dec-13 14:47pm View

But I have to access in c# also i.e. back end

Member 7909353 10-Dec-13 8:22am View

What is solution?
Please...................

Member 7909353 10-Dec-13 8:18am View

connection is connectionString="Data Source=SUMIT;AttachDbFilename=D:\DL PROJECT\App_Data\eResourceMgmt.mdf;Integrated Security=True"

Member 7909353 10-Dec-13 8:17am View

Now I am not deploying my web site but from properties where I select Use IIS Web Server radio button and url is http://localhost/DL PROJECT
my connection is <add name="MyCon" connectionstring="Data Source=SUMIT;AttachDbFilename=D:\DL PROJECT\DL PROJECT\DL PROJECT\DL PROJECT\App_Data\abc.mdf;Integrated Security=True">
it gives an error Login failed for user 'SUMIT\ASPNET

Member 7909353 10-Dec-13 8:10am View

Now I am using Use IIS web server from properties and click on login button
Login failed for user 'SUMIT\ASPNET'.

Member 7909353 10-Dec-13 2:21am View

Are you sure?

Member 7909353 10-Dec-13 2:09am View

yes

Member 7909353 10-Dec-13 1:59am View

yes

if (!IsPostBack)
{

DDLState.DataSource = StateList.Values;
DDLState.DataBind();
}

Member 7909353 10-Dec-13 1:33am View

According to index, text has been changed but DDLState_SelectedIndexChangeddoes not fire

if I change text, index is also changed but DDLState_SelectedIndexChangeddoes not fire

Member 7909353 10-Dec-13 1:33am View

if I change text, index is also changed but DDLState_SelectedIndexChangeddoes not fire

Member 7909353 10-Dec-13 1:31am View

According to index text has been changed but DDLState_SelectedIndexChangeddoes not fire

Member 7909353 5-Dec-13 23:36pm View

I am using session, but want to know another way if any.

Member 7909353 25-Nov-13 9:04am View

But one service install successfully

Member 7909353 25-Nov-13 8:59am View

I have two service one of them is installed but one is not.

Member 7909353 25-Nov-13 8:40am View

@ECHO OFF

REM The following directory is for .NET 2.0
set DOTNETFX2=%SystemRoot%\Microsoft.NET\Framework\v2.0.50727
set PATH=%PATH%;%DOTNETFX2%

echo Installing MyService...
echo ---------------------------------------------------
InstallUtil /i c:\abc.exe
net start | find "AutomateSMS" > nul 2>&1
if not .%errorlevel%.==.0. goto startservice
goto skip

:startservice
net start "abc"

echo ---------------------------------------------------
echo Done.
stop

why it ask for username ,password

Member 7909353 19-Nov-13 5:25am View

I want combo box to be sorted and item "All" at position zero.

Member 7909353 19-Nov-13 4:10am View

Ok!
contractor.Add("Abcd");
contractor.Add("ab");
contractor.Insert(0, "All");
cmbcategory.Sorted = true;
cmbcategory.DataSource = contractor;
It does not show item All on top of combo box

Member 7909353 19-Nov-13 4:06am View

If I modifiy after fill combo box then a warning is shown
"Additional information: Items collection cannot be modified when the DataSource property is set."

Member 7909353 19-Nov-13 3:52am View

I am using List<string> which is already filled then fill the combo box.

Member 7909353 30-Oct-13 4:49am View

But page is child page.

Member 7909353 25-Oct-13 6:30am View

It is done by putting all css class in master page.
But I want to use separate css file.

Member 7909353 25-Oct-13 6:21am View

file TextFormate.css is there.Even I am using same for another master/content page.

Member 7909353 22-Oct-13 5:08am View

yes, now it is working thanks!

Member 7909353 10-Oct-13 8:36am View

But first time it is false then I can create object.

Member 7909353 10-Oct-13 8:34am View

Is it better that assigned memory by this line Customer cms=new Customer(); before page load;

Member 7909353 4-Oct-13 9:39am View

no

Member 7909353 3-Oct-13 6:51am View

Hurreh................. Problem is solved.
Thank you!

Member 7909353 3-Oct-13 6:33am View

right now no.
Thank you!

Member 7909353 3-Oct-13 6:12am View

I have application only.
But I check that client machine has these two dll.
Thank you!

Member 7909353 3-Oct-13 6:03am View

Microsoft.ReportViewer.Commons
Microsoft.ReportViewer.WinForms

Member 7909353 3-Oct-13 5:20am View

I install reportviwer as you suggest but it is not working

Member 7909353 3-Oct-13 5:11am View

should report viewer on client computer?

Member 7909353 19-Jul-13 0:50am View

I debug the code problem is in "this.reportViewer1.ProcessingMode = Microsoft.Reporting.WinForms.ProcessingMode.Remote" in GetConnectionOfReportServer(),after this line control does not go ahead.

Member 7909353 15-Apr-13 6:52am View

I mean when I put database in MSSQL.1\DATA, how to find it without giving full path in the code

Member 7909353 4-Apr-13 0:48am View

yes i can get Table1 because i can get name = dataRow[0].ToString();

Member 7909353 3-Apr-13 4:43am View

control gets black screen.

Member 7909353 25-Mar-13 6:10am View

bInfo.bmiHeader.biSizeImage =(uint) (control.Width * control.Height * bInfo.bmiHeader.biBitCount) / 8;
does not get work

Member 7909353 5-Feb-13 6:19am View

INT_PTR nResponse =dlg.DoModal();
above line pop up msg

Member 7909353 30-Jan-13 0:33am View

When I open image from ms access it shows a message as
The OLE object is empty.

Member 7909353 28-Jan-13 0:58am View

It does not show image in ms access table.

Member 7909353 25-Jan-13 8:11am View

I MAKE A CALL WRONGLY.
NOW MAKE THE BUTTONS ASSCENDING ORDER.
IT FINE.

Member 7909353 25-Jan-13 4:59am View

Yes,Thank you!

Member 7909353 25-Jan-13 4:08am View

pBmp is showing 0x00000000.

Member 7909353 10-Jan-13 23:58pm View

Right now I am saving image in a folder and path of image in database.
HWND wnd=::GetDlgItem(GetSafeHwnd(), IDC_DetectImage);
//HWND wnd=::GetDlgItem(m_hWnd, IDC_IMAGE);
DRM_EXP_THROW_0(((NULL != wnd) && ::IsWindow(wnd)),Drm::CXSystemSpecificException);
Drm::utilities::ClSimpleBitmap bmp;
bmp.Attach((BITMAPINFOHEADER*)(pImg));
BITMAPINFOHEADER *img=bmp.BI();
bitmap_type tmp(new ClSimpleBitmap(bmp));
GLB_m_pSrcBmpScanner.Swap(tmp);

Member 7909353 18-Dec-12 23:35pm View

Thank you!

Member 7909353 18-Dec-12 6:13am View

Actually I want to add system menu in CPropertySheet

Member 7909353 22-Nov-12 1:34am View

Thank you!
You are saying right.

Member 7909353 15-Nov-12 0:57am View

Actually I am creating controls(button,text ....) on a tab control at run time for FirstDlg box. Then how to write like
BEGIN_MESSAGE_MAP(CFirstDlg, CDialog)
...
ON_BN_CLICKED(IDC_BUTTON1, &CFirstDlg::OnBnClickedButton1)
...
END_MESSAGE_MAP()

Member 7909353 5-Nov-12 23:55pm View

Actually my control is referenced by m_cTab.
Here I was tying to get dlgitem by m_cTab1.

Member 7909353 5-Nov-12 23:53pm View

Yes.
Thanks!

Member 7909353 5-Nov-12 6:50am View

Same error is occurred

Member 7909353 1-Nov-12 1:46am View

hMyWindow=::GetDlgItem(m_cTab.GetSafeHwnd(),id);
hMyWindow = capCreateCaptureWindow("handle", WS_CHILD | WS_VISIBLE, 50, 150, ImageX, ImageY,hMyWindow,90);

bool xx = capDriverConnect( hMyWindow,0);
now value of hMyWindow=0x00010a62{unused=-17891602} and
capDriverConnect() return true but image does not get(show).

Member 7909353 31-Oct-12 8:55am View

I want to use CStatic for image which is dynamically created.

Member 7909353 31-Oct-12 8:08am View

When I does not create dynamically, I create at design time it works.

Member 7909353 31-Oct-12 7:59am View

On Button click
int id,tabID;
tabID=m_cTab.GetCurFocus();
INT_PTR iCount =m_cTab.obArray.GetCount();
for(INT_PTR i=0; i<icount; i++)
="" {
="" dialogitem*="" pitem="(DialogItem*)m_cTab.obArray[i];"
="" if(pitem-="">ItemID==4000&tabID==2)
{
id=pItem->ItemID;
break;
}
}
hMyWindow=::GetDlgItem(m_cTab.GetSafeHwnd(),id);
hMyWindow = capCreateCaptureWindow("handle", WS_CHILD | WS_VISIBLE, 50, 150, ImageX, ImageY, hMyWindow,90);
bool xx = capDriverConnect( hMyWindow,0);
if(xx == false)
{
AfxMessageBox("Webcam not found ",0,0);
}
xx is true but no image capturing occurred.

Member 7909353 4-Oct-12 5:30am View

When I use option first and I click the button it gives...
Unhandled exception at 0x0044d8ee in ZF1SDKDemo.exe: 0xC0000005: Access violation reading location 0x00000020.

and in 2nd option it gives error number
c2143,c4430,c2065,c2227,c2143

Member 7909353 24-Sep-12 4:30am View

As you suggest, I did but it gives error
error C2504: 'CMFCPropertySheet' : base class undefined

Member 7909353 18-Sep-12 6:45am View

void CreateGroupBox(LPCTSTR sCaption, int nID, int iTab, int width, int height, UINT uLocation = 0, int iX = 0, int iY = 0);
It does not return anything

Member 7909353 18-Sep-12 6:10am View

void CMyTabCtrl::CreateEdit(LPCTSTR sCaption, int nID, int iTab, UINT uLocation, int iX, int iY, int iLen)
{
CRect rc;
GetClientRect(&rc);//GetWindowRect
int x = rc.left + MARGIN_LEFT;
int y = rc.top + MARGIN_TOP;
if(uLocation & P_BELOW){y = iLastBottom;}
if(uLocation & P_RIGHT){x = iLastRight;}
if(uLocation & P_LEFT){x = iLastLeft;}
if(uLocation & P_TOP){y = iLastTop;}
x += iX;
y += iY;
CSize sz;
sz.cy = 20;
sz.cx = iLen;
if(iLen != 0 ){sz.cx = iLen;}
CEdit* pEdit = new CEdit;
pEdit->Create(WS_CHILD|WS_VISIBLE|WS_TABSTOP|WS_BORDER,CRect(x,y,x+sz.cx,y+sz.cy),this,nID);
}

Member 7909353 6-Sep-12 8:05am View

thank you!

Member 7909353 17-Aug-12 2:36am View

Thanks!
I will try.

Member 7909353 8-Aug-12 6:07am View

Thanks!But I want to call using dllimport.

Member 7909353 31-Jul-12 0:25am View

I have added.

Member 7909353 30-Jul-12 5:16am View

definition is in xyz.dll

Member 7909353 9-Jul-12 3:22am View

But how to save template in sql database

Member 7909353 27-Jun-12 5:50am View

When gridview has all data, why we required to make function it is again server hitting.

Member 7909353 27-Jun-12 5:28am View

I bind data by below code
SqlCommand cmd = new SqlCommand("AttendenceViewSP", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Option", SqlDbType.Int, 3).Value = 0;
cmd.Parameters.Add("@username", SqlDbType.VarChar, 50).Value = UserNameTextBox.Text;
cmd.Parameters.Add("@password", SqlDbType.VarChar, 50).Value = PasswordTextBox.Text;
cmd.Parameters.Add("@year", SqlDbType.VarChar, 100).Value = yearDropDownList.SelectedItem.Text;
cmd.Parameters.Add("@month", SqlDbType.VarChar, 100).Value = monthDDL.SelectedItem.Text;

SqlParameter p1 = new SqlParameter("ret", SqlDbType.Int);
p1.Direction = ParameterDirection.ReturnValue;
cmd.Parameters.Add(p1);
SqlDataAdapter ad = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
ad.Fill(ds);
string dds = ds.Tables[0].Rows[0][1].ToString();

GridView1.DataSource = ds;
GridView1.DataBind();

ad.Dispose();
cmd.Dispose();
in button event
as you suggest,gridview is disable.

Member 7909353 26-Jun-12 0:32am View

Now error is
Object reference not set to an instance of an object.

Member 7909353 22-Jun-12 0:59am View

In main method I am using free(pBitmap1) and free(pBitmap2) in further statements

Member 7909353 21-Jun-12 10:16am View

when I use free() function it gives following message
Windows has triggered a breakpoint in Tutorial.exe.
This may be due to a corruption of the heap, which indicates a bug in Tutorial.exe or any of the DLLs it has loaded.
This may also be due to the user pressing F12 while Tutorial.exe has focus.
The output window may have more diagnostic information.

Member 7909353 19-Jun-12 2:06am View

Excel.XlRgbColor.rgbLightBlue; is working but I want fill a cell where content is 5

Member 7909353 19-Jun-12 2:04am View

Deleted

Excel.XlRgbColor.rgbLightBlue;
is working but I want to fill particular cell where content is "P"

Member 7909353 19-Jun-12 1:31am View

it gives error
The name 'XlRgbColor' does not exist in the current context

Member 7909353 19-Jun-12 1:29am View

In saveas method it gives error
The name 'XlFileFormat' does not exist in the current context

Member 7909353 12-Jun-12 3:24am View

when condition is not satisfied temp table row have all null values.I do not want row having all null values

Member 7909353 12-Jun-12 3:24am View

when condition is not satisfied temp table row have all null values.I do not want row having all null values

Member 7909353 12-Jun-12 3:21am View

Deleted

temp table shows data

empcode timein timeout
--------------- --------------- ---------------
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
1001 11:59:46 11:57:59
1001 10:46:29 19:54:13
1001 10:09:07 18:44:13
<null> <null> <null>
<null> <null> <null>
1001 11:12:11 7:31PM
1001 11:29AM <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>
<null> <null> <null>

Member 7909353 5-Jun-12 7:21am View

I want every row which satisfies condition year and month

Member 7909353 5-Jun-12 6:37am View

Here punchdate is not a singal value its collection of value i.e. column value.
Because when I run SELECT *
FROM register
WHERE DATEPART(YEAR,convert(datetime,(select PunchDate from InOutRegister)))= @Year AND DATEPART(MONTH,convert(datetime,(select PunchDate from InOutRegister)))=@Month
it gives an error....
Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.

Member 7909353 28-May-12 6:29am View

When I insert into table , value is inserted with time.I do not want time.

Member 7909353 24-May-12 8:32am View

Will it return datetime object?

Member 7909353 24-May-12 5:40am View

In place of getdate() i have to pass datetime object from c#

Member 7909353 15-May-12 3:24am View

I have to select the dropdownlist and that string should be search in gridview and display in textbox.

Member 7909353 14-May-12 8:34am View

Thanks,Your solution is correct but I want to use only sqldatareader.

Member 7909353 14-May-12 8:16am View

Thanks,Your solution is correct but I want to use only sqldatareader.

Member 7909353 14-May-12 8:15am View

No this is not working.

Member 7909353 10-May-12 0:19am View

It is also not working.

Member 7909353 4-May-12 0:44am View

how?

Member 7909353 24-Apr-12 9:23am View

I am using DateTime.Now.ToString()

Member 7909353 24-Apr-12 9:22am View

I am using DateTime.Now.ToString("T") but this not sufficient.

Member 7909353 13-Apr-12 8:39am View

sql 2005 express.

Member 7909353 13-Apr-12 8:38am View

Express

Member 7909353 11-Apr-12 1:33am View

I am using sql 2005.

Member 7909353 11-Apr-12 0:44am View

I am using sql 2005

Member 7909353 9-Apr-12 2:53am View

SQL Server Agent does not shown.

Member 7909353 9-Apr-12 2:52am View

How to set stored procedure to my table(WeeklyTable).

Member 7909353 23-Mar-12 3:18am View

Thank you!
But when I click the SQL Server Management Studio it does not open now.

Member 7909353 19-Mar-12 8:44am View

I have done according to your advise but page display following field
database name ,server name ,user name and password

Member 7909353 13-Jan-12 0:53am View

I have done,toiu said.

Member 7909353 11-Jan-12 1:38am View

I am using span in link.

Member 7909353 14-Dec-11 5:35am View

I have checked this link.I want that tags in doxygen wizard.

Member 7909353 12-Dec-11 1:22am View

It is not working fine

Member 7909353 11-Dec-11 23:27pm View

what is the solution?

Member 7909353 9-Dec-11 5:49am View

I have done.Assembly is not loaded during debuging.

Member 7909353 8-Dec-11 23:49pm View

I have done in .def file

EXPORTS
ABC @12
ABCx64 @13

Member 7909353 23-Nov-11 2:00am View

I have done

Member 7909353 25-Oct-11 1:55am View

It is not working.

Member 7909353 11-Aug-11 2:53am View

it is not done till now

Comments by Member 7909353 (Top 178 by date)