Comments by manvendra patel

manvendra patel 20-May-16 7:54am View

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) ---> System.ComponentModel.Win32Exception (0x80004005): The network path was not found
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
at System.Data.ProviderBase.DbConnectio

manvendra patel 20-May-16 6:40am View

please look at this link
http://stackoverflow.com/questions/30162076/net-cant-connect-to-mdf-on-another-machine

manvendra patel 20-May-16 6:39am View

my connection string is
connectionstring="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=Database1.mdf;integrated security=true"

its work on my Development pc but when i run setup on client machine than getting connection error.how it possible on one system it work and on another system its not work.?

manvendra patel 20-May-16 6:38am View

Deleted

my connection string is
<add name="localconnection" connectionstring="Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=Database1.mdf;integrated security=true">

its work on my Development pc but when i run setup on client machine than getting connection error.how it possible on one system it work and on another system its not work.?

manvendra patel 27-Apr-16 5:05am View

I am synchronizing a number of databases with each other. I have one central SQL Server database and many client SQL Server databases. Now say I have table Xyz in the database which have a primary key ID.

In the first client we have the following IDs in table X:

xyz (client A)
--------
1|value1
2|value2
3|value3
4|value4

and in the second client I have

xyz (client B)
--------
1|value222
2|value333
3|value444
4|value555

Now when I synchronize the first client with the server, it will add the primary keys from (1 .. 4). However, when I synchronize with the second client, it will be PRIMARY KEY CLASH. How can I solve this problem?

manvendra patel 18-Mar-16 5:52am View

but my sitemap are dynamic. i am working on eCommerce website .there is lot of dynamic category subcategory in my database .i want to show this category on sitemap page.then how can we use xml file instead of database.?

manvendra patel 13-Aug-15 7:58am View

okey no problem

manvendra patel 13-Aug-15 4:55am View

thnaks for your response, but its very old question.

manvendra patel 23-Jul-15 11:13am View

okey i understand it . i think it works client side only. when server respond. then it closed .is there any code to show loading image until postback completed . for example -
if i am binding gridview with thousand row on button click .then i want to show loading image untill gridview fully loaded with thousand data . ?

manvendra patel 23-Jul-15 5:30am View

but when i click on Load Customer Button .then it show loading image only for 2-3 second . but Gridview still loading.why ?

manvendra patel 23-Jul-15 5:07am View

hello DamithSL sir .firstly thanks for your response . i tried your link .but not satisfied my condition . it show only given time (System.Threading.Thread.Sleep(5000));

manvendra patel 22-Jul-15 7:33am View

is there any code ?

manvendra patel 22-Jul-15 7:32am View

thanks Tadit Sir for your response . i know how to apply css on asp.net control. but asp.net multihandlarExtender Provide default css properties with fixed class .when i aspect in browser i saw some class . after that i have added class and modified its properties ,but its not working

manvendra patel 17-Jul-15 5:39am View

thanks sir,you explain very well.

manvendra patel 25-Mar-15 14:54pm View

I am using asp.net web form

manvendra patel 17-Mar-15 9:35am View

Sir I want actually mention ur link type (flipkart) .but no idea coming in my mind how to solve this .pls suggest me or provide code

manvendra patel 9-Feb-15 2:58am View

can i use json with caching ?

manvendra patel 4-Feb-15 8:04am View

is there any code for these type in asp.net with database ?

manvendra patel 12-Jan-15 2:19am View

if you are using Update panel then try this
<Triggers>
<asp:AsyncPostBackTrigger ControlID="grdSymtom" EventName="RowCommand" />
</Triggers>

may be it work

manvendra patel 12-Jan-15 2:19am View

Deleted

if you are using Update panel then try this
<Triggers>
<asp:AsyncPostBackTrigger ControlID="gvTenderList" EventName="RowCommand" />
</Triggers>

may be it work

manvendra patel 14-Dec-14 7:37am View

thanks lot, its working .but I don't understand why it was not running .

manvendra patel 10-Oct-14 11:33am View

