Comments by kozmikadam (Top 68 by date)

I solved my problem. Get column count ( i get with for loop ) and then i convert it to alphabetical version.

private string GetExcelColumnName(int columnNumber)
{
int dividend = columnNumber;
string columnName = String.Empty;
int modulo;

while (dividend > 0)
{
modulo = (dividend - 1) % 26;
columnName = Convert.ToChar(65 + modulo).ToString() + columnName;
dividend = (int)((dividend - modulo) / 26);
}

return columnName;
}

I'm already know their type and use select on the top of this code for the read.
But i need to put a string value in to cell which type is integer. So i got missmatch type error for this.

Syntax error in query. Incomplete query clause.
Accually, i don't have any idea. I'm trying it first time. And examine some posts about it. And found the link abowe.

hi, it gives syntax error still.

But i restart my computer, and now it didn't give any error for : UPDATE [30187$K6:K6] SET F1='OK' but now program freezes. And it isn't in any loop.

i tried this also :) still got error.

Hello ,
I'm not a pro-coder. So i guess it's normal to make this type faults and learning : what i shouldn't do it and why. :)

I'm using breakpoints also.
I can say excel string is : UPDATE 30187$K6:K6 SET F1=OK
But when i put this string in to directly excel string ( without any parametric content ) it's gives same error.

And when i tried just like on the link, i get same error.

Or do you have any other suggestion for update excel's some cell's value from datagridview ?

Hi,
i'm using OleDB for my project. I want to ask, is there any other way for update data from datagridview to excel or need i use oledb command for that ? ? i don't want to create a new excel file, i want to edit old one which i imported it to datagridview.

In this view i have just a form for add students to my "student" table. Also i'm trying to add course name to a second table which name is "course". So in this view i have just a form.

Is there any article about this type work ?

I'm trying to a very simple thing i think. With the classic way ( asp.net web application ) i can do this without any problem. But in MVC i couldn't solve yet.

Hello Dave,
I'm trying to understand , now in my db i have 2 table as i said. And all models created automatically after i connect with my db.

For example i want to add same value like course in two table with one form. You said create another MVC , that includes course data twice ?

Sorry , i'm really a newbie about it.

Hi Andy ,
Thank you for your help.I solve the problem ! I restart the sql server and now it works !

Thank you for your interest about this issue !I learned a lot of think today thanks to you !

yes in code. i have 2 connection strings ( they are same. that my mistake and now i use 2 connection strings. ) one of them in form load event and the other one is in settings.designer.cs ( this one comes from gridviews)

yes it's a uniq user.

my gridview is filling with form_load event.

i create a new user with sql server authentication.
also set a password for it.
uncheck enforce password policy
in user mapping select db_owner ( public is selected default , i can't uncheck it )

i tried , but again it says : Login failed for user "msi/atak"
why it's tring to login with this user ? I don't get it.

yes it's the correct user.

SERVER=.//SQLEXPRESS;Database=atak_db;Trusted_Connection=true;

i selected all of them already. :/

yes it's the user login.
i tried a few connection string with trusted_connection or user sa . error is the same. login failed for user "msi\atak"

I reinstall sql server. And now we have some progress !

Our new error is : Cannot open database "atak_db" requested by the login the login failed. Login failed for user "Msi\atak"

I already enabled tcp/ip and named pipes. sql server is running also. sql browser is not running. But i enable it. Now it's running also.

And now , i will try reinstall sql server.

I have sql server management studio in this computer also.

Yes error says it cannot find the host.

Tried and i can say , it isn't work. Also isn't work on my computer.

i tried this also. But let me try again :)

Edit : Tried and we got the same error. I don't get it. What is the problem.

server name = .\SQLEXPRESS but i also try this , also i tried computers name. still same error.

I tried this connection string and still same error :

"Data Source=.;Database=atak_db;Trusted_Connection=True;"

Ok ,i found it under the server > sequrity > logins and i add to my db owner.

But still i can't connect.

Should i make any change in my connection string ?


Here is the error description :

Bu iletişim kutusu yerine JIT hata ayıklamayı çağırma
hakkında detaylı bilgi için bu iletinin sonuna bakın.

************** Özel Durum Metni **************
System.Data.SqlClient.SqlException (0x80131904): Sunucuyla bağlantı kurulurken ağ ile ilgili veya örneğe özel bir hata oluştu. Sunucu bulunamadı veya sunucuya erişilemiyor. Örnek adının doğru olduğunu ve SQL Server'ın uzak bağlantılara izin verdiğini doğrulayın. (provider: Named Pipes Provider, error: 40 - SQL Server için bağlantı açılamadı) ---> System.ComponentModel.Win32Exception (0x80004005): Sistem belirtilen dosyayı bulamıyor
konum: System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
konum: System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
konum: System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover, SqlAuthenticationMethod authType)
konum: System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
konum: System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
konum: System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
konum: 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)
konum: System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
konum: System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
konum: System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
konum: System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
konum: System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
konum: System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
konum: System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
konum: System.Data.ProviderBase.DbC