yes you are right . just i am loking some source code in mvc about how to create Review and rating system.

manvendra patel 9-Oct-14 1:02am View

just put into into template field with above code.

<asp:TemplateField HeaderText="login" >
<itemtemplate>

Click Here

manvendra patel 24-Sep-14 8:36am View

if your asp.net project on server then please contact to hosting server website ,because you have no authority to edit /Delete/ data in asp.net Folder .

manvendra patel 24-Sep-14 8:20am View

yes why not,this is very usefull.

manvendra patel 24-Sep-14 6:24am View

thanks lot its working

manvendra patel 24-Sep-14 6:12am View

i want any one out of them for student_Id 6

manvendra patel 3-Sep-14 6:19am View

ok i have solved this problem

manvendra patel 3-Sep-14 2:49am View

yes i want Grid popup on label mouse-hover .

manvendra patel 3-Sep-14 2:46am View

i am creating gallery system ,i have a Label called(Photo Gallery),when i mousehover on label than popup all the gallery Category .popup gallery category should be also clickable .

manvendra patel 3-Sep-14 2:16am View

thanks both of you ,i have solved this problem using PIVOT method.

manvendra patel 21-Aug-14 4:12am View

second query going fine

manvendra patel 21-Aug-14 4:09am View

thanks lot its working

manvendra patel 1-Aug-14 4:03am View

thanks lot its working

manvendra patel 24-May-14 2:00am View

try this link-http://www.dotnetfox.com/articles/bind-Asp-Net-chart-control-from-database-using-C-Sharp-1056.aspx

manvendra patel 22-May-14 2:58am View

try this in connection string -Connect Timeout=3000;pooling='true'; Max Pool Size=3000;

manvendra patel 22-May-14 2:57am View

Deleted

try this in webconfig <add name="ErpConnection" connectionstring="Data Source=MANVENDRA;Initial Catalog=tuition;integrated security=true; Connect Timeout=3000;pooling='true'; Max Pool Size=3000; " providername="System.Data.SqlClient">

manvendra patel 22-May-14 1:13am View

thanks lot for ur response Mr.aravinth04 . i solved this problem

manvendra patel 17-Apr-14 1:13am View

reate table AutoIncrementTable
(
id bigint,
name varchar(50)
)
After creating table now I am going to create a paramentrized stored procedure which insert value in table and
accept name as parameter. This procedure insert id in table automatically and increment id by 1.

Creating parametrized stored procedure

alter proc p_auto_increment_table_proc
@name varchar(50)
as
declare @Id bigint
select @Id=count(Id)+1 from AutoIncrementTable
begin
insert into AutoIncrementTable values(@Id,@name)
end
After creating stored procedure now execute it and see the result.
Executing stored procedure
p_auto_increment_table_proc 'Alok'

This will insert record in table and each time id is automatically incremented.

manvendra patel 16-Apr-14 8:12am View

thanks for ur response ,these link helpfuull for me

manvendra patel 26-Feb-14 2:59am View

Are you getting any error? or no getting the result as expected? Post the source code

manvendra patel 9-Jan-14 4:21am View

main problem is that i want get all data from table one with Course _Id ,but your query returning
on the basis of cce_weightages_Id is match

but i want to get all value from table one data which cce_weightages_Id is not exists.in table 2.

manvendra patel 9-Jan-14 3:56am View

actually i am using two table

table 1-

CREATE TABLE [dbo].[tbl_CceWeightage](
[cce_weightages_Id] [int] IDENTITY(1,1) NOT NULL,
[Weightages] [int] NULL,
[CceExamCat_Id] [int] NULL,
[Criteria_Type] [nvarchar](50) NULL,
[Created_At] [datetime] NULL,
[Updated_At] [datetime] NULL,
CONSTRAINT [PK_tbl_CceWeightage] PRIMARY KEY CLUSTERED
(
[cce_weightages_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

output from first query is-
1 123 FA dsfgdsf
2 32 SA frwewrw
3 20 FA frwewrwwqer
4 12 FA minterm exam
5 13 FA minterm exam
6 20 SA minterm exam
7 25 SA minterm exam

and second table is -

CREATE TABLE [dbo].[tbl_CceWeightagesCourse](
[WeightagesCourse_Id] [int] IDENTITY(1,1) NOT NULL,
[cce_weightages_Id] [nvarchar](50) NULL,
[Course_Id] [nvarchar](50) NULL,
[Created_At] [datetime] NULL,
[Updated_At] [datetime] NULL,
CONSTRAINT [PK_tbl_CceWeightagesCourse] PRIMARY KEY CLUSTERED
(
[WeightagesCourse_Id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

and output of second query is

3
3
3
3
2
2
2

i want to merge second query output with first query output as a column not row.

manvendra patel 24-Dec-13 2:35am View

thankyou very much .

manvendra patel 14-Nov-13 4:40am View

file does not uplaod when add any control value like cmd.Parameters.AddWithValue("@Category_Id",dropcategory.SelectedItem.Value);
at ajax file update event.

manvendra patel 18-Oct-13 1:00am View

fire gvPaging_PageIndexChanged event not gvPaging_PageIndexChanging event.

manvendra patel 9-Oct-13 1:47am View

Deleted

firstly at the save button to save aproved value in approve field ,and write where condition in stored procedure to select all value where aproved !@aproved .after that bind these values.

manvendra patel 6-Oct-13 13:20pm View

plz write
if (Session["userid"] != null)//bbefore postback
{
int userId = Convert.ToInt32(Session["UserID"]);

if (!IsPostBack)
{

}
}
else
{
respone.redirect("login.aspx");
}

manvendra patel 3-Oct-13 1:41am View

okay

manvendra patel 1-Oct-13 5:58am View

thankyou very much ,its working fine

manvendra patel 1-Oct-13 5:35am View

http://forums.asp.net/t/1645633.aspx plz try this link

manvendra patel 28-Sep-13 1:25am View

Attendance_Id,Student_Id Month_Date Batch_Id Status
746 191 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 1
747 192 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
748 196 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
749 197 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
750 200 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
751 217 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
752 218 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
753 220 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
754 221 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1 NULL
755 222 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1 NULL
756 223 NULL NULL NULL NULL 2013-09-24 00:00:00.000 4 5 1
757 191 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
758 192 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
759 196 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1 NULL
760 197 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
761 200 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
762 217 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
763 218 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
764 220 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
765 221 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1
766 222 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1 NULL
767 223 NULL NULL NULL NULL 2013-09-20 00:00:00.000 4 5 1 NULL
768 175 NULL NULL NULL NULL 2013-09-24 00:00:00.000 13 5 1
769 176 NULL NULL NULL NULL 2013-09-24 00:00:00.000 13 5 1
770 180 NULL NULL NULL NULL 2013-09-24 00:00:00.000 13 5 1 NULL
771 175 NULL NULL NULL NULL 2013-09-28 00:00:00.000 13 5 1
772 176 NULL NULL NULL NULL 2013-09-28 00:00:00.000 13 5 3
773 180 NULL NULL NULL NULL 2013-09-28 00:00:00.000 13 5 1

manvendra patel 27-Sep-13 1:22am View

on my attedance page is
1-one dropdown to select batch
2-second dropdown for select month
3-third dropdown for select year and on year dropdown selectindex to bind number of student and Perecetage in gridview which is exists in attendace table

manvendra patel 27-Sep-13 1:01am View

i am not getting error . at this time i am get attnedance percentage of each student on the based on number of persent in a month but i want firstly count number of working days after minus from holiday like (sunady) then count number of persent in working days.still i am getting percentage only by persent base in class and it not see how mucch working days in a month

manvendra patel 11-Sep-13 3:54am View

hi,
thanks for your reply
but my problem remains the same.

manvendra patel 5-Sep-13 4:12am View

i want to create a autocomplete textbox to search data from dataabse and when we select any populated value from autocomplete textbox then redirect on a other page which is depend on selected value.

Comments by manvendra patel (Top 56 by date)