Thanks for that ! But i have one more question. Which one is the windows user account ? dbo - guest - INFO SHEMA -sys and i can delete just guest. So can i assume it's the windows account user ?

Hi Andy ,

I haven't so much experiance with sql server management studio. can you explain step by step ?


I didn't get "remove the previous credentials". Can you explain more ?

There is 2 option in security. One of in my db. And another one in under Databases. And there are 4 users , which one is the windows account ?

Can it be , can't connect to new computers sql server ?

Hi Richard ,
I know , but i didn't wrote any code for this form components. It's a standart for joomla.

It's not my db. So we have a lot of data in this db , and i am trying to get this data from there. So I'm looking for a solution. I can't create a new db, i haven't any permissions for this.

Hi Richard ,

But I'm using Windows. So why it's looking for unistd.h ? I'm using Visual Studio 2015.

So how can i do this ? In solution explorer there isn't properties for right click.
My project is not local also. It's online.

for this , it's refreshing page.

for this , i have another error : "System.Reflection.ReflectionTypeLoadException: Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information."

I delete all ajax dll file. And after added again. Nothing change.

I tried Solution 6 in another sample project. And i have same error.

Same error unfortunately

yes. same error.

yes , i tried.

Tried. Still refreshing page.

Hi Amy , Please check comment's of solution 2. I tried already ToolkitScriptManager but this time i saw another errors.

My new error is " This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowoverride="false"> from an inherited configuration file."

Already i tried this link. Result : "Parser Error Message: This configuration section cannot be used at this path. This happens when the site administrator has locked access to this section using <location allowoverride="false"> from an inherited configuration file."

Should i open a new system web tag in configuration or can i use default system web tag which one is already in configuration tag ?

I use default one.

I haven't yet. I search on internet. And i found this : "<trust level="Full"/>" But i can't find , must be this line in which tags. I wrote in system.web tag but it's giving error like :"This configuration section cannot be used at this path"


My web.conf :

connection string
system.web

<trust level="Full"/>

system.web />

i removed toolkitscriptmanager from my code. Rebuild my solution. After i added the toolkitscript from toolbox. But still i have same problem "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information."

<configsections>

<sectiongroup name="system.web.extensions" type="System.Web.Configuration.SystemWebExtensionsSectionGroup,
System.Web.Extensions, Version=3.5.0.0, Culture=neutral,
PublicKeyToken=31BF3856AD364E35">



It's giving this error : Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information

In this line :



Line 69:
Line 70:
Line 71: <cc1:ToolkitScriptManager id="ToolkitScriptManager1" runat="server" enablescriptglobalization="true">
Line 72:
Line 73:

In which tag ?

Hello , I tried this now. It's says : Unknown server tag 'AjaxToolkit:ToolkitScriptManager'.

So i change it like this : <cc1:ToolkitScriptManager id="ToolkitScriptManager1" runat="server" enablescriptglobalization="true">


And this time it's giving an another error like: "Unable to load one or more of the requested types. Retrieve the LoaderExceptions property for more information."

And what sould i see in this script ?

Problem solved ! Thanks to you :)

I tried , It isn't work still.

Button is in a contentplaceholder. And contentplaceholder is in a form tag in master page.

Yes , exacly ! But button isn't work. It's there just like an image.

Already , i tried this. I convert to Windows format with Notepad++. But still i have same problem.

But for every computer , installation file directory can be change.

how can i do this ? just show a way. what should i do ?

I am creating a connection between Datagridview and DataSource.I write a query for display image. And when i clicked to "test" button it's work.I can see a little part of the picture.Not the whole picture. I clicked to "ok" button. İ see nothing. My databases value type is "image".So the problem could be this?

my .cs page :


using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

namespace deneme.User
{
public partial class profile : System.Web.UI.Page
{

protected void Button1_Click(object sender, EventArgs e)
{

}

protected void Button2_Click(object sender, EventArgs e)
{

}
}

}

my .aspx page

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Add" />

<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Button" />


all the same. button1 works. any other buttons don't work.

Click event of button2 is Button2_Click

drag-drop

<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="Add" /> // Does work

<asp:Button ID="Button2" runat="server" onclick="Button2_Click" Text="Button" /> //Doesn't work.

Thanks !

$sql = mysql_query("SELECT * from Jant ORDER BY ID DESC LIMIT 1;");

$goster=mysql_fetch_array($sql);
echo $goster['ID'];


Problem solved ! Thanks for your help.

Table Jant :

ID - Name - type - marka

$last_id = mysql_query("SELECT MAX(ID) FROM Jant"
echo $last_id

always return me "Resource id #3"

doesn't matter. but we have two database for two people. (1.mdb and 2.mdb)

1.mdb and 2.mdb have users name , surname , adress etc.

for example j(1).ToString = getting name. ( in 1.mdb )

but j1(1).ToString is not getting. ( in 2.mdb )

There is a simple problem. But what ? I could find it.

i understand. But i need last id.How can i find it ?

problem solved thank you